jOOQ FAQ

Querying

Q:
jOOQ does not support a vendor-specific function. Can I still use this function?

A:
Yes, whenever something isn't supported out-of-the-box in jOOQ, you can use plain SQL templating to make it work.

Q:
How do I create a constant value in a SQL query?

A:
Constants are just ordinary Field expressions. Use bind values or inline values.

Q:
How can I change the qualification of tables and columns in jOOQ generated SQL (e.g. for multi tenancy)?

A:
By default, jOOQ fully qualifies all identifiers of tables, columns, and other objects. However, using the runtime schema mapping feature, you can change these qualifications at runtime, configuratively.

Code Generator

Q:
I don't want to connect to a live database for code generation. Can I do it?

A:
Yes, we currently support generating code from XML, JPA entities, and SQL scripts, without requiring a live connection.

Q:
Do I have to use the code generator?

A:
While we recommend using it, you don't have to. You can create queries from identifiers only.

Q:
Where to put generated code?

A:
There is no correct answer to this question, but there are some opinions.

The jOOQ Logo