mybatis获取oracle中的clob，long类型字段映射

long字段

<!-- 接口数据库用户的视图信息 -->

<resultMap id="viewsResultMap" type="com.ly.business.entity.servicemanager.ViewsInfoEntity">

<result property="styj" column="TEXT" /> //需要放在最前面 知道为什么 实在没有办法JDBC是可以读取long类型的

<result property="yhm" column="OWNER" />

<result property="stm" column="VIEW_NAME" />

</resultMap>

<select id="findDBinterfaceViews" resultMap="viewsResultMap">

SELECT TEXT,OWNER ,VIEW_NAME FROM ALL_VIEWS WHERE OWNER

NOT IN ('APEX_040200','APPQOSSYS','AUDSYS','CTXSYS','DBSNMP','DVSYS','FLOWS_FILES',

'GSMADMIN_INTERNAL','LBACSYS','MDSYS','OJVMSYS','OLAPSYS','ORDDATA','ORDSYS',

'OUTLN','SCOTT','SYS','SYSTEM','WMSYS','XDB')

</select>

clob字段

<!-- 接口数据库用户的视图信息 -->

<resultMap id="viewsSqlResultMap" type="com.ly.business.entity.servicemanager.ViewsInfoEntity">

<result property="styj" column="TEXT" jdbcType="CLOB"

javaType = "java.lang.String" typeHandler ="com.ly.business.common.mybatis.OracleClobTypeHandler"/>

</resultMap>

<select id="findDBinterfaceViewSQl" parameterType="com.ly.business.entity.servicemanager.ViewsInfoEntity" resultMap="viewsSqlResultMap">

SELECT DBMS_METADATA.GET_DDL('VIEW',#{stm, jdbcType=VARCHAR},#{yhm, jdbcType=VARCHAR}) AS TEXT FROM DUAL

</select>