有关存储clob大字段的设置

1   spring中 配置

<bean id="nativeJdbcExtractor"
  class="org.springframework.jdbc.support.nativejdbc.CommonsDbcpNativeJdbcExtractor"
  lazy-init="true" />
 <bean id="oracleLobHandler"
  class="org.springframework.jdbc.support.lob.OracleLobHandler"
  lazy-init="true">
  <property name="nativeJdbcExtractor">
   <ref local="nativeJdbcExtractor" />
  </property>
 </bean>
 <bean id="sqlMapClient"
  class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
  <property name="configLocation">
   <value>WEB-INF/sqlMapConfig.xml</value>
  </property>
  <property name="lobHandler">
   <ref local="oracleLobHandler" />
  </property>
 </bean>

 

 

2  sqlMapConfig.xml配置文件修改

 

<sqlMapConfig>
 <settings
  cacheModelsEnabled="true"
  enhancementEnabled="true"
  lazyLoadingEnabled="true"
  errorTracingEnabled="true"
  maxRequests="32"
  maxSessions="10"
  maxTransactions="5"
  useStatementNamespaces="true"
 />
 <typeHandler jdbcType="CLOB" javaType="java.lang.String" callback="org.springframework.orm.ibatis.support.ClobStringTypeHandler" />

 

3    ibais配置文件修改 

     插入是指定类型 #×××Intro:CLOB#,

    结果指定类型 <result property="**ntro" column="**_INTRO" jdbcType="CLOB"/>