I am building an application where each customer has its own schema, but the same set of tables (to avoid any single table becoming too big in a multihosting scenario). A post here earlier indicated that the only solution to this is to build multiple SessionFactories, one for each customer. In my situation I am using JBoss, and that means that I would have to instantiate one instance the HibernateMBean per customer, and consequently have one SessionFactory per customer in the JNDI.

While this solution is far from being bad, I would suggest to have the possibility to specify the schema at the time of session creation, e.g.

sessionFactory.getCurrentSession(<SCHEMA-NAME>)

Is there something that I am missing?