异常信息:org.springframework.dao.TransientDataAccessResourceException: Error attempting to get column 'req_end' from result set. Cause: java.sql.SQLException: Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp
; SQL []; Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp; nested exception is java.sql.SQLException: Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp
解决方案:查看数据库里面的日期类型的数据是否是“0000-00-00 00:00:00”,将其改为正常日期时间即可。
建议:设计数据库时,且使用mybatis3等相关数据库框架时,日期类型指定默认值,不要为空,否则日期类型为空时会自动填充为“0000-00-00 00:00:00”,报异常。