【报错】BatchUpdateException: Data truncation: Data too long

最新推荐文章于 2025-03-06 08:30:00 发布

稚枭天卓

最新推荐文章于 2025-03-06 08:30:00 发布

阅读量5.3k

点赞数 1

分类专栏： JavaWeb贴士 MySQL 入门文章标签： BatchUpdateException truncation long batch update

本文链接：https://blog.youkuaiyun.com/u013630349/article/details/51776238

版权

JavaWeb贴士同时被 2 个专栏收录

70 篇文章

订阅专栏

MySQL 入门

25 篇文章

订阅专栏

本文介绍了在使用Hibernate框架操作MySQL数据库过程中遇到的数据截断异常问题及其解决方案。异常主要是由于插入数据长度超过字段定义长度导致，通过调整字段长度或确保字符集一致性可以有效解决。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

【报错】

log4j:WARN No appenders could be found for logger (org.hibernate.type.BasicTypeRegistry).

log4j:WARN Please initialize the log4j system properly.
log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
Tue Jun 28 15:11:58 CST 2016 WARN: Establishing SSL connection without server's identity verification is not recommended. According to MySQL 5.5.45+, 5.6.26+ and 5.7.6+ requirements SSL connection must be established by default if explicit option isn't set. For compliance with existing applications not using SSL the verifyServerCertificate property is set to 'false'. You need either to explicitly disable SSL by setting useSSL=false, or set useSSL=true and provide truststore for server certificate verification.
Hibernate: insert into User (name, password, createTime, expireTime, id) values (?, ?, ?, ?, ?)
org.hibernate.exception.DataException: Could not execute JDBC batch update
   at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:102)
   at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
   at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:275)
   at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:268)
   at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:184)
   at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:321)
   at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:51)
   at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1216)
   at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:383)
   at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:133)
   at com.tgbnode.hibernate.Client.main(Client.java:35)
Caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'id' at row 1
   at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
   at sun.reflect.NativeConstructorAccessorImpl.newInstance(Unknown Source)
   at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(Unknown Source)
   at java.lang.reflect.Constructor.newInstance(Unknown Source)
   at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
   at com.mysql.jdbc.Util.getInstance(Util.java:387)
   at com.mysql.jdbc.SQLError.createBatchUpdateException(SQLError.java:1161)
   at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1773)
   at com.mysql.jdbc.PreparedStatement.executeBatchInternal(PreparedStatement.java:1257)
   at com.mysql.jdbc.StatementImpl.executeBatch(StatementImpl.java:958)
   at org.hibernate.jdbc.BatchingBatcher.doExecuteBatch(BatchingBatcher.java:70)
   at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:268)
   ... 8 more
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'id' at row 1
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3964)
   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3902)
   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2526)
   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2673)
   at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2549)
   at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1861)
   at com.mysql.jdbc.PreparedStatement.executeUpdateInternal(PreparedStatement.java:2073)
   at com.mysql.jdbc.PreparedStatement.executeBatchSerially(PreparedStatement.java:1751)

... 12 more

【解决】

1. 可能是因为数据库里的表设置的字符集不相同。

解决方法：将数据库、库表、字段的字符集设置成一致。

2. 也可能真是数据库字段里数据库确实过长(本次就是遇到的这种情况)。

去数据库中，修改 varchar 字段长度，将20调整为40，即可。

3. 对某些不常见的字符( 比如 “ · ? 空白符号 “ ) 会出现Data too long for column

采取 ` 字符，即可。

详见：