Error Executing Database Query Using ColdFusion

Ok, this is a problem I solved a wee while ago via google and it is something that I have recently encountered on my shared remote server with support not aware of the fix…so I thought best broadcast.

Problem: Error Executing Database Query. Value ‘0000-00-00’ can not be represented as java.swl.Date

The datasource is set up with a JDBC URL of: jdbc:mysql://localhost:3306/newtriksexample

Solution: Append this to the end of the url: ?zeroDateTimeBehavior=convertToNull So we will have: jdbc:mysql://localhost:3306/newtriksexample?zeroDateTimeBehavior=convertToNull