Error when dates are null in MySQL

[wyattb]

MySQL.new database name@itrdata_root *
java.sql.SQLException: Value '0000-00-00' can not be represented as java.sql.Date

SELECT
CategoryReporting.CategoryName,
CompanyCategories.CompanyId,
CompanyCategories.CategoryId,
CategoryReporting.ReportingFreq,
CategoryReporting.ReportingPeriodName,
CategoryReporting.ReportingCloseDate,
CategoryReporting.SurveyStartDate,
CategoryReporting.SurveyDueDate,
CategoryReporting.SurveyDescription
FROM
CategoryReporting INNER JOIN CompanyCategories ON CategoryReporting.CategoryId = CompanyCategories.CategoryId
WHERE
CompanyCategories.CompanyId = "WAS-1035-00"
AND CategoryReporting.ReportingFreq = "M"

[Anu]

Seems MySQL vendor connector problem. Quick googling gives this

Add this in your datasource connection
jdbc:mysql://yourserver:3306/yourdatabase?zeroDateTimeBehavior=convertToNull

Its mentioned in MySQL manual dateTime section
http://dev.mysql.com/doc/refman/5.0/en/connector-j-installing-upgrading.html