MySQL dsn issue (zeroDateTimeBehavior)


Looks like it was saved as “convertToNull”, but after upgrade Lucee to, we see the error message: The connection property ‘zeroDateTimeBehavior’ acceptable values are: ‘CONVERT_TO_NULL’, ‘EXCEPTION’ or ‘ROUND’. The value ‘convertToNull’ is not acceptable.


Right. That was changed in version 8 of the MySQL JDBC driver.

You can either edit the connection string manually, or downgrade to an older driver.


We are trying the newer version of MySQL… so we will keep in mind to modify DSN manually.

Thank you.