Reference

Applies to ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

These chapters hold some general jOOQ reference information

Table of contents

8.1.

Supported RDBMS

8.2.

Commercial only features

8.3.

Experimental features

8.4.

Data types

8.4.1.

BLOBs and CLOBs

8.4.2.

BOOLEAN data type

8.4.3.

Unsigned integer types

8.4.4.

INTERVAL data types

8.4.5.

JSON data types (new)

8.4.6.

XML data types

8.4.7.

Geospatial data types

8.4.8.

CURSOR data types

8.4.9.

ARRAY and TABLE data types

8.4.10.

Oracle DATE data type

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.

Exception message

8.7.4.

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