Data truncation: Incorrect datetime value: '' for column 'EVENT_DATE' at row 1
来源:互联网 发布:帝国cms 统计代码 编辑:程序博客网 时间:2024/04/30 21:11
hibernate执行到session.getTransaction().commit();是报异常:
Data truncation: Incorrect datetime value: '' for column 'EVENT_DATE' at row 1
找了好久,终于找到问题了,记录一下:
我使用的jdk是1.8,hibernate是4.2,mysql-connector是3.1,结果运行下面代码
// 读取hibernate.cfg.xml文件Configuration cfg = new Configuration().configure();// 建立SessionFactorySessionFactory sessionFactory = cfg.buildSessionFactory();Session session = sessionFactory.openSession();session.beginTransaction();session.save(new Event("b very first event!", new Date()));session.save(new Event("A follow up event", new Date()));session.getTransaction().commit();session.close();
Exception in thread "main" org.hibernate.exception.DataException: could not execute statementat org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:71)at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:49)at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:124)at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:109)at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:189)at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:59)at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3079)at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:3521)at org.hibernate.action.internal.EntityInsertAction.execute(EntityInsertAction.java:88)at org.hibernate.engine.spi.ActionQueue.execute(ActionQueue.java:395)at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:387)at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:303)at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:349)at org.hibernate.event.internal.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:56)at org.hibernate.internal.SessionImpl.flush(SessionImpl.java:1195)at org.hibernate.internal.SessionImpl.managedFlush(SessionImpl.java:404)at org.hibernate.engine.transaction.internal.jdbc.JdbcTransaction.beforeTransactionCommit(JdbcTransaction.java:101)at org.hibernate.engine.transaction.spi.AbstractTransactionImpl.commit(AbstractTransactionImpl.java:175)at com.struts.user.service.EventService.main(EventService.java:27)Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'EVENT_DATE' at row 1at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2973)at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1600)at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1129)at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:681)at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1368)at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1283)at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1268)at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.executeUpdate(ResultSetReturnImpl.java:186)... 14 more
查了下说是因为我的mysql-connector的jar包不匹配造成的,于是我将
mysql-connector-java-3.1.14-bin.jar
换成
mysql-connector-java-5.0.8-bin.jar
异常就消失了
阅读全文
0 0
- Data truncation: Incorrect datetime value: '' for column 'EVENT_DATE' at row 1
- Data truncation: Incorrect datetime value: '' for column 'xxxx' at row
- Data truncation: Incorrect datetime value: '' for column 'create_date' at row 1
- Data truncation: Incorrect datetime value: '' for column 'pdate' at row 1
- Data truncation: Incorrect datetime value: '' for column 'start' at row 1的解决方法
- Data truncation: Incorrect datetime value: '' for column 'time' at row 1
- jbpm 4.4 启动流程实例报错:Data truncation: Incorrect datetime value: '' for column 'START_' at row 1
- MySql Incorrect datetime value: '' for column 'dateTime' at row 1
- Incorrect datetime value: '' for column 'log_time' at row 1
- Incorrect datetime value: '' for column 'ordertime' at row 1
- Data truncation: Incorrect datetime value: '' for column XX
- 解决异常 Data truncation: Incorrect datetime value: '' for column 'ordertime'
- Data truncation: Data truncated for column 'content' at row 1
- Data truncation: Data truncated for column 'xxxxxxxxx' at row 1
- Data truncation: Out of range value for column '列名' at row 1
- Exception:Data truncation: Out of range value for column 'phone' at row 1异常问题
- 解决Incorrect datetime value: '' for column 'time' at row 1的问题
- 【SSH网上商城】Incorrect datetime value: '' for column 'pdate' at row 1
- docker下运行sonarqube
- HDU
- STM32单片机ESP8266发送数据到WiFi接收端代码实现
- 随手笔记
- static 关键字
- Data truncation: Incorrect datetime value: '' for column 'EVENT_DATE' at row 1
- 数据结构--表(List)
- eclipse插件的安装方式,例如checkstyle插件
- iTOP-4412搭建Linux+QT开发环境
- 从零开始建立Rancher Catalog模板
- # 快速、轻量级自定义图库选择库(仿微信图库选择界面)
- 《中文版PHOTOSHOP.CS3完全自学教程》李金明.李金荣.彩色扫描版.pdf
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE的调错
- JavaScript获取时间戳的方法