Caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'JLFSM' at row 1
来源:互联网 发布:易语言软件破解 编辑:程序博客网 时间:2024/05/13 20:02
Caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'JLFSM' at row 1
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2018)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1454)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:2018)
at com.mysql.jdbc.PreparedStatement.executeBatch(PreparedStatement.java:1454)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeBatch(NewProxyPreparedStatement.java:1723)
at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
... 131 more
今天在添加的时候遇到这个错误,原因是在添加数据的时候,
添加的字段或者内容与数据库的字段不相符,请认真检查数据库的字段与添加或修改的字段是否一样
提供解决方法:
1:修改该的长度:alter table test modify column JLFSM varchar(130); ,之前我的长度是1,现在增大,已解决
2:修改类型: alter table test modify columnJLFSM char(30); 修改类型
请认真检查:数据库、库表、字段的字符集设置成一致。
阅读全文
0 0
- Caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'JLFSM' at row 1
- Caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'cont' at row 1
- java.sql.BatchUpdateException: Data truncation: Data too long for column 'site_name' at row 1
- java.sql.BatchUpdateException: Data truncation: Data too long for column
- java-mysql异常<Data truncation: Data too long for column 'name ' at row 1>讨论
- java-mysql异常<Data truncation: Data too long for column 'name ' at row 1>讨论
- 报错Java.sql.SQLException: Data truncation: Data too long for column 'content' at row 1 Query
- Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'name' at r
- Data truncation: Data too long for column 'name' at row 1的处理
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'title' at row 1
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'title' at row 1
- Data truncation: Data too long for column 'name' at row 1
- SSH - Data truncation: Data too long for column 'name' at row 1
- Data truncation: Data too long for column '***' at row 1 的解决
- Data truncation: Data too long for column 'id' at row 1
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'title' at row 1
- Data truncation: Data too long for column 'name' at row 1
- Data truncation: Data too long for column 'XXX' at row 1
- 简单描述为什么编译Android C程序所用的交叉编译工具链是arm-linux-androideabi-xx不是GNU开发的工具链arm-linux-gnueabi-xx?
- ORACLE PACKAGE 包详解
- 网络通信socket连接数上限
- 中国物联网产业应用联盟——物联网产业知识培训一期
- iOS 应用架构
- Caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'JLFSM' at row 1
- Android DragGridView的简单介绍
- Mac安装软件----XXX 已损坏,打不开。您应该推出磁盘映像。
- js基础-canvas
- 数据库中事务隔离级别详解
- H5 唤醒Android App
- 微信小程序
- Mac和Windows上hosts代理配置
- 【python图像处理】python绘制灰度直方图