Hi Thomas, does the plattform setting 'Oracle9i' only affect the client side and can i use it together with an 8i database, or do i have to use 9i on either side if i use Oracle9i in my connection descriptor.
Regards Max > -----Urspr�ngliche Nachricht----- > Von: Thomas Mahler [mailto:[EMAIL PROTECTED] > Gesendet: Dienstag, 25. Mai 2004 09:55 > An: OJB Users List > Betreff: 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]
