Caused by: com.mysql.cj.exceptions.DataReadException: Zero date value prohibited

5.50K viewsSqlJava
1

Caused by: com.mysql.cj.exceptions.DataReadException: Zero date value prohibitedCaused by: com.mysql.cj.exceptions.DataReadException: Zero date value prohibited

Manohar Changed status to publish July 16, 2021
Add a Comment
3

Please add end of the JDBC URL  “?zeroDateTimeBehavior=convertToNull” like as below

jdbc:mysql://yourdbserverip:3306/yourdatabasename?zeroDateTimeBehavior=convertToNull

 

Manohar Changed status to publish March 10, 2020
Add a Comment
Write your answer.