jOOQ 3.6.0

A free and open source Java database that supports a wide array of formats and combines SQL and source code generation features.

  Add it to your Download Basket!

 Add it to your Watch List!


Rate it!

What's new in jOOQ 3.6.0:

  • We've been working hard to add support for our 18th database dialect: SAP HANA,
  • which is now officially supported by the jOOQ Enterprise Edition. HANA is SAP's
  • excellent Big Data offering, supporting column stores combined with the power of
  • SQL standard OLAP functionality, such as window functions. Integrate HANA into
Read full changelog
send us
an update
13.3 MB
Lukas Eder
Home \ Developer Tools
1 jOOQ Screenshot:
jOOQ effectively combines complex SQL, typesafety, source code generation, active records, stored procedures, UDTs, and Java in a fluent API.

Supported DBs are DB2, HSQLDB, MySQL, Oracle, Derby, Ingres, H2, Postgres, SQLite, SQL Server, Sybase.

How does jOOQ help you?

· Your database always comes FIRST! That's where the real schema is, not in Java code or some XML mapping file, whose syntax you're not familiar with.
· You keep your code DRY.
· You won't suffer from the Object-relational impedance mismatch.
· You won't have syntax errors in your query.
· You won't forget to bind variables correctly. No SQL injection, either.
· You don't need to know your database schema by heart when you develop. The schema is generated in Java. You can use auto-completion in your IDE!
· You don't need to create value objects for your data. Use the generated artifacts instead.
· You have automatic type mapping between SQL data types and Java types.
· You change something in the database? Your Java code won't compile. You don't need to wait until runtime to notice.
· You can forget about JDBC (especially useful when dealing with UDTs, ARRAYs and stored procedures).
· You can port your SQL to a new database. jOOQ will generate SQL that works on any database.

Last updated on February 24th, 2015

Runs on: Mac OS X (-)

feature list requirements

#database query #database API #query database #query #database #API #UDT

Add your review!