Thanks Bruce! I am off to download the new drivers...
--- Bruce Snyder <[EMAIL PROTECTED]> wrote: > 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] > ------------------------------------------------- > > ------------------------------------------------- If you wish to unsubscribe from this list, please send an empty message to the following address: [EMAIL PROTECTED] -------------------------------------------------
