【报错】BatchUpdateException: Data truncated for column 'id' at row 1
来源:互联网 发布:实战数据库营销 编辑:程序博客网 时间:2024/06/05 16:16
【报错】
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
【解决】
0 0
- 【报错】BatchUpdateException: Data truncated for column 'id' at row 1
- BatchUpdateException: Data truncated for column 'id' at row 1
- load data 报错" truncated for column..... at row 1"
- Data truncated for column 'id' at row 1
- java.sql.BatchUpdateException: Data truncated for column 'nowCost' at row 1
- mysql报错:1265 - Data truncated for column 'heroType' at row 1
- Data truncation: Data truncated for column 'content' at row 1
- Data truncation: Data truncated for column 'xxxxxxxxx' at row 1
- Data truncated for column at row
- Warning(1265)Data truncated for column 'v_mmi' at row 1
- Warning: Data truncated for column at row 1
- java.sql.BatchUpdateException: Data truncation: Data too long for column 'site_name' at row 1
- Caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'cont' at row 1
- Caused by: java.sql.BatchUpdateException: Data truncation: Data too long for column 'JLFSM' at row 1
- java.sql.SQLException: Data truncated for column 'uid' at row 1
- mysql导入文件出现Data truncated for column 'xxx' at row 1的原因
- 出现 Data truncated for column 'date' at row 1 的错误解决方案
- java.sql.SQLException: Data truncated for column 'myprice' at row 1
- C++虚函数表解析(基础篇)
- 数据结构中常见的树(BST二叉搜索树、AVL平衡二叉树、RBT红黑树、B-树、B+树、B*树)
- Toolbar使用
- 搭建messo+chronos+ zookeeper集群
- java处理字符串总结
- 【报错】BatchUpdateException: Data truncated for column 'id' at row 1
- spring 4.2.3返回视图(jsp/vm)或者json
- HDFS节点内数据平衡:DiskBalancer
- iOS json格式的字符串转字典或数组
- 如何mock合作方的报文(报文可设置)
- Java中的HashCode(2)之Hashset造成的内存泄露
- C++虚函数表解析(高级篇)
- mysql单表百万记录,limit分页
- 在myeclipse中安装JBOSS(转载)