Hi,
in the "Hibernate Reference Documentation" is written in section 3.2:
"Hibernate does allow your application to instantiate more than one SessionFactory. This is useful if you are using more than one database".
Ok, but it´s not written in this documentation how to do it.

So here is my problem: we are writing a system wich is made of several jar files, each jar file correspond to a module of the system.
And many jar files are using Hibernate. But when we try to use more than one jar files, and they are all using differente databases, we get a message wich says that Hibernate could not find entity x, y, z, etc.

How can we instantiate more than one SessionFactory, each one with it´s own configuration file?

Hibernate version: 3.2

Mapping documents:

Code between sessionFactory.openSession() and session.close():

Full stack trace of any exception that occurs:

Name and version of the database you are using:

The generated SQL (show_sql=true):

Debug level Hibernate log excerpt:

Yep, set each one up with it's own configuration file. It doesn't appear that the config DTD allows for multipe <session-factory> elements. And if it did, you can't share mapping between the two factories. I have had no problems with multiple config file and it works just fine.

Ryan-

Ok, but I´m just a beginner: how can I work with multiple configuration files for multiple SessionFactory objects?

What I did is create a varient of the HibernateUtil class that is described in the Caveat Emptor demo application (http://caveatemptor.hibernate.org/). Basically, I changed so that it would create n-number of SessionFactories and I can access them by name. So rather than say:



I could do either:



Or prehaps a bit more flexible:



I also changed the initialization to that it could read a specific URL to load different config files. I could not use the static initialization block that the original HibernateUtil uses to inialize the factory. But about 90% of the configuration code you'll need is already in HibernateUtil, you'll just need to adapt it to you needs. Hope this helps.

Ryan-

Hibernate Reference Documentation
Chapter 3. Configuration
3.7. XML configuration file
last example code