[toddkaufmann]

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