JOOQ how generate record without connection to database

Question

What does your approach to generating Records during compilation time look like without connection to the database? I use to maven plugin for that but I still need a connection to the database but I don't have one.

Answer 1

jOOQ offers 4 out of the box solutions to generating code without a connection to a live database, including:

• JPADatabase if your meta data source of truth is encoded in JPA annotations
• XMLDatabase for XML based meta data
• DDLDatabase for DDL script based meta data (e.g. Flyway migrations)
• LiquibaseDatabase for liquibase migration based meta data

All of the above meta data sources come with their own set of limitations, including lack of support for some vendor specific stuff, but that might not affect you. In simple cases, especially the DDLDatabase can be really useful to achieve quicker turnarounds when generating code.

If vendor specific functionality is a thing in your application, then the official recommendation is to use testcontainers to set up your schema for jOOQ code generation (and integration testing!).