How is your datasource configured to connect to Oracle: oci or thin? I've never stored BLOBs in Oracle - don't believe in it. But I've read on this list repeatedly that using the thin driver to store blobs won't work, you need the oci driver.
----- Original Message ----- From: "Marek Lange" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 15, 2003 6:20 AM Subject: [JBoss-user] JMS persistence manager for Oracle8 > 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? > > Thanks, > > -marek > > > > ------------------------------------------------------- > This sf.net email is sponsored by:ThinkGeek > Welcome to geek heaven. > http://thinkgeek.com/sf > _______________________________________________ > JBoss-user mailing list > [EMAIL PROTECTED] > https://lists.sourceforge.net/lists/listinfo/jboss-user > ------------------------------------------------------- This sf.net email is sponsored by:ThinkGeek Welcome to geek heaven. http://thinkgeek.com/sf _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
