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.