Hey there-

I have an application with multiple instances of the same schema, one per corporate account. I would ideally like to pool datasources and be able to switch between schema depending on the caller's environment. Is this possible through hibernate? Right now I am maintaining a Map of SessionFactory objects for each schema, but at a certain point I'm going to max out of database connections if each factory maintains its own pool. I may also max out of memory storing the session factories in a map rather quickly as well. Any thoughts? I know using a mysql connection i can access the other databases' data by using schemaname.table type of notation, so theoretically this would be possible using JDBC.

Thanks for any input you could provide

If the schemas are located in the same database, you can have multiple mapping files per class, each one naming the entity differently and having a different "default schema" attribute.
In this way you still get only one sessionFactory and pooling, pointing to multiple schemas.

Could you please give some more details. How this can be used in while doing a query or save.


Thanks & Regards

unni