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.7.1.

Schema: Unnecessary surrogate keys

9.7.2.

SQL: NOT IN predicate

9.7.3.

SQL: SELECT *

9.7.4.

SQL: N+1

9.7.5.

jOOQ: Referencing the Step types