RDBMS bind variable casting madness

Spoiled with every day work on the Magnificent Oracle Database TM, I had to become quite inventive at the first time, when I wanted to start supporting RDBMS such as Derby, HSQLDB, DB2, etc in jOOQ. Oracle really does a great job in keeping the hard work away from you. Bind variable types are assessed … Continue reading RDBMS bind variable casting madness

Postgres INSERT .. RETURNING clause and how this can be simulated in other RDBMS

One of jOOQ's major features is to take the most useful SQL constructs and clauses from any RDBMS and make them available to other SQL dialects, as well. This had been done previously with MySQL's INSERT .. ON DUPLICATE KEY UPDATE construct, which can be easily simulated with the more powerful SQL standard MERGE statement, … Continue reading Postgres INSERT .. RETURNING clause and how this can be simulated in other RDBMS

Loading CSV data with jOOQ

After the recent efforts made in jOOX, developments of jOOQ have been continued. The main new feature of the upcoming release 1.6.5 is the support for loading of CSV data. The jOOQ Factory will now provide access to a dedicated fluent API for loading CSV files into generated tables, specifying a field mapping and various … Continue reading Loading CSV data with jOOQ

There’s still potential for new SQL dialects

A recent feature request reminded me, that there is still a lot of potential for new SQL dialects supported by jOOQ. User Philippe is considering jOOQ for various projects in his organisation, and one dialect he's missing is that of Sybase's Adaptive Server Enterprise. Sybase is one of the older databases, that is still widely … Continue reading There’s still potential for new SQL dialects

Oracle’s object-oriented PL/SQL extensions

I have recently re-discovered an interesting feature of Oracle's PL/SQL language. Not only can you define your own types very easily, you can also associate "methods" to them, as in other object-oriented languages. Oracle calls those "methods" member functions and member procedures. This is documented here, for example: https://download.oracle.com/docs/cd/B28359_01/appdev.111/b28371/adobjbas.htm#i477669 So you can define your own … Continue reading Oracle’s object-oriented PL/SQL extensions

FluentDOM, another mimick of jQuery DOM manipulation, in PHP

The triumph of jQuery over any other XML API seems prominent, in many languages. Here is another example of a nice jQuery-port to PHP: FluentDOM. http://fluentdom.github.com/ Similar to jOOX, FluentDOM aims to combine a jQuery-like fluent API with XPath and general DOM XML manipulation. Here are some simple examples taken from the FluentDOM documentation: // … Continue reading FluentDOM, another mimick of jQuery DOM manipulation, in PHP

Another Fluent API: jOOX. Porting jQuery to Java

Recently, in my every day programming madness, I really felt the urge to kill someone involved with the formal specification of DOM. The beloved Document Object Model. While everyone understands that this API is complete in functionality and scope and it's a standard, and it's almost the same in every language.... well it's incredibly verbose. … Continue reading Another Fluent API: jOOX. Porting jQuery to Java

The art of doing it right – who knows it?

When I first started developing jOOQ, I was pretty sure that 85% of the people that hear about it for the first time will not take the time to look behind the first impression and think any of these things: Yet another ORM Why not just use Hibernate That's not surprising, and I can't blame … Continue reading The art of doing it right – who knows it?

iciql, a fork of H2’s JaQu

I just came across a new project in the world of SQL-simulating fluent API's. It's called iciql and can be found here: http://iciql.com/ iciql has been forked by James Moger who has recently contributed to H2's JaQu library. JaQu is a side-product of the H2 database, which currently suffers from a low priority on the … Continue reading iciql, a fork of H2’s JaQu

jOOQ and Java 7

There are more and more blog posts popping up on the internet about Java 7's bugs that crash Lucene and Solr, as well as other software. I just found this interesting post here, from a Lucene developer: http://blog.thetaphi.de/2011/07/real-story-behind-java-7-ga-bugs.html I wonder what the implications of using Java 7 will be for jOOQ users. So far, no … Continue reading jOOQ and Java 7