com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to

迷南。 2023-01-20 15:56 39阅读 0赞

配置mybitis连接mysql的时候出现了bug，显示日志如下：

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3ExNTEwMjc4MDcwNQ_size_16_color_FFFFFF_t_70][]

看了半天原因是配置的jdbc连接驱动版本过低造成的，我们更换一下pom.xml的连接驱动的版本为高版本就可以了

<dependency>
    	    <groupId>org.mybatis</groupId>
    	    <artifactId>mybatis</artifactId>
    	    <version>3.4.6</version>
    	</dependency>
     
    		
    	<dependency>
    	    <groupId>mysql</groupId>
    	    <artifactId>mysql-connector-java</artifactId>
    	    <version>8.0.13</version>
    	</dependency>

同时我们更换application.yml里面的配置驱动

com.mysql.jdbc.Driver更换新驱动为com.mysql.cj.jdbc.Driver

spring:
      datasource:
        username: root
        password: 123456
        url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&useSSL=true&serverTimezone=UTC&autoReconnect=true&failOverReadOnly=false
        driver-class-name: com.mysql.cj.jdbc.Driver

更换完毕后重启项目测试接口

![20210513184239896.png][]

正常返回数据

完毕！

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3ExNTEwMjc4MDcwNQ_size_16_color_FFFFFF_t_70]: /images/20221021/3e3d9afae06340359823a437e83134dd.png
[20210513184239896.png]: /images/20221021/bf954690448f4877b23af950cd1f4f64.png

com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to

发表评论取消回复

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

相关阅读

相关 MySQLNonTransientConnectionException: Could not create connection to database server.

相关【数据库连接异常】MySQLNonTransientConnectionException: Could not create connection to database server.

相关 com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to

相关 mybatis错误：Could not create connection to database server.

相关 com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to

相关数据库驱动问题：MySQLNonTransientConnectionException: Could not create connection to database server

相关 MySQLNonTransientConnectionException: Could not create connection to database server.

相关 Cannot create PoolableConnectionFactory (Could not create connection to database server.)

相关 could not create connection to database问题解决

相关 Cannot create PoolableConnectionFactory (Could not create connection to database server.