[jboss-user] [EJB 3.0] - Many database schemas with same structure. How to implement

Hi Guys, I have the following scenario: I've a database schema per user in my application(an online ERP/CRM). All the schemas have the same tables, I would like to know how to map it in my persistence.xml file. If I need to specify a jta-data-source I'm hardcoding the client for that persistence unit. Do I need to create a persistence-unit per client and map all the classes in all of my persistence-units ? Thanks View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4194124#... Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&a...