Cannot convert value '0000-00-00 00:00:00' 异常解决方案
Cannot convert value '0000-00-00 00:00:00' 错误解决方案
MySQL数据库，如果数据库中Datetime字段为空为值为'0000-00-00 00:00:00', Hibernate就会报如下错误
“Cannot convert value '0000-00-00 00:00:00' from column 3 to TIMESTAMP。”
解决方案:为在数据库连接后面加上
"jdbc:mysql://127.0.0.1:3306/ht?useUnicode=true
&characterEncoding=UTF-8
&autoReconnect=true&failOverReadOnly=false
&maxReconnects=10000&initialTimeout=2
&connectTimeout=0&socketTimeout=0
&zeroDateTimeBehavior=convertToNull
&transformedBitIsBoolean=true"即可
autoReconnect=true 重新连接参数
转自:http://jerryqiu.iteye.com/blog/635515