Lightweight JDBC helper library alternative to Apache Commons DbUtils

Question

I've just developed my own tiny little JDBC helper library, and I've already realized what a maintenance nightmare it will be.

I'm not looking for a full fledged ORM, like Hibernate, just something light and useful to quickly make JDBC calls passing SQL statements without messing with checked exceptions, closing resources manually, etc...

From your experiencie, can you recommend a nice JDBC helper library?

So far now, I've had a look at Apache Commons DbUtils which seems pretty good. Any other idea?

Answer 1

Here's a list of tools that "ease the pain" when interacting with simple JDBC:

• Spring's JdbcTemplate
• jOOQ (can be used with SQL strings as well - disclaimer: I work for the vendor)
• Apache DbUtils (which you've mentioned yourself)
• JDBI
• sql2o
• persism