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

elikyip do-not-reply at jboss.com
Tue Apr 24 14:12:47 EDT 2007


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



More information about the jboss-user mailing list