Hi All,

Currently we are facing an architecture for our j2ee application which needs to interact with two separates Oracle Databases (not oracle schemas).

One is a data warehousing (OLAP) type database & the other is a OLTP.
The architecture is something like this
- we have screens which insert & modify data. For this we interact with the OLTP database.
- We have to show Reports. This data will be fetched from the OLAP database. The OLAP database is read only & cannot be modified.

So ideally the structure of both the database table & entity names may overlap.
For both database entities we have to create Hibernate objects. I reckon we will have to create & use separate sessionFactories. So ideally for data modification related activites we will use one sessionFactory.
And for all Reports we will be using a different sessionFactory.

My question is about overlapping entity names in both the databases. Will this in any way impact the functioning of Hibernate.

Do post your thoughts on the same.


Regards,