mybatis 大字段问题处理

小咪咪 2022-08-08 15:52 262阅读 0赞

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;

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);
        }
    }