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

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