ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Can not connect MySQL8 in JDBC.

book

Article ID: 199430

calendar_today

Updated On:

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