2 Replies Latest reply on Jun 12, 2008 3:55 PM by Andrea Di Cesare

    Multiple Data Bases Data Source Pool

    Andrea Di Cesare Newbie

      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?