Available in versions: Dev (3.21) | Latest (3.20) | 3.19 | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11
This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.
Reference
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
These chapters hold some general jOOQ reference information
Table of contents
- 7.1.
- Supported RDBMS
- 7.2.
- Commercial only features
- 7.3.
- Experimental features
- 7.4.
- Built-in data types
- 7.4.1.
- BLOBs and CLOBs
- 7.4.2.
- BOOLEAN data type
- 7.4.3.
- Unsigned integer types
- 7.4.4.
- INTERVAL data types
- 7.4.5.
- JSON data types
- 7.4.6.
- XML data types
- 7.4.7.
- Spatial data types
- 7.4.8.
- CURSOR data types
- 7.4.9.
- ARRAY and TABLE data types
- 7.4.10.
- Oracle DATE data type
- 7.4.11.
- Domains
- 7.5.
- SQL to DSL mapping rules
- 7.6.
- Quality Assurance
- 7.7.
- Security
- 7.7.1.
- SQL Injection
- 7.7.2.
- Debug logging
- 7.7.3.
- Redacted columns (new)
- 7.7.4.
- Exception message
- 7.7.5.
- Contact
- 7.8.
- Migrating to jOOQ 3.0
- 7.9.
- Don't do this
- 7.9.1.
- jOOQ: Implementing the DSL types
- 7.9.2.
- jOOQ: Referencing the Step types
- 7.9.3.
- Schema: NULL columns
- 7.9.4.
- Schema: Unnamed constraints
- 7.9.5.
- Schema: Unnecessary surrogate keys
- 7.9.6.
- Schema: Wrong data types
- 7.9.7.
- SQL: COUNT(*) instead of EXISTS()
- 7.9.8.
- SQL: N+1
- 7.9.9.
- SQL: NATURAL JOIN or JOIN USING
- 7.9.10.
- SQL: NOT IN predicate
- 7.9.11.
- SQL: ORDER BY [column index]
- 7.9.12.
- SQL: Rely on implicit ordering
- 7.9.13.
- SQL: SELECT *
- 7.9.14.
- SQL: SELECT DISTINCT
- 7.9.15.
- SQL: Unnecessary UNION instead of UNION ALL
- 7.10.
- The most important jOOQ types
- 7.11.
- Credits
| previous : next |
Feedback
Do you have any feedback about this page? We'd love to hear it!