Hi Max, I red this page but some usefull info are missing. Furthermore, I didn't found a solution in the mail archive and I'm using the Oracle 9i thin driver.
My most important question is : I'm wondering if OJB uses oracle.sql.BLOB which seems to be required for Blob access within Oracle. Where Can I check the code used in this area ? I don't understand why I got the following exception for a very small stream : java.sql.SQLException: Oracle thin driver cannot update BLOB values with length>2000. (Consider using Oracle9i as OJB platform). Thanks, Christophe -----Original Message----- From: Geigl Maximilian, R235 [mailto:[EMAIL PROTECTED] Sent: Tue 5/25/2004 9:21 AM To: OJB Users List Cc: Subject: AW: Oracle & Blob Hi Christophe, i do not use BLOBS but there were discussions about this problem - it seems it is a bug in the Oracle 8.1.x thin driver. Maybe the following information helps you to solve your problem: http://db.apache.org/ojb/howto-use-lobs.html If not, i didn't here abaout a similar problem with the Oracle 9i thin driver, maybe you want to try this - it shoul word with an existion 8i database, too. Regards Max > -----Ursprüngliche Nachricht----- > Von: Christophe Lombart > [mailto:[EMAIL PROTECTED] > Gesendet: Montag, 24. Mai 2004 23:45 > An: [EMAIL PROTECTED] > Betreff: Oracle & Blob > > > Hi All, > > I'm just wondering how to defined a blob attribute for the Oracle > plateform ? > > I got the following error : > > java.sql.SQLException: Oracle thin driver cannot update BLOB > values with > length>2000. (Consider using Oracle9i as OJB platform.) > > What I did is : > 1. in the repository.xml : > <field-descriptor > name="content" > jdbc-type="BLOB" > column="CONTENT" > /> > > 2. In the class impl : > protected byte[] content; > > 3. in the table definition : > CONTENT BLOB NULL > > What's wrong ? I'm wondering if OJB uses oracle.sql.BLOB which is > required for Blob within Oracle. > > Kind regards, > Christophe > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
