1 Reply Latest reply on Mar 31, 2004 8:33 AM by jae

    multiple datasource configuration

    sanjaymistry Newbie

      hi All,

      I have a huge database which involves multiple Schemas running on Oracle server. As of now, they are all on one server, but we are planning to put separate schema on separate machine.

      Now, how do I configure my Jboss so that I can access different schemas using different datasources.

      For example, I would map datasource name to schema.

      AccountDS should go to Account Schema
      OrderDS should go to Ordre schema
      UserDS should go to User Schema.

      How do I do this ?

      I tried putting multipel entries in oracle-ds.xml but somehow doesn't work ?

      any help ?

      Thanks.