Have you tried just reading or writing it just like any other field in iBATIS? If so, what did not work?
-Richard
At 01:56 PM 3/24/2005, you wrote:
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/
