Hi all,


I have a system with over 1000 database instances - each instance with the same database schema. If I understand correctly, I need a sessionfactory object for each separate database. Is it possible to have 1000 sessionfactory objects loaded simultanously? 2000? 3000?

Hardware limitations are quite high, that should not be a problem.


Thanks

You do not want to load 2,000 session factory objects. The time it takes to load one is large.

If I remember right you can change the mapping files to read the different schema, so you only need one config file and one factory.