Apache Cayenne

What do you like best?

The best thing is that it also works well for non java users as well. Java Objects is directly accessible by Database and it stores data base directly into it. Also, its Object-Relational model is pretty good and handy at the same time. The database mapping is quite good, and Cayenne API is good to know thing for sure. Also, you should not require any specific knowledge on SQL.

What do you dislike?

Well, its quite complicated and hard to understand everything in short time. You have to give this a more time to better understand. Also, the user interface could be more easier to understand and locate the objects correctly.

Recommendations to others considering the product:

Well, if you user of this then you should have this and mapping of database is quite good. Overall this is the software you should consider on priority for sure.

What problems are you solving with the product? What benefits have you realized?

Firstly the mapping to java objects, second is working with Object-Relational model is a different experience. Along with this it works well for java and non java both users. Well, I don't have any knowledge on SQL but this framework helped me to work on the projects without the help of SQL.