CA API Gateway: Unknown system variable tx_isolation

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.