ORACL 异常：can bind a LONG value only for insert into a LONG column以下为异常信息：Caused by:java.sql.BatchUpdateException:ORA-01461:can bind a LONG value only for insert into a LONG column..严重:Servlet.service() for servlet default th
来源：学生作业帮助网 编辑：六六作业网 时间：2024/12/19 12:24:38
ORACL 异常：can bind a LONG value only for insert into a LONG column以下为异常信息：Caused by:java.sql.BatchUpdateException:ORA-01461:can bind a LONG value only for insert into a LONG column..严重:Servlet.service() for servlet default th
ORACL 异常：can bind a LONG value only for insert into a LONG column
以下为异常信息：
Caused by:java.sql.BatchUpdateException:ORA-01461:can bind a LONG value only for insert into a LONG column
.
.
严重:Servlet.service() for servlet default threw exception
java.sql.BatchUpdateException:ORA-01461:can bind a LONG value only for insert into a LONG column
...
...
Hibernate operation:Could not execute JDBC batch update; uncategorized SQLException for SQL [update INS_MTO_PLAN_UNIT_MX set REMARK=?,CAPABILITYID=?,CAPABILITY=?,CAPABILITYDATE=?,PROCESSINGRESULTS=?,ALARMID=?,ALARM=?,INS_MTO_PLAN_UNIT_ID=?,ALARMLEVEL=?,ALARMTYPE=?,ALARMDATE=?where ID=?]; SQL state [72000]; error code [1461]; ORA-01461:can bind a LONG value only for insert into a LONG column
; nested exception is java.sql.BatchUpdateException:ORA-01461:can bind a LONG value only for insert into a LONG column
能准确描述错误原因最好.
没有的话,
请列举 出现这个错误有哪些原因.
ORACL 异常：can bind a LONG value only for insert into a LONG column以下为异常信息：Caused by:java.sql.BatchUpdateException:ORA-01461:can bind a LONG value only for insert into a LONG column..严重:Servlet.service() for servlet default th
原因大概如下：
1、插入到字符串长度大于4000字节.
2、插入到表中的记录的某个字段数据的实际长度大于2000个字节（如果是UTF-8,则是1333个字节）；或者是插入的记录中有两个或两个以上长度大于2000字节的字符串.
3、数据库与客户端的JDBC驱动不匹配.
建议用Oracle 10g 10.2.0.4 JDBC_classes12.jar