On 6/1/05, August Detlefsen <[EMAIL PROTECTED]> wrote: > I am trying to update a CLOB field in oracle 9i. If I make the content > of the field longer than 4000 characters, the transaction succeeds, but > the value never gets updated in the database. Thereafter, I can see the > changes to the object that is in Castor's cache, but if I reload the > app server (thus wiping the cache) they disappear. > > Has anyone else seen behavior like this? Am I doing something wrong? > Here is the mapping and table definition.
The Oracle JDBC drivers up through 9i had bugs that caused limitations with LOBs, one of which surrounded a limitation of 4k in size. Making use of the 10g drivers has solved some of these issues. Also note that you don't need to be running the 10g database to use the 10g JDBC drivers. Oracle's JDBC drivers are fully backward compatible back to 8i. I blogged about the 10g JDBC drivers back in December here: http://jroller.com/page/bsnyder/20041202#oracle10g_jdbc_driver_fixes_lob Bruce -- perl -e 'print unpack("u30","D0G)[EMAIL PROTECTED]&5R\"F)R=6-E+G-N>61E<D\!G;6%I;\"YC;VT*" );' The Castor Project http://www.castor.org/ Apache Geronimo http://geronimo.apache.org/ ------------------------------------------------- If you wish to unsubscribe from this list, please send an empty message to the following address: [EMAIL PROTECTED] -------------------------------------------------
