java.sql.SQLException：未知的系统变量'query_cache_size' [英] java.sql.SQLException: Unknown system variable 'query_cache_size'

问题描述

我有一个运行JDBC的应用程序并从MySQL获取数据，但由于此错误我无法构建它：

  java.sql.SQLException：未知系统变量'query_cache_size'
 at com.mysql.jdbc.SQLError.createSQLException（SQLError.java:964）〜[mysql-connector-java-5.1.41.jar：5.1 .41] 
 at com.mysql.jdbc.MysqlIO.checkErrorPacket（MysqlIO.java:3973）〜[mysql-connector-java-5.1.41.jar：5.1.41] 
 at com.mysql .jdbc.MysqlIO.checkErrorPacket（MysqlIO.java:3909）〜[mysql-connector-java-5.1.41.jar：5.1.41] 
 at com.mysql.jdbc.MysqlIO.sendCommand（MysqlIO.java： 2527）〜[mysql-connector-java-5.1.41.jar：5.1.41] 
 at com.mysql.jdbc.MysqlIO.sqlQueryDirect（MysqlIO.java:2680)~ [mysql-connector-java-5.1 .41.jar：5.1.41] 
 at com.mysql.jdbc.ConnectionImpl.execSQL（ConnectionImpl.java:2497）〜[mysql-connector-java-5.1.41.jar：5.1.41] 
 at com.mysql.jdbc.ConnectionImpl.execSQL（ConnectionImpl.java:2455）〜[mysql-connector-java-5.1.41.jar：5.1.41] 
在com.mysql.jdbc.StatementImpl.executeQuery（StatementImpl.java:1369）〜[mysql-connector-java-5.1.41.jar：5.1.41] 
 at com.mysql.jdbc.ConnectionImpl.loadServerVariables （ConnectionImpl.java:3777）〜[mysql-connector-java-5.1.41.jar：5.1.41] 
 at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer（ConnectionImpl.java:3240）〜[mysql- connector-java-5.1.41.jar：5.1.41] 
 at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly（ConnectionImpl.java:2249）〜[mysql-connector-java-5.1.41.jar：5.1 .41] 
 at com.mysql.jdbc.ConnectionImpl.createNewIO（ConnectionImpl.java:2035）〜[mysql-connector-java-5.1.41.jar：5.1.41] 
 at com.mysql .jdbc.ConnectionImpl。< init>（ConnectionImpl.java:790）〜[mysql-connector-java-5.1.41.jar：5.1.41] 
 at com.mysql.jdbc.JDBC4Connection。< init> ;（JDBC4Connection.java:47）〜[mysql-connector-java-5.1.41.jar：5.1.41] 
 at sun.reflect.NativeConstructorAccessorImpl.newInstance0（Native Method）〜[na：1.8.0_131] 
  

我这里有application.properties文件

 ＃specs.dir = / specs / 
＃
 #################### Spring Boot Data Source Configuration ############ 
 #spring。 datasource.driver-class-name = com.mysql.jdbc.Driver 
＃spring.datasource.url = jdbc：mysql：// localhost：3306 / savingbooking？useSSL = false 
＃spring.datasource。 username = root 
＃spring.datasource.password = ZAQ！2wsx 
＃spring.datasource.initialize = true 
＃spring.jpa.hibernate.ddl-auto = update 
＃ spring.jpa.properties.hibernate.format_sql = true 
＃spring.jpa.show -sql = true 
＃spring.jpa.properties.hibernate.dialect = org.hibernate.dialect.MySQLDialect 
  

Mysql workbench是8.0版本

解决方案<在MySQL中删除了/ div>

query_cache_size 8.检查 docs 。

它适用于JDBC驱动程序5.1.44。

I have a app running with JDBC and get data from MySQL, but I can't build it because of this error :

java.sql.SQLException: Unknown system variable 'query_cache_size'
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:964) ~[mysql-connector-java-5.1.41.jar:5.1.41]
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3973) ~[mysql-connector-java-5.1.41.jar:5.1.41]
    at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3909) ~[mysql-connector-java-5.1.41.jar:5.1.41]
    at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2527) ~[mysql-connector-java-5.1.41.jar:5.1.41]
    at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2680) ~[mysql-connector-java-5.1.41.jar:5.1.41]
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2497) ~[mysql-connector-java-5.1.41.jar:5.1.41]
    at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2455) ~[mysql-connector-java-5.1.41.jar:5.1.41]
    at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1369) ~[mysql-connector-java-5.1.41.jar:5.1.41]
    at com.mysql.jdbc.ConnectionImpl.loadServerVariables(ConnectionImpl.java:3777) ~[mysql-connector-java-5.1.41.jar:5.1.41]
    at com.mysql.jdbc.ConnectionImpl.initializePropsFromServer(ConnectionImpl.java:3240) ~[mysql-connector-java-5.1.41.jar:5.1.41]
    at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2249) ~[mysql-connector-java-5.1.41.jar:5.1.41]
    at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2035) ~[mysql-connector-java-5.1.41.jar:5.1.41]
    at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:790) ~[mysql-connector-java-5.1.41.jar:5.1.41]
    at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[mysql-connector-java-5.1.41.jar:5.1.41]
    at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_131]

I have file application.properties here

#specs.dir=/specs/
#
#################### Spring Boot Data Source Configuration ############
#spring.datasource.driver-class-name=com.mysql.jdbc.Driver
#spring.datasource.url=jdbc:mysql://localhost:3306/savingbooking?useSSL=false
#spring.datasource.username=root
#spring.datasource.password=ZAQ!2wsx
#spring.datasource.initialize=true
#spring.jpa.hibernate.ddl-auto=update
#spring.jpa.properties.hibernate.format_sql=true
#spring.jpa.show-sql=true
#spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.MySQLDialect

Mysql workbench is 8.0 version

解决方案

query_cache_size was removed in MySQL 8. Check the docs.

It works with JDBC driver 5.1.44.

这篇关于java.sql.SQLException：未知的系统变量'query_cache_size'的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！