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
Month: September 2011
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
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
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?