kindly let me know as how to switch between two databases. i have just a single hibenate.cfg.xml file and have set connection.url for jus one db.

thanks

Hi sambhavi,

I don't know if it is your case, but using hibernate with spring you have the possibility to define several datasources and assign them to specific DAOs.

Can anyone give me idea to switch databases without using the spring framework.

Thanks

You have to change the data in your configuration object, rebuild it, and rebuild your session factory.

Check the hibernate api docs. There are some methods for you to read in a new configuration, or set specific properties.