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

た入场券 2022-09-22 11:37 19阅读 0赞

**【报错】**

**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

采取 \` 字符，即可 。

详见：

# [MySQL 中 \` 的保留字冲突处理][MySQL _ _] #

#  #

详址：http://blog.csdn.net/u013630349/article/details/51777115