jOOQ 3.1.0 / 3.2.0 Alpha 01

A tool for Java database object oriented querying
It combines active records, stored procedures, advanced data types, complex SQL, typesafety, source code generation and Java in a fluent, intuitive DSL.

jOOQ generates a simple Java representation of the database schema.

For every table, view, stored procedure, enum, UDT is a class.

jOOQ implements an easy-to-use active record pattern. It is NOT an OR-mapper, but provides a 1:1 mapping between tables/views and classes. Between columns and members.

It also allows for writing compile-time typesafe querying using its built-in DSL.

jOOQ supports all standard SQL language features including the more complex UNION's, nested SELECTs, JOINs, aliasing

jOOQ allows developers the use of vendor-specific extensions such as stored procedures, UDT's, ARRAY's and many more.

Main features:

  • General features:
  • Object Oriented SQL Modelling
  • SQL code generation
  • OR-Mapping
  • Typesafe SQL
  • Stored procedure and UDT support
  • Supported databases:
  • MySQL 5.1.41 and 5.5.8
  • H2 1.3.154
  • Oracle XE
  • DB2 9.7
  • PostgreSQL 9.0
  • HSQLDB 2.0.0
  • SQLite with inofficial JDBC driver v056
  • Derby 10.7
  • Sybase
  • Future support for:
  • Ingres
  • Firebird

last updated on:
August 29th, 2013, 8:16 GMT
developed by:
Lukas Eder
license type:

Apache License

operating system(s):
Windows / Linux / Mac OS / BSD / Solaris
C: \ Database Tools
Download Button

In a hurry? Add it to your Download Basket!

user rating 3



Rate it!
What's New in version 3.0.0
  • Factory has been split into DSL (static QueryPart construction) and DSLContext (Query execution, "attached" QueryPart construction). This greatly improves the overall DSL experience while allowing for more fine-grained Executor lifecycle control.
  • A ConnectionProvider has been introduced as an abstraction of the JDBC Connection lifecycle. The standalone Connection and pooled DataSource modes are still supported, but you can now inject your own ConnectionProvider for more control.
  • A lot of performance improvements have been implemented within the jOOQ API removing most of the overhead caused by jOOQ when fetching data from JDBC
  • A JDBC Mock API has been added to help you create simple unit tests for your application built on top of jOOQ.
read full changelog

Add your review!