ibatis + spring框架下，对CLOB字段操作

ibatis + spring框架下，对CLOB字段操作。

TfBTradeInterSend.xml设置：

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap
PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN"
"http://ibatis.apache.org/dtd/sql-map-2.dtd">

<sqlMap namespace="TfBTradeInterSend">
<typeAlias alias="TfBTradeInterSend" type="com.sitech.groupcust.common.dto.TfBTradeInterSend"/>

<resultMap id="TfBTradeInterSendResult" class="TfBTradeInterSend">
<result property="tradeId" column="TRADE_ID"/>
<result property="subscribeId" column="SUBSCRIBE_ID"/>
<result property="infaceType" column="INFACE_TYPE"/>
<result property="dealState" column="DEAL_STATE"/>
<result property="dealMsg" column="DEAL_MSG"/>
<result property="resendCount" column="RESEND_COUNT"/>
<result property="sendContent" column="SEND_CONTENT" javaType="java.lang.String" jdbcType="CLOB"/>
<result property="dealDate" column="DEAL_DATE"/>
<result property="inDate" column="IN_DATE"/>
<result property="notes" column="NOTES"/>
<result property="provinceCode" column="PROVINCE_CODE"/>
</resultMap>

t.send_content: 类型是CLOB。

问题描述：根据上面sqlMapClient设置后，当对send_content进行插入、更新操作时，没问题。但是当以send_content:作为查询条件时，报下面的错误：

ORA-00932: inconsistent datatypes

解决：

select * from tf_b_trade_inter_send t where

dbms_lob.instr(t.send_content,'02BBSS000100001348479247031914',1,1)>0

参考：http://www.iteye.com/problems/64807