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

View the original post : 
http://www.jboss.org/index.html?module=bb&op=viewtopic&p=3854815#3854815

Reply to the post : 
http://www.jboss.org/index.html?module=bb&op=posting&mode=reply&p=3854815


-------------------------------------------------------
This SF.Net email is sponsored by:
Sybase ASE Linux Express Edition - download now for FREE
LinuxWorld Reader's Choice Award Winner for best database on Linux.
http://ads.osdn.com/?ad_id=5588&alloc_id=12065&op=click
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user

Reply via email to