the jbossmq-service.xml file (jboss3.0.1rc1) has a sample config for hsql persistence. I found that the sqlProperties as listed have a small problem. The MARK_MESSAGE entry reads:
MARK_MESSAGE = UPDATE JMS_MESSAGES SET (TXID, TXOP) VALUES(?,?) WHERE MESSAGEID=? AND DESTINATION=?
which results in exception org.jboss.mq.SpyJMSException: Cannot process a transaction. The root cause is an unknown column SQL exception. changing to:
MARK_MESSAGE = UPDATE JMS_MESSAGES SET TXID=?, TXOP=? WHERE MESSAGEID=? AND DESTINATION=?
fixes it for me.
Eoin.
