Blog: jooq (Lukas Eder)

232 blogs updated: 107 min. ago
Setting the JDBC Statement.setFetchSize() to 1 for Single Row Queries
An interesting hint by Vladimir Sitnikov has made me think about a new benchmark for jOOQ: The benchmark should check whether single row que...
11-05-2022 11:08:50 jooq (Lukas Eder) Advanced
How to Typesafely Map a Nested SQL Collection into a Nested Java Map with 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 blogg...
09-05-2022 12:42:09 jooq (Lukas Eder) Advanced
A Quick and Dirty Way to Concatenate Two Vaguely Related Tables in SQL
Every now and then I run across a use case for the arcane NATURAL JOIN SQL operator, and I'm even more delighted when I can make that a NATU...
04-05-2022 10:13:18 jooq (Lukas Eder) Advanced
Nested Transactions in jOOQ
Since jOOQ 3.4, we have an API that simplifies transactional logic on top of JDBC in jOOQ, and starting from jOOQ 3.17 and #13502, an equiva...
28-04-2022 18:13:12 jooq (Lukas Eder) Advanced
How to Fetch Sequence Values with jOOQ
A lot of RDBMS support standard SQL sequences of some form. The standard SQL syntax to create a sequence is: The following is how you could ...
01-03-2022 14:59:02 jooq (Lukas Eder) Advanced
Various Meanings of SQL's PARTITION BY Syntax
For SQL beginners, there's a bit of an esoteric syntax named PARTITION BY, which appears all over the place in SQL. It always has a similar ...
24-02-2022 15:44:28 jooq (Lukas Eder) Advanced
Use MULTISET Predicates to Compare Data Sets
Questions that might be a bit more difficult to solve using ordinary SQL are questions of the kind: What films have the same actors as a giv...
22-02-2022 15:01:05 jooq (Lukas Eder) Advanced
Projecting Type Safe Nested TableRecords with jOOQ 3.17
A long standing feature request has seen little love from the jOOQ community, despite a lot of people probably wanting it. It goes by the un...
21-02-2022 14:55:36 jooq (Lukas Eder) Advanced
jOOQ 3.16 and Java EE vs Jakarta EE
A tidal wave is rippling through the Java ecosystem. It is the renaming of javax to jakarta package names. Now, while we've all been whining...
14-02-2022 10:56:45 jooq (Lukas Eder) Advanced
No More MultipleBagFetchException Thanks to Multiset Nested Collections
I've recently stumbled upon this interesting Stack Overflow question about Hibernate's popular MultipleBagFetchException . The question is s...
08-02-2022 16:32:23 jooq (Lukas Eder) Advanced

© Jiri Pinkas | this project on GitHub | related: JavaVids | Maven Central Repository Search | Java školení

Top Java Blogs is a Java blog aggregator (with English-written blogs only) focused on Java SE, Java EE, Spring Framework and Hibernate.

Made better & faster using Java Profiler