CA API Gateway: Unknown system variable tx_isolation

Document ID : KB000112451
Last Modified Date : 30/08/2018
Show Technical Document Details
Issue:
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'
Resolution:
At this time OTK only supports using MySQL 5.5.x and 5.7.x Enterprise edition.