-
1. Re: help : jdbc2.PersistenceManager in 3.0.4 with hsqldb
manishsharan Nov 13, 2002 7:36 PM (in response to manishsharan)I tried this in 3.0.3 and I get the same problem. I am convinced this cannot be a bug (pre-release unit tests would have caught it )but a misconfiguration on my end. Can someone please tell me what else do I need to do to make this work ?
This is what my jbossmq-service.xml looks like wehn I try to use the jdbc2 persistence manager.
<!-- The PersistenceManager is used to store messages to disk.
db/jbossmq/file
<depends optional-attribute-name="MessageCache">jboss.mq:service=MessageCache
| The jdbc2 PersistenceManager is the new improved JDBC implementation.
| This implementation allows you to control how messages are stored in
| the database.
|
| Use this PM if you want the reliablity a relational database can offer
| you. The default configuration is known to work with hsqldb, other databases
| will requrie teaking of the SqlProperties.
-->
<depends optional-attribute-name="MessageCache">jboss.mq:service=MessageCache
<depends optional-attribute-name="DataSource">jboss.jca:service=LocalTxDS,name=hsqldbDS
jboss.jca:service=LocalTxCM,name=hsqldbDS
BLOB_TYPE=OBJECT_BLOB
INSERT_TX = INSERT INTO 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 JMS_MESSAGES
SELECT_MESSAGES_IN_DEST = SELECT MESSAGEID, MESSAGEBLOB FROM JMS_MESSAGES WHERE DESTINATION=?
SELECT_MESSAGE = SELECT MESSAGEID, MESSAGEBLOB FROM JMS_MESSAGES WHERE MESSAGEID=? AND DESTINATION=?
MARK_MESSAGE = UPDATE JMS_MESSAGES SET (TXID, TXOP) VALUES(?,?) WHERE MESSAGEID=? AND DESTINATION=?
DELETE_ALL_MESSAGE_WITH_TX = DELETE FROM JMS_MESSAGES WHERE TXID=?
DELETE_TX = DELETE FROM JMS_TRANSACTIONS WHERE TXID = ?
DELETE_MARKED_MESSAGES = DELETE FROM JMS_MESSAGES WHERE TXID=? AND TXOP=?
DELETE_MESSAGE = DELETE FROM JMS_MESSAGES WHERE MESSAGEID=? AND DESTINATION=?
CREATE_MESSAGE_TABLE = CREATE TABLE JMS_MESSAGES ( MESSAGEID INTEGER NOT NULL, \
DESTINATION VARCHAR(50) NOT NULL, TXID INTEGER, TXOP CHAR(1), \
MESSAGEBLOB OBJECT, PRIMARY KEY (MESSAGEID, DESTINATION) )
CREATE_TX_TABLE = CREATE TABLE JMS_TRANSACTIONS ( TXID INTEGER ) -
2. Re: help : jdbc2.PersistenceManager in 3.0.4 with hsqldb
adrian.brock Nov 13, 2002 9:24 PM (in response to manishsharan)This is wrong
MARK_MESSAGE = UPDATE JMS_MESSAGES SET (TXID, TXOP) VALUES(?,?)
This is correct
MARK_MESSAGE = UPDATE JMS_MESSAGES SET TXID=?, TXOP=?
Regards,
Adrian -
3. Re: help : jdbc2.PersistenceManager in 3.0.4 with hsqldb
manishsharan Nov 13, 2002 10:11 PM (in response to manishsharan)Thank You ! Thank You !! It worked. I changed the statement as you suggested and its working !
Regards
-m