记录一个学习时遇到的bug:在配置Mybatis自动生成器的时候,报错:
Unknown system variable 'query_cache_size'
上网查了之后发现是mysql-connecter-java的版本过低,数据库驱动程序与数据库版本不对应
我之前pom配置的mysql-connecter-java版本为5.1.41,但我的数据库版本实际是8.0.18
在官网查到
SQLException: Unknown system variable ‘query_cache_size’, because the query
cache has been removed from the server. All query cache server variables and
functionality has now been removed from Connector/J 5.1.".
所以将mysql-connecter-java版本改为和数据库匹配的版本就可以了
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<version>8.0.18</version>
</dependency>