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

Fri May 2 05:03:18 EDT 2008

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: Other
    Affects Versions: JBossAS-4.2.3.GA
         Environment: Version 4.2.3_GA_SP of jbossts
            Reporter: Michael Musgrove
         Assigned To: Adrian Brock
            Priority: Optional

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

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: http://jira.jboss.com/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira