New versions: Dev (3.15) | Latest (3.14) | 3.13 | 3.12 | 3.11 | 3.10 | 3.9 | 3.8 | Old versions: 3.7 | 3.6 | 3.5 | 3.4 | 3.3 | 2.6
Custom Settings
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
The jOOQ Factory allows for some optional configuration elements to be used by advanced users. The org.jooq.conf.Settings class is a JAXB-annotated type, that can be provided to a Factory in several ways:
- In the constructor. This will override default settings below
- From a location specified by a JVM parameter: -Dorg.jooq.settings
- From the classpath at /jooq-settings.xml
- From the settings defaults, as specified in http://www.jooq.org/xsd/jooq-runtime-2.5.0.xsd
Example
For example, if you want to indicate to jOOQ, that it should inline all bind variables, and execute static java.sql.Statement instead of binding its variables to java.sql.PreparedStatement, you can do so by using the following Factory:
Settings settings = new Settings(); settings.setStatementType(StatementType.STATIC_STATEMENT); Factory create = new Factory(connection, dialect, settings);
Subsequent sections of the manual contain some more in-depth explanations about these settings:
- Runtime schema and table mapping
- Execute listeners and SQL tracing
- Execute CRUD with optimistic locking enabled
- Enabling DEBUG logging of all executed SQL
Please refer to the jOOQ runtime configuration XSD for more details:
http://www.jooq.org/xsd/jooq-runtime-2.5.0.xsd
Feedback
Do you have any feedback about this page? We'd love to hear it!