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
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
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();
Hibernate with multiple database
Linear Mode
