Take a look at: jOOQ and Avaje
jOOQ it is a framework indicated by a lot of people, the users of this frameworks praise it in a lot of sites/forums.
Unfortunately the jOOQ did not work in my PC because my database was too old, and I could not download other database when writing this post (I was in an airplane).
I noticed that to use the jOOQ you will need to generated several jOOQ classes based in your model. jOOQ has a good documentation in the site and it details how to generate those classes.
jOOQ is free to those that uses a free database like: MySQL, Postgre, etc. The paid jOOQ version is needed to those that uses paid databases like: Oracle, SQL Server, etc.
Is a framework quoted in several blogs/forums. It works with the ORM concept and it is easy to execute database CRUD actions.
Problems that I found:
Not well detailed documentation: its Hello World is not very detailed
Configurations: it has a required properties configuration file with a lot of configurations, really boring to those that just want to do a Hello World
A Enhancer is needed: enhancement is a method do optimize the class bytecode, but is hard to setup in the beginning and is mandatory to do before the Hello World