[ https://jira.jboss.org/jira/browse/JBAS-1341?page=com.atlassian.jira.plug... ] Adrian Brock commented on JBAS-1341: ------------------------------------ To enable this experimental feature within JBossMQ change the jdbc2 persistence to To use this feature, you need a recovering transaction manager. 1) Set XARecovery=true 2) Add the alternate queries that will then be used to perform the recovery. <mbean code="org.jboss.mq.pm.jdbc2.PersistenceManager" name="jboss.mq.recovery:service=PersistenceManager"> ... <attribute name="XARecovery">true</attribute> <attribute name="SqlProperties"> ... INSERT_TX_XARECOVERY = INSERT INTO JMS_TRANSACTIONS (TXID, XID) VALUES(?, ?) DELETE_ALL_TX_XARECOVERY = DELETE FROM JMS_TRANSACTIONS WHERE XID IS NULL SELECT_ALL_TX_XARECOVERY = SELECT TXID, XID FROM JMS_TRANSACTIONS SELECT_MESSAGES_IN_DEST_XARECOVERY = SELECT MESSAGEID, MESSAGEBLOB, TXID, TXOP FROM JMS_MESSAGES WHERE DESTINATION=? SELECT_MESSAGE_XARECOVERY = SELECT MESSAGEID, MESSAGEBLOB, TXID, TXOP FROM JMS_MESSAGES WHERE MESSAGEID=? AND DESTINATION=? UPDATE_MARKED_MESSAGES_XARECOVERY = UPDATE JMS_MESSAGES SET TXID=?, TXOP=? WHERE TXOP=? AND TXID NOT IN (SELECT TXID FROM JMS_TRANSACTIONS WHERE XID IS NOT 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 IS NULL) CREATE_TX_TABLE_XARECOVERY = CREATE TABLE JMS_TRANSACTIONS ( TXID INTEGER, XID OBJECT, PRIMARY KEY (TXID) ) CREATE_TABLES_ON_STARTUP = TRUE </attribute> Notes. 1) Change the type OBJECT for the XID to be whatever is the blob type for the database (see MESSAGEBLOB on the JMS_MESSAGES table) 2) If you already started JBoss once, you'll need to drop table JMS_TRANSACTIONS or "alter table" it to add the new column. -- 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