reply myself:
this only chages two files---jbossmq-destinations-service.xml as
<depends
optional-attribute-name="DestinationManager">jboss.mq:service=DestinationManager
true
and null-persistence-service.xml as add these codes
<!-- An optional delegate for real persistence of some destinations
e.g. jdbc2 -->
<depends
optional-attribute-name="DelegatePM">jboss.mq:service=SomePersistenceManager
<depends
optional-attribute-name="ConnectionManager">jboss.jca:service=DataSourceBinding,name=DefaultDB
BLOB_TYPE=BINARYSTREAM_BLOB
INSERT_TX = INSERT INTO ALLHOTDB.JMS_TRANSACTIONS (TXID) values(?)
INSERT_MESSAGE = INSERT INTO JMS_MESSAGES (MESSAGEID, DESTINATION,
MESSAGEBLOB, TXID, TXOP) VALUES(?,?,?,?,?)
SELECT_ALL_UNCOMMITED_TXS = SELECT TXID FROM JMS_TRANSACTIONS
SELECT_MAX_TX = SELECT MAX(TXID) FROM (SELECT MAX(TXID) AS TXID FROM
JMS_TRANSACTIONS UNION SELECT MAX(TXID) AS TXID FROM JMS_MESSAGES)
DELETE_ALL_TX = DELETE FROM JMS_TRANSACTIONS
SELECT_MESSAGES_IN_DEST = SELECT MESSAGEID, MESSAGEBLOB FROM
ALLHOTDB.JMS_MESSAGES WHERE DESTINATION=?
SELECT_MESSAGE = SELECT MESSAGEID, MESSAGEBLOB FROM ALLHOTDB.JMS_MESSAGES
WHERE MESSAGEID=? AND DESTINATION=?
MARK_MESSAGE = UPDATE ALLHOTDB.JMS_MESSAGES SET TXID=?, TXOP=? WHERE
MESSAGEID=? AND DESTINATION=?
UPDATE_MESSAGE = UPDATE ALLHOTDB.JMS_MESSAGES SET MESSAGEBLOB=? WHERE
MESSAGEID=? AND DESTINATION=?
UPDATE_MARKED_MESSAGES = UPDATE ALLHOTDB.JMS_MESSAGES SET TXID=?, TXOP=?
WHERE TXOP=?
UPDATE_MARKED_MESSAGES_WITH_TX = UPDATE ALLHOTDB.JMS_MESSAGES SET TXID=?,
TXOP=? WHERE TXOP=? AND TXID=?
DELETE_MARKED_MESSAGES_WITH_TX = DELETE FROM ALLHOTDB.JMS_MESSAGES MESS
WHERE TXOP=:1 AND EXISTS (SELECT TXID FROM ALLHOTDB.JMS_TRANSACTIONS TX WHERE
TX.TXID = MESS.TXID)
DELETE_TX = DELETE FROM ALLHOTDB.JMS_TRANSACTIONS WHERE TXID = ?
DELETE_MARKED_MESSAGES = DELETE FROM ALLHOTDB.JMS_MESSAGES WHERE TXID=?
AND TXOP=?
DELETE_TEMPORARY_MESSAGES = DELETE FROM ALLHOTDB.JMS_MESSAGES WHERE
TXOP='T'
DELETE_MESSAGE = DELETE FROM ALLHOTDB.JMS_MESSAGES WHERE MESSAGEID=? AND
DESTINATION=?
CREATE_MESSAGE_TABLE = CREATE TABLE ALLHOTDB.JMS_MESSAGES ( MESSAGEID
INTEGER NOT NULL, \
DESTINATION VARCHAR(255) NOT NULL, TXID INTEGER, TXOP CHAR(1), \
MESSAGEBLOB BLOB, PRIMARY KEY (MESSAGEID, DESTINATION) )
CREATE_IDX_MESSAGE_TXOP_TXID = CREATE INDEX JMS_MESSAGES_TXOP_TXID ON
ALLHOTDB.JMS_MESSAGES (TXOP, TXID)
CREATE_IDX_MESSAGE_DESTINATION = CREATE INDEX JMS_MESSAGES_DESTINATION ON
ALLHOTDB.JMS_MESSAGES (DESTINATION)
CREATE_TX_TABLE = CREATE TABLE ALLHOTDB.JMS_TRANSACTIONS ( TXID INTEGER,
PRIMARY KEY (TXID) )
CREATE_TABLES_ON_STARTUP = FALSE
<!-- Uncomment to override the transaction timeout for recovery per
queue/subscription, in seconds -->
<!--attribute name="RecoveryTimeout">0</attribute-->
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=3982336#3982336
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=3982336
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
