Uploaded image for project: 'Application Server 3  4  5 and 6'
  1. Application Server 3 4 5 and 6
  2. JBAS-1341 XA Recovery
  3. JBAS-6510

Wrong SQL for XARecovery in hard-coded default values and guideline

    Details

    • Type: Sub-task
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: JBossAS-4.2.3.GA
    • Fix Version/s: None
    • Component/s: JMS (JBossMQ)
    • Labels:
      None

      Description

      Affected: 4.0.5, 4.2.3, maybe others.
      2 small SQL mistakes in description of http://jira.jboss.com/jira/browse/JBAS-1341 how to enable XARecovery and in its code:

      DELETE_ALL_TX_XARECOVERY = DELETE FROM JMS_TRANSACTIONS WHERE XID = NULL
      should be:
      DELETE_ALL_TX_XARECOVERY = DELETE FROM JMS_TRANSACTIONS WHERE XID IS NULL

      DELETE_MARKED_MESSAGES_WITH_TX_XARECOVERY = DELETE FROM JMS_MESSAGES WHERE TXOP=? AND JMS_MESSAGES.TXID IN (SELECT TXID FROM JMS_TRANSACTIONS WHERE XID = NULL)
      should be:
      DELETE_MARKED_MESSAGES_WITH_TX_XARECOVERY = DELETE FROM JMS_MESSAGES WHERE TXOP=? AND JMS_MESSAGES.TXID IN (SELECT TXID FROM JMS_TRANSACTIONS WHERE XID IS NULL)

      The default SQL statements are also wrong in org.jboss.mq.pm.jdbc2.PersistenceManager's code.

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                adrian.brock Adrian Brock
                Reporter:
                MrEasy Rico Neubauer
              • Votes:
                0 Vote for this issue
                Watchers:
                1 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: