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

<!-- ===================================================================== -->
<!--                                                                       -->
<!--  Engine DS Configuration                                              -->
<!--                                                                       -->
<!-- ===================================================================== -->

<datasources>
    <xa-datasource>
        <jndi-name>jdbc/OracleDS</jndi-name>
        <track-connection-by-tx>true</track-connection-by-tx>
        <isSameRM-override-value>false</isSameRM-override-value>
        <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
        <xa-datasource-property name="URL">jdbc:oracle:thin:@(DESCRIPTION = (LOAD_BALANCE=ON) (FAILOVER=ON)(ADDRESS = (PROTOC
OL = TCP)(HOST = mzmpm01srv015)(PORT = 1523))(ADDRESS = (PROTOCOL = TCP)(HOST = mzmpm01srv016)(PORT = 1523))(CONNECT_DATA =(S
ERVICE_NAME = erp)(SERVER=SHARED)(FAILOVER_MODE=(TYPE=select)(METHOD=basic))))</xa-datasource-property>
        <xa-datasource-property name="User">engineuser</xa-datasource-property>
        <xa-datasource-property name="Password">password</xa-datasource-property>
        <exception-sorter-class-name>
            org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter
        </exception-sorter-class-name>
        <min-pool-size>0</min-pool-size>
        <max-pool-size>110</max-pool-size>
        <idle-timeout-minutes>10</idle-timeout-minutes>

        <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>

        <no-tx-separate-pools/>

       <!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -->
       <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connec
tion-checker-class-name>

       <!-- Checks the Oracle error codes and messages for fatal errors -->
       <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name
>

       <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml (optional) -->
       <metadata>
          <type-mapping>Oracle9i</type-mapping>
       </metadata>

    </xa-datasource>

    <mbean code="org.jboss.resource.adapter.jdbc.vendor.OracleXAExceptionFormatter"
name="jboss.jca:service=OracleXAExceptionFormatter">
        <depends optional-attribute-name="TransactionManagerService">
            jboss:service=TransactionManager
        </depends>
    </mbean>

</datasources>