[ANNOUNCEMENT] The wonderful jOOQ 3.4 is out, with Common Table Expressions, Transactions, and DDL support

[Lukas Eder]

Version 3.4.0 - June 20, 2014

================================================================================

With this awesome new minor release version, we have finally started supporting

a couple of very important aspects of the SQL language:

- Common table expressions

- Transactions

- DDL

Common table expressions have been missing from jOOQ for a long time, and

they're now finally part of our DSL API, both for recursive or regular usage.

Transactions are handled very nicely in JavaEE or through Spring TX. But if

you're running small standalone programs with JDBC (and jOOQ) only, you have to

resort to a transaction API that is no longer contemporay. With jOOQ 3.4, we're

now shipping a Java-8 ready transaction API and a default implementation backed

by JDBC transactions. Our manual also contains an example implementation that is

backed by Spring TX. While we do not want to compete with popular transaction

models, we do want to provide a simple, functional-interface oriented API to

apply transactions in client code.

DDL is very hard to standardise across databases, and with jOOQ 3.4, we have now

started adding type safe support for some DDL statements, including thus far:

- ALTER SEQUENCE

- ALTER TABLE

We're going to be adding support for more DDL statements in jOOQ 3.5 as part of

our more general DDL support strategy.

Apart from that, there is a tremendous amount of minor improvements.

  ---------------------------------

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

More details can be seen here: 

http://www.jooq.org/notes

Note: We'll be updating the manual in the next couple of days, so stay tuned

[Roger Thomas]

First minor issue, when trying to access the PDF manual for 3.4 via http://www.jooq.org/learn I am given the link 

          http://www.jooq.org/doc/3.4/manual-pdf/jOOQ-manual-3.3.pdf

And the error

HTTP 404 / ORA-00942

table or view does not exist

Roger

[Lukas Eder]

Thanks for the hint, Roger. I've fixed this (you may need to refresh the page).

Note, though, that the manual will only be updated next week.

Cheers

Lukas

--
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 jooq-user+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Deven Phillips]

I had just come to the forum to ask if there was a timeline for this release!!! AMAZING and awesome! Thanks!!!

[Lukas Eder]

Yes, it was about time! :-)

--

[Roger Thomas]

Any idea when you will have the updated manual available.

Roger

On Friday, June 20, 2014 11:21:21 AM UTC+1, Lukas Eder wrote:

[Lukas Eder]

I'm sorry, I forgot to update this thread, I guess. It is updated (although the transactions section is still missing)

--

[Roger Thomas]

Oh, now guess with part of the update I'm most interested in :(

Thanks for posting what there is so far and I'm looking forward to the rest.

Roger

[Lukas Eder]

Will do, soon. In the mean time, you can check out the integration tests to see what the API is all about:

https://github.com/jOOQ/jOOQ/blob/master/jOOQ-test/src/test/java/org/jooq/test/all/testcases/TransactionTests.java

Another place where we have example code is the jOOQ-Spring-Example project:

https://github.com/jOOQ/jOOQ/blob/master/jOOQ-examples/jOOQ-spring-example/src/test/java/org/jooq/example/TransactionTest.java

Cheers

Lukas

[Lukas Eder]

Hi Roger,

The manual has finally been updated:

http://www.jooq.org/doc/latest/manual/sql-execution/transaction-management/

Cheers

Lukas

[Roger Thomas]

Thanks.

Roger