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

Status

Assignee

Michael Offner

Reporter

Bruce Kirkpatrick

Sprint

None

Fix versions

Affects versions

5.3.1.38

Priority

Critical
Configure