Hi Friends,
If I want to use two database in my application for e.g mySQL and MS-SQL Server then how can I define two datasource in the xml file.Do I have to make two hibernate.cfg.xml files or single file would be fine.If single file then how can I write both datasource in that file.I dont have any idea about this.Please let me know.All suggestions are welcome.
Thanx in Advance,
Chirag

You need two SessionFactories = two config files.

Hi,
I agree of having 2 cfg files but then what name should be given to file and how can I decide which file to call when.I guess during SessionFactory.Please mention small code snippet if possible.
Thanx once again,
Chirag

Configuration config1 = new Configuration();
config1.configure("fst_hibernate.cfg.xml");
SessionFactory sf1 = config1.buildSessionFactory();

Configuration config2 = new Configuration();
config2.configure("snd_hibernate.cfg.xml");
SessionFactory sf2 = config1.buildSessionFactory();

Both configs must be in classpath.