blog.jooq.orgadded August 2026
Java, SQL and jOOQ.by lukaseder4 Nov 2022
The standard SQL WITH clause has been tremendously helpful in structuring SQL queries. Instead of nesting everything in unreadable derived tables like this: SELECT actor_id, name, COUNT(*) FROM (...
Java, SQL and jOOQ.by lukaseder21 Oct 2022
Using jOOQ’s code generator to call stored procedures is a popular reason to use jOOQ. For example, when you have a procedure like the following Oracle PL/SQL procedure: CREATE OR REPLACE PROCEDURE...
Java, SQL and jOOQ.by lukaseder13 Sept 2022
Starting with jOOQ 3.11, type safe implicit JOIN have been made available, and they’ve been enhanced to be supported also in DML statements in jOOQ 3.17.
Java, SQL and jOOQ.by lukaseder6 Sept 2022
For new users working with jOOQ for the first time, the number of types in the jOOQ API can be overwhelming.
Java, SQL and jOOQ.by lukaseder30 Aug 2022
I’ve just stumbled upon this great post by Vlad Mihalcea, titled The Best Way to Fetch a Spring Data JPA DTO Projection. It got some nice traction on reddit, too.
Java, SQL and jOOQ.by lukaseder30 Aug 2022
Starting with jOOQ 3.16 and #12601, there may be a compilation error with a message like this in your jOOQ generated code: [ERROR] …/DefaultCatalog.java:[53,73] cannot find symbol [ERROR] symbol...
Java, SQL and jOOQ.by lukaseder25 Aug 2022
Since jOOQ 3.11, implicit joins have been supported. An implicit join is a JOIN (mostly a LEFT JOIN) that is generated implicitly because of the presence of a path expression.
Java, SQL and jOOQ.by lukaseder24 Aug 2022
Starting with jOOQ 3.17, the Condition type extends the Field<Boolean> type. Because, that’s what the SQL standard thinks it is, in sorts: <boolean value expression> ::= <predicate> The exact...
Java, SQL and jOOQ.by lukaseder23 Aug 2022
Probably the hardest thing to standardise in SQL is RETURNING data from DML statements. In this article, we’ll look at various ways of doing that with jOOQ, in many of jOOQ’s supported dialects...
Java, SQL and jOOQ.by lukaseder22 Aug 2022
When you write stored procedures and functions in your database, you want to ensure their correctness, just like with your Java code. In Java, this is done with unit tests, typically with JUnit.
Java, SQL and jOOQ.by lukaseder19 Aug 2022
The H2 database is an immensely popular in-memory database product mostly used by Java developers for testing.
Java, SQL and jOOQ.by lukaseder28 Jul 2022
jOOQ is mainly known for its powerful type safe, embedded, dynamic SQL capabilities that are made available through code generation.
Java, SQL and jOOQ.by lukaseder22 Jun 2022
This release contiues the work from previous releases around more sophisticated SQL transformation capabilities, including: - Client side computed columns for both read and write operations - Audit...
Java, SQL and jOOQ.by lukaseder10 Jun 2022
I stumbled upon a very interesting question on Stack Overflow about how to use jOOQ’s MULTISET operator to nest a collection, and then filter the result by whether that nested collection contains a...
Java, SQL and jOOQ.by lukaseder9 Jun 2022
It’s been a while since jOOQ 3.15 has been released with its revolutionary standard SQL MULTISET emulation feature.
Java, SQL and jOOQ.by lukaseder31 May 2022
Every now and then, I see folks lament the SQL syntax’s peculiar disconnect between - the lexical order of operations (SELECT .. FROM ) - the logical order of operations (FROM ..
Java, SQL and jOOQ.by lukaseder19 May 2022
The jOOQ API is all about convenience, and as such, an important operation (the most important one?) like fetch() must come with convenience, too.
Java, SQL and jOOQ.by lukaseder11 May 2022
An interesting hint by Vladimir Sitnikov has made me think about a new benchmark for jOOQ: The benchmark should check whether single row queries should have a JDBC Statement.setFetchSize(1) call...
6%