I have a JBoss Seam application which uses two datasources, one Oracle and one
MySQL, requiring the use of an xa-datasource. Everything worked fine when
connecting to a MySQL 5 server but when I try to connect to a MySQL 4 server, I
get the following error:
| [com.arjuna.ats.internal.jta.transaction.arjunacore.enliststarterror]
[com.arjuna.ats.internal.jta.transaction.arjunacore.enliststarterror]
TransactionImple.enlistResource - XAResource.start returned:
[com.arjuna.ats.jta.utils.unknownerrorcode] Unknown error code:0 for < 131075,
26, 24, 1-1d060145:e81:475894cd:c81d060145:e81:475894cd:d2_
|
| com.mysql.jdbc.jdbc2.optional.MysqlXAException: You have an error in your
SQL syntax. Check the manual that corresponds to your MySQL server version for
the right syntax to use near 'XA START
0x312d31643036303134353a6538313a34373538393463643a6338
|
This used the 5.0.8 J/Connector driver since the 5.1.5 version causes JBoss to
hang during startup. I have read in other forums that there have been
xa-datasource issues related to the driver but I haven't found anything that
specifically triggers that unknown error code. My datasource is defined as
follows:
| <xa-datasource>
| <jndi-name>eventDBDatasource</jndi-name>
|
<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
| <xa-datasource-property
name="URL">${tm.event.db.url}</xa-datasource-property>
| <user-name>${tm.event.db.user}</user-name>
| <password>${tm.event.db.pass}</password>
| <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
| <track-connection-by-tx />
| <isSameRM-override-value>false</isSameRM-override-value>
| <no-tx-separate-pools>true</no-tx-separate-pools>
| <min-pool-size>5</min-pool-size>
| <max-pool-size>20</max-pool-size>
| <blocking-timeout-millis>5000</blocking-timeout-millis>
| <idle-timeout-minutes>15</idle-timeout-minutes>
|
<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>
| </xa-datasource>
|
|
Given I can't upgrade the MySQL server to 5.0, is there any configuration
setting I can modify to get the XA SQL syntax to work with 4.0? I was hoping
there was a config setting to make the SQL syntax generic enough so MySQL won't
complain about it. Any help would be appreciated. Thanks.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4111338#4111338
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4111338
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
