MySQL dsn issue (zeroDateTimeBehavior)


#1

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


#2

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.


#3

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

Thank you.

Allen