MySQL Connector/J 8 Changes
Since Payara Server 5.184
MySQL Connector/J underwent a package name change with the 8.0 release, meaning that to make use of the newer connector version you’ll need to configure your connection pools slightly differently as to before.
To support both the original connector and the new connector, we’ve added the newer connector version as a separate datasource type. When selecting the database driver vendor for a new JDBC connection pool, there are now two options for MySQL: MySql and MySql8. If using a MySQL Connector/J version lower than 8.0, use the MySql option, and if using a version greater than or equal to 8.0 use the new MySql8 option.
If you prefer to specify the class name yourself, the new class names to use for
the new 8.0 and above Connector/J are
for non-XA datasources, and
com.mysql.cj.jdbc.MysqlXADataSource for XA datasources.
If using an older Connector/J version, use the original class names of
com.mysql.jdbc.jdbc2.optional.MysqlXADataSource for non-XA and XA connection pools