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

    Details

    • Workaround:
      Workaround Exists
    • Workaround Description:
      Hide

      Set RecoverMessagesChunk to 0

      Show
      Set RecoverMessagesChunk to 0
    • Estimated Difficulty:
      Low

      Description

      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

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  adrian.brock Adrian Brock
                  Reporter:
                  mmusgrov Michael Musgrove
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  0 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: