Don't do this

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

Like any software, jOOQ has a few pitfalls, known issues, historic design flaws, etc., which the seasoned jOOQ developer should know to avoid. This section summarises both of jOOQ's and SQL's own pitfalls.

Table of contents

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: Unnecessary UNION instead of UNION ALL