Projects / jOOQ / Releases

All releases of jOOQ

  •  10 Jul 2011 21:25
Avatar

    Release Notes: This release mainly introduces three new projects. The project CURSOR is where jOOQ finally supports various RDBMS's TABLE, CURSOR, and REF CURSOR data types. The project EXPORT aims at exporting data from the database in various serialisable formats, such as XML, CSV, HTML, Text, and JSON. The project CODEGEN has finally been started. Many improvements suggested by jOOQ users will be implemented in the next releases.

    •  19 Jun 2011 20:19
    Avatar

      Release Notes: In this release, the PORTABILITY project has been implemented. Finally, the SQLDialect has been removed from most generated artefacts (Schema, Table, Field, Sequence, etc). Also, the constructing Factory is not referenced by its created QueryParts anymore, unless this is really necessary (query objects, UDT's, and ARRAY types). This leads to higher compatibility between schemata of different databases, e.g. if users want to use an HSQLDB development and Oracle productive database.

      •  05 Jun 2011 12:26
      Avatar

        Release Notes: Apart from supporting various additional standard and non-standard JOIN constructs, there is now also full support for the SQL standard MERGE statement and MySQL's ON DUPLICATE KEY variant thereof. A great number of API enhancements have been added, which improve the usability of jOOQ. The Ingres database is now also supported.

        •  15 May 2011 18:48
        Avatar

          Release Notes: This version ships with a lot of new functionality. The DSL-style API has finally been extended to CRUD operations (INSERT, UPDATE, DELETE). Support for the TRUNCATE TABLE statement has been added. The most important new features include the support for SQL:2003 standard window functions, which are available in most major RDBMSs. Additionally, basic function support has been widely extended.

          •  29 Apr 2011 23:21
          Avatar

            Release Notes: Two important new RDBMS are supported: SQL Server and Sybase. There is now full support for the non-SQL standard LIMIT clause, even in dialects where the LIMIT clause is not supported natively (especially Oracle, but also DB2, SQL Server, and Sybase, which have limitations). jOOQ simulates LIMITs by rendering nested selects filtering on ROWNUM (Oracle) or on ROW_NUMBER() (DB2, SQL Server, and Sybase).

            •  19 Apr 2011 16:57
            Avatar

              Release Notes: This is a Maven release only for artefact jooq-codegen. Version 1.5.7 of jooq-codegen misleadingly referenced jooq:1.5.7-SNAPSHOT instead of jooq:1.5.7. This has been corrected with jooq-codegen:1.5.7.1. If you downloaded jOOQ directly from Sourceforge, you don't need to worry about this release.

              •  17 Apr 2011 15:56
              Avatar

                Release Notes: The main new feature in this release is improved support for serialization/deserialization of jOOQ objects through use of the newly introduced "Attachable" interface. If using log4j or the newly supported slf4j logging framework in debug/trace mode, there is the possibility to log query building/execution time statistics. Apart from these new features, fixes were mainly done in the fields of type casting, HSQLDB 2.1 upgrade support, and stored procedures with OUT or IN/OUT parameters. Please upgrade if you are using any of those features.

                •  31 Mar 2011 18:40
                Avatar

                  Release Notes: This release consists mainly of code generation bugfixes and minor API improvements and enhancements. The most important improvement is ticket #90, by which lazy fetching and iteration over data is now supported. jOOQ lets you keep a reference to a Cursor that has an open JDBC ResultSet, to fetch data from on-the-fly. A few major code generation bugs were reported where the generated code may cause ambiguity due to an inconsistent API. This means that you will have to re-generate your schema after upgrading to version 1.5.6. Some of your code may not compile anymore after this upgrade.

                  •  15 Mar 2011 18:08
                  Avatar

                    Release Notes: A critical bug was reported from the 1.5 release stream where stored functions did not render their parameters in correct order. Upgrade to this version if you are using stored functions embedded in SQL. Also, source code generation for Oracle stored procedures and stored functions with NUMBER parameters was improved.

                    •  13 Mar 2011 18:54
                    Avatar

                      Release Notes: If you are using jOOQ's Derby integration in 1.5.5, please update to 1.5.5.1 immediately. Release 1.5.5 has fatally broken source code generation for the Derby dialect. Other SQL dialects are not affected.

                      Screenshot

                      Project Spotlight

                      episoder

                      A tool to tell you about new episodes of your favourite TV shows.

                      Screenshot

                      Project Spotlight

                      BalanceNG

                      A modern software IP load balancer.