Blog: jooq (Lukas Eder)

232 blogs updated: 107 min. ago show: latest top this week top this month search:

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... 9 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... 9 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... 7 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... 9 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 ... 0 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 ... 11 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... 6 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... 11 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... 16 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... 7 08-02-2022 16:32:23 jooq (Lukas Eder) Advanced

load next 10 items

© 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 https://www.yourkit.com/ Java Profiler