Hello,

I am trying to evaluate Hibernate for a reporting project which involves complex 4-5 production queries.
Currently we use in house db control built on top of RowsetDynabeans.
Is hibernate a candidiate for these simple queries where no persistance involved. Also instead of HQL, can I use the queries provided by DBA as it is? Any experience of using OSCache with Hibernate? Thank you for your replies.

Easiest question first. You can use your sql queries that you already have written in hibernate.

Loaded question second. It depends on how much time you have to implement hibernate for your needs. Understanding how to replicate relationships that exist in your database in hibernate can be confusing. and time consuming.

If you desire query results in the form of easily navigable java objects, then yes, hibernate is very good at that.

There are too many other benefits of hibernate to list here.

There are also a lot of reasons why using hibernate would NOT be a good choice too.

alot of it depends on what your database looks like and what functionality you desire from a db layer such as hibernate.

another option would be IBATIS sqlmaps, if you want to look that up

Thanks a lot. I will evaluate SQLMap besides Hibernate. Since it is only 4-5 complex select only queries, I will implement SQLMap instead of Hibernate. Thanks again for your suggestion.

Hibernates native SQL support is less verbose than iBatis SQL maps and much more powerful.