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?

[vickyk]

"uji" wrote:

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?

You can have the same database but pools getting created per user , this can be done by configuring the -ds.xml file .

Check this
http://wiki.jboss.org/wiki/JBossJCAPooling

The same -ds.xml will have now pools getting created for various users ,does this help you ?

[uji]

not really.

what we need is a connection pool containing sub-pools of connections to different databases.