6 Replies Latest reply: Apr 15, 2014 5:19 AM by Tom Jenkinson RSS

xa_start - caught: XAException.XAER_INVAL for < 131

blured blured Newbie

Hello,

I'd like to test XA datasource toward mysql 5. However, as soon as I acess to a datasource inside jboss 4.2.0 GA (like on jboss 4.0.0), I get the message :
<<
09:26:56,950 WARN [loggerI18N] [com.arjuna.ats.internal.jta.transaction.arjunac
ore.xastart] [com.arjuna.ats.internal.jta.transaction.arjunacore.xastart] Transa
ctionImple.enlistResource - xa_start - caught: XAException.XAER_INVAL for < 131
075, 25, 23, 1-ae10719:a5e:467f6dbd:4bae10719:a5e:467f6dbd:4f
>
09:26:56,950 ERROR [STDERR] com.mysql.jdbc.jdbc2.optional.MysqlXAException: XAER
_INVAL: Invalid arguments (or unsupported command)
09:26:56,950 ERROR [STDERR] at com.mysql.jdbc.jdbc2.optional.MysqlXAConnecti
on.mapXAExceptionFromSQLException(MysqlXAConnection.java:566)
09:26:56,950 ERROR [STDERR] at com.mysql.jdbc.jdbc2.optional.MysqlXAConnecti
on.dispatchCommand(MysqlXAConnection.java:549)
09:26:56,950 ERROR [STDERR] at com.mysql.jdbc.jdbc2.optional.MysqlXAConnecti
on.start(MysqlXAConnection.java:489)
09:26:56,950 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.xa.XAManagedC
onnection.start(XAManagedConnection.java:121)
09:26:56,950 ERROR [STDERR] at org.jboss.resource.connectionmanager.xa.JcaXA
ResourceWrapper.start(JcaXAResourceWrapper.java:113)
09:26:56,950 ERROR [STDERR] at com.arjuna.ats.internal.jta.transaction.arjun
acore.TransactionImple.enlistResource(TransactionImple.java:775)
09:26:56,950 ERROR [STDERR] at com.arjuna.ats.internal.jta.transaction.arjun
acore.TransactionImple.enlistResource(TransactionImple.java:446)
09:26:56,950 ERROR [STDERR] at org.jboss.resource.connectionmanager.TxConnec
tionManager$TxConnectionEventListener$TransactionSynchronization.enlist(TxConnec
tionManager.java:773)
>>

Identicam result with driver jconnecter 5.0.6 et 5.1.0.

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


<xa-datasource>
<jndi-name>MyApp_RW_DS</jndi-name>

<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
<xa-datasource-property name="URL">jdbc:mysql://localhost:3306/myApp</xa-datasource-property>
<user-name>root</user-name>
password
<transaction-isolation>TRANSACTION_REPEATABLE_READ</transaction-isolation>
<max-pool-size>5</max-pool-size>
<min-pool-size>0</min-pool-size>

<blocking-timeout-millis>2000</blocking-timeout-millis>
<idle-timeout-minutes>2</idle-timeout-minutes>
<track-connection-by-tx>true</track-connection-by-tx>
<no-tx-separate-pools>false</no-tx-separate-pools>


<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>

<type-mapping>mySQL</type-mapping>

</xa-datasource>

<xa-datasource>
<jndi-name>MyApp_RO_DS</jndi-name>

<xa-datasource-class>com.mysql.jdbc.jdbc2.optional.MysqlXADataSource</xa-datasource-class>
<xa-datasource-property name="URL">jdbc:mysql://localhost:3306/myApp</xa-datasource-property>
<user-name>root</user-name>
password
<transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>
<max-pool-size>5</max-pool-size>
<min-pool-size>0</min-pool-size>

<blocking-timeout-millis>2000</blocking-timeout-millis>
<idle-timeout-minutes>2</idle-timeout-minutes>
<track-connection-by-tx>true</track-connection-by-tx>
<no-tx-separate-pools>false</no-tx-separate-pools>


<exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MySQLExceptionSorter</exception-sorter-class-name>

<type-mapping>mySQL</type-mapping>

</xa-datasource>


>>

I've seen those ref :
http://bugs.mysql.com/bug.php?id=27832
http://www.jboss.com/index.html?module=bb&op=viewtopic&t=106725

Did you already get this kind of error ?

Regards,
Blured.