JBoss EAP 6.3 H2 MySQL Oracle datasources

README.md

    <extension module="org.jboss.as.weld"/>
</extensions>
<system-properties>
    <property name="com.sun.xml.ws.transport.http.HttpAdapter.dump" value="true"/>
    <property name="com.sun.xml.ws.transport.http.client.HttpTransportPipe.dump" value="true"/>
    <property name="com.sun.xml.internal.ws.transport.http.HttpAdapter.dump" value="true"/>
    <property name="com.sun.xml.internal.ws.transport.http.client.HttpTransportPipe.dump" value="true"/>
</system-properties>
<management>
    <security-realms>

<subsystem xmlns="urn:jboss:domain:datasources:1.2">
            <datasources>

                <!-- ===================== H2 === ===================== -->

                <datasource jndi-name="java:jboss/datasources/H2DS" pool-name="H2DS" enabled="true" use-java-context="true">
                    <connection-url>jdbc:h2:tcp://localhost/~/dev/tmp/isps;INIT=CREATE SCHEMA IF NOT EXISTS ccmc;</connection-url>
                    <driver>h2</driver>
                    <security>
                        <user-name>xxx</user-name>
                        <password>xxx</password>
                    </security>
                </datasource>

                <xa-datasource jndi-name="java:jboss/datasources/H2DSXA" enabled="true" use-java-context="true" pool-name="H2DSXA">
                    <xa-datasource-property name="URL">jdbc:h2:tcp://localhost/~/dev/tmp/ispsxa;INIT=CREATE SCHEMA IF NOT EXISTS ccmc;</xa-datasource-property>
                    <xa-datasource-property name="DatabaseName">ispstool</xa-datasource-property>
                    <driver>h2</driver>
                    <security>
                        <user-name>xxx</user-name>
                        <password>xxx</password>
                    </security>
                </xa-datasource>


                <!-- ===================== Oracle ===================== -->

                <xa-datasource jndi-name="java:/OracleDSXA" pool-name="ISPS_PU" enabled="true" use-ccm="false">
                    <xa-datasource-property name="URL">jdbc:oracle:thin:@xxx:1521:alc</xa-datasource-property>
                    <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
                    <driver>oracle</driver>
                    <xa-pool>
                        <min-pool-size>10</min-pool-size>
                        <max-pool-size>20</max-pool-size>
                        <prefill>true</prefill>
                        <is-same-rm-override>false</is-same-rm-override>
                        <interleaving>false</interleaving>
                        <pad-xid>false</pad-xid>
                        <wrap-xa-resource>false</wrap-xa-resource>
                    </xa-pool>
                    <security>
                        <user-name>xxx</user-name>
                        <password>xxx</password>
                    </security>
                    <validation>
                        <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/>
                        <validate-on-match>false</validate-on-match>
                        <background-validation>false</background-validation>
                        <stale-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleStaleConnectionChecker"/>
                        <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleExceptionSorter"/>
                    </validation>
                    <timeout>
                        <set-tx-query-timeout>false</set-tx-query-timeout>
                        <blocking-timeout-millis>0</blocking-timeout-millis>
                        <idle-timeout-minutes>0</idle-timeout-minutes>
                        <query-timeout>0</query-timeout>
                        <use-try-lock>0</use-try-lock>
                        <allocation-retry>0</allocation-retry>
                        <allocation-retry-wait-millis>0</allocation-retry-wait-millis>
                        <xa-resource-timeout>0</xa-resource-timeout>
                    </timeout>
                    <statement>
                        <share-prepared-statements>false</share-prepared-statements>
                    </statement>
                </xa-datasource>

                <!-- ===================== MySQL ====================== -->

                <xa-datasource jndi-name="java:/MysqlDSXA" pool-name="mysql" enabled="true" use-java-context="true">
                    <xa-datasource-property name="URL">
                        jdbc:mysql://localhost:3306/ispstool
                    </xa-datasource-property>
                    <driver>mysql</driver>
                    <!-- https://en.wikipedia.org/wiki/Isolation_%28database_systems%29 -->

                    <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
                    <security>
                        <user-name>xxx</user-name>
                        <password>xxx</password>
                    </security>
                </xa-datasource>

                <!-- ==================== DRIVERS ===================== -->

                <drivers>
                    <driver name="mysql" module="com.mysql">
                        <driver-class>com.mysql.jdbc.Driver</driver-class>
                        <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
                    </driver>
                    <driver name="oracle" module="com.oracle">
                        <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
                    </driver>
                    <driver name="h2xa" module="com.h2database.h2">
                        <driver-class>org.h2.Driver</driver-class>
                        <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
                    </driver>
                </drivers>
            </datasources>