Well, I was looking for patching village and/or torque, but it is harder than I thought as in fact the blob column in oracle needs 3 steps when creating (insert null blob, select it for update, update), 2 when updating (same without nullblob) !!!
see http://otn.oracle.com/sample_code/tech/java/sqlj_jdbc/files/advanced/LOBSample/LOBSample.java.html, this is just awful... I'm VERY surprised that the jdbc thin driver for oracle isn't handling setbinarystream correctly for blob, you have to make an explicit call oracle.sql.Blob, which means you have to make an Oracle specific code :( Someone told me that blob handling in oracle was weird, I can confirm :) Aurelien Weaver, Scott a �crit : > I have already converted my personal jetspeed security > implementation from Torque to OJB. I plan on donating that > along with an event driven security pipeline for 1.5. I > could also look at porting the DBPSML to OJB also. I think > BLOBS+Oracle+OJB are working, at least according to the OJB lists > they are ;) > > Regards, > *================================* >> Scott T Weaver | >> <[EMAIL PROTECTED]> | >> Apache Jetspeed Portal Project | >> Apache Pluto Portlet Container | > *================================* --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
