Q: jOOQ does not support a vendor-specific function. Can I still use this function?
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?
Constants are just ordinary
expressions. Use bind values or inline values
Q: Why am I getting a connection leak?
If you pass jOOQ a JDBC
, jOOQ will never close it for you. Instead, try passing jOOQ a
, and jOOQ will manage the connection lifecycle for you
Q: How can I change the qualification of tables and columns in jOOQ generated SQL (e.g. for multi tenancy)?
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.
Q: I don't want to connect to a live database for code generation. Can I do it?
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?
While we recommend using it, you don't have to. You can create queries from identifiers only
Q: Where to put generated code?
There is no correct answer to this question, but there are some opinions