Hi All,

Currently we have a scenario where in we need to create reports in excel & pdf through java.

So ideally we have some complex queries which will fetch us the data.

My question here is would it be a good idea to use Hibernate in this scenario.
Since this is largely an OLAP kind of an application where we interact only with read-only data, is Hibernate the right way to go.

From what i read (correct me if I am wrong here) using Hibernate makes more sense only where there are more frequent data modification (OLTP) scenarios.

Also I would like to know if there is a limit on the number of database tables for making use of Hibernate. Can Hibernate be used in large scale databases.

Please provide your feedback on the same as we are in the process of evaluating Hibernate for our project. Also if you could post some pointers about the usage of Hibernate in OLAP type of scenarios would be very helpful


Thanks,

I am using Hibernate in an large scale OLAP application (400 tables). It works like a champ. The main benefit of using Hibernate in these situations is the ability to use Criteria and Example queries, which can be built programatically from varying parameters. Back in the old days ;) , you would have to build a SQL string dynamically or have a multitude of prepared statements and/or complex stored procedures.