0 Replies Latest reply on Jun 21, 2006 8:10 PM by Moises Quinto

    any workaround for XA END [SUSPEND] not supported in MySQL 5

    Moises Quinto Newbie

      I am getting the following error when starting jboss 4.0.4 with the jboss transaction manager, using MySql 5.0 as the default datasource.

      The docs of MySQL 5.0 says:
      For XA END the SUSPEND [FOR MIGRATE] clause is not supported

      is there any work around I could use for my tests?

      2006-06-21 16:54:59,061 DEBUG [org.jboss.mq.sm.jdbc.JDBCStateManager] Starting jboss.mq:service=StateManager
      2006-06-21 16:54:59,233 DEBUG [MySQL] Executing XA statement: XA START 0x312d613638303137613a313232663a34343939646334343a3131,0x613638303137613a313232663a34343939646334343a3135,0x20000
      2006-06-21 16:54:59,592 DEBUG [MySQL] Executing XA statement: XA END 0x312d613638303137613a313232663a34343939646334343a3131,0x613638303137613a313232663a34343939646334343a3135,0x20000 SUSPEND
      2006-06-21 16:54:59,592 DEBUG [MySQL] Executing XA statement:
      2006-06-21 16:54:59,592 ERROR [STDERR] java.sql.SQLException: XAER_INVAL: Invalid arguments (or unsupported command)
      2006-06-21 16:54:59,592 ERROR [STDERR] at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:946)
      2006-06-21 16:54:59,592 ERROR [STDERR] at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2822)
      2006-06-21 16:54:59,592 ERROR [STDERR] at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1536)
      2006-06-21 16:54:59,592 ERROR [STDERR] at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1626)
      2006-06-21 16:54:59,592 ERROR [STDERR] at com.mysql.jdbc.Connection.execSQL(Connection.java:3025)
      2006-06-21 16:54:59,592 ERROR [STDERR] at com.mysql.jdbc.Connection.execSQL(Connection.java:2954)
      2006-06-21 16:54:59,592 ERROR [STDERR] at com.mysql.jdbc.Statement.execute(Statement.java:681)
      2006-06-21 16:54:59,592 ERROR [STDERR] at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.dispatchCommand(MysqlXAConnection.java:473)
      2006-06-21 16:54:59,592 ERROR [STDERR] at com.mysql.jdbc.jdbc2.optional.MysqlXAConnection.end(MysqlXAConnection.java:379)
      2006-06-21 16:54:59,592 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.end(XAManagedConnection.java:127)
      2006-06-21 16:54:59,592 ERROR [STDERR] at com.arjuna.ats.internal.jta.transaction.jts.TransactionImple.delistResource(TransactionImple.java:951)
      2006-06-21 16:54:59,592 ERROR [STDERR] at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.delist(TxConnectionManager.java:581)