JBoss Mysql XA datasource

standalone-full.xml

<datasources>
                <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>sa</user-name>
                        <password>sa</password>
                    </security>
                </datasource>
                <xa-datasource jndi-name="java:jboss/datasources/H2DSXA" pool-name="H2DSXA" enabled="true" use-java-context="true">
                    <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">
                        xxx
                    </xa-datasource-property>
                    <driver>h2</driver>
                    <security>
                        <user-name>xxx</user-name>
                        <password>xxx</password>
                    </security>
                </xa-datasource>
                <xa-datasource jndi-name="java:/OracleDSXA" pool-name="OracleDSXA" 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>
                <xa-datasource jndi-name="java:/MysqlDSXA" pool-name="MysqlDSXA" enabled="true" use-java-context="true">
                    <xa-datasource-property name="URL">
                        jdbc:mysql://localhost:3306/xxx
                    </xa-datasource-property>
                    <driver>mysql</driver>
                    <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
                    <security>
                        <user-name>xxx</user-name>
                        <password>xxx</password>
                    </security>
                </xa-datasource>
                <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="h2" module="com.h2database.h2">
                        <driver-class>org.h2.Driver</driver-class>
                        <xa-datasource-class>org.h2.jdbcx.JdbcDataSource</xa-datasource-class>
                    </driver>
                </drivers>
            </datasources>