[jboss-jira] [JBoss JIRA] Updated: (JBAS-6510) Wrong SQL for XARecovery in hard-coded default values and guideline
[
https://jira.jboss.org/jira/browse/JBAS-6510?page=com.atlassian.jira.plug...
]
Rico Neubauer updated JBAS-6510:
--------------------------------
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.
was:
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 tJMSTransactions WHERE cXID 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.
Wrong SQL for XARecovery in hard-coded default values and guideline
-------------------------------------------------------------------
Key: JBAS-6510
URL: https://jira.jboss.org/jira/browse/JBAS-6510
Project: JBoss Application Server
Issue Type: Sub-task
Security Level: Public(Everyone can see)
Components: JMS (JBoss Messaging)
Affects Versions: JBossAS-4.2.3.GA
Reporter: Rico Neubauer
Assignee: Clebert Suconic
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.
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira