jOOQ 2.5.1

Developer: Website: License / Price: Platforms: Databases: Language: Last Updated: Category: Lukas Eder | More scripts sourceforge.net Apache License  Windows / Linux / Mac OS / BSD / Solaris MSSQL / MySQL / PostgreSQL / Oracle / Access / Flat file Java September 27th, 2012, 02:33 GMT [view history] C: \ Database Tools

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.

Here are some key features of "jOOQ":

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 10.2.0.1.0
· DB2 9.7
· PostgreSQL 9.0
· HSQLDB 2.0.0
· SQLite with inofficial JDBC driver v056
· Derby 10.7
· MSSQL
· Sybase

Future support for:
· Ingres
· Firebird

Requirements:

· Java 1.6 or higher

What's New in This Release: [ read full changelog ]

· Remove casting of bind values in Ingres
· Simulate RPAD and LPAD in SQLite
· Add support for Oracle Text functions
· Add option to generate immutable pojos
· Support "optimistic locking" in UpdatableRecord.store() and delete()
· Generate fetchBy[ColumnName] methods in generated DAO classes
· Add some Javadoc to document the difference between using a Factory with a Connection or with a DataSource
· Add javax.validation API to full deliverable
· Add Factory.connectByRoot(Field<?>) to support the Oracle CONNECT_BY_ROOT pseudo column
· Add Factory.condition(String, QueryPart...) similar to Factory.field(String, QueryPart...)
· Add support for Oracle's ORDER SIBLINGS BY clause, in combination with CONNECT BY
· Add missing constructors taking DataSource to dialect-specific factories
· Generate missing constructors taking DataSource in schema-specific factories
· Simulate REPEAT() in SQLite

Via: jOOQ 2.5.1