I prototype a simple hobby web application where a user can create many companies
but each company will have it's own database schema

So a user may choose to work on company X and another user can choose at login time to work on company Y
Number of companies are dynamic since anytime a new company may be created.

So each company will have it's own schema (companyX,companyY...)

Now on server side how can i manage multimple session factories ?

In servlet do i have to identify the company then to attach create a session factory that will be used how ????

THX any link or advice is welcomed

Isn't a sessionFactory pool or a hashMap that returns you the correct sessionFactory based on the key which would be the company good enough to get a session and solve the problem of handling many schemas or databases?

Somebody correct me if I am wrong here, everything including ThreadLocal and session access would remain the same!

Cheers
Krishna