Storing LOBs with the thin driver fails in jboss but the same code runs and the same driver works fine in weblogic and as an stand-alone executable: verified several times on several jbi: 3.02 ... 3.06. Solution is to install oracle client and use OCI as you mentioned. Reason we're storing LOBs in the database (oracle or otherwise) is so we can write from a zipped war without having to set up external path access for each client's documents and images.
----- Original Message ----- From: "Guy Rouillier" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Saturday, February 15, 2003 9:39 AM Subject: Re: [JBoss-user] JMS persistence manager for Oracle8 > 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 ------------------------------------------------------- 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
