CA API Gateway: JDBC Connection error 'Unknown system variable'tx_isolation'

Products

• CA API Gateway
• API SECURITY

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'

Environment

Release : 10.0

Component : API GATEWAY

Resolution

Remove "l7tech" from the JDBC URL.
Correct JDBC URL: jdbc:mysql://localhost:3306/ssg?ConnectionRetryCount=300&ConnectionRetryDelay=1