Skip to:

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

Datasource JDBC Type 4 driver mysql lucee admin page is wrong on some features now

Description

The mysql driver used to be this class: org.gjt.mm.mysql.Driver but now it is com.mysql.cj.jdbc.Driver which appears to have different values on some of the configuration which makes the lucee admin page break.

The new cj driver is throwing an error on Zero Datetime behavior field for convertToNull, it validates and shows an error message stating:
The connection property 'zeroDateTimeBehavior' acceptable values are: 'CONVERT_TO_NULL', 'EXCEPTION' or 'ROUND'. The value 'convertToNull' is not acceptable.

I assume the HTML of the radio buttons needs to be updated to match the new values for this driver.

Also, at the bottom when editing an existing datasource in the lucee admin, lucee generates a string to be able to paste to the application.cfc the datasource. It outputs yes for clob/blog instead of "yes" or true. yes is not a defined variable in cfml, please make it a valid boolean again.

I was able to get past the issues by writing the updated application.cfc code manually.

Environment

None

Attachments

3
  • 18 Feb 2019, 03:57 pm
  • 19 Sept 2018, 11:42 pm
  • 19 Sept 2018, 11:20 pm

Activity

Show:

Zac Spitzer 27 July 2024 at 12:28

Brad Wood 29 January 2021 at 17:52

Thanks for the follow up Bruce.

Bruce Kirkpatrick 29 January 2021 at 15:08

I switched to mariadb driver with my own custom lucee extension. I wouldn’t know about current situation.

Brad Wood 29 January 2021 at 03:09

I see this is marked fixed in version 8.015 of the driver. I'm getting the " Unknown system variable 'query_cache_size'" error while using the 8.0.19 version of the MySQL extension. Was this error not fixed? Did you guys find a workaround.

Michael Offner 18 February 2019 at 15:57

It outputs yes for clob/blog instead of "yes" or true. yes is not a defined variable in cfml, please make it a valid boolean again.
it shows "true" for me

Fixed

Details

Assignee

Reporter

Priority

Labels

Fix versions

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

Sprint

Affects versions

Created 14 August 2018 at 13:57
Updated 27 July 2024 at 12:28
Resolved 18 February 2019 at 16:30