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/08/02 11:12:19
![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](/uploads/image/z/12007054-46-4.jpg?t=ORACL+%E5%BC%82%E5%B8%B8%EF%BC%9Acan+bind+a+LONG+value+only+for+insert+into+a+LONG+column%E4%BB%A5%E4%B8%8B%E4%B8%BA%E5%BC%82%E5%B8%B8%E4%BF%A1%E6%81%AF%EF%BC%9ACaused+by%3Ajava.sql.BatchUpdateException%3AORA-01461%3Acan+bind+a+LONG+value+only+for+insert+into+a+LONG+column..%E4%B8%A5%E9%87%8D%3AServlet.service%28%29+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 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