Validation errors: "Value '0000-00-00' can not be represented as java.sql.Date"
ANALYSIS:
This is a MySQL-specific problem that does not happen often. It is caused by storing zero dates ('0000-00-00 00:00:00') in MySQL and trying to convert those into date objects in Java. Unfortunately, Java does not understand dates in this format, so the MySQL JDBC driver will throw this error by default.
RECOMMENDED ACTION:
Apart from modifying the source data, the easiest solution is to modify the JDBC connection URL for the affected Data Source to include ?zeroDateTimeBehavior=convertToNull as shown below.
REFERENCES:
For more information about this JDBC parameter, see the Datetimes bullet under section 20.3.3.3.3 of the MySQL Manual.