Hi,
I just can't get the JBossMQ persistence manager to work with an Oracle8 data source. The tables JMS_TRANSACTIONS and JMS_MESSAGES are successfully created (using BLOB_TYPE=BLOB and the sql statement
CREATE_MESSAGE_TABLE = CREATE TABLE JMS_MESSAGES ( MESSAGEID INTEGER NOT NULL, \
DESTINATION VARCHAR(255) NOT NULL, TXID INTEGER, TXOP CHAR(1), \
MESSAGEBLOB BLOB, PRIMARY KEY (MESSAGEID, DESTINATION) )
from jbossmq-service.xml.
When a message should be inserted, it fails throwing this SQL Exception:
An exception occured while sending message to the jms queue: org.jboss.mq.SpyJMSException: Could not store message: 4 msg=1 hard NOT_STORED PERSISTENT queue=QUEUE.smsMessageQueue priority=4 hashCode=11632138; - nested throwable: (java.sql.SQLException: invalid column type)
I think the problem is related to the oracle BLOB type. Is there a solution for this?