Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

ZeroDateTime behaviour can't be set to convertToNull after updating to MySQL Driver 8.0.11

Description

When updating to the latest MySQL Driver 8.0.11 the setting of the ZeroDateTime behaviour doesn't allow to change it to convertToNull.
The name of the setting in the latest version is different. Error message says:

The connection property 'zeroDateTimeBehavior' acceptable values are: 'CONVERT_TO_NULL', 'EXCEPTION' or 'ROUND'. The value 'convertToNull' is not acceptable.

Environment

None

Activity

Show:

Michael Offner 6 May 2019 at 16:32

Andrew Dixon 6 January 2019 at 22:00

Andrew Dixon 6 January 2019 at 19:47

- Looks like it is a change in the syntax for the JDBC connection string from "convertToNull" to "CONVERT_TO_NULL":

https://dev.mysql.com/doc/connector-j/5.1/en/connector-j-reference-configuration-properties.html

https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-reference-configuration-properties.html

Search for "zeroDateTimeBehavior" on the page.

Looks like it has been "fixed" in 8.0.13 to allow the legacy value:

https://bugs.mysql.com/bug.php?id=91421

and

https://dev.mysql.com/doc/relnotes/connector-j/8.0/en/news-8-0-13.html

So, if the driver was updated to the latest Connector/J release, 8.0.13, it would fix this. Either that or the value needs changing to the new "CONVERT_TO_NULL" value.

Duplicate

Details

Assignee

Reporter

Priority

Labels

New Issue warning screen

Before you create a new Issue, please post to the mailing list first https://dev.lucee.org

Once the issue has been verified, one of the Lucee team will ask you to file an issue

Affects versions

Created 6 January 2019 at 14:01
Updated 6 May 2019 at 16:32
Resolved 6 May 2019 at 16:32

Flag notifications