Available in versions: Dev (3.19) | Latest (3.18) | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10 | 3.9
The jOOQ User Manual
Applies to ✅ Open Source Edition ✅ Express Edition ✅ Professional Edition ✅ Enterprise Edition
Overview
This manual is divided into six main sections:
-
Getting started with jOOQ
This section will get you started with jOOQ quickly. It contains simple explanations about what jOOQ is, what jOOQ isn't and how to set it up for the first time
-
SQL building
This section explains all about the jOOQ syntax used for building queries through the query DSL and the query model API. It explains the central factories, the supported SQL statements and various other syntax elements
-
Code generation
This section explains how to configure and use the built-in source code generator
-
SQL execution
This section will get you through the specifics of what can be done with jOOQ at runtime, in order to execute queries, perform CRUD operations, import and export data, and hook into the jOOQ execution lifecycle for debugging
-
Tools
This section is dedicated to tools that ship with jOOQ, such as the jOOQ's JDBC mocking feature
-
Reference
This section is a reference for elements in this manual
Table of contents
- 1.
- Preface
- 2.
- Copyright, License, and Trademarks
- 3.
- Getting started with jOOQ
- 3.1.
- How to read this manual
- 3.2.
- The sample database used in this manual
- 3.3.
- Different use cases for jOOQ
- 3.3.1.
- jOOQ as a SQL builder without code generation
- 3.3.2.
- jOOQ as a SQL builder with code generation
- 3.3.3.
- jOOQ as a SQL executor
- 3.3.4.
- jOOQ for CRUD
- 3.3.5.
- jOOQ for PROs
- 3.4.
- Getting jOOQ
- 3.5.
- Tutorials
- 3.5.1.
- jOOQ in 7 easy steps
- 3.5.1.1.
- Step 1: Preparation
- 3.5.1.2.
- Step 2: Your database
- 3.5.1.3.
- Step 3: Code generation
- 3.5.1.4.
- Step 4: Connect to your database
- 3.5.1.5.
- Step 5: Querying
- 3.5.1.6.
- Step 6: Iterating
- 3.5.1.7.
- Step 7: Explore!
- 3.5.2.
- Using jOOQ with Flyway
- 3.5.3.
- Using jOOQ with jbang
- 3.6.
- jOOQ and Java 8
- 3.7.
- jOOQ and JavaFX
- 3.8.
- jOOQ and Nashorn
- 3.9.
- jOOQ and Scala
- 3.10.
- jOOQ and Groovy
- 3.11.
- jOOQ and Kotlin
- 3.12.
- jOOQ and NoSQL
- 3.13.
- jOOQ and JPA
- 3.14.
- Build your own
- 3.15.
- jOOQ and backwards-compatibility
- 4.
- SQL building
- 4.1.
- The query DSL type
- 4.1.1.
- DSL subclasses
- 4.2.
- The DSLContext API
- 4.2.1.
- SQL Dialect
- 4.2.2.
- SQL Dialect Family
- 4.2.3.
- Connection vs. DataSource
- 4.2.4.
- Custom data
- 4.2.5.
- Custom ExecuteListeners
- 4.2.6.
- Custom Settings
- 4.2.6.1.
- Auto-attach Records
- 4.2.6.2.
- Backslash Escaping
- 4.2.6.3.
- Execute Logging
- 4.2.6.4.
- Fetch Warnings
- 4.2.6.5.
- Identifier style
- 4.2.6.6.
- IN-list Padding
- 4.2.6.7.
- JDBC Flags
- 4.2.6.8.
- Keyword style
- 4.2.6.9.
- Map JPA Annotations
- 4.2.6.10.
- Object qualification
- 4.2.6.11.
- Optimistic Locking
- 4.2.6.12.
- Parameter types
- 4.2.6.13.
- Reflection caching
- 4.2.6.14.
- Return All Columns On Store
- 4.2.6.15.
- Runtime schema and table mapping
- 4.2.6.16.
- Scalar subqueries for stored functions
- 4.2.6.17.
- Statement Type
- 4.2.6.18.
- Updatable Primary Keys
- 4.2.7.
- Thread safety
- 4.3.
- SQL Statements (DML)
- 4.3.1.
- jOOQ's DSL and model API
- 4.3.2.
- The WITH clause
- 4.3.3.
- The WITH RECURSIVE clause
- 4.3.4.
- The SELECT statement
- 4.3.4.1.
- SELECT clause
- 4.3.4.1.1.
- Projection type safety
- 4.3.4.1.2.
- SelectField
- 4.3.4.1.3.
- SELECT DISTINCT
- 4.3.4.1.4.
- Convenience methods
- 4.3.4.2.
- FROM clause
- 4.3.4.3.
- JOIN operator
- 4.3.4.4.
- WHERE clause
- 4.3.4.5.
- CONNECT BY clause
- 4.3.4.6.
- GROUP BY clause
- 4.3.4.6.1.
- GROUP BY columns
- 4.3.4.6.2.
- GROUP BY ROLLUP
- 4.3.4.6.3.
- GROUP BY CUBE
- 4.3.4.6.4.
- GROUP BY GROUPING SETS
- 4.3.4.6.5.
- GROUP BY empty grouping set
- 4.3.4.7.
- HAVING clause
- 4.3.4.8.
- WINDOW clause
- 4.3.4.9.
- ORDER BY clause
- 4.3.4.10.
- LIMIT .. OFFSET clause
- 4.3.4.11.
- SEEK clause
- 4.3.4.12.
- FOR UPDATE clause
- 4.3.4.13.
- Set operations
- 4.3.4.13.1.
- Type safety
- 4.3.4.13.2.
- Projection rowtype
- 4.3.4.13.3.
- Differences to standard SQL
- 4.3.4.13.4.
- UNION
- 4.3.4.13.5.
- INTERSECT
- 4.3.4.13.6.
- EXCEPT
- 4.3.4.14.
- Lexical and logical SELECT clause order
- 4.3.5.
- The INSERT statement
- 4.3.5.1.
- INSERT .. VALUES
- 4.3.5.2.
- INSERT .. DEFAULT VALUES
- 4.3.5.3.
- INSERT .. SET
- 4.3.5.4.
- INSERT .. SELECT
- 4.3.5.5.
- INSERT .. ON DUPLICATE KEY UPDATE
- 4.3.5.6.
- INSERT .. ON DUPLICATE KEY IGNORE
- 4.3.5.7.
- INSERT .. ON CONFLICT
- 4.3.5.8.
- INSERT .. RETURNING
- 4.3.6.
- The UPDATE statement
- 4.3.6.1.
- UPDATE .. SET
- 4.3.6.2.
- UPDATE .. SET ROWS
- 4.3.6.3.
- UPDATE .. FROM
- 4.3.6.4.
- UPDATE .. WHERE
- 4.3.6.5.
- UPDATE .. RETURNING
- 4.3.7.
- The DELETE statement
- 4.3.7.1.
- DELETE .. WHERE
- 4.3.7.2.
- DELETE .. RETURNING
- 4.3.8.
- The MERGE statement
- 4.4.
- SQL Statements (DDL)
- 4.4.1.
- The ALTER statement
- 4.4.1.1.
- ALTER INDEX
- 4.4.1.2.
- ALTER SCHEMA
- 4.4.1.3.
- ALTER SEQUENCE
- 4.4.1.4.
- ALTER TABLE
- 4.4.1.5.
- ALTER VIEW
- 4.4.1.5.1.
- ALTER VIEW .. RENAME
- 4.4.1.5.2.
- ALTER VIEW IF EXISTS
- 4.4.2.
- The CREATE statement
- 4.4.2.1.
- CREATE INDEX
- 4.4.2.2.
- CREATE SCHEMA
- 4.4.2.3.
- CREATE SEQUENCE
- 4.4.2.4.
- CREATE TABLE
- 4.4.2.4.1.
- Columns
- 4.4.2.4.2.
- Nullability
- 4.4.2.4.3.
- Defaults
- 4.4.2.4.4.
- Identities
- 4.4.2.4.5.
- Primary key
- 4.4.2.4.6.
- Unique constraints
- 4.4.2.4.7.
- Foreign keys
- 4.4.2.4.8.
- Check constraints
- 4.4.2.4.9.
- From a SELECT
- 4.4.2.4.10.
- Temporary tables
- 4.4.2.5.
- CREATE VIEW
- 4.4.2.5.1.
- WITH CHECK OPTION
- 4.4.2.5.2.
- WITH READ ONLY
- 4.4.3.
- The DROP statement
- 4.4.3.1.
- DROP INDEX
- 4.4.3.1.1.
- IF EXISTS
- 4.4.3.2.
- DROP SCHEMA
- 4.4.3.2.1.
- IF EXISTS
- 4.4.3.3.
- DROP SEQUENCE
- 4.4.3.3.1.
- IF EXISTS
- 4.4.3.4.
- DROP TABLE
- 4.4.3.4.1.
- IF EXISTS
- 4.4.3.5.
- DROP VIEW
- 4.4.3.5.1.
- IF EXISTS
- 4.4.4.
- The TRUNCATE statement
- 4.4.5.
- Generating DDL from objects
- 4.5.
- Catalog and schema expressions
- 4.6.
- Table expressions
- 4.6.1.
- Generated Tables
- 4.6.2.
- Aliased Tables
- 4.6.2.1.
- Aliased generated tables
- 4.6.2.2.
- Aliased table expressions
- 4.6.2.3.
- Derived column lists
- 4.6.2.4.
- Unnamed derived tables
- 4.6.3.
- Joined tables
- 4.6.3.1.
- CROSS JOIN
- 4.6.3.2.
- INNER JOIN
- 4.6.3.3.
- OUTER JOIN
- 4.6.3.4.
- SEMI JOIN
- 4.6.3.5.
- ANTI JOIN
- 4.6.3.6.
- ON clause
- 4.6.3.7.
- ON KEY clause
- 4.6.3.8.
- USING clause
- 4.6.3.9.
- NATURAL clause
- 4.6.3.10.
- LATERAL
- 4.6.3.11.
- APPLY
- 4.6.3.12.
- PARTITION BY
- 4.6.4.
- The VALUES() table constructor
- 4.6.5.
- Derived tables
- 4.6.6.
- The Oracle 11g PIVOT clause
- 4.6.7.
- jOOQ's relational division syntax
- 4.6.8.
- Array and cursor unnesting
- 4.6.9.
- Table-valued functions
- 4.6.10.
- GENERATE_SERIES
- 4.6.11.
- The DUAL table
- 4.7.
- Column expressions
- 4.7.1.
- Table columns
- 4.7.1.1.
- Generated table columns
- 4.7.1.2.
- Dereferenced table columns
- 4.7.1.3.
- Named table columns
- 4.7.2.
- Aliased columns
- 4.7.3.
- Cast expressions
- 4.7.4.
- Datatype coercions
- 4.7.5.
- Arithmetic expressions
- 4.7.6.
- String concatenation
- 4.7.7.
- Case sensitivity with strings
- 4.7.8.
- General functions
- 4.7.8.1.
- COALESCE
- 4.7.8.2.
- DECODE
- 4.7.8.3.
- NULLIF
- 4.7.8.4.
- NVL
- 4.7.8.5.
- NVL2
- 4.7.9.
- Numeric functions
- 4.7.9.1.
- ABS
- 4.7.9.2.
- ACOS
- 4.7.9.3.
- ASIN
- 4.7.9.4.
- ATAN
- 4.7.9.5.
- ATAN2
- 4.7.9.6.
- CEIL
- 4.7.9.7.
- COS
- 4.7.9.8.
- COSH
- 4.7.9.9.
- COT
- 4.7.9.10.
- COTH
- 4.7.9.11.
- DEG
- 4.7.9.12.
- E
- 4.7.9.13.
- EXP
- 4.7.9.14.
- FLOOR
- 4.7.9.15.
- GREATEST
- 4.7.9.16.
- LEAST
- 4.7.9.17.
- LN
- 4.7.9.18.
- LOG
- 4.7.9.19.
- NEG
- 4.7.9.20.
- PI
- 4.7.9.21.
- POWER
- 4.7.9.22.
- RAD
- 4.7.9.23.
- RAND
- 4.7.9.24.
- ROUND
- 4.7.9.25.
- SIGN
- 4.7.9.26.
- SIN
- 4.7.9.27.
- SINH
- 4.7.9.28.
- SQRT
- 4.7.9.29.
- TAN
- 4.7.9.30.
- TANH
- 4.7.9.31.
- TRUNC
- 4.7.10.
- Bitwise functions
- 4.7.10.1.
- BIT_AND
- 4.7.10.2.
- BIT_COUNT
- 4.7.10.3.
- BIT_NAND
- 4.7.10.4.
- BIT_NOR
- 4.7.10.5.
- BIT_NOT
- 4.7.10.6.
- BIT_OR
- 4.7.10.7.
- BIT_XNOR
- 4.7.10.8.
- BIT_XOR
- 4.7.10.9.
- SHL
- 4.7.10.10.
- SHR
- 4.7.11.
- String functions
- 4.7.11.1.
- ASCII
- 4.7.11.2.
- CONCAT
- 4.7.11.3.
- LEFT
- 4.7.11.4.
- LENGTH
- 4.7.11.5.
- LOWER
- 4.7.11.6.
- LPAD
- 4.7.11.7.
- LTRIM
- 4.7.11.8.
- MD5
- 4.7.11.9.
- MID
- 4.7.11.10.
- POSITION
- 4.7.11.11.
- REPEAT
- 4.7.11.12.
- REPLACE
- 4.7.11.13.
- REVERSE
- 4.7.11.14.
- RIGHT
- 4.7.11.15.
- RPAD
- 4.7.11.16.
- RTRIM
- 4.7.11.17.
- SPACE
- 4.7.11.18.
- SUBSTRING
- 4.7.11.19.
- TRANSLATE
- 4.7.11.20.
- TRIM
- 4.7.11.21.
- UPPER
- 4.7.12.
- Datetime functions
- 4.7.12.1.
- CURRENT_DATE
- 4.7.12.2.
- CURRENT_LOCALDATE
- 4.7.12.3.
- CURRENT_LOCALDATETIME
- 4.7.12.4.
- CURRENT_LOCALTIME
- 4.7.12.5.
- CURRENT_OFFSETDATETIME
- 4.7.12.6.
- CURRENT_OFFSETTIME
- 4.7.12.7.
- CURRENT_TIME
- 4.7.12.8.
- CURRENT_TIMESTAMP
- 4.7.12.9.
- DATE
- 4.7.12.10.
- DATEADD
- 4.7.12.11.
- DATEDIFF
- 4.7.12.12.
- DATESUB
- 4.7.12.13.
- DAY
- 4.7.12.14.
- EXTRACT
- 4.7.12.15.
- HOUR
- 4.7.12.16.
- LOCALDATE
- 4.7.12.17.
- LOCALDATETIME
- 4.7.12.18.
- LOCALTIME
- 4.7.12.19.
- MINUTE
- 4.7.12.20.
- MONTH
- 4.7.12.21.
- SECOND
- 4.7.12.22.
- TIME
- 4.7.12.23.
- TIMESTAMP
- 4.7.12.24.
- TIMESTAMPADD
- 4.7.12.25.
- TO_DATE
- 4.7.12.26.
- TO_LOCALDATE
- 4.7.12.27.
- TO_LOCALDATETIME
- 4.7.12.28.
- TO_TIMESTAMP
- 4.7.12.29.
- TRUNC
- 4.7.12.30.
- YEAR
- 4.7.13.
- ARRAY functions
- 4.7.13.1.
- ARRAY constructor
- 4.7.14.
- System functions
- 4.7.14.1.
- CURRENT_SCHEMA
- 4.7.14.2.
- CURRENT_USER
- 4.7.15.
- Aggregate functions
- 4.7.15.1.
- Grouping
- 4.7.15.2.
- Distinctness
- 4.7.15.3.
- Filtering
- 4.7.15.4.
- Ordering
- 4.7.15.5.
- Ordering WITHIN GROUP
- 4.7.15.6.
- Keeping
- 4.7.15.7.
- ARRAY_AGG
- 4.7.15.8.
- AVG
- 4.7.15.9.
- BOOL_AND
- 4.7.15.10.
- BOOL_OR
- 4.7.15.11.
- COLLECT
- 4.7.15.12.
- COUNT
- 4.7.15.13.
- CUME_DIST
- 4.7.15.14.
- DENSE_RANK
- 4.7.15.15.
- EVERY
- 4.7.15.16.
- GROUP_CONCAT
- 4.7.15.17.
- LISTAGG
- 4.7.15.18.
- MAX
- 4.7.15.19.
- MEDIAN
- 4.7.15.20.
- MIN
- 4.7.15.21.
- MODE
- 4.7.15.22.
- PERCENT_RANK
- 4.7.15.23.
- PERCENTILE_CONT
- 4.7.15.24.
- PERCENTILE_DISC
- 4.7.15.25.
- PRODUCT
- 4.7.15.26.
- RANK
- 4.7.15.27.
- SUM
- 4.7.16.
- Window functions
- 4.7.16.1.
- PARTITION BY
- 4.7.16.2.
- ORDER BY
- 4.7.16.3.
- ROWS, RANGE, GROUPS (frame clause)
- 4.7.16.4.
- EXCLUDE
- 4.7.16.5.
- NULL treatment
- 4.7.16.6.
- FROM FIRST, FROM LAST
- 4.7.16.7.
- Nested aggregate functions
- 4.7.16.8.
- Window aggregation
- 4.7.16.9.
- Window ordered aggregate
- 4.7.16.10.
- ROW_NUMBER
- 4.7.16.11.
- RANK
- 4.7.16.12.
- DENSE_RANK
- 4.7.16.13.
- PERCENT_RANK
- 4.7.16.14.
- CUME_DIST
- 4.7.16.15.
- NTILE
- 4.7.16.16.
- LEAD
- 4.7.16.17.
- LAG
- 4.7.16.18.
- FIRST_VALUE
- 4.7.16.19.
- LAST_VALUE
- 4.7.16.20.
- NTH_VALUE
- 4.7.17.
- Grouping functions
- 4.7.18.
- User-defined functions
- 4.7.19.
- User-defined aggregate functions
- 4.7.20.
- The CASE expression
- 4.7.21.
- Sequences and serials
- 4.7.22.
- Scalar subqueries
- 4.7.23.
- Tuples or row value expressions
- 4.8.
- Conditional expressions
- 4.8.1.
- Condition building
- 4.8.2.
- TRUE and FALSE condition
- 4.8.3.
- BOOLEAN columns
- 4.8.4.
- AND, OR, NOT boolean operators
- 4.8.5.
- Comparison predicate
- 4.8.6.
- Boolean operator precedence
- 4.8.7.
- Comparison predicate (degree > 1)
- 4.8.8.
- Quantified comparison predicate
- 4.8.9.
- NULL predicate
- 4.8.10.
- NULL predicate (degree > 1)
- 4.8.11.
- DISTINCT predicate
- 4.8.12.
- BETWEEN predicate
- 4.8.13.
- BETWEEN predicate (degree > 1)
- 4.8.14.
- LIKE predicate
- 4.8.15.
- IN predicate
- 4.8.16.
- IN predicate (degree > 1)
- 4.8.17.
- EXISTS predicate
- 4.8.18.
- OVERLAPS predicate
- 4.8.19.
- Query By Example (QBE)
- 4.9.
- Operator precedence
- 4.10.
- Synthetic SQL clauses
- 4.11.
- Dynamic SQL
- 4.12.
- Plain SQL
- 4.13.
- Plain SQL Templating Language
- 4.14.
- Hints
- 4.14.1.
- MySQL hints
- 4.14.1.1.
- Index hints
- 4.14.1.2.
- STRAIGHT_JOIN
- 4.14.1.3.
- Oracle style hints in MySQL
- 4.14.2.
- Oracle hints
- 4.14.3.
- SQL Server hints
- 4.14.3.1.
- WITH
- 4.14.3.2.
- OPTION
- 4.15.
- Names and identifiers
- 4.16.
- Bind values and parameters
- 4.16.1.
- Indexed parameters
- 4.16.2.
- Named parameters
- 4.16.3.
- Inlined parameters
- 4.16.4.
- SQL injection
- 4.17.
- QueryParts
- 4.17.1.
- SQL rendering
- 4.17.2.
- Declaration vs reference
- 4.17.3.
- Pretty printing SQL
- 4.17.4.
- Variable binding
- 4.17.5.
- Custom data type bindings
- 4.17.6.
- Custom syntax elements
- 4.17.7.
- Plain SQL QueryParts
- 4.17.8.
- Serializability
- 4.17.9.
- Custom SQL transformation with VisitListener
- 4.17.9.1.
- Example: Logging abbreviated bind values
- 4.18.
- SQL Parser
- 4.19.
- Zero-based vs one-based APIs
- 4.20.
- SQL building in Scala
- 5.
- SQL execution
- 5.1.
- Comparison between jOOQ and JDBC
- 5.2.
- Query vs. ResultQuery
- 5.3.
- Fetching
- 5.3.1.
- Record vs. TableRecord
- 5.3.2.
- Record1 to Record22
- 5.3.3.
- Arrays, Maps and Lists
- 5.3.4.
- RecordHandler
- 5.3.5.
- RecordMapper
- 5.3.6.
- POJOs
- 5.3.7.
- POJOs with RecordMappers
- 5.3.8.
- Lazy fetching
- 5.3.9.
- Lazy fetching with Streams
- 5.3.10.
- Many fetching
- 5.3.11.
- Later fetching
- 5.3.12.
- ResultSet fetching
- 5.3.13.
- Auto data type conversion
- 5.3.14.
- Custom data type conversion
- 5.4.
- Static statements vs. Prepared Statements
- 5.5.
- Reusing a Query's PreparedStatement
- 5.6.
- JDBC flags
- 5.7.
- Using JDBC batch operations
- 5.8.
- Sequence execution
- 5.9.
- Stored procedures and functions
- 5.9.1.
- Oracle Packages
- 5.9.2.
- Oracle member procedures
- 5.10.
- Exporting to XML, CSV, JSON, HTML, Text
- 5.10.1.
- Exporting XML
- 5.10.2.
- Exporting CSV
- 5.10.3.
- Exporting JSON
- 5.10.4.
- Exporting HTML
- 5.10.5.
- Exporting Text
- 5.11.
- Importing data
- 5.11.1.
- The Loader API
- 5.11.2.
- Import options
- 5.11.2.1.
- Throttling
- 5.11.2.2.
- Duplicate handling
- 5.11.2.3.
- Error handling
- 5.11.3.
- Import data sources
- 5.11.3.1.
- Importing CSV
- 5.11.3.2.
- Importing JSON
- 5.11.3.3.
- Importing records
- 5.11.3.4.
- Importing arrays
- 5.11.3.5.
- Importing XML
- 5.11.4.
- Import listeners
- 5.11.5.
- Import result and error handling
- 5.12.
- CRUD with UpdatableRecords
- 5.12.1.
- Simple CRUD
- 5.12.2.
- Records' internal flags
- 5.12.3.
- IDENTITY values
- 5.12.4.
- Navigation methods
- 5.12.5.
- Non-updatable records
- 5.12.6.
- Optimistic locking
- 5.12.7.
- Batch execution
- 5.12.8.
- CRUD SPI: RecordListener
- 5.13.
- DAOs
- 5.14.
- Transaction management
- 5.15.
- Exception handling
- 5.16.
- ExecuteListeners
- 5.17.
- Database meta data
- 5.17.1.
- JDBC meta data
- 5.17.2.
- XML meta data
- 5.18.
- JDBC Connection
- 5.19.
- Logging with LoggerListener
- 5.20.
- Performance considerations
- 5.21.
- Alternative execution models
- 5.21.1.
- Using jOOQ with Spring's JdbcTemplate
- 5.21.2.
- Using jOOQ with JPA
- 5.21.2.1.
- Using jOOQ with JPA Native Query
- 5.21.2.2.
- Using jOOQ with JPA entities
- 5.21.2.3.
- Using jOOQ with JPA EntityResult
- 6.
- Code generation
- 6.1.
- Configuration and setup of the generator
- 6.2.
- Advanced generator configuration
- 6.2.1.
- Logging
- 6.2.2.
- Jdbc
- 6.2.3.
- Generator
- 6.2.4.
- Database
- 6.2.4.1.
- Database name and properties
- 6.2.4.2.
- RegexFlags
- 6.2.4.3.
- Includes and Excludes
- 6.2.4.4.
- Include object types
- 6.2.4.5.
- Record Version and Timestamp Fields
- 6.2.4.6.
- Synthetic identities
- 6.2.4.7.
- Synthetic primary keys
- 6.2.4.8.
- Override primary keys
- 6.2.4.9.
- Date as timestamp
- 6.2.4.10.
- Ignore procedure return values (deprecated)
- 6.2.4.11.
- Unsigned types
- 6.2.4.12.
- Catalog and schema mapping
- 6.2.4.13.
- Catalog and schema version providers
- 6.2.4.14.
- Forced types
- 6.2.4.14.1.
- Matching of forced types
- 6.2.4.14.2.
- Data type rewriting
- 6.2.4.14.3.
- Qualified converters
- 6.2.4.14.4.
- Inline converters
- 6.2.4.14.5.
- Data type bindings
- 6.2.4.15.
- Table valued functions
- 6.2.5.
- Generate
- 6.2.5.1.
- Annotations
- 6.2.5.2.
- Covariant overrides
- 6.2.5.2.1.
- Overriding as()
- 6.2.5.2.2.
- Overriding rename()
- 6.2.5.3.
- Default catalog and schema
- 6.2.5.4.
- Fluent setters
- 6.2.5.5.
- Fully Qualified Types
- 6.2.5.6.
- Global Artefacts
- 6.2.5.7.
- Java Time Types
- 6.2.6.
- Output target configuration
- 6.3.
- Programmatic generator configuration
- 6.4.
- Custom generator strategies
- 6.5.
- Matcher strategies
- 6.5.1.
- MatcherRule
- 6.5.2.
- Matching schemas
- 6.5.3.
- Matching tables
- 6.5.4.
- Matching fields
- 6.5.5.
- Matching routines
- 6.5.6.
- Matching sequences
- 6.5.7.
- Matcher examples
- 6.6.
- Custom code sections
- 6.7.
- Generated global artefacts
- 6.8.
- Generated tables
- 6.9.
- Generated records
- 6.10.
- Generated POJOs
- 6.11.
- Generated Interfaces
- 6.12.
- Generated DAOs
- 6.13.
- Generated sequences
- 6.14.
- Generated procedures
- 6.15.
- Generated UDTs
- 6.16.
- Mapping generated catalogs and schemas
- 6.17.
- Code generation for large schemas
- 6.18.
- Code generation and version control
- 6.19.
- JPADatabase: Code generation from entities
- 6.20.
- XMLDatabase: Code generation from XML files
- 6.21.
- XMLGenerator: Generating XML
- 6.22.
- Running the code generator with Maven
- 6.23.
- Running the code generator with Ant
- 6.24.
- Running the code generator with Gradle
- 6.25.
- Features requiring generated code
- 7.
- Tools
- 7.1.
- JDBC mocking for unit testing
- 7.2.
- API validation using the Checker Framework or Error Prone
- 7.3.
- jOOQ Console
- 8.
- Coming from JPA
- 8.1.
- Set based thinking
- 8.2.
- Database first
- 8.3.
- Eager or lazy loading
- 8.4.
- First level cache and second level cache
- 8.5.
- AttributeConverter
- 8.6.
- User types
- 9.
- Reference
- 9.1.
- Supported RDBMS
- 9.2.
- Commercial only features
- 9.3.
- Experimental features
- 9.4.
- Data types
- 9.4.1.
- BLOBs and CLOBs
- 9.4.2.
- BOOLEAN data type
- 9.4.3.
- Unsigned integer types
- 9.4.4.
- INTERVAL data types
- 9.4.5.
- XML data types
- 9.4.6.
- Geospatial data types
- 9.4.7.
- CURSOR data types
- 9.4.8.
- ARRAY and TABLE data types
- 9.4.9.
- Oracle DATE data type
- 9.5.
- SQL to DSL mapping rules
- 9.6.
- Quality Assurance
- 9.7.
- Security
- 9.7.1.
- SQL Injection
- 9.7.2.
- Debug logging
- 9.7.3.
- Exception message
- 9.7.4.
- Contact
- 9.8.
- Migrating to jOOQ 3.0
- 9.9.
- Don't do this
- 9.9.1.
- jOOQ: Implementing the DSL types
- 9.9.2.
- jOOQ: Referencing the Step types
- 9.9.3.
- Schema: NULL columns
- 9.9.4.
- Schema: Unnamed constraints
- 9.9.5.
- Schema: Unnecessary surrogate keys
- 9.9.6.
- Schema: Wrong data types
- 9.9.7.
- SQL: COUNT(*) instead of EXISTS()
- 9.9.8.
- SQL: N+1
- 9.9.9.
- SQL: NOT IN predicate
- 9.9.10.
- SQL: Rely on implicit ordering
- 9.9.11.
- SQL: SELECT *
- 9.9.12.
- SQL: SELECT DISTINCT
- 9.9.13.
- SQL: Unnecessary UNION instead of UNION ALL
- 9.10.
- The most important jOOQ types
- 9.11.
- Credits
next |
Feedback
Do you have any feedback about this page? We'd love to hear it!