MySQL XA datasource and JBoss

For some reason, I had a really hard time finding how to setup an XA datasource in JBoss for MySQL. Below is the contents of the file mysql-xa-ds.xml.

<datasources>
     <xa-datasource>
         <jndi-name>jdbc/DataSource</jndi-name>
         <xa-datasource-property name="URL">jdbc:mysql://localhost:3306/ordb</xa-datasource-property>
         <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
         <user-name>root</user-name>
         <password>password</password>
         <track-connection-by-tx>true</track-connection-by-tx>
         <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
         <valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLValidConnectionChecker</valid-connection-chec    ker-class-name>
         <min-pool-size>1</min-pool-size>
         <max-pool-size>10</max-pool-size>
         <idle-timeout-minutes>10</idle-timeout-minutes>
         <metadata>
             <type-mapping>mySQL</type-mapping>
         </metadata>
     </xa-datasource>
 </datasources>
June 06th 2009 Posted to Technology

Comments are closed.