报错信息:java.sql.SQLException: Unknown system variable
'tx_isolation' at
com.mysql.jdbc.SQLError.createSQLException(SQLError.
~[mysql-connector-java-5.1.43.jar:5.1.43] at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.
~[mysql-connector-java-5.1.43.jar:5.1.43] at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.
~[mysql-connector-java-5.1.43.jar:5.1.43] at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.
~[mysql-connector-java-5.1.43.jar:5.1.43] at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.
~[mysql-connector-java-5.1.43.jar:5.1.43] at
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.
~[mysql-connector-java-5.1.43.jar:5.1.43] at
com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.
~[mysql-connector-java-5.1.43.jar:5.1.43] at
com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.
~[mysql-connector-java-5.1.43.jar:5.1.43] at
com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.
~[mysql-connector-java-5.1.43.jar:5.1.43] at
com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.
~[mysql-connector-java-5.1.43.jar:5.1.43] at
com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.
~[mysql-connector-java-5.1.43.jar:5.1.43] at
com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.
~[mysql-connector-java-5.1.43.jar:5.1.43] at
com.mysql.jdbc.ConnectionImpl.(ConnectionImpl.
~[mysql-connector-java-5.1.43.jar:5.1.43] at
com.mysql.jdbc.JDBC4Connection.(JDBC4Connection.
~[mysql-connector-java-5.1.43.jar:5.1.43] at
sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native
Method) ~[na:1.8.0_171] at
sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.
~[na:1.8.0_171] at
sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.
~[na:1.8.0_171] at
~[na:1.8.0_171] at
com.mysql.jdbc.Util.handleNewInstance(Util.
~[mysql-connector-java-5.1.43.jar:5.1.43] at
com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.
~[mysql-connector-java-5.1.43.jar:5.1.43] at
com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.
~[mysql-connector-java-5.1.43.jar:5.1.43] at
org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.
~[tomcat-jdbc-8.5.16.jar:na] at
org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.
~[tomcat-jdbc-8.5.16.jar:na] at
org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.
[tomcat-jdbc-8.5.16.jar:na] at
org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.
[tomcat-jdbc-8.5.16.jar:na] at
org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.
[tomcat-jdbc-8.5.16.jar:na] at
org.apache.tomcat.jdbc.pool.ConnectionPool.(ConnectionPool.
[tomcat-jdbc-8.5.16.jar:na] at
org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.
[tomcat-jdbc-8.5.16.jar:na] at
org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.
[tomcat-jdbc-8.5.16.jar:na] at
org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.
[tomcat-jdbc-8.5.16.jar:na] at
org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.
[spring-jdbc-4.3.10.RELEASE.jar:4.3.10.RELEASE] at
org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.
[spring-jdbc-4.3.10.RELEASE.jar:4.3.10.RELEASE] at
org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.
[spring-jdbc-4.3.10.RELEASE.jar:4.3.10.RELEASE] at
org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.
[spring-jdbc-4.3.10.RELEASE.jar:4.3.10.RELEASE] at
org.springframework.boot.autoconfigure.orm.jpa.DatabaseLookup.getDatabase(DatabaseLookup.
[spring-boot-autoconfigure-1.5.6.RELEASE.jar:1.5.6.RELEASE] at
org.springframework.boot.autoconfigure.orm.jpa.JpaProperties.determineDatabase(JpaProperties.
[spring-boot-autoconfigure-1.5.6.RELEASE.jar:1.5.6.RELEASE] at
org.springframework.boot.autoconfigure.orm.jpa.JpaBaseConfiguration.jpaVendorAdapter(JpaBaseConfiguration.
[spring-boot-autoconfigure-1.5.6.RELEASE.jar:1.5.6.RELEASE] at
org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaAutoConfiguration
解决办法:在pom.xml文件中将MySQL Connector / J版本升级为8:
mysql
mysql-connector-java
8.0.12
注释:8.0.11时安装的mysql的版本号
加载中,请稍候......