The following are some known issues and limitations for MySQL Connector/J 5.1:
When Connector/J retrieves timestamps for a daylight saving time (DST) switch day using the
getTimeStamp()method on the result set, some of the returned values might be wrong. The errors can be avoided by using the following connection options when connecting to a database:
useTimezone=true useLegacyDatetimeCode=false serverTimezone=UTC
Since release 5.1.41, the functionality of the property
elideSetAutoCommitshas been disabled due to Bug# 66884. Any value given for the property is ignored by Connector/J.
Connector/J 5.1 does not support the
caching_sha256_passwordauthentication plugin, which is the default authentication plugin for MySQL 8.0.4 and later (see Caching SHA-2 Pluggable Authentication for details). Therefore, using Connector/J 5.1, applications will not be able to connect to accounts that authenticate with the plugin (which might include the root account created by default during a new installation of a MySQL 8.0 Server) .