Thanks Thomas, that's work. I'm stupid, I set the plateform to Oracle instead of Oracle9i.
Kind regards, Christophe -----Original Message----- From: Thomas Mahler [mailto:[EMAIL PROTECTED] Sent: Tue 5/25/2004 9:55 AM To: OJB Users List Cc: Subject: Re: Oracle & Blob Hi Christophe, This is a known problem with Oracles thin driver. You can try to either use the "thick" driver or to try to use Oracle9i platform in your connection descriptor. Thomas Christophe Lombart wrote: > 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]
