ORA-12899: value too large for...

最新推荐文章于 2024-08-19 11:44:14 发布

Jalen备忘录

最新推荐文章于 2024-08-19 11:44:14 发布

阅读量3.5k

点赞数

分类专栏： Exception

本文链接：https://blog.csdn.net/baidu_30809315/article/details/78496699

版权

Exception 专栏收录该内容

20 篇文章 0 订阅

订阅专栏

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

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