[jboss-jira] [JBoss JIRA] Created: (JBAS-7162) Add mysql-xa-ds.xml to JBOSS_HOME\docs\examples\jca directory

[asookazian (JIRA)]

Add mysql-xa-ds.xml to JBOSS_HOME\docs\examples\jca directory
-------------------------------------------------------------

                 Key: JBAS-7162
                 URL: https://jira.jboss.org/jira/browse/JBAS-7162
             Project: JBoss Application Server
          Issue Type: Feature Request
      Security Level: Public (Everyone can see)
    Affects Versions: JBossAS-5.1.0.GA
         Environment: n/a
            Reporter: asookazian
            Priority: Minor


JBoss 5.1.0.GA does not provide a xa-datasource example xml file for MySQL.  Please add.

Example (please note, this config is not fully tested!):

/**********************************************************************************************************************/

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

<!DOCTYPE datasources
    PUBLIC "-//JBoss//DTD JBOSS JCA Config 1.5//EN"
    "http://www.jboss.org/j2ee/dtd/jboss-ds_1_5.dtd">

<datasources>
     <xa-datasource>
         <jndi-name>bookingDatasource</jndi-name>
         <xa-datasource-property name="URL">jdbc:mysql://localhost:3306/jboss</xa-datasource-property>
         <xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
         <user-name>jboss</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-checker-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>

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira