'0000-00-00 00:00:00' can not be represented as java.sql.Timestamp error

iteye_494

于 2016-07-14 14:47:40 发布

阅读量146

点赞数

CC 4.0 BY-SA版权

分类专栏： Mysql 文章标签： java 数据库

本文链接：https://blog.youkuaiyun.com/iteye_494/article/details/82654581

Mysql 专栏收录该内容

3 篇文章

订阅专栏

本文介绍了一种常见的数据库操作错误——无法将'0000-00-00 00:00:00'解析为Java Timestamp类型的问题及其解决方案。通过在JDBC连接字符串中添加参数'zeroDateTimeBehavior=convertToNull'来避免此类异常。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

### 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
org.springframework.dao.TransientDataAccessResourceException: 
### Error querying database.  Cause: java.sql.SQLException: Value '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp