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.

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

book

Article ID: 199444

calendar_today

Updated On:

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

Attachments