数据库常见问题(一)
问题:ERROR BGJOB_2]com.kingdee.bos.dao.ormapping.SQLAccessException: update data error.Error for batch element #1: The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use.. SQLCODE=-302, SQLSTATE=22001, DRIVER=3.68.61
Caused exception message is: DataLimit
Caused exception message is: Error for batch element #1: The value of a host variable in the EXECUTE or OPEN statement is out of range for its corresponding use.. SQLCODE=-302, SQLSTATE=22001, DRIVER=3.68.61
原因:sql中要更新的某个字段的长度超过了数据库表中字段的定义长度。
梦想,是一个目标,是让自己活下去的原动力,是让自己开心的原因。坚持!