com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value
来源:互联网 发布:域名不以封疆 编辑:程序博客网 时间:2024/05/21 06:17
记录由Windows + MySql5.0.45 升级为Linux +Mysql 5.6.17时遇到的问题。
现象:数据库升级后,能正常查询。但在插入datetime类型的字段报如下错误:
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'crtTime' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2868)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1573)
at com.mysql.jdbc.ServerPreparedStatement.serverExecute(ServerPreparedStatement.java:1160)
at com.mysql.jdbc.ServerPreparedStatement.executeInternal(ServerPreparedStatement.java:685)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1400)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1314)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:1299)
解决方法:将驱动由mysql-connector-java-5.0.3-bin.jar更新为mysql-connector-java-5.1.10-bin.jar 问题解决。
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value:
- mysql 插入中文报错: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value...
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value: '' for column 'rdate'
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value
- MysqlDataTruncation: Data truncation: Incorrect datetime value
- Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value: 'L
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE
- com.mysql.jdbc.MysqlDataTruncation: Data truncation异常
- com.mysql.jdbc.MysqlDataTruncation: Data truncation异常
- nested exception is com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE的调错
- MysqlDataTruncation: Data truncation: Truncated incorrect DOUBLE value
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value adjusted for column 'price'
- Cause: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Truncated incorr
- ERROR JDBCExceptionReporter: Data truncation: Incorrect datetime value
- Best Time to Buy and Sell Stock_Runtime error 1
- OpenTextFile
- iOS Developer:真机测试
- android ContentResolver ContentProvider 详解
- 近期非技术类书籍读书计划
- com.mysql.jdbc.MysqlDataTruncation: Data truncation: Incorrect datetime value
- Android中的style和theme的用法
- UINavigationController 导航控制器
- system函数的总结
- 黑马程序员_问题总结(持续更新)
- MyEcplise开发Servlet笔记
- 二叉树的先序、中序、后序的递归与非递归实现
- 神经网络学习算法matlab应用分析
- Android View.post(Runnable )