Uploaded image for project: 'Application Server 3  4  5 and 6'
  1. Application Server 3 4 5 and 6
  2. JBAS-7162

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

    XMLWordPrintable

Details

    • Feature Request
    • Resolution: Obsolete
    • Minor
    • No Release
    • JBossAS-5.1.0.GA
    • None
    • None

    Description

      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>

      Attachments

        Activity

          People

            Unassigned Unassigned
            asookazian Arbi Sookazian (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: