Hi,
can I map more than one database on the same hibernate.cfg file?
If this is possible, how should I proceed?

If it´s not possible, how can I map an entity wich is not stored on the same database defined on the hibernate.cfg file? Is it possible too? What should I do in this case?

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:

If same db server but a different schema, you could specify the [schema="xxxx"] attribute in .hbm.xml file. This is not very flexible but it will work.

I don't know what your database provides, but you might be able to unify the databases so that it looks like a single db. On DB2/400, we can create an Alias -- a pointer in one database that points to a table in another database (but must be on same database server).

Beyond these suggestions, you will probably need to create multiple .cfg.xml files, multiple SessionFactory object, etc. This has been discussed several times in this forum.

Good luck,
Curtis ...