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.

Changes

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 com.mysql.cj.jdbc.MysqlConnectionPoolDataSource 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.MysqlDataSource and com.mysql.jdbc.jdbc2.optional.MysqlXADataSource for non-XA and XA connection pools respectively.