Hibernate Cannot convert value '0000-00-00 00:00:00' from column 5 to TIMESTAMP
来源:互联网 发布:python sap 编辑:程序博客网 时间:2024/04/30 15:15
问题显示:
17:24:09.062 ERROR org.hibernate.util.JDBCExceptionReporter - Cannot convert value '0000-00-00 00:00:00' from column 5 to TIMESTAMP.
原因:在mysql数据库中,如果Date类型的字段为空或者值为'0000-00-00"时,用Hibernate的生成类时就会报错
解决方法:
把jdbc.url变为:
jdbc.url=jdbc:mysql://192.168.3.7:3306/mmcms_pmi?characterEncoding=
UTF-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true
这样就可以了。
1 1
- Hibernate Cannot convert value '0000-00-00 00:00:00' from column 5 to TIMESTAMP
- mysql错误: Cannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP
- Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP
- Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP
- Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP
- Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP .
- Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP
- Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP
- Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP
- Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP
- 开发 - Cannot convert value '0000-00-00 00:00:00' from column 38 to TIMESTAMP.
- Cannot convert value '0000-00-00 00:00:00' from column 22 to TIMESTAMP
- spring mvc 查询报错Cannot convert value '0000-00-00' from column 20 to TIMESTAMP
- java java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 5 to TIMESTAMP.
- java java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 5 to TIMESTAMP.
- java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 7 to TIMESTAMP
- java.Sql.Exception:Cannot convert value '0000-00-00 00:00:00' from column 13 to TIMESTAMP的解决办法
- MYSQL:Cannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP的解决办法
- 读paper总结(文献阅读经验分析总结)
- 微软YY公开课[《微软中国云计算Azure平台体验与新企业架构设计》 周六晚9点
- Visual Studio中使用正则表达式进行代码规范的检查
- 第一次接触脱壳
- FactorialTest2
- Hibernate Cannot convert value '0000-00-00 00:00:00' from column 5 to TIMESTAMP
- android Toast大全(五种情形)建立属于你自己的Toast
- 第七周作业3——最长递增子序列
- java面试题分析
- MAC 下的Java JDK
- c语言 访问数组首地址的几种方式
- Choose a destination with a supported architecture in order to run on this device.
- 详解 Qt Quick 开始使用QML编程
- Visual Studio 2010 安装MSDN Library