ibatis+spring select oracle clob

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. Relative

to 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.xsd

http://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>