Thanks Adrain!
1. I replaced it with:
DELETE_MARKED_MESSAGES_WITH_TX = DELETE FROM JMS_MESSAGES WHERE TXID IN (SELECT TXID
FROM JMS_TRANSACTIONS) AND TXOP=?
2. also reduced the DESTINATION VARCHAR(250) to VARCHAR(190)
3. and change BLOB_TYPE=BINARYSTREAM_BLOB.
It worked now for jdbc2 PM. I al
I tried to use jdbc2 persistent manager (jboss3.2.4) with firebird database and
jaybird jdbc driver v1.5 and I kept getting the following error messages:
12:59:24,000 WARN [ServiceController] Problem starting service
jboss.mq:service=PersistenceManager
| org.jboss.mq.SpyJMSException: Could n