If I had multiple db's with the same schema(like multiple dbs in MySQL or MS SQL), how can I use the same hibernate objects for both dbs and switch between the dbs. I am doing this so the row count is not 1,000,000 and instead is 10,000 for a particular table.
thanks,
dean


Hibernate version:

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: