Every product manager knows this situation: This is such a common pattern, and while it’s perfectly understandable for such a user to request this, it is so terribly wrong to give in to this user’s request. Why is it wrong? The features are unrelated Most of the time, the two features X1 and X2 are … Continue reading Resisting the Urge to Document Everything Everywhere→| Java, SQL and jOOQ.
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.
jOOQ 3.19 supports explicit path joins, to-many path joins, and implicit join path correlation to greatly simplify your SQL queries| 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.
jOOQ 3.17 supports the powerful path expressions / implicit JOIN also in UPDATE and DELETE| Java, SQL and jOOQ.
Every SQL dialect and JDBC driver works a bit differently when it comes to fetching generated keys| 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.
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 cont…| Java, SQL and jOOQ.
It’s been a while since jOOQ 3.15 has been released with its revolutionary standard SQL MULTISET emulation feature. A thing that has been long overdue and which I promised on twitter a few ti…| Java, SQL and jOOQ.
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 .. SELECT) Most rece…| 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.