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]



Reply via email to