CA API Gateway: Unknown system variable tx_isolation

book

Article ID: 112451

calendar_today

Updated On:

Products

STARTER PACK-7 CA Rapid App Security CA API Gateway

Issue/Introduction

When using MySQL enterprise 8.x for a JDBC connection to OTK the test may result in the below error:

Testing failed: invalid connection properties setting.
[l7tech][MySQL JDBC Driver] Unknown system variable 'tx_isolation'

Environment

Release:
Component: APIESM

Resolution

At this time OTK only supports using MySQL 5.5.x and 5.7.x Enterprise edition.