Hi,

I want to know whether I can use two session factories in a single hibernate.cfg.xml file.
If I use that like so, then how can i specify in the Java code which session factory need to be used.


Thanks and Regadrs,
Jacob

Hi Jacob,

U can not have two session factory tags in configuration XML.

In DTD it is specifies like this

<!ELEMENT hibernate-configuration (session-factory,security?)>
It means in hibernate-configuration u should have only one session-factory tag with optional security.

Thanks for your reply..
But, is there any way I can use two databases in a single java program using hibernate?

I need to write 2 configuration files whcih contains one session factory each and include these two corresponding files in program corresponding to the database i want to use?

Is there any other method other than this.

Also is it mandatory to keey the name of the xml file same as hibernate.cfg.xml ?

Thanks and Regards,
Jacob.

You can have multiple databases in a single application. You can also specify multiple <session-factory> in a configuration file. But the easiest way would be to use 2 different configuration files. Then you can have as below

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

SessionFactory sf2 = new Configuration()
.configure("b.cfg.xml")
.buildSessionFactory();

Hope that helps.
Thanks

Somu,

you answer was helpful, but can I know how can i use multuple session factories in a single configuration file and invoke the needed database in Java program. As per the first replier, its not possible..

Thanks and Regards,
Jacob.

You cannot do directly. What you can do perhaps is read the single configuration file into 2 sessionfactories and update the JDBC settings into them. So probably have a single XML configuration file and have 2 different properties file having the JDBC settings.

Thanks.

thanks somu