java.sql.SQLException: Zero date value prohibited
今天使用mybatis出现了异常
java.sql.SQLException: Zero date value prohibited
查了下原因
mysql文档上写着
Datetimes with all-zero components (0000-00-00 ...
): These values cannot be represented reliably in Java. Connector/J 3.0.x always converted them to NULL
when being read from a ResultSet.
Connector/J 3.1 throws an exception by default when these values are encountered, as this is the most correct behavior according to the JDBC and SQL standards.
This behavior can be modified using the zeroDateTimeBehavior
configuration property. The permissible values are:
exception
(the default), which throws an SQLException with an SQLState ofS1009
.
convertToNull
, which returnsNULL
instead of the date.
round
, which rounds the date to the nearest closest value which is0001-01-01
.
zeroDateTimeBehavior
默认为exception,会抛出一个SQLException异常
解决的方法:
在jdbcUrl中设置zeroDateTimeBehavior=convertToNull
如:
spring.datasource.url=jdbc:mysql://localhost:3306/mrbird?serverTimezone=Asia/Shanghai&zeroDateTimeBehavior=convertToNull
问题解决