Hi,

I'm researching the possibility of integrating hibernate into an existing DB-backed client/server application. This application will be rearchitected as a multi-tenant distributed application in the future. By this I mean, we will have a lot of different DBs, one per customer (this is a strict requirement and there is no way to consolidate all customers' data into one database). The server component will consist of many identical instances serving incoming client requests independently and each instance will serve requests for any client; therefore each instance of the server will need to be able to communicate with every database.

I am just learning about Hibernate now, and am wondering whether this architecture is compatible with Hibernate? As is my understanding, there is exactly one SessionFactory object per database. So will every server instance maintain a collection of SessionFactory objects - one per database? Or will I have to share and pass around SessionFactories? Are there other considerations/problems?

Thanks

EDIT - Sorry, i clearly did not do enough research before posting - in particular the hibernate dev guide even has a section on mutli-tenancy...