Database Access | Cubano

There are a range of options for automating database requests:

Low Level:

  • JDBC: will meet your needs but needs some work to get going

Lightweight:

My personal preference would be to use either of these libraries for the flexibility they add with named parameter support and POJO mapping. They get you up and running immediately and are simpler than JDBC.

  • Fluent JDBC: is a java library for operating with SQL queries conveniently
  • JDBI: a SQL convenience library for Java

Other: Generally a full ORM package such as Hibernate or JPA will be overkill for your needs. jOOQ looks like an interesting alternative but is still overkill for most testing requirements in my opinion.