Hi Richard, Thanks for your reply. Basically i am setting up a context within our org so that all the tools will be deployed there. So my base framework has ibatis configured for it as the DAO Layer(uses SQLMaps). I had a requirement for reading a clob and also writing it to the Oracle database(ver 8.1.7).
I am a bit time crunched. I am implementing the normal way or using JDBC directly. Once i finish the initial version i will want to implement it in IBatis. I will surely start this conversation in this forum again and also try using oracle 10g driver. Thanks a lot for your time Prashanth Sukumaran. --- "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/ > __________________________________ Do you Yahoo!? Yahoo! Small Business - Try our new resources site! http://smallbusiness.yahoo.com/resources/
