Uploaded image for project: 'Application Server 3  4  5 and 6'
  1. Application Server 3 4 5 and 6
  2. JBAS-5502

Enabling JBossMQ XA recovery fails

XMLWordPrintable

    • Low
    • Workaround Exists
    • Hide

      Set RecoverMessagesChunk to 0

      Show
      Set RecoverMessagesChunk to 0

      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

              adrian.brock Adrian Brock (Inactive)
              rhn-engineering-mmusgrov Michael Musgrove
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: