jOOQ (Java Object Oriented Querying) is an open source Java software that features code generation capabilities, active records, typesafe SQL, SQL standard, as well as vendor-specific feature support.
JOOQ supports the following databases CUBRID 8.4.1 and 9.0.0, DB2 9.7, Derby 10.8, Firebird 2.5.1, H2 1.3.161, HSQLDB 2.2.5, Ingres 10.1.0, MySQL 5.1.41 and 5.5.8, Oracle XE 10.2.0.1.0 and 11g, PostgreSQL 9.0, SQLite with inofficial JDBC driver version 056, SQL Server 2008 R8 and 2012, Sybase Adaptive Server Enterprise 15.5 and Sybase SQL Anywhere 12.
Product's homepage
Requirements:
· Java 2 Standard Edition Runtime Environment
What's New in This Release: [ read full changelog ]
· This major release is a great move towards better integration of SQL as a language in Java. Unlike any other database abstraction framework, jOOQ now formally supports the notion of "row value expressions". The jOOQ API uses Xtend-generated API types from Row1 .. Row22, as well as Record1 .. Record22 to bring you even more compile-time typesafety on a record-level.