Can not connect MySQL8 in JDBC.

Products

• CA API Gateway
• API SECURITY
• CA API Gateway Precision API Monitoring Module for API Gateway (Layer 7)
• CA API Gateway Enterprise Service Manager (Layer 7)
• STARTER PACK-7
• CA Microgateway

Issue/Introduction

Cannot connect to MySQL8 when using com.l7tech.jdbc.mysql.MySQLDriver.
The following error is displayed.
Testing failed:invalid connection properties setting.
[l7tech][MySQL JDBC Driver][MySQL]Unknown system variable'tx_isolation'

[JDBC properties]
Driver Class: com.l7tech.jdbc.mysql.MySQLDriver
JDBC URL: jdbc:l7tech:mysql://localhost:3306;DatabaseName=ssg;ConnectionRetryCount=300;ConnectionRetryDelay=1;

Environment

Release : 10.0

Component : API GATEWAY

Resolution

For MySQL8, Use "jdbc: mysql://..." instead of jdbc: "l7tech:mysql://...".

for example:
JDBC URL: jdbc:mysql://localhost:3306/ssg?ConnctionRetryCount=300&ConnectionRetryDelay=1&allowPublicKeyRetrieval=true