Havine multiple Oracle Data Sources in JBOSS3.14

[satyadoorva]

Hi,
Need to configure multiple Oracle DataSources in JB3.14. The help will be greatly appreciated.
Thanks

Satya

[informsantosh]

Hi
You can have the same oracle-ds.xml for many datasources

<?xml version="1.0" encoding="UTF-8"?>

<!-- ===================================================================== -->
<!-- -->
<!-- JBoss Server Configuration -->
<!-- -->
<!-- ===================================================================== -->

<!-- $Id: oracle-ds.xml,v 1.1.1.1 2004/02/09 19:54:11 gage Exp $ -->
<!-- ==================================================================== -->
<!-- Datasource config for Oracle originally from Steven Coy -->
<!-- ==================================================================== -->



<local-tx-datasource>
<jndi-name>ORACLE_DS_1</jndi-name>
<connection-url>jdbc:oracle:thin:@server1:1521:RORD</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>ROR_OWNER</user-name>
ROR_OWNER
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
</local-tx-datasource>

<local-tx-datasource>
<jndi-name>ORACLE_DS_2</jndi-name>
<connection-url>jdbc:oracle:thin:@server1:1521:RD</connection-url>
<driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
<user-name>ROR_USER</user-name>
ROR_USER
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
</local-tx-datasource>



Also if you have many datasources. You have luxary of writing 2 files like oracle-ds.xml,oracle-ds1.xml

Thanks

Santosh Korde