Recommendations to others considering Hibernate:
Hibernate generates dynamics queries so If your database schema has complex relations then think twice before using HQL. Although Hibernate provide simple interaction to populate data from a table to your java class.
If you have many tables and entities in the database, the ORM engine may create very complex queries that will slow down the database and application. If you are using the Hibernate ORM, I recommend that you simplify the table structure.
It could be more complex and in some cases it's impossible to fetch related data in 1 query at this stage I prefer to use native query or store procedure to mitigate the performance issue.
1 very important point Hibernate need expertise to implement it properly otherwise you never touch the good performance with it. Review collected by and hosted on G2.com.
What problems is Hibernate solving and how is that benefiting you?
Independent from database schema
Low risk of data lost
Object Oriented Interface base mapping on java classes Review collected by and hosted on G2.com.