Universal Controller 6.4.7.0 Release Notes

Upgrade of Packaged MySQL JDBC Connector to 8.0.x

This update affects users using MySQL as the Universal Controller Database, or have SQL / Stored Procedure Tasks that run against MySQL databases.

If you use MySQL as the Universal Controller Database, or have SQL / Stored Procedure Tasks that run against MySQL databases, you should review the MySQL JDBC Connector 8.0 upgrade information before upgrading to UC 6.4.7.0.

https://dev.mysql.com/doc/connector-j/8.0/en/connector-j-upgrading-to-8.0.html
 

It is important to note that we have observed the following changes in behavior with the new MySQL JDBC Connector:

Change 1

If the SQL Task Instance or Stored Procedure Task Instance is currently processing the SLEEP(\n) function at the time a cancel is attempted, depending on the SQL statement, a MySQLStatementCancelledException may no longer be thrown, meaning the SQL Task Instance or Stored Procedure Task Instance will immediately transition to Success from Cancel Pending, rather than transitioning to Cancelled.

For example:

If cancelled, the following SQL Task Instance SQL Command would complete with status Success.

 

If cancelled, the following SQL Task Instance SQL Command would complete with status Cancelled.

 

For more information on the SLEEP function, please see the MySQL documentation here: https://dev.mysql.com/doc/refman/5.6/en/miscellaneous-functions.html#function_sleep
 

Change 2

If the server time zone value is unrecognized or represents more than one time zone, you must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specific time zone value if you want to utilize time zone support.

We recommended adding the following parameter to the Connection URL: &serverTimezone=UTC (or alternatively, a preferred timezone, such as &serverTimezone=America/New_York).