6 Replies Latest reply on Apr 15, 2014 5:19 AM by tomjenkinson

    xa_start - caught: XAException.XAER_INVAL for < 131

    blured75

      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.