Hi Max,
I'm not really sure. I think it is really a problem located in the Oracle thin driver.
I don't know If it is possible to use a 9i thin driver to access an Oracle 8 db. If so, it should be OK to use the Oracle9iPlatformImpl.
I guess it's at least worth a try, Thomas
Geigl Maximilian, R235 wrote:
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]
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
