On 07 Mar 2005 04:37, grrrrr wrote:

>On 22 Jan 2004 10:44, themax wrote:

>>From what I can see CLOB / CLOB support varies for these databases
and 
>>drivers:

>>2) Oracle 9.2.0.2 using Oracle thin driver 9.2.0.3: Good. Works for
>>4000 char clobs, but I get errors trying to deal with anything
>>bigger.. possibly a sqlplus option that needs to be set.

>Oracle says NOT A BUG.

>Use OCI, or use JDBC-Thin-Driver specfic streaming methods for larger
>than 4000.

I would also recommend using the Oracle 10g JDBC driver if possible. 
It works with Oracle8 and Oracle9i, and provides a fix for this 
limitation. If you set the connection 
property "SetBigStringTryClob=true", no need for Clobs as big (4k+) 
strings will work in PreparedStatements, etc. We made the change and 
all of our Pojos now use strings (no Clobs). We routinely (and 
unfortunately) sling 6-8k string (xml) blobs to Oracle9i CLOB columns 
using java.lang.String mappings in Hibernate 2.1.8. No problems 
encountered so far.