1 Reply Latest reply on Mar 17, 2005 8:53 AM by Santosh Korde

    Havine multiple Oracle Data Sources in JBOSS3.14

    satyadoorva Newbie

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

      Satya

        • 1. Re: Havine multiple Oracle Data Sources in JBOSS3.14
          Santosh Korde Newbie

          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