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

5.05K viewsSqlJava
1
0 Comments

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

1 Answer

3
Manohar586 0 Comments

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.