Starting with jOOQ 3.19, implicit path joins may skip unnecessary tables in the join tree, when no columns are referenced from those tables| Java, SQL and jOOQ.
"can't specify target table for update in FROM clause" is an annoying limitation in MySQL, for which jOOQ automatically implements a workaround.| Java, SQL and jOOQ.
Most serious data centric applications will quickly find DAOs or repositories insufficient. This is when jOOQ really shines with all its SQL support.| Java, SQL and jOOQ.
The simplest way to integration test your stored procedures is with jOOQ and testcontainers| Java, SQL and jOOQ.
Using H2 as a test database vs integration testing directly on your production RDBMS| Java, SQL and jOOQ.
A lot of RDBMS support standard SQL sequences of some form. The standard SQL syntax to create a sequence is: CREATE SEQUENCE s; The following is how you could fetch a value from this sequence, usin…| Java, SQL and jOOQ.
jOOQ's code generator generates powerful stubs to type safely call stored procedures on all supported RDBMS, as if the procedure were a local method| Java, SQL and jOOQ.
This article shows a simple example configuration of the jOOQ code generator for keeping generated output in a single package, and making it package private| Java, SQL and jOOQ.
The jOOQ API is all about convenience, and as such, an important operation (the most important one?) like fetch() must come with convenience, too. The default way to fetch data is this: Result| Java, SQL and jOOQ.
A really cool, recent question on Stack Overflow was about how to map a nested collection into a Java Map with jOOQ. In the past, I’ve blogged about the powerful MULTISET operator many times,…| Java, SQL and jOOQ.
Using jOOQ's code generator, it is very easy to call a stored function accepting a table-valued parameter in SQL Server from your Java application.| Java, SQL and jOOQ.