Living through the latest developments of the H2 and HSQLDB databases has been very exciting for me as jOOQ developer. Those two databases have a common heritage and share a lot of functionality. Both are progressing at a high pace with a very active community around their respective lead developers. I have recently posted an … Continue reading How to use H2 with jOOQ
Vaadin, a very nice web framework
The recent hype about the Play ! Framework seemed to have lead to a lot of people thinking "That's it! That's how it ought to be". And after trying to reproduce the Play ! tutuorial, I immediately agreed. Web development should be as easy as in Play ! But Play ! is just simplifying the … Continue reading Vaadin, a very nice web framework
Stored procedures returning multiple cursors
When adding support for Sybase ASE to jOOQ, I came across a peculiar procedure that can be used instead of the dictionary tables, to query for schema meta information (see also my previous post about database schema navigation). With Sybase ASE, you can call a procedure (or pragma?) called sp_help, which will return a cursor … Continue reading Stored procedures returning multiple cursors
jOOQ has a new home page
I am proud to announce the launch of jOOQ's new home page: https://www.jooq.org/ I'm moving away from the very slow hosting on source forge and its quite technical-looking Trac Wiki. Any feedback appreciated!
Suggestions for the Java, SQL and jOOQ Blog
This blog is picking up momentum and thus, relevance. With jOOQ, I have come a long way, working with Java, JDBC, and SQL. I have solved many problems that are worth discussion, and I know quite a few things about various RDBMS, and how they compare with each other. Some examples: Database Schema Navigation RDBMS … Continue reading Suggestions for the Java, SQL and jOOQ Blog
MentaBean, the ORM/SQL Builder of Mentawai
I ran across an incredible discovery just now. I'm always closely observing jOOQ-related topics on Stack Overflow, so I immediately saw these somewhat advertising answers to a dedicated jOOQ user's question: https://stackoverflow.com/questions/5625832/java-jooq-persistence-framework-performance-and-feed-back#7387325 https://stackoverflow.com/questions/5620985/is-there-any-good-dynamic-sql-builder-library-in-java#7351575 MentaBean is an ORM/SQL Builder that has recently been made independent from Mentawai, a library building on top of the Servlet specification … Continue reading MentaBean, the ORM/SQL Builder of Mentawai
Database schema navigation in Java
An important part of jOOQ is jooq-meta, the database schema navigation module. This is used by the code generator to discover relevant schema objects. I was asked several times why I rolled my own instead of using other libraries, such as SchemaCrawler or SchemaSpy, and indeed it's a pity I cannot rely on other stable … Continue reading Database schema navigation in Java
Elmer Fudd’s opinion on jOOQ
jOOX brand launch
jOOQ and jOOX are like my little children. Brothers and sisters. Hence, they should also look alike. Here they are together: Let's see what other cute little siblings they might have in the near future! :-) You can get them officially from here: http://jooq.sourceforge.net/logo/joox-small.png http://jooq.sourceforge.net/logo/jooq-small.png
Oracle scalar subquery caching
The importance of being able to fully control executed SQL (using jOOQ, or plain JDBC) on large-scale systems becomes obvious every time you need to fine-tune your SQL queries for a specific RDBMS. In this case, we're looking at Oracle and its miraculous scalar subquery caching mechanisms: Usually, the context switch from SQL to PL/SQL … Continue reading Oracle scalar subquery caching