ORA-12899: value too large for...

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

1. 字段长度不足

原因：

### 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或更长。

最后

以上就是长情海燕为你收集整理的ORA-12899: value too large for...的全部内容，希望文章能够帮你解决ORA-12899: value too large for...所遇到的程序开发问题。

如果觉得靠谱客网站的内容还不错，欢迎将靠谱客网站推荐给程序员好友。