MySQLNonTransientConnectionException: Could not create connection to database server.

红太狼 2024-03-03 03:02 176阅读 0赞

问题描述

SPringBoot项目后断使用MYSQL 5.7.43。Java JDBC驱动依赖选择的是

  1. <groupId>mysql</groupId>
  2.     <artifactId>mysql-connector-java</artifactId>
  3.     <version>5.1.47</version>
  4. </dependency>

驱动参数配置如下：

  1. spring:
  2.   datasource:
  3.     username: root
  4.     password: root
  5.     url: jdbc:mysql://127.0.0.1:3306/data_backend?autoReconnect=true&useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8
  6.     driver-class-name: com.mysql.jdbc.Driver

使用后端接口测试工具测试后端接口是否正常工作时报错如下：

  1. com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
  2.     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_381]
  3.     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_381]
  4.     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_381]
  5.     at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_381]
  6.     at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.47.jar:5.1.47]
  7.     at com.mysql.jdbc.Util.getInstance(Util.java:408) ~[mysql-connector-java-5.1.47.jar:5.1.47]
  8.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919) ~[mysql-connector-java-5.1.47.jar:5.1.47]
  9.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:898) ~[mysql-connector-java-5.1.47.jar:5.1.47]
  10.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:887) ~[mysql-connector-java-5.1.47.jar:5.1.47]
  11.     at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:861) ~[mysql-connector-java-5.1.47.jar:5.1.47]
  12.     at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2105) ~[mysql-connector-java-5.1.47.jar:5.1.47]
  13.     at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2030) ~[mysql-connector-java-5.1.47.jar:5.1.47]
  14.     at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:778) ~[mysql-connector-java-5.1.47.jar:5.1.47]
  15.     at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47) ~[mysql-connector-java-5.1.47.jar:5.1.47]
  16.     at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ~[na:1.8.0_381]
  17.     at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62) ~[na:1.8.0_381]
  18.     at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) ~[na:1.8.0_381]
  19.     at java.lang.reflect.Constructor.newInstance(Constructor.java:423) ~[na:1.8.0_381]
  20.     at com.mysql.jdbc.Util.handleNewInstance(Util.java:425) ~[mysql-connector-java-5.1.47.jar:5.1.47]
  21.     at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:386) ~[mysql-connector-java-5.1.47.jar:5.1.47]
  22.     at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330) ~[mysql-connector-java-5.1.47.jar:5.1.47]
  23.     at com.zaxxer.hikari.util.DriverDataSource.getConnection(DriverDataSource.java:138) ~[HikariCP-4.0.3.jar:na]
  24.     at com.zaxxer.hikari.pool.PoolBase.newConnection(PoolBase.java:364) ~[HikariCP-4.0.3.jar:na]
  25.     at com.zaxxer.hikari.pool.PoolBase.newPoolEntry(PoolBase.java:206) ~[HikariCP-4.0.3.jar:na]
  26.     at com.zaxxer.hikari.pool.HikariPool.createPoolEntry(HikariPool.java:476) [HikariCP-4.0.3.jar:na]
  27.     at com.zaxxer.hikari.pool.HikariPool.checkFailFast(HikariPool.java:561) [HikariCP-4.0.3.jar:na]
  28.     at com.zaxxer.hikari.pool.HikariPool.<init>(HikariPool.java:115) [HikariCP-4.0.3.jar:na]
  29.     at com.zaxxer.hikari.HikariDataSource.getConnection(HikariDataSource.java:112) [HikariCP-4.0.3.jar:na]
  30.     at org.springframework.jdbc.datasource.DataSourceUtils.fetchConnection(DataSourceUtils.java:159) [spring-jdbc-5.3.22.jar:5.3.22]
  31.     at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:117) [spring-jdbc-5.3.22.jar:5.3.22]
  32.     at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80) [spring-jdbc-5.3.22.jar:5.3.22]
  33.     at org.mybatis.spring.transaction.SpringManagedTransaction.openConnection(SpringManagedTransaction.java:80) [mybatis-spring-2.0.7.jar:2.0.7]
  34.     ........................................................................................
  35. ........................................................................................
  36. ........................................................................................
  37. ........................................................................................
  38. ........................................................................................
  39. ........................................................................................
  40. Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

解决方案

Mysql数据库的驱动版本不对。

看看connector/J与MYSQL的版本对应关系：

e70ec1da30b74e81910fb6621528c1d3.webp

好像5.1的驱动也支持5.7的MYSQL数据库唉，但是就是没法用，官方推荐使用或升级到 8.0 的驱动版本。试着换成8.0的数据库驱动并更改yml配置文件数据库驱动信息。

把mysql-Connector-java的版本换成8.0.x的。即将5.1.47的依赖换成如下依赖：

  1. <dependency>
  2.             <groupId>mysql</groupId>
  3.             <artifactId>mysql-connector-java</artifactId>
  4.             <version>8.0.19</version>
  5.         </dependency>

并将application.yml中的数据库驱动配置为com.mysql.cj.jdbc.Driver，如下：

  1. spring:
  2.   datasource:
  3.     username: root
  4.     password: root
  5.     url: jdbc:mysql://127.0.0.1:3306/data_backend?autoReconnect=true&useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8
  6.     driver-class-name: com.mysql.cj.jdbc.Driver

重启项目，后端接口即能够成功访问数据库。

发表评论

表情：
评论列表 （有 0 条评论，176人围观）

还没有评论，来说两句吧...

相关阅读