Hibernate with multiple database

[Marty]

Hello people
Does anybody use hibernate to access to a multiple database?
I searched in internet but I don´t understand and the documentation of hibernate says:


How do I use multiple databases?
You must configure multiple SessionFactory instances.
If you have more information, please tell me

Marty

[goldhouse]

Hibernate has a configuration file called hibernate.properties or hibernate.cfg.xml. There you can specify the properties of database like

Code:

hibernate.connection.driver_class	jdbc driver class
hibernate.connection.url	jdbc URL
hibernate.connection.username	database user
hibernate.connection.password	database user password
hibernate.connection.pool_size	maximum number of pooled connections

By default if you download the hibernate source , it will working on hsqldb.
I have tried hibernate in oracle, mysql, hsqldb

[pegitha]

I have used Hibernate with two databases. You just need to make two datasources then call the one you need for the specific query. I have most recently been using hibernate with Spring but I looked up some old code and what I did was made two different SessionFactories, and so I would call either one or the other session from the factory.
session = DBUtil.getABCSession();
or
session = DBUtil.getDEFSession();