Could not create connection to database server. Attempted reconnect 3 times. Giving up.

最新推荐文章于 2020-03-22 23:16:24 发布
最新推荐文章于 2020-03-22 23:16:24 发布
阅读量278 收藏
点赞数
分类专栏： java 开发常用 文章标签： JAVA Boot
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_34926773/article/details/103476191
版权 
com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.Util.getInstance(Util.java:408)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:918)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:897)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:886)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:860)
	at com.mysql.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:2115)
	at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2040)
	at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:790)
	at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
	at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400)
	at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
	at org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:310)
	at org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:203)
	at org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:735)
	at org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:667)
	at org.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:482)
	at org.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:154)
	at org.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:118)
	at org.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:107)
	at org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:131)
	at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)
	at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)
	at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:326)
	at org.springframework.jdbc.support.JdbcUtils.extractDatabaseMetaData(JdbcUtils.java:366)
	at org.springframework.boot.autoconfigure.orm.jpa.DatabaseLookup.getDatabase(DatabaseLookup.java:72)
	at org.springframework.boot.autoconfigure.orm.jpa.JpaProperties.determineDatabase(JpaProperties.java:139)
	at org.springframework.boot.autoconfigure.orm.jpa.JpaBaseConfiguration.jpaVendorAdapter(JpaBaseConfiguration.java:105)
	at org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaAutoConfiguration$$EnhancerBySpringCGLIB$$368a7d15.CGLIB$jpaVendorAdapter$6(<generated>)
	at org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaAutoConfiguration$$EnhancerBySpringCGLIB$$368a7d15$$FastClassBySpringCGLIB$$420c27fb.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
	at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:358)
	at org.springframework.boot.autoconfigure.orm.jpa.HibernateJpaAutoConfiguration$$EnhancerBySpringCGLIB$$368a7d15.jpaVendorAdapter(<generated>)
	at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
	at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.lang.reflect.Method.invoke(Method.java:497)
	at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:162)
	at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:588)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1173)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1067)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066)
	at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835)
	at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:741)
	at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:467)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1173)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1067)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202)
	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:208)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1138)
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1066)
	at org.springframework.beans.factory.support.ConstructorResolver.resolveAutowiredArgument(ConstructorResolver.java:835)
	at org.springframework.beans.factory.support.ConstructorResolver.createArgumentArray(ConstructorResolver.java:741)
	at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:467)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1173)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:1067)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:513)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:483)
	at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
	at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1081)
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:856)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:542)
	at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:122)
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:737)
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:370)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:314)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1162)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1151)
	at com.imooc.SellApplication.main(SellApplication.java:10)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

新建了一个项目 复制了mysql链接后 启动不了，如上图错误：

因为驱动不对 使用的是：

driver-class-name: com.mysql.jdbc.Driver

应该使用：

driver-class-name: com.mysql.cj.jdbc.Driver

改了就可以了

这只是我遇到的情况，如果不能解决你的问题。sorry

如果mysql-connector-java用的6.0以上的，如：
<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>6.0.6</version>
</dependency>
但是你的driver用的还是com.mysql.jdbc.Driver就会报错，此时需要把com.mysql.jdbc.Driver改为com.mysql.cj.jdbc.Driver。

 

张小帅和刘美美
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 打赏
    打赏
  • 0
    评论
专栏目录
sch_dsmark.rar_And Yet ...
09-14
Only complain if a change was actually attempted. This way, we can send non-IP traffic through dsmark and don t need yet another qdisc as a bypass.
树莓派4B无法启动，出现end kernel panic not syncing: attempted to kill init! exitcode = 0x00000000b
01-06
出现问题现象 本人最近在玩树莓派4B的时候，树莓派在烧录镜像之后，无法启动，一直卡死在end kernel panic not syncing: attempted to kill init! exitcode = 0x00000000b 环境 设备：树莓派4B 查找原因–树莓派官网 根据官网给出的检查方案，我排除了 SPI EEPROM 损坏的可能。 个人解决方案 原来是因为在格式化内存卡的时候，格式化工具把内存卡格式化成非FAT32（4096 k 对齐）格式。 后来自己使用 DiskGenius 对内存卡进行格式化，格式化格式为 FAT32（4096 k 对齐）, 然后在把镜像烧录进去，
ns3 assert failed. cond=”uid != 0″, msg=”Assert in TypeId::LookupByName: xxx not found”, file=../src
01-20
ns3中在使用.waf –run xxx时候出现 assert failed. cond=”uid != 0″, msg=”Assert in TypeId::LookupByName: sender not found”, file=../src/core/model/type-id.cc, line=828 terminate called without an active exception 前提： 使用了自定义的模块（即#include了自己写的.cc和.h文件） 在将在run的.cc文件中使用了模板Ptr时写了 Config::Connect(“……/sender/……”)   
Kernel panic(Attempted to kill init!).zip
01-27
ARM 启动 后显示Kernel panic(Attempted to kill init!)
Resource ‘taggers/averaged_perceptron_tagger/averaged_perceptron _tagger.pickle’ not found.
12-22
错误如下： LookupError: ********************************************************************** Resource 'taggers/averaged_perceptron_tagger/averaged_perceptron _tagger.pickle' not found. Please use the NLTK Downloader to obtain the resource: >>> nltk.download() Searched in: - 'C:\\Users\\Dr
Could not create connection to database server. Attempted reconnect 3 times.
yiye2017zhangmu的博客
06-25 7970
问题描述: 用docker-compose部署了一个mysql，然后项目部署时报错： Could not create connection to database server. Attempted reconnect 3 times. 问题分析： 我百度了很久，好多都是配置连接池的url时加后缀 useUnicode=true&amp;characterEncod...
[08001] Could not create connection to database server. Attempted reconnect 3 times. Giving up.
10-19 1973
[08001] Could not create connection to database server. Attempted reconnect 3 times. Giving up. 一般处理方式：在url后面加上 ?serverTimezone=GMT 原因的话是因为mysql默认的时区不是中国的，好像是美国的，然后如果想根源解决的话： 在终端登录 mysql -uroot -p123...
解决异常：Could not create connection to database server. Attempted reconnect 3 times.
weixin_44961626的博客
07-15 2万+
解决异常：Could not create connection to database server. Attempted reconnect 3 times. 安装MySQL以后，使用IDEA2019连接MySQL出现如下错误，刚开始我以为是连接MySQL的配置文件参数写错了，检查以后发现都是正确的，于是仔细看了一下报的错误，感觉应该是MySQL监听器出现了问题 试了试连接用Navicat...
虚拟机黑屏end kernel panic - not syncing两种解决方式.docx
01-06
虚拟机黑屏end kernel panic - not syncing两种解决方式 最新的Ubuntu或Debian安装新虚拟机，或者复制别人安装好的虚拟机，出现黑屏，屏幕上提示kernel panic错误： end kernel panic - not syncing: corrupted stack end detected inside scheduler 或者 end kernel panic - not syncing: Attempted to kill init! exit code=0x0000000b 创建新的兼容性虚拟机或该 vmx文件都可以修复问题。
"Turn Page. Do Not Turn Back"
06-29
"Turn Page. Do Not Turn Back" “TURN PAGE. DO NOT TURN BACK” A-EILA PETTIT AND IRVIN COCKRIEL University of Missouri-Columbia “Turn Page. Do Not Turn Back” is a phrase familiar to experienced teachers, who see it printed a t the bottom of many test pages. In fact, on occasion teachers are likely to have experienced problems with students who attempted to turn back and reread a previous test page. Why is this phrase used in test situations
FileUtils.java
11-30
FileUtils.java 文件处理工具类
1D-Eurler-Solver-Clean-SOD.rar_ABLE-M_Limiter_Local_Solver.m_SOD
09-20
Attempted 1D Euler Solver. Local Lax Friedrich scheme with MINMOD/SUPERBEE/MC flux limiter scheme. I m able to successfully apply the flux limiter, but for some reason, I still get some bizarre oscillations that do not amplify but causes unphysical results.
IDEA链接MySQL报错08001和连接成功后不显示表的问题及解决方法
01-19
[08001] Could not create connection to database server. Attempted reconnect 3 times. Giving up. 解决办法：在url后面拼接?serverTimezone=UTC 连接成功后数据库不显示表 通过设置解决： scheme选择当前...
SVN出现提示org.apache.subversion.javahl.ClientException: Attempted to lock an already-locked dir解决方案
09-01
主要介绍了SVN出现提示org.apache.subversion.javahl.ClientException: Attempted to lock an already-locked dir解决方案的相关资料,需要的朋友可以参考下
[08001] Could not create connection to database server. Attempted reconnect 3 times.
Roker
03-22 8719
现象描述： 在JetBrains的系列产品中，database连接MySQL数据库时，如Idea、DataGrip、GoLand、Pycharm 等等，连接MySQL数据库时会出现如下提示： 连接失败的信息是： [08001] Could not create connection to database server. Attempted reconnect 3 times. 原因分...
解决异常：Could not create connection to database server. Attempted reconnect 3 times. Giving up.
热门推荐
Kevin_Zhou的博客
06-11 6万+
1.检查配置文件中mysql.jdbcUrl：mysql.userName：mysql.passWord：表名是否正确。2.检查MySQL服务是否运行。3.如果使用Eclipse类工具的项目，一定要记得clean工程。
nacos Could not create connection to database server. Attempted reconnect 3 times. Giving up.
最新发布
03-02
当出现"Could not create connection to database server. Attempted reconnect 3 times. Giving up."的错误时，通常是由于nacos无法连接到数据库服务器导致的。 这个错误可能有以下几个原因： 1. 数据库服务器未...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包

打赏作者

张小帅和刘美美

你的鼓励将是我创作的最大动力

¥1 ¥2 ¥4 ¥6 ¥10 ¥20
扫码支付：¥1
获取中
扫码支付

您的余额不足，请更换扫码支付或充值

打赏作者

实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值