Available in versions: Dev (3.20) | Latest (3.19) | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10
Custom Settings
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
The jOOQ Configuration 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 Configuration in several ways:
- In the DSLContext constructor (
DSL.using()
). This will override default settings below - in the
org.jooq.impl.DefaultConfiguration
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 https://www.jooq.org/xsd/jooq-runtime-3.12.4.xsd
The most specific settings for a given context will apply.
If you wish to configure your settings through XML, but explicitly load them for a given Configuration
, you can do so as well, using JAXB:
Settings settings = JAXB.unmarshal(new File("/path/to/settings.xml"), Settings.class);
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 creating the following DSLContext:
Settings settings = new Settings(); settings.setStatementType(StatementType.STATIC_STATEMENT); DSLContext create = DSL.using(connection, dialect, settings);
More details
Please refer to the jOOQ runtime configuration XSD for more details:
https://www.jooq.org/xsd/jooq-runtime-3.12.4.xsd
Table of contents
- 3.2.7.1.
- Auto-attach Records
- 3.2.7.2.
- Backslash Escaping
- 3.2.7.3.
- Execute Logging
- 3.2.7.4.
- Fetch Warnings
- 3.2.7.5.
- Identifier style
- 3.2.7.6.
- Inline Threshold (new)
- 3.2.7.7.
- IN-list Padding
- 3.2.7.8.
- JDBC Flags
- 3.2.7.9.
- Keyword style
- 3.2.7.10.
- Listener Invocation Order (new)
- 3.2.7.11.
- Locales (new)
- 3.2.7.12.
- Map JPA Annotations
- 3.2.7.13.
- Object qualification
- 3.2.7.14.
- Optimistic Locking
- 3.2.7.15.
- Parameter name prefix (new)
- 3.2.7.16.
- Parameter types
- 3.2.7.17.
- Parser Configuration (new)
- 3.2.7.18.
- Reflection caching
- 3.2.7.19.
- Return all columns on store
- 3.2.7.20.
- Return Identity Value On Store (new)
- 3.2.7.21.
- Runtime schema and table mapping
- 3.2.7.22.
- Scalar subqueries for stored functions
- 3.2.7.23.
- Statement Type
- 3.2.7.24.
- Updatable Primary Keys
previous : next |
References to this page
Feedback
Do you have any feedback about this page? We'd love to hear it!