ibatis TIMESTAMP的异常解决方法
后台错误信息如下:
Cannot convert value '0000-00-00 00:00:00' from column 16 to TIMESTAMP.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
Cannot convert value '0000-00-00 00:00:00' from column 16 to TIMESTAMP.; nested exception is com.ibatis.common.jdbc.exception.NestedSQLException:
解决方法:jdbc连接字符串添加后面黑体部分的内容。
jdbc:mysql://localhost:3306/sun?characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true
jdbc:mysql://localhost:3306/sun?characterEncoding=utf-8&zeroDateTimeBehavior=convertToNull&transformedBitIsBoolean=true