Nested Transactions in jOOQ – Java, SQL and 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 equivalent API will also be made available on top of ...
Java
The Many Different Ways to Fetch Data in jOOQ – 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: ...
The Performance of Various To-Many Nesting Algorithms – 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 ...
Create Dynamic Views with jOOQ 3.17’s new Virtual Client Side Computed Columns – Java, SQL and jOOQ.
One of jOOQ 3.17‘s coolest new features are client side computed columns. jOOQ 3.16 already added support for server side computed columns, which many of you appreciate for various reasons. ...
How to create hierarchies of Java objects from flat lists with Collector
Occasionally, you want to write a SQL query and fetch a hierarchy of data, whose flat representation may look like this: SELECT id, parent_id, label FROM t_directory; The result might ...
Use jOOQ’s code generator to easily pass table-valued parameters
Microsoft T-SQL supports a language feature called table-valued parameter (TVP), which is a parameter of a table type that can be passed to a stored procedure or function. For example, you ...
The JDBC driver Maven Central coordinates for the most popular RDBMS
Do you need to add a JDBC driver to your application, and don’t know its Maven coordinates? This blog post lists the most popular drivers from the jOOQ integration tests. Look up the ...
jOOQ 3.19 offers many new and useful path based join features
jOOQ 3.19 finally delivers on a set of features that will greatly simplify your queries further, after jOOQ 3.11 introduced implicit to-one joins: What are these features? Many ORMs ...
Implicit path joins may now skip unnecessary tables in the join tree
One of jOOQ’s key features so far has always been to render pretty much exactly the SQL that users expect, without any surprises – unless some emulation is required to make a query work, of ...
A Complete Tutorial and Examples – SitePoint
Collections in Java form the backbone of efficient data management and manipulation. Whether you’re handling a collection list in Java for small-scale tasks or managing vast datasets, Java ...
Show next