测试环境MyBatis+maven,启动单元测试持续报错:
java.sql.SQLException: Unknown system variable 'tx_isolation'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3491)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3423)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1936)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2060)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2536)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2465)
at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1383)
at com.mysql.jdbc.ConnectionImpl.getTransactionIsolation(ConnectionImpl.java:3117)
at com.alibaba.druid.pool.DruidConnectionHolder.<init>(DruidConnectionHolder.java:98)
at com.alibaba.druid.pool.DruidDataSource.put(DruidDataSource.java:1704)
at com.alibaba.druid.pool.DruidDataSource$CreateConnectionThread.run(DruidDataSource.java:1873)
原因:mysql-connector-java的版本太低,数据库的版本太高
而我的pom文件导入的mysql-connector-java的版本是5.1.6
解决方法:将mysql-connector-java升级到最新版本。
注: 此文章只为记录开发过程中的错误,学习,如发现侵权请私信删除