0 Replies Latest reply on Jul 30, 2002 9:37 AM by Eoin Curran

    sample config for hsql persistence: problem with MARK_MESSAG

    Eoin Curran Newbie

      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.