[jboss-user] [Persistence, JBoss/CMP, Hibernate, Database] - One SessionFactory for multiple schema

[elikyip]

Long story short: 
In our multi-tenant architecture we cannot afford to create one SessionFactory per schema because of the number of schema's we have. The table structures are identical in ALL the schemas though.

We are trying to see if we can use ONE SessionFactory for multiple schema without comprimising the second-level cache.  We are thinking about creating a cache region for each schema by adding the schema's name to the region's name.

Has anyone done this before with the cache region name?

Any idea, clue, hint,....is highly appreciated

View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4040296#4040296

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4040296