org.springframework.jdbc.UncategorizedSQLException:
### Error updating database. Cause: java.sql.SQLException: ORA-01461: 仅能绑定要插入 LONG 列的 LONG 值
### The error may involve com.extr.persistence.ExamPaperMapper.insertExamPaper-Inline
### The error occurred while setting parameters
### SQL: insert into et_exam_paper (id,name,content,duration,pass_point,total_point,status,summary,is_visible,answer_sheet,group_id, is_subjective,creator,paper_type,field_id) values (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? )
### Cause: java.sql.SQLException: ORA-01461: 仅能绑定要插入 LONG 列的 LONG 值
protected Object content;
<resultMap id ="myMapper" type="org.zz.ExamPaper" >
<result property ="id" column="id" jdbcType="VARCHAR" />
<result property ="content" column="content" jdbcType="CLOB" javaType = "java.lang.String" typeHandler ="org.service.OracleClobTypeHandler" />
<result property ="duration" column="duration" jdbcType="INTEGER" />
<result property ="create_time" column="create_time" jdbcType="DATE" javaType="java.util.Date" />
</resultMap>
import java.sql.CallableStatement;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import oracle.sql.CLOB;
import org.apache.ibatis.type.JdbcType;
import org.apache.ibatis.type.TypeHandler;
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);
}
}