ORA-12899: value too large for...

81 阅读 0 评论 54 点赞

我是靠谱客的博主长情海燕，这篇文章主要介绍ORA-12899: value too large for...，现在分享给大家，希望可以做个参考。

数据库字段设置问题，这里是文件路径长度不足

1. 字段长度不足

原因：

复制代码

1
2
3
4
5
6
7
8
9
10
### Error updating database.
Cause: java.sql.SQLException: ORA-12899: value too large for column "IFLYYJY"."FILE_UPLOAD"."FILEPATH" (actual: 56, maximum: 50)
### The error may exist in file [/app/tomcat_gps/apache-tomcat-7.0.79/webapps/ifly-web-gps/WEB-INF/classes/com/iflytek/gps/gps/entity/mapper/GPSFileUploadMapper.xml]
### The error may involve com.iflytek.gps.gps.dao.GPSFileUploadMapper.insertFileData-Inline
### The error occurred while setting parameters
### SQL: INSERT INTO FILE_UPLOAD (ID,fileName, fileLength, fileStoreName,
filePath, isHandled,createTime)
VALUES (?,?, ?, ?,
?, ?,?)
### Cause: java.sql.SQLException: ORA-12899: value too large for column "IFLYYJY"."FILE_UPLOAD"."FILEPATH" (actual: 56, maximum: 50)

修改：

将FILE_UPLOAD表中FILEPATH字段长度修改为100或更长。