java.sql.SQLException: Unknown system variable 'tx_isolation'
If you are using MYSQL8, try to show variables like 'transaction_isolation'
.Mysql8 has renamed tx_isolation
to transaction_isolation
.
I had a same problem. I upgraded my MySql Connector and solved my issue. try to use version 8 , like this:
<!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java --><dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.13</version></dependency>
I was also getting the same error (when I am using the mysql6 database in mysql5 it was working fine) then I changed my connector jar from mysql-connector-java-5.1.46.jar
to mysql.jar
then the problem gone.