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