jOOQ effectively combines complex SQL, type safety, source code generation, active records, stored procedures, advanced data types, and Java in a fluent, intuitive DSL.


The main improvement in this release is the redesign of the stored procedure/function API. With 12 supported RDBMS, which all have their own idea about what is a stored procedure and what is a stored function, it has proven to be a better design to unite them in one single type, org.jooq.Routine. A routine can have a return value as well as OUT parameters. It can be embedded in SQL and used as a field or a table.

URL: jOOQ - jOOQ : A peace treaty between SQL and Java