any workaround for XA END [SUSPEND] not supported in MySQL 5
moisesjboss Jun 21, 2006 8:10 PMI 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)