使用JDBC连接MySQL报Unknown system variable 'query_cache_size'错误

最新推荐文章于 2024-07-15 14:21:43 发布

QQ秦政

最新推荐文章于 2024-07-15 14:21:43 发布

阅读量1.7k

点赞数 1

分类专栏： Mybatis

本文链接：https://blog.csdn.net/qq_40961980/article/details/86623955

版权

Mybatis 专栏收录该内容

10 篇文章 0 订阅

订阅专栏

报错信息如下：

一月 24, 2019 11:39:13 上午 org.springframework.jdbc.datasource.DriverManagerDataSource setDriverClassName
信息: Loaded JDBC driver: com.mysql.cj.jdbc.Driver
Exception in thread "main" org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException: 
### Error querying database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Unknown system variable 'query_cache_size'
### The error may exist in com/qin/mapper/UserMapper.java (best guess)
### The error may involve com.qin.mapper.UserMapper.selectById
### The error occurred while executing a query
### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Failed to obtain JDBC Connection; nested exception is java.sql.SQLException: Unknown system variable 'query_cache_size'
	at org.mybatis.spring.MyBatisExceptionTranslator.translateExceptionIfPossible(MyBatisExceptionTranslator.java:77)
	at org.mybatis.spring.SqlSessionTemplate$SqlSessionInterceptor.invoke(SqlSessionTemplate.java:446)
	at com.sun.proxy.$Proxy14.selectOne(Unknown Source)
	at org.mybatis.spring.SqlSessionTemplate.selectOne(SqlSessionTemplate.java:166)
	at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:83)
	at org.apache.ibatis.binding.MapperProxy.invoke(MapperProxy.java:59)
	at com.sun.proxy.$Proxy17.selectById(Unknown Source)
	at com.qin.service.impl.UserServiceImpl.selectById(UserServiceImpl.java:20)
	at com.qin.controller.UserController.main(UserController.java:21)

原因：

mysql-connecter-java的版本太低，数据库驱动程序与数据库版本不对应，换成高版本的驱动程序，即可解决问题