This is a maintenance release for jOOQ 2.0. The main improvements include - The whole jOOQ API is now annotated with a new org.jooq.Support annotation to help you assess whether a certain SQL clause is available in your database or not. This is particularly useful when your application should support several databases at once (e.g. MySQL, Postgres, Oracle) - The Oracle PIVOT clause is now formally supported for advanced statistical queries in Oracle. This clause will be simulated in other dialects in the future. - The DATE data type can be mapped to TIMESTAMP. This important when you query a legacy Oracle database, where DATE columns can also contain time information - Several convenience methods have been added for more fluent syntax, when using plain SQL result queries, subqueries as tables, or when unnesting arrays in ANY() and ALL() quantifiers
Further type mapping support is still experimental. An official cooperation with MinuteProject for source code generation is being analysed. With MinuteProject, many source code generation issues could be addressed centrally, as MinuteProject specialises in source code generation: http://minuteproject.wikispaces.com/
