[jboss-user] [JCA/JBoss] - Multiple Data Bases Data Source Pool

[uji]

we have an application that must be used by different customers and we want each customer to have its own data base.

I am wondering which is the best way to accomplish this.

One solution would be to deploy the application once per customer and to configure the deployment descriptors to bind to different data sources. 

This works but it has few issues: reconfiguring the deployees is very time consuming (and cannot be automated easily) and it also leads to memory problems.

An alternative would be to map the ejbs to a special data source pool that returns connections to different data bases depending on the authenticated user.

It this possible? How?

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

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