MySQL, JDBC Driver and zero dates
I am in the middle of moving a lot of my datasources over to the updated Connector/J (JDBC)One error I have seen a lot in my development enviorment isError Executing Database Query.
Cannot convert value '0000-00-00 00:00:00' from column xxxx to TIMESTAMP.
This is caused by Java as it cannot handle zero dates ('0000-00-00 00:00:00'), it trys todo anything it can with them but convert them to the original date :o). To get round this you can set a parameter in the JDBC URL called zeroDateTimeBehavior to convertToNull.So in your Data Sources page you should have something similar to: jdbc:mysql://localhost:3306/mySqlDatabase?zeroDateTimeBehavior=convertToNull
I’m here, learning and working away. If you liked this content and want to keep me going, consider buying me a coffee.
Your support keeps this site running and the coffee brewing! ☕️