subscribe to this newsletter here
Only 8 Days Left in jOOLY
Time is running so fast! The month of jOOLY is almost over – have you taken advantage of our limited-time promotional discount of 20% that we’re offering to all of your purchases in July 2014? And that’s not it, you will also get a free copy of the popular e-book SQL Performance Explained by Markus Winand, a book that we believe belongs on the shelf of every SQL developer.
Act now to get 20% off your next jOOQ purchase!
Tweet of the Day
Our customers, users, and followers are sharing their love for jOOQ with the world and we can hardly catch up with them! Here are:
Álvaro Hernández Tortosa, who has the final word on frameworks that hide SQL, because SQL is really powerful
Calvin Thomas, who Has come to an end of his search for the stack he direly needs. And that consists of AngularJS, Bootstrap, Play, Scala, jOOQ. Well done!
The famous Adam Bien, who explains how to properly use jOOQ in a Java EE context.
Thanks for the shouts, guys! You make the jOOQ experience rock!
New tiered pricing model
In the recent months, we have been having a lot of interesting discussions about our workstation-based pricing model, and how that fits in larger organisations with more fluctuation among team members.
We think of our workstation-based model as particularly fair because the price increases when more value is added – but we have heard the various concerns about simplifying the administration effort for large volumes. This is why we’re now officially offering a tiered pricing model on all subscriptions larger than 10 workstations.
If this is interesting for your organisation, please consider the updated license textcontaining prices (on page 17), or contact us directly.
Of course, if you act quickly, this offering can be combined with the “jOOLY” promotional discount to help you get even more value out of your next purchase!
jOOQ 3.5: Oracle AQ Support
The upcoming jOOQ 3.5 will ship with an extension to the code generator and the API that will make using Oracle AQ with jOOQ as easy as everything else!
Oracle AQ is a very powerful feature when you need to notify your database clients of data changes. Typical use-cases include triggers on updates needing to invalidate a UI cache for an “expensive” value.
If you’re using Oracle AQ with JDBC directly, however, you might be put off by the complexity of binding / loading OBJECT types from CallableStatements. Not with jOOQ.
This is what an enqueue call will look like:
DBMS_AQ.enqueue(conf, QUEUE_NAME, object);
And this is what a dequeue call will look like:
MyObjectType object = DBMS_AQ.dequeue(conf, QUEUE_NAME);
Both the MyObjectType and the QUEUE_NAME reference are generated objects with type information associated with them. This means, you can enqueue / dequeue just as if Java were the same as PL/SQL. Excited? We are!
Community Zone – The jOOQ aficionados have been active!
The jOOQ community has been very active again in the last month. We’re happy to point out these editor’s picks from our radar:
Tired of building with Maven? We’re very happy to announce Etienne Studer’s publication of a fully-functional gradle-jooq-plugin. This is a great community effort for those of you working with jOOQ and Gradle – or even Groovy in general.
Bert van Langen is a passionate DB2 DBA who has given us this excellent introduction to jOOQ on his blog. An alternative tutorial that should get new users started very quickly.
Marco Behler has published a treaties about the Java persistence ghetto (and how jOOQ might change that). We’re very glad to see that Marco is also coming to the same conclusion that we try to repeat time and again: Nothing keeps you from using JPA and SQL (e.g. in the form of jOOQ) in the same project.
Feedback zone
You’ve read to the end of this newsletter, that’s great! Did you like it? What did we do great? What can we improve? What other subjects would you like us to cover?
We’d love to hear from you, so if you want to reach out to us, just drop a message tocontact@datageekery.com. Looking forward to hearing from you!