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 ?
just create seperate datasource files - you will have to update your code to use the correct jndi name (ie java:/AccountDS, java:/OrderDS, java:/UserDS).