Reference

Supported by ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

These chapters hold some general jOOQ reference information

Table of contents

8.1.

Modules

8.1.1.

jOOQ module

8.1.2.

jOOQ-beans-extensions module

8.1.3.

jOOQ-bom module

8.1.4.

jOOQ-checker module

8.1.5.

jOOQ-codegen module

8.1.6.

jOOQ-codegen-gradle module

8.1.7.

jOOQ-codegen-maven module

8.1.8.

jOOQ-jackson-extensions module

8.1.9.

jOOQ-jpa-extensions module

8.1.10.

jOOQ-kotlin module

8.1.11.

jOOQ-kotlin-coroutines module

8.1.12.

jOOQ-meta module

8.1.13.

jOOQ-meta-extensions module

8.1.14.

jOOQ-meta-extensions-hibernate module

8.1.15.

jOOQ-meta-extensions-liquibase module

8.1.16.

jOOQ-meta-kotlin module

8.1.17.

jOOQ-postgres-extensions module

8.1.18.

jOOQ-reactor-extensions module

8.1.19.

jOOQ-scala module

8.1.20.

jOOQ-xtend module

8.2.

Supported RDBMS

8.3.

Commercial only features

8.4.

Experimental features

8.5.

SQL to DSL mapping rules

8.6.

Quality Assurance

8.7.

Security

8.7.1.

SQL Injection

8.7.2.

Debug logging

8.7.3.

Redacted columns (new)

8.7.4.

Exception message

8.7.5.

Contact

8.8.

Migrating to jOOQ 3.0

8.9.

Don't do this

8.9.1.

jOOQ: Implementing the DSL types

8.9.2.

jOOQ: Referencing the Step types

8.9.3.

Schema: NULL columns

8.9.4.

Schema: Unnamed constraints

8.9.5.

Schema: Unnecessary surrogate keys

8.9.6.

Schema: Wrong data types

8.9.7.

SQL: COUNT(*) instead of EXISTS()

8.9.8.

SQL: N+1

8.9.9.

SQL: NATURAL JOIN or JOIN USING

8.9.10.

SQL: NOT IN predicate

8.9.11.

SQL: ORDER BY [column index]

8.9.12.

SQL: Rely on implicit ordering

8.9.13.

SQL: SELECT *

8.9.14.

SQL: SELECT DISTINCT

8.9.15.

SQL: Unnecessary UNION instead of UNION ALL

8.10.

The most important jOOQ types

8.11.

Credits