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
Tag: sql
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
Developer blog started for interesting insights in Java, SQL and jOOQ
On this blog, I'd like to share my thoughts about developing in Java and SQL, and my "middleware passion" jOOQ. Java and databases are my professional passion. When they work together, great software can evolve. Many proprietary and standard ideas have been around to make them work together. I feel that there is yet one … Continue reading Developer blog started for interesting insights in Java, SQL and jOOQ