jOOQ effectively combines complex SQL, type safety, source code generation, active records, stored procedures, advanced data types, and Java in a fluent, intuitive DSL.
Information regarding Project Releases and Project Resources. Note that the information here is a quote from Freecode.com page, and the downloads themselves may not be hosted on OSDN.
This is a maintenance release for the 1.x branch. Developments on this branch will stop after version 1.6.9. Only important bugfixes are merged to this branch. Developments for release 2.0 have started.
The most important functionality in release 1.6.9 is newly-added support for JDBC batch operations. You can now batch execute several queries.
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.
This release coincides with the launch of the new Web site. Hence, it ships with little additions to the deliverable itself. Apart from new convenience methods, the main addition is a Maven plugin for jooq-codegen.
Finally, support for another RDBMS has been added. Sybase's other
important product, Sybase Adaptive Server Enterprise (or simply Sybase
ASE), is now officially supported by jOOQ. Apart from this, there were
important improvements with the recently-added INSERT .. RETURNING
clause, as well as some fixes related to DECIMAL/NUMERIC data types.
This release finally adds a loader for CSV data to jOOQ. You can now load CSV data using a simple fluent API, configuring error handling, duplicate behaviour and transaction handling, and various CSV parameters. This release also changes the way generated keys are retrieved after INSERTs. Instead of (potentially inconsistently) running SELECT MAX(pk) immediately after the INSERT, PostgreSQL's INSERT.. RETURNING clause is used (or simulated) in a single statement.
