I second Richard's comments. The 2.0.9 release of iBATIS handles CLOBs and BLOBs to byte[] (and possibly others), out of the box. This, of course, depends on the JDBC driver supporting the necessary features. If you're using Oracle, you may want to give the 10g drivers a chance, I have heard good things on the list for them.
Furthermore, understand that any handling of column types not natively supported in iBATIS (per the documentation), needs a TypeHandlerCallback written. So, maybe you could Google on that, and you may have more luck. I am fairly certain that the iBATIS Wiki also has some information on writing a Callback. At some point, someone even posted some code for a CLOB handler ... it may have been on the old SF.net forums, though - not the new Apache mailing lists. Here's a link to the iBATIS Javadocs that gives an example ... http://www.ibatis.com/common/javadocs/com/ibatis/sqlmap/client/extensions/TypeHandlerCallback.html Good luck and remember that iBATIS always accepts contributions from skilled developers such as yourself! Best, Brice Ruth On Thu, 24 Mar 2005 18:29:31 -0000, Yee, Richard K, CTR,, DMDCWEST <[EMAIL PROTECTED]> wrote: > 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/ >
