I have a requirement of connecting to 2 DB in one session at a time ...

Detailed explan : In my application when my application starts hibernate is configured to interact with a DB which is meant for my application.I am using Data source for obtaining a connection from this database.
Now in one of my module, I have to connect to another 3rd party DB and execute few stored procedure on it.
Now question is , how do I connect to these two DB in one session at a time

Can I specify 2 data source in my one hibernate.cfg.xml and while initialising session factory I can specify the specific data source....

Any clue please

thanks and regards,

sudhir

I don't beleive it's possible to have a Session having to connect to multiple DBs. Read Section 3.2 of the documentation. Since Session is created out of SessionFactory and SessionFactory is usually bound to 1 DB or 1 Data source.

I beleive the reason is that this restriction facilitates the 1st level caching of data at the Session level as if it were to connect to 2 DBs it would result in unknown behaviour.

You will have to use 2 different session factories and obtain the relevant factory and session from that. You could create multiple confiigurations and bind the 2 Factories to a JNDI and lookup the corresponding factory in your application as applicable.

Thanks Anand, I am aware @ option of having multiple configuration files for individual DB......but still wanted to take a chance, where in , there might be some other soln......

thanks any ways

sudhir