So the BLOBs work with this format. I need to try this same thing again with CLOBs. The CLOBs are character data, not binary data, and should come back as a string instead of a byte-array (according to the documentation), but maybe I should try this again with your way below. I think I was using "CLOB" (all upper case). You are using "Blob" (Pascal-case) and maybe if I use "Clob" it will work.
Tony -----Original Message----- From: Tony Wang [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 27, 2007 9:52 AM To: [email protected]; [EMAIL PROTECTED] Subject: RE: Oracle CLOB and IBatis 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
