Oracle+Mybatis插入Clob数据问题

<result column="content" property="content" jdbcType="CLOB" javaType="string" typeHandler="com.cn.handler.OracleClobTypeHandler" />

处理器代码:

package com.cn.handler;
import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import org.apache.ibatis.type.JdbcType;
import org.apache.ibatis.type.TypeHandler;
import oracle.sql.CLOB;

public class OracleClobTypeHandler implements TypeHandler<Object>{

public Object valueOf(String param) {  
        return null;  
    }  
    @Override  
    public Object getResult(ResultSet arg0, String arg1) throws SQLException {  
        CLOB clob = (CLOB) arg0.getClob(arg1);  
        return (clob == null || clob.length() == 0) ? null : clob.getSubString((long) 1, (int) clob.length());  
    }  
    @Override  
    public Object getResult(ResultSet arg0, int arg1) throws SQLException {  
        return null;  
    }  
    @Override  
    public Object getResult(CallableStatement arg0, int arg1) throws SQLException {  
        return null;  
    }  
    @Override  
    public void setParameter(PreparedStatement arg0, int arg1, Object arg2, JdbcType arg3) throws SQLException {  
        CLOB clob = CLOB.empty_lob();  
        clob.setString(1, (String) arg2);  
        arg0.setClob(arg1, clob);  
    }  

}

插入时注意:

<insert>

    insert into table(column,column...) values(value,value...)

</insert>

如果插入失败，则需要改成

<insert>

begin

    insert into table(column,column...) values(value,value...)

;end;

</insert>

2、CLOB类型不支持的语法有

呃呃呃呃