HikariPool-1 - Failed to execute isValid() for connection, configure connection test query. (com.mysql.jdbc.Connection.isValid(I)Z)
这要怎么解决啊
后端运行没有错误,但一打开前端后端就报错,好像是连接池的问题
ERROR 21116 --- [nio-8080-exec-5] com.zaxxer.hikari.pool.PoolBase : HikariPool-1 - Failed to execute isValid() for connection, configure connection test query. (com.mysql.jdbc.Connection.isValid(I)Z)
2022-12-16 15:57:52.968 ERROR 21116 --- [nio-8080-exec-5] o.a.c.c.C.[.[.[/].[dispatcherServlet] : Servlet.service() for servlet [dispatcherServlet] in context with path [] threw exception [Handler dispatch failed; nested exception is java.lang.AbstractMethodError: com.mysql.jdbc.Connection.isValid(I)Z] with root cause
这是我一开始用的
<dependency>
<groupId>mysqlgroupId>
<artifactId>mysql-connector-javaartifactId>
<version>5.1.47version>
dependency>
spring:
datasource:
username: root
password: 123456
url: jdbc:mysql://localhost:3306/nocv?serverTimezone=UTC&useSSL=false&characterEncoding=utf-8
driver-class-name: com.mysql.jdbc.Driver
查了一下说是mysql版本太低,于是我换成8.0.12/22
但更高的版本报错更多
用了8以上的版本
Driver也改了
报错
ERROR 22516 --- [nio-8080-exec-5] com.zaxxer.hikari.pool.HikariPool : HikariPool-1 - Exception during pool initialization.
前端网站也报错
于是上网查了一下又说我mysql版本太高
url: jdbc:mysql://127.0.0.1:3306/nocv?useUnicode=true&characterEncoding=utf-8&serverTimezone=GMT&useSSL=false