0 Replies Latest reply on May 17, 2006 5:26 AM by c96mud

    Dynamic datasource selection

    c96mud

      Hi,

      I'm looking at the possibility to deploy different customers/groups of users in the same application server cluster, but with separate underlying databases (identical structure - different data).

      I want to avoid keeping references in the application (i.e. a resource-env-ref in jboss.xml) to each customer's datasource, and instead use a "generic" DS-configuration and perform some kind of delegation to the correct datasource.

      Each thread can be identified to belong to a given customer, so that part is a non-issue.

      I read about the varia DatasourceDelegator which seems to be pretty close to what I need, but it appears to have been removed in JBoss 4.x. Anyone with a clue about that?

      Anyone with the same problem or existing solution?

      Thanks,

      Markus