clob 데이터 타입 처리

sql-mapper-config.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE configuration PUBLIC "-//mybatis.org//DTD Config 3.0//EN" "http://mybatis.org/dtd/mybatis-3-config.dtd">

<configuration>
  	<!-- mybatis option null column view -->
  	<settings>
  		<setting name="mapUnderscoreToCamelCase" value="true"/>
	  	<setting name="callSettersOnNulls" value="true"/>
	  	<setting name="cacheEnabled" value="false" />
	  	<setting name="jdbcTypeForNull" value="NULL"/>
	</settings>

    <typeAliases>
		<typeAlias alias="egovMap" type="egovframework.rte.psl.dataaccess.util.EgovMap"/>
		<typeAlias type="java.util.HashMap" alias="hmap"/>
		<typeAlias alias="searchVO" type="kecic.cmmn.service.SearchVO"/>
    </typeAliases>
    
    <typeHandlers>
        <typeHandler handler="org.apache.ibatis.type.ClobTypeHandler" jdbcType="CLOB" javaType="java.lang.String"/>
    </typeHandlers>
</configuration>

 

 

SQL.xml

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">

<mapper namespace="testNs">
	<resultMap id="testMap" type="egovMap">  
		<result property="CN" column="cn" jdbcType="CLOB" javaType="java.lang.String" />		
	 </resultMap>
     
    <select id="selectTest" resultMap="testMap"> 
    	쿼리
    </select>
</mapper>