Prashanth, What database are you using? I'm pretty sure that iBATIS handles CLOBS, and BLOBS fine out of the box. What error do you get?
-Richard -----Original Message----- From: Prashanth Sukumaran [mailto:[EMAIL PROTECTED] Sent: Thursday, March 24, 2005 10:12 AM To: ibatis-user-java@incubator.apache.org; Andrey Rogov Subject: Re: Struggling with insertion of Clob into the database. PS: Hi All, We need a proper implementation explanation for LOBs with IBatis. I am really wasting a lot of time. Please advice. Andrey you are right we need a clear implementation defn for iBatis. When i search for "IBatis CLOB" in google in dont get any page that gives the proper implementation explanation. Thanks in advance Prashanth. --- Andrey Rogov <[EMAIL PROTECTED]> wrote: > > Hi Prashanth, > > Some months ago I sent a letter about CLOB supporting to Clinton. He > sad me that LOB where not supported well! He sad, he hoped to solve > this problem with custom type handlers that will allow to deal with > LOBs as I like. That's why I've been reading LOB's by my 'fingers' ( > without iBatis. ), but, also I want to use iBatis in a whole! > > Let's ask Clinton about LOB;s support now, > > <statement id="LobSupport"> > is IBatis read Lobs ? > <isEqual property='YES'> > Long Live iBatis ! > </isEqual> > <isNotEqual property='YES'> > We want bread & sight & LOBS ! > </isNotEqual> > </statement> > > Andrey. > > PS> Hi Andrey, > > PS> I am able to get this working without ibatis this way, the normal > PS> JDBC way. > PS> Do i have to do the same in iBatis in order to get the Large String written into CLOB field. > > PS> Thanks > PS> Prashanth > > PS> --- Andrey Rogov <[EMAIL PROTECTED]> wrote: > >> > >> Before updating CLOB object you must create it. > >> First of all I've got new primary key ( by sequence ), Insert ' ' > >> into clob simply insert ' ' into ... clob, and when object was > >> created, write string. > >> > >> I use Oracle 9i, > >> classes12.jar. > >> > >> > >> PS> Hi, > >> > >> PS> I am trying to insert a String into a CLOB field into an Oracle > >> PS> Database. > >> > >> PS> Can anybody paste the code for this if you have already done > >> PS> this. > >> > >> PS> Thanks > >> PS> Prashanth. > >> > >> > >> > >> PS> __________________________________ > >> PS> Do you Yahoo!? > >> PS> Yahoo! Small Business - Try our new resources site! > >> PS> http://smallbusiness.yahoo.com/resources/ > >> > >> > >> > >> -- > >> regards, > >> Andrey mailto:[EMAIL PROTECTED] > >> > >> > > PS> __________________________________________________ > PS> Do You Yahoo!? > PS> Tired of spam? Yahoo! Mail has the best spam protection around > PS> http://mail.yahoo.com > > > > -- > С уважением, > Andrey mailto:[EMAIL PROTECTED] > > __________________________________ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/
