different databases simultaneously

hibernatus · **Joined:** Wed Jan 10, 2007 5:20 pm **Posts:** 8

I'm using hibernate in my struts web application and I need to connect to different databases simultaneously.
Can Anyone tell me how to do that ?
thanks

david · **Posted:** Wed Jan 10, 2007 8:46 pm

The question is not defined very well... anyway.

1) Use Java Threads - create two - then using the two SessionFactories (one for each database) each thread then accesses the databases 'simultaneously' assuming you have a multi-core/cpu platform (and the OS allocated the threads as such).

2) Assuming you meant in sequence usder the same Transaction - you need to setup the JDBC connections to use a TX data source and use an appripately setup Transaction manager (JTA is the usual approach).

hibernatus · **Joined:** Wed Jan 10, 2007 5:20 pm **Posts:** 8

THX,
It's true the question wasn't defined very well.
Actually, In my application I have independent ajax components that do their own database access through Hibernate, but these queries must be done on different database.
That's why I said that I want to access to different databases simulatneously.
In consequence, I think the first solution you gave is more convenient in my situation.
For the moment I'm using the following code to create a SessionFactory.

[i]sessionFactory = new Configuration().configure().buildSessionFactory();[/i]

[b]I suppose I will have to create a second hibernate.cfg.xml to access to a second database.[/b] If not, please let me know...
[b]But then, how do I must write my code in order to access to the second hibernate.cfg.xml ?[/b]

thanks a lot

kochcp · **Posted:** Thu Jan 11, 2007 12:22 pm

you can specify the config file to load when you make the Configuration object

hibernatus · **Joined:** Wed Jan 10, 2007 5:20 pm **Posts:** 8

Can you give more details about how to do it please?

thanks

kochcp · **Posted:** Thu Jan 11, 2007 4:25 pm

Code:

Configuration conf1 = new Configuration();
conf1.configure(new File("/some/folder/hibernate1.cfg.xml"));
conf1.buildSessionFactory();

Configuration conf2 = new Configuration();
conf2.configure(new File("/some/other/folder/hibernate2.cfg.xml"));
conf2.buildSessionFactory();

http://www.hibernate.org/hib_docs/v3/api/