I need to use table name/column names in annotations so they must be constant (can't call TABLE1.getName()).

Is there a way to have Jooq code generator generate these automatically in the format of public static final String TABLE1 = "table1"

and similarly for columns inside each table?

I need to use table name/column names in annotations so they must be constant (can't call TABLE1.getName()).

Is there a way to have Jooq code generator generate these automatically in the format of public static final String TABLE1 = "table1"

and similarly for columns inside each table?

• java
• postgresql
• jooq

1 Answer 1

In jOOQ 3.19+, you can enable globalObjectNames in the code generator: https://www.jooq./doc/latest/manual/code-generation/codegen-advanced/codegen-config-generate/codegen-generate-global-object-names/

Here's how to configure it with Maven

<configuration>
  <generator>
    <generate>
      <globalObjectNames>true</globalObjectNames>
    </generate>
  </generator>
</configuration>

Or Gradle:

configuration {
  generator {
    generate {
      isGlobalObjectNames = true
    }
  }
}