I second jOOQ. The fluent interface actually catches SQL errors at compile time (brief example is in the wikipedia entry[1]). [1] http://en.wikipedia.org/wiki/

I second jOOQ. The fluent interface actually catches SQL errors at compile time (brief example is in the wikipedia entry[1]). [1] http://en.wikipedia.org/wiki/Java_Object_Oriented_Querying http://en.wikipedia.org/wiki/Java_Object_Oriented_Querying