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 is

Error 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