Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP
来源:互联网 发布:swift json解析框架 编辑:程序博客网 时间:2024/05/01 11:20
转自:http://hi.baidu.com/marlon_xiaoyu/item/41fee32f39ef570173863e2d
问题显示:
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
这样就可以了。
0 0
- 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
- mysql错误: Cannot convert value '0000-00-00 00:00:00' from column 10 to TIMESTAMP
- Hibernate Cannot convert value '0000-00-00 00:00:00' from column 5 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
- Cannot convert value '0000-00-00 00:00:00' from column 1 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的解决办法
- mysql错误: Cannot convert value ’0000-00-00 00:00:00′ from column 10 to TIMESTAMP
- 偶然错误解决方案
- ffmpeg 源代码简单分析 : av_read_frame()
- 关于OpenSSL支持USB-KEY证书的尝试
- Linux中socket 错误编码表 errno
- Webservice 之生成客户端代码
- Cannot convert value '0000-00-00 00:00:00' from column 1 to TIMESTAMP
- ps kill awk 杀死同一个应用的所有进程
- WinForm中提示Circular base class dependency involving 'TestEncryption.Form' and 'TestEncryption.Form'
- 框架技术--S2SH框架整合(注解 No 1)
- 超快地写网页代码 -zen-coding项目使用
- [Leetcode] Maximum Subarray (Java)
- Mysql设计索引的原则
- java 从jar包中读取资源文件
- 工具接口标准(TIS)可执行链接格式(ELF)规范-卷III-操作系统特性(Operating System Specific)-对象文件