We have a bad date time of '00-00-00 000000' in one of our cloud provider services database. It is causing this appropriate error.

2021-08-13 18:07:02 ERROR () LineGobbler(voidCall):85 - Exception in thread "main" java.lang.RuntimeException: java.sql.SQLException: Zero date value prohibited

Is there anyway to work around this other than fixing it in the database?

@s is possible to prioritize this issue a few users using MySQL are having this problem.

@Nathan Atkins for now you need to add the adittional jdbc params

zerodatetimebehavior=Converttonull

Thanks. It failed the first time with the capitalization as you have it. It might have been because I didn't reset the data or changing the capitalization to

zeroDateTimeBehavior=ConvertToNull

.

@Opeyemi Fabiyi FYI ^

Thanks @George Claireaux (Airbyte) for the mention I will try it out now