[jboss-jira] [JBoss JIRA] Closed: (JBAS-5502) Enabling JBossMQ XA recovery fails

Enabling JBossMQ XA recovery fails ---------------------------------- Key: JBAS-5502 URL: http://jira.jboss.com/jira/browse/JBAS-5502 Project: JBoss Application Server Issue Type: Bug Security Level: Public(Everyone can see) Components: JMS service Affects Versions: JBossAS-4.2.2.GA Environment: Version 4.2.3_GA_SP of jbossts Reporter: Michael Musgrove Assigned To: Adrian Brock Priority: Optional Fix For: JBossAS-5.0.0.CR1, JBossAS-4.2.3.GA Set the XARecovery property of the JBossMQ PersistenceManager mbean to true. When the persistence manager tries to restore a queue it gets the following exception. Caused by: java.sql.SQLException: Column Index out of range, 3 > 1. at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:910) at com.mysql.jdbc.ResultSet.checkColumnBounds(ResultSet.java:690) at com.mysql.jdbc.ResultSet.getLong(ResultSet.java:2854) at com.mysql.jdbc.ResultSet.getLong(ResultSet.java:2845) at org.jboss.resource.adapter.jdbc.WrappedResultSet.getLong(WrappedResultSet.java:721) at org.jboss.mq.pm.jdbc2.PersistenceManager.internalRestoreQueue(PersistenceManager.java:649) This is because it is using the wrong result set on line 648 of org.jboss.mq.pm.jdbc2.PersistenceManager