springboot 使用

最新推荐文章于 2022-10-13 17:00:46 发布

qingchunqidewo

最新推荐文章于 2022-10-13 17:00:46 发布

阅读量83

点赞数

本文链接：https://blog.csdn.net/qingchunqidewo/article/details/108194642

版权

1 、java.sql.SQLException: Unknown system variable 'query_cache_size' 或com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException异常解决方法

mysql 版本不一致引起如mysql-8.0.19-winx64引入8.0.11版本，更新驱动如下

<dependency>
   <groupId>mysql</groupId>
   <artifactId>mysql-connector-java</artifactId>
   <version>8.0.11</version> 
</dependency>

2、mysql版本大于8需要加时区或遇到

Exception in thread "main" java.sql.SQLException: The server time zone value '�й��׼ʱ��' is unrecognized or represents more than one time zone. You must configure either the server or JDBC driver (via the serverTimezone configuration property) to use a more specifc time zone value if you want to utilize time zone support

url加时区serverTimezone=UTC  如下
spring:
  datasource:
    url: jdbc:mysql://localhost:3306/springboot_db?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC&autoReconnect=true&useSSL=false