Panel | |
---|---|
|
...
Wiki Markup |
---|
{panel} {toc} {panel} h2. 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
...
It is important to note that we have observed the following changes in behavior with the new MySQL JDBC Connector: h5.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: |
...
{html}</ul> <li>If cancelled, the following SQL Task Instance SQL Command would complete with status Success. |
...
SELECT SLEEP(1000); |
...
<li>If cancelled, the following SQL Task Instance SQL Command would complete with status Cancelled. |
...
SELECT column-name FROM table-name WHERE SLEEP(1000); |
...
</ul>{html} 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.
...
h5. 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). |