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]
