作业帮 > 综合 > 作业

ORACL 异常：can bind a LONG value only for insert into a LONG c

来源：学生作业帮 编辑：大师作文网作业帮 分类：综合作业 时间：2024/11/12 01:32:47
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 c
原因大概如下：
1、插入到字符串长度大于4000字节.
2、插入到表中的记录的某个字段数据的实际长度大于2000个字节（如果是UTF-8,则是1333个字节）；或者是插入的记录中有两个或两个以上长度大于2000字节的字符串.
3、数据库与客户端的JDBC驱动不匹配.
建议用Oracle 10g 10.2.0.4 JDBC_classes12.ja
ORACL 异常：can bind a LONG value only for insert into a LONG c you can 什么a short speech into a long one I can can a can,for a long time. I long for a moment__I can have a rest.A.when B.which C.wher train for a long think for a long FOR LONG OF A Only __ a long growing period can large plants exist. "Darling!for a long long time love! How long can I the book ?--For two days. A borrow B lend C k can I wait for you A long time? i think i can like you for a long time