ibatis-user-java mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andre Peterka" <apete...@nsdcom.de>
Subject AW: Clob - with oracle 9 and spring transaction
Date Mon, 19 Jun 2006 13:36:33 GMT
Hi Hilde,

I also have ecountered problems with LOBs and Oracle Databases (8i and 9i).  Although I was
using BLOBs as opposed to CLOBs. I did not receive any errors, but the LOB in the Db was truncated
(I assume at the 4000kb boundary).  I few years back, I coded my own jbdcHandlers to insert
the LOBs, but as of Oracle 10g I am using the 10g JDBC driver on the 9i DataBase with success.
 Give it a try.


> -----Urspr√ľngliche Nachricht-----
> Von: Hilde.DE-GRAEVE@ext.cec.eu.int 
> [mailto:Hilde.DE-GRAEVE@ext.cec.eu.int] 
> Gesendet: Montag, 19. Juni 2006 14:48
> An: user-java@ibatis.apache.org
> Betreff: Clob - with oracle 9 and spring transaction
> Hello,
> We have a Oracle database with a clob. When inserting a new 
> record to this table with Ibatis and when the text is bigger 
> then 4000kb, oracle says that the size is to big. We checked 
> the faq and have done those changes using the <property 
> name="Driver.SetBigStringTryClob" value="true"/> but we still 
> have the same problem.
> Does anyone have an example on how to insert text to a clob 
> bigger than 4000kb using Ibatis and Spring transaction.
> Thank you,
> Hilde

View raw message