init datasource error, url: jdbc:mysql://lcoalhost:3306/test com.mysql.cj.jdbc.exceptions.Com

最新推荐文章于 2022-10-13 14:08:04 发布
最新推荐文章于 2022-10-13 14:08:04 发布
阅读量1.8k 收藏
点赞数
分类专栏： 异常统计 文章标签： mysql java spring
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/qq_44042428/article/details/123507717
版权

报错信息：

com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
	at com.mysql.cj.jdbc.exceptions.SQLError.createCommunicationsException(SQLError.java:174) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:64) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:836) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:456) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:246) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:199) ~[mysql-connector-java-8.0.18.jar:8.0.18]
	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:156) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:218) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:150) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1560) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1623) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:861) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1229) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:1225) ~[druid-1.1.10.jar:1.1.10]
	at com.alibaba.druid.pool.DruidDataSource.getConnection(DruidDataSource.java:90) ~[druid-1.1.10.jar:1.1.10]
	at org.springframework.jdbc.datasource.DataSourceTransactionManager.doBegin(DataSourceTransactionManager.java:263) ~[spring-jdbc-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.transaction.support.AbstractPlatformTransactionManager.getTransaction(AbstractPlatformTransactionManager.java:376) ~[spring-tx-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.createTransactionIfNecessary(TransactionAspectSupport.java:560) ~[spring-tx-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:347) ~[spring-tx-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:99) ~[spring-tx-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) ~[spring-aop-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$CglibMethodInvocation.proceed(CglibAopProxy.java:747) ~[spring-aop-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:689) ~[spring-aop-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at com.baidu.fsg.uid.worker.DisposableWorkerIdAssigner$$EnhancerBySpringCGLIB$$17ab474d.assignWorkerId(<generated>) ~[classes/:?]
	at com.baidu.fsg.uid.impl.DefaultUidGenerator.afterPropertiesSet(DefaultUidGenerator.java:89) ~[classes/:?]
	at com.baidu.fsg.uid.impl.CachedUidGenerator.afterPropertiesSet(CachedUidGenerator.java:69) ~[classes/:?]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1862) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1799) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:595) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.beans.factory.config.DependencyDescriptor.resolveCandidate(DependencyDescriptor.java:276) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1287) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1207) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.autowireResource(CommonAnnotationBeanPostProcessor.java:537) ~[spring-context-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.getResource(CommonAnnotationBeanPostProcessor.java:513) ~[spring-context-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor$ResourceElement.getResourceToInject(CommonAnnotationBeanPostProcessor.java:653) ~[spring-context-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.beans.factory.annotation.InjectionMetadata$InjectedElement.inject(InjectionMetadata.java:224) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:116) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.context.annotation.CommonAnnotationBeanPostProcessor.postProcessProperties(CommonAnnotationBeanPostProcessor.java:334) ~[spring-context-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1429) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:594) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323) ~[spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) [spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) [spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) [spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:879) [spring-beans-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:878) [spring-context-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:550) [spring-context-5.2.0.RELEASE.jar:5.2.0.RELEASE]
	at org.springframework.boot.web.servlet.context.ServletWebServerApplicationContext.refresh(ServletWebServerApplicationContext.java:141) [spring-boot-2.2.0.RELEASE.jar:2.2.0.RELEASE]
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:747) [spring-boot-2.2.0.RELEASE.jar:2.2.0.RELEASE]
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:397) [spring-boot-2.2.0.RELEASE.jar:2.2.0.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:315) [spring-boot-2.2.0.RELEASE.jar:2.2.0.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1226) [spring-boot-2.2.0.RELEASE.jar:2.2.0.RELEASE]
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1215) [spring-boot-2.2.0.RELEASE.jar:2.2.0.RELEASE]
	at cn.com.icbf.framework.uid.UidStartApplication.main(UidStartApplication.java:20) [classes/:?]
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: Communications link failure

解决方法

这是因为MySQL在高版本需要指明是否进行SSL连接：?useSSL=false
在这里插入图片描述

思凡04
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
正确解决com.mysql.cj.jdbc.exceptions.CommunicationsException异常的有效解决方法
wbajsjhhhhh的博客
05-12 3715
正确解决com.mysql.cj.jdbc.exceptions.CommunicationsException异常的有效解决方法
### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException
qq_40181435的博客
04-14 3439
org.apache.ibatis.exceptions.PersistenceException: ### Error querying database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manu...
[ERROR]-[com.alibaba.druid.pool.DruidDataSource.init()]: init datasource error问题解决
luoluo18的博客
06-16 1万+
[ERROR]-[com.alibaba.druid.pool.DruidDataSource.init()]: init datasource error， url: jdbc:mysql://XXX问题解决 导入项目，启动报错 报错信息 [ERROR]-[Thread: localhost-startStop-1]-[com.alibaba.druid.pool.DruidDataSource.init()]: init datasource error, url: jdbc:mysql://loc
数据库链接报错init datasource error, url:.....
weixin_43803387的博客
10-13 1万+
init datasource error, url:.....数据库链接报错
init datasource error, url: jdbc:mysql://localhost:3306/test 解决办法
段占彪的博客
12-13 1万+
问题描述 今天启动项目突然抛出如下错误信息： [16:14:32.735][ERROR][com.alibaba.druid.pool.DruidDataSource][main] init datasource error, url: jdbc:mysql://localhost:3306/test com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure The last packet sen
init datasource error, url: jdbc:mysql://localhost:3306/book(初始化数据库错误)
DreamBeliever的博客
10-31 9846
1.问题 初始化数据库错误，init datasource error, url: jdbc:mysql://localhost:3306/book 2.原因 本地下载安装的MySQL服务是8.0的，但是数据库驱动使用了5.X版本的 3.解决办法 （1）将数据库驱动更新为符合数据库版本的 MySQL :: Begin Your Download 再次启动，出现如下错误： Loading class com.mysql.jdbc.Driver'. This is deprecated. The new
jdbc连接mysql 8 的一些坑
wanglong1221的博客
07-21 1万+
1、驱动包要升级为 mysql-connector-java-8.0.11.jar   2、JDBC driver 由“com.mysql.jdbc.Driver”改为“com.mysql.cj.jdbc.Driver”   3、url中加上“userSSL=false”。否则会出现以下错误： “Establishing SSL connection withoutserver's id...
连接MySQL 报错"init datasource error, url: jdbc:mysql:/" 解决
热门推荐
Kainx
03-15 3万+
原因 原来数据库5.5升级到8.0后，数据库连接配置没有改造成的 解决办法 1、驱动包要升级为 mysql-connector-java-8.0.11.jar 或更新的版本 https://dev.mysql.com/downloads/file/?id=477058 Maven 依赖: <dependencies> <dependency> <group...
jdbc连接mysql报null问题解决
Autumn_bell的博客
07-22 5442
今天换了个maven来管理项目，在运行之前程序的时候，发现一直报null跟踪调试了一下，发现是：connection = DriverManager.getConnection(URL, "root", "123456");报错：The server time zone value '乱码' is unrecognized or represents more than one time zone.
mybatis 使用jdbc.properties文件设置不起作用的解决方法
08-27
然后，我们可以在 `<dataSource>` 元素中使用 `${jdbc.driverClass}`、`${jdbc.url}`、`${jdbc.username}` 和 `${jdbc.password}` 等变量来获取 jdbc.properties 文件中的信息。例如： ```xml <dataSource type=...
MySql5.x升级MySql8.x的方法步骤
09-08
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/sell?serverTimezone=GMT%2B8&useUnicode=true&characterEncoding=UTF8 ``` **三、升级数据库服务器** 1. **停服并备份**：在升级前，停止所有数据库服务，...
datasource-proxy：为JDBC交互和通过代理执行查询提供侦听器框架
02-05
为JDBC API提供代理类，以拦截正在执行的查询和方法。 版本号 2.x （开发中） Java8基准。 master分支 1.x 与JDK1.6 +兼容（与Java8兼容）。 1.x分支 用户指南 Maven < groupId>net.ttddyy</ groupId> ...
Tomcat报错： JDBC unregister 解决办法
09-30
DataSource ds = (DataSource)envCtx.lookup("jdbc/MyDB"); Connection conn = ds.getConnection(); ``` 感谢您的阅读，希望这些信息对您解决问题有所帮助。对于更多关于Tomcat、JDBC驱动管理或者内存泄漏预防的...
连接数据库报错问题：严重: init datasource error, url: jdbc:mysql:
weixin_46200533的博客
07-08 1万+
原因：版本不一致： 练习时用的MYSQL驱动包是5.1版本，而本地MYSQL安装的是8.0，需使用8.0版本jar包，同时更改数据库连接配置。 更改数据库连接配置： jdbc.driver=com.mysql.cj.jdbc.Driver jdbc.url=jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=utf-8&userSSL=false&serverTimezone=GMT%2B8 在数据库
com.alibaba.druid.pool.DruidDataSource.init- init datasource error, url: jdbc:mysql: 数据库连接异常
weixin_44267840的博客
07-15 8835
com.alibaba.druid.pool.DruidDataSource.init- init datasource error, url: jdbc:mysql: 数据库连接异常 1.产生原因 猜测是数据库驱动与数据库不匹配导致无法正常连接，尤其是MySQL版本高于5.7.29以后需要8版本的驱动器 2.解决方法 在pom.xml中引入8版本的驱动 <dependency> <groupId>mysql</groupId> <artifac
【已解决】启动项目时报错：init datasource error, url: jdbc:mysql://……
qq_51101760的博客
08-03 6732
解决报错 init datasource error, url: jdbc:mysql:……
Nacos启动异常
you_get_me_there的博客
08-11 6814
可能原因一: 集群切换单机 startup -m standalone 可能原因二: derby-data文件夹内文件解析失败 解决方案: 删了derby-data文件夹重启就行 报错信息(供网友搜索): 2021-08-11 13:11:37,550 WARN Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.U
init datasource error, url: jdbc:mysql://localhost:3306/book?characterEncoding=utf8&useSSL=false&ser
OYMNCHR的博客
05-01 1761
错误信息： init datasource error, url: jdbc:mysql://localhost:3306/book?characterEncoding=utf8&useSSL=false&serverTimezone=UTC&rewriteBatchedStatements=true java.sql.SQLException: Access denied for user 'root'@'localhost' (using password: YES) 错误原因
spring-boot连接数据库时init datasource error, url: jdbc:mysql://xx.xxx.xxx.xxx:3306/demo?的报错
m0_51041464的博客
10-23 2637
因为电脑上的mysql坏掉 所以连接的mysql换为了在服务器上的，自己最开始写的代码是这样的 spring: datasource: type: com.alibaba.druid.pool.DruidDataSource druid: driver-class-name: com.mysql.cj.jdbc.Driver url: jdbc:mysql://xxxx.xxx.xxx.xxxx:3306/xxxx?useUnicode=true&ch
ERROR [com.alibaba.druid.pool.DruidDataSource] - init datasource error url: jdbc:mysql://xxx 解决方法
最新发布
09-20
对于您提出的错误信息，"ERROR [com.alibaba.druid.pool.DruidDataSource] - init datasource error url: jdbc:mysql://xxx"，这是Druid数据源初始化时出现的错误。 出现这个错误可能有以下几种原因和解决方法： 1...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

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

余额充值