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;
Release : 10.0
Component : API GATEWAY
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