5 Replies Latest reply on Mar 18, 2005 3:23 PM by Mark Gruener

    oracle can not persist BLOB in JMS_MESSAGES table

    schambers Newbie

      I have looked everywhere and have not found that anyone is having this same problem, although we have it quite a lot, namely that Oracle (9.2.0.4 with thin driver) can not persist a BLOB with creating an empty one first and then updating with the binary data. For this reason we can not use the line of SQL found in the oracle-jdbc2-service.xml where

      INSERT_MESSAGE = INSERT INTO JMS_MESSAGES (MESSAGEID, DESTINATION, MESSAGEBLOB, TXID, TXOP) VALUES(?,?,?,?,?)


      Is this something that I am just missing? I saw a couple of posts about switching to oci drivers but, as this is a very large application, I am catching all kinds of trouble for even suggesting it. I also heard that the new Oracle 10g drivers might be different, but I got the same results with it.

      Thanks,
      Steve