ibatis+spring select oracle clob

zenzuguo

sql-map-config.xml
 
<?xml version="1.0" encoding="UTF-8" ?><!
 

DOCTYPE sqlMapConfig PUBLIC "-//ibatis.apache.org//DTD SQL Map Config 2.0//EN"
 

 
 
"http://ibatis.apache.org/dtd/sql-map-config-2.dtd" >
 
<
 

sqlMapConfig >
 

 
 
<settings enhancementEnabled="true" maxTransactions="20" lazyLoadingEnabled=
"true" maxRequests="32" maxSessions="10" />
 

 
 
<typeHandler jdbcType="CLOB" javaType="java.lang.String"
 

 
callback="org.springframework.orm.ibatis.support.ClobStringTypeHandler" />
 
 
 

 
<!-- Identify all SQL Map XML files to be loaded by this SQL map. Relativeto classpath -->

 

 
 
<sqlMap resource="sqlmaps/LookupSQL.xml" />
 
 

 
</
 
sqlMapConfig >


<?
 
xml version="1.0" encoding="UTF-8"?><
 

beans xmlns="http://www.springframework.org/schema/beans" 

xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:context="http://www.springframework.org/schema/context" 

xmlns:aop="http://www.springframework.org/schema/aop" 

xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.5.xsdhttp://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
http://www.springframework.org/schema/context http://www.springframework.org/schema/context/spring-context-2.5.xsd"
 

default-lazy-init="true">
 
　
applicationContext-dao.xml
　
 
<bean id="nativeJdbcExtractor" class="org.springframework.jdbc.support.nativejdbc.CommonsDbcpNativeJdbcExtractor" /> 
 

<bean id="oracleLobHandler" class="org.springframework.jdbc.support.lob.OracleLobHandler" lazy-init="true">  

<property name="nativeJdbcExtractor">  

<ref local="nativeJdbcExtractor" /> 
 

</property>
 
</bean> 
 
 

<!-- SqlMap setup for iBATIS Database Layer -->
 
<bean id="sqlMapClient" class="org.springframework.orm.ibatis.SqlMapClientFactoryBean">
 
<property name="configLocation" value="classpath:/admin/sql-map-config.xml" />
 
<property name="dataSource" ref="dataSource" />
 
<property name="lobHandler">  

<ref local="oracleLobHandler" />  

</property> 
 

</bean>
 
 
<!-- Transaction manager for a single JDBC DataSource -->
 
<bean id="transactionManager" 

class="org.springframework.jdbc.datasource.DataSourceTransactionManager">
 
<property name="dataSource" ref="dataSource" />
 
</bean>
 
 
<!-- Activates scanning of @Autowired -->
 
<context:annotation-config />
 
 
<!-- Activates scanning of @Repository -->
</
 
beans>