How to use H2 with jOOQ

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

Annotatiomania™ in Struts 2.0

I have to admit, I have not made any experience with Struts 1.0. Neither with 2.0. From what I understand, Struts 2.0 tried to move away from XML to use annotations instead. Just like Hibernate/JPA did. They have published Struts 2.0 with this title: "Apache Struts 2 is an elegant, extensible framework for building enterprise-ready … Continue reading Annotatiomania™ in Struts 2.0

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: http://stackoverflow.com/questions/5625832/java-jooq-persistence-framework-performance-and-feed-back#7387325 http://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

Annotatiomania™, or why did Hibernate/JPA get so complex?

I was curious about good answers to this question on Stack Overflow: http://stackoverflow.com/questions/7332904/how-to-store-a-collection-of-dates-in-hibernate And a good answer came up, pointing at this Hibernate documentation page: http://docs.jboss.org/hibernate/core/3.6/reference/en-US/html/collections.html#collections-ofvalues Is anyone out there actually willing to mess around with gazillions of annotations on simple methods? Who ever writes this stuff: @Entity public class User { [...] public String … Continue reading Annotatiomania™, or why did Hibernate/JPA get so complex?

Elmer Fudd’s opinion on jOOQ

Very nice: http://wikien4.appspot.com/wiki/Java_Object_Oriented_Querying