【报错】BatchUpdateException: Data truncated for column 'id' at row 1

缺乏、安全感 2022-09-22 08:11 205阅读 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 14:53:55 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.GenericJDBCException: Could not execute JDBC batch update  
at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)  
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)  
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 truncated 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: java.sql.SQLException: Data truncated for column 'id' at row 1  
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:963)  
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3966)  
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

【解决】

这个错误 其实就是插入的数据不合法造成的, 比如:乱码，超出字段长度，非法字符等, 此次非法是由于 id 在数据库中是 int 类型，而在 java 文件中是 string 类型，同一类型即可实现 数据库的增删改查。