Hi
I have this map with a CLOB field in Oracle 9i/10g database. It never gives
me any trouble at all (C#NET iBatis.NET).
Type of the property DocData is byte[].
<resultMap id="DocumentDataResult" class="DocumentDataValue">
<result property="DocId" column="DOCID"
dbType="Int32"/>
<result property="DocData" column="DOCDATA"
dbType="Blob"/>
<result property="RevisionDate" column="REVDATETIME"
dbType="Date"/>
</resultMap>
Thanks,
Tony
-----Original Message-----
From: Tony Selke [mailto:[EMAIL PROTECTED]
Sent: June-26-07 9:27 PM
To: [email protected]
Subject: RE: Oracle CLOB and IBatis
I posted this same question 1-2 weeks ago with no response yet. The
iBATIS.NET documentation claims support for CLOBs, but I could not get them
to work. We temporarily changed them to VARCHAR(4000), but I need to
revisit this soon.
Tony
-----Original Message-----
From: Sheldon A. Brown [mailto:[EMAIL PROTECTED]
Sent: Tuesday, June 26, 2007 8:25 PM
To: [email protected]
Subject: Oracle CLOB and IBatis
Has anyone been able to hook up IBatis 1.6.1 with an Oracle Database
and transfer large CLOBs (greater than 4000 characters)?
If so, could you please steer me in the right direction.
I quickly tried to implement a CustomTypeHandler but was greeted by
the infamous ORA-01460: unimplemented or unreasonable conversion
requested.
It seems like someone else must have done this by now. I see that
Java IBatis now officially supports BLOBs and CLOBs as well. Is this
planned for IBatis .Net?
Sheldon
