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

    XMLWordPrintable

Details

    • Sub-task
    • Resolution: Done
    • Major
    • None
    • JBossAS-4.2.3.GA
    • JMS (JBossMQ)
    • 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.

      Attachments

        Activity

          People

            adrian.brock Adrian Brock (Inactive)
            r.neubauer@seeburger.de Rico Neubauer (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: