All versions: 3.11 | 3.10 | 3.9 | Development versions: 3.12

jOOQ's code generator recognises identity columns if they are reported as such by the database. Some databases do not support "real" identity columns, but allow for emulating them, e.g. through triggers and sequences (e.g. Oracle prior to 12c). If a column is a known "identity" without formally being one, users can specify a regular expression that matches all columns (one column per table), which will be treated as if they were formal identities. For example:

XML configuration (standalone and Maven)

<configuration xmlns="">

Programmatic configuration

  .withGenerator(new Generator(
    .withDatabase(new Database()

Gradle configuration

myConfigurationName(sourceSets.main) {
  generator {
    database {
      syntheticIdentities = 'SCHEMA\.TABLE\.ID'

Note again that these expressions are regular expressions with default flags

The jOOQ Logo