Hibernate Community • View topic - How to use hibernate to handle 2 databases at same time

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

How to use hibernate to handle 2 databases at same time

Page 1 of 1

[ 2 posts ]

Previous topic | Next topic

Author

Message

vbkurhade

Post subject: How to use hibernate to handle 2 databases at same time

Posted: Tue Sep 05, 2006 7:28 am

Newbie

Joined: Tue Sep 05, 2006 7:23 am
Posts: 1

I have a scenario

lets say my application wants to use 2 databases MySQL & Oracle.
I have x tables in MySQL & y in Oracle.

How will i be able to create two sessionFactories in either applicationContext.xml or hibernate_cfg.hxl.

will following snippet work


<bean id="sessionFactory" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
</bean>

<bean id="sessionFactoryO" class="org.springframework.orm.hibernate3.LocalSessionFactoryBean">
</bean>

Top

evdelst

Post subject: It should work

Posted: Tue Sep 05, 2006 9:24 am

Regular

Joined: Wed Aug 24, 2005 11:49 am
Posts: 63

If you specify different properties for each session factory (eg. different configLocation, datasource etc.) it should work.

Top

Page 1 of 1

[ 2 posts ]

Board index » Hibernate & Java Persistence » Hibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum