With so many goodies in just one minor release, I have actually forgotten another, very important feature of jOOQ 3.3 :-)
We now have full support for the MS Access database! This is great news for so many of you, because the MS Access SQL dialect is tricky to master, which is where jOOQ's SQL transformation capabilities play an important role. We'll be making MS Access support available to all commercial jOOQ editions: jOOQ Express, jOOQ Professional and jOOQ Enterprise 2014-02-14 18:58 GMT+01:00 Lukas Eder <[email protected]>: > Version 3.3.0 - February 14, 2014 > > ================================================================================ > > Finally, a new awesome jOOQ release is ready for you to download! The most > important feature first: > > * The SEEK method* > * ---------------* > > We've been blogging about keyset paging before: > > - > http://blog.jooq.org/2013/10/26/faster-sql-paging-with-jooq-using-the-seek-method/ > - > http://blog.jooq.org/2013/11/18/faster-sql-pagination-with-keysets-continued/ > > Every SQL developer should have this tool in their toolchain. And now, with > jOOQ 3.3, we natively support a synthetic SQL clause for you to express > keyset > paging very easily. jOOQ is the only database software out there to do so! > > * Gudu Software's SQL 2 jOOQ Parser* > * ---------------------------------* > > We're very happy to announce our collaboration with Gudu Software Ltd who > have > implemented a very powerful SQL parser and transformer for enterprise > databases. > > Together with Gudu Software, we have created an Open Source SQL 2 jOOQ > parser > that takes native SQL statements as input and generates jOOQ code as > output. > > The source code can be found here: > > - https://github.com/sqlparser/sql2jooq > > And our manual features a tutorial here: > > - http://www.jooq.org/doc/3.2/manual/tools/sql2jooq/ > > We will ship, test and maintain this awesome new addition with our own > deliverables. So far, SQL 2 jOOQ supports the MySQL and PostgreSQL > dialects and > it is in an alpha stadium. Please, community, provide as much feedback as > possible > to make this great tool rock even more! > > Please take note of the fact that the sql2jooq library is Open Source, but > it depends > on the commercial gsp.jar parser, whose trial licensing terms can be seen > here: > > - > https://github.com/sqlparser/sql2jooq/blob/master/sql2jooq/LICENSE-GSQLPARSER.txt > > * Great new SQL Feature Support* > * -----------------------------* > > We've been looking around for SQL standard and vendor-specific features, > such as > the WINDOW clause (standard!), CROSS APPLY, OUTER APPLY, LATERAL join, > DEFAULTs > for inserts, and nice datetime arithmetic functions and emulations > thereof. > > As always, we've also blogged about all these features. See the following > links > for more details: > > - > http://blog.jooq.org/2013/11/03/probably-the-coolest-sql-feature-window-functions/ > - > http://blog.jooq.org/2013/12/18/add-lateral-joins-or-cross-apply-to-your-sql-tool-chain/ > - > http://blog.jooq.org/2014/01/08/lesser-known-sql-features-default-values/ > - > http://blog.jooq.org/2014/02/06/youre-very-likely-to-have-gotten-sql-date-time-arithmetic-wrong/ > > * Formal Spring integration support* > * ---------------------------------* > > Spring is one of the most popular frameworks to handle transactions, and > it does > so very well. With the help of our community, we've established new > standards and > examples of how to get started very quickly with jOOQ and Spring. See the > following > resources for details: > > - > http://www.jooq.org/doc/latest/manual/getting-started/tutorials/jooq-with-spring/ > - > https://github.com/jOOQ/jOOQ/tree/master/jOOQ-examples/jOOQ-spring-example > > * ---------------------------------* > > This release is available for all editions, including: > > - jOOQ Open Source Edition (with a small lag on Maven Central) > - jOOQ Express Edition > - jOOQ Professional Edition > - jOOQ Enterprise Edition > > The SQL 2 jOOQ parser is not available from Maven Central. > > More details can be seen here: > http://www.jooq.org/notes > > -- You received this message because you are subscribed to the Google Groups "jOOQ User Group" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/groups/opt_out.
