Skip to main content
S
sbudlong
Inspiring
December 24, 2008
Answered

Value '0000-00-00' can not be represented as java.sql.Date error

  • December 24, 2008
  • 1 reply
  • 517 views
On two out of about 40 MySQL data sources in CF 8 admin I'm getting this java error. On the other data sources, I have the same configuration. I've tried adding this line to the Connection String box and deleting it from the JDBC URL. I've also tried unchecking Maintain Connections. Still the error persists. Should I delete these data sources and recreate them, maybe using MySQL driver 3? Or does someone have another suggestion?

zeroDateTimeBehavior=convertToNull
    This topic has been closed for replies.
    Correct answer sbudlong
    I found my problem. The usual solutions do work in CF admin. The converttoNull configuration property does it. I added that to the Connection String box, and the errors disappeared.

    1 reply

    S
    sbudlongAuthorCorrect answer
    Inspiring
    December 24, 2008
    I found my problem. The usual solutions do work in CF admin. The converttoNull configuration property does it. I added that to the Connection String box, and the errors disappeared.
    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices