其中使用的有：ibatis-2.3.4.726.jar、ojdbc6.jar、classes12.jar
问题描述如下
当请求第三方做交易操作时，第三方会将交易的报文返回，我需要将请求的报文与返回的报文保存到表中。当报文较少的时候，能正常插入。但当报文比较大的时候，则无法进行插入操作。
异常信息如下
17:28:54,733 INFO [XmlBeanDefinitionReader] Loading XML bean definitions from class path resource [org/springframework/jdbc/support/sql-error-codes.xml]
17:28:54,906 INFO [SQLErrorCodesFactory] SQLErrorCodes loaded: [DB2, Derby, H2, HSQL, Informix, MS-SQL, MySQL, Oracle, PostgreSQL, Sybase]
17:29:07,084 ERROR [STDERR] org.springframework.jdbc.UncategorizedSQLException: SqlMapClient operation; uncategorized SQLException for SQL []; SQL state [null]; error code [17070];
--- The error occurred in com/upic/pay/biz/bo/sql/TradeMessagesSql.xml.
--- The error occurred while applying a parameter map.
--- Check the tradeMessages.insert-InlineParameterMap.
--- Check the parameter mapping for the 'requestXml' property.
--- Cause: java.sql.SQLException: 数据大小超出此类型的最大值: 3539; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
--- The error occurred in com/upic/pay/biz/bo/sql/TradeMessagesSql.xml.
--- The error occurred while applying a parameter map.
--- Check the tradeMessages.insert-InlineParameterMap.
--- Check the parameter mapping for the 'requestXml' property.
--- Cause: java.sql.SQLException: 数据大小超出此类型的最大值: 3539
环境大致描述如下：
oracle中有一张交易报文的表，其中包括请求与返回两个字段是clob类型。存放XML类型的数据。
主要的字段如下
BIZ_NO = #bizNo:VARCHAR#,
SERIALIZE_NO = #serializeNo:VARCHAR#,
RESPONSE_XML = #responseXml:CLOB#,
REQUEST_XML = #requestXml:CLOB#,
INTERACTIVE_TIME = #interactiveTime:DATE#,
INTERACTIVE_TYPE = #interactiveType:VARCHAR#,
CHANNEL_TYPE = #channelType:VARCHAR#,
TRADE_TYPE = #tradeType:VARCHAR#,
java对象主要属性如下：geter，seter方法略
private String messageId;
private String bizNo;
private String serializeNo;
private String responseXml;
private String requestXml;
private Date interactiveTime;
private String interactiveType;
private String channelType;
private String tradeType;
ibatis的配置主要点如下
dao-context.xml
<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
<property name="configLocation" value="com/upic/pay/biz/bo/sql/sql-map-config.xml" />
<property name="dataSource" ref="dataSource" />
<property name="lobHandler" ref="lobHandler" />
</bean>
<bean id="lobHandler" class="org.springframework.jdbc.support.lob.DefaultLobHandler" lazy-init="true"/>
sql-map-config.xml
<sqlMapConfig>
<settings
cacheModelsEnabled="true"
enhancementEnabled="true"
lazyLoadingEnabled="true"
maxSessions="3000"
maxTransactions="3000"
maxRequests="3000"/>
<typeHandler jdbcType="CLOB" javaType="java.lang.String" callback="org.springframework.orm.ibatis.support.ClobStringTypeHandler" />
</sqlMapConfig>
插入部分的sql如下
<insert id="tradeMessages.insert" parameterClass="com.upic.pay.domain.TradeMessages">
<![CDATA[
insert into T_PAY_TRADE_MESSAGES
(
MESSAGE_ID,
BIZ_NO,
SERIALIZE_NO,
RESPONSE_XML,
REQUEST_XML,
INTERACTIVE_TIME,
INTERACTIVE_TYPE,
CHANNEL_TYPE,
TRADE_TYPE,
CREATED_BY,
CREATED_DATE,
UPDATED_BY,
UPDATED_DATE
,DELETED_FLAG
)
values
(
#messageId:VARCHAR#,
#bizNo:VARCHAR#,
#serializeNo:VARCHAR#,
#responseXml,javaType=java.lang.String,jdbcType=CLOB#,
#requestXml,javaType=java.lang.String,jdbcType=CLOB#,
#interactiveTime:DATE#,
#interactiveType:VARCHAR#,
#channelType:VARCHAR#,
#tradeType:VARCHAR#,
#createdBy:VARCHAR#,
sysdate,
#updatedBy:VARCHAR#,
sysdate
,'0'
)
]]>
</insert>
网上查了不少文章，试了好几种方法，都是因为长度导致失败。特到这儿发帖求助，望大家帮忙看看怎么解决。
