com.alibaba.druid.pool.DruidDataSource : init datasource error, url:报错问题

最新推荐文章于 2024-09-11 11:29:04 发布
最新推荐文章于 2024-09-11 11:29:04 发布
阅读量900 收藏 15
点赞数 22
分类专栏： java异常总结 文章标签： java mysql
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/han_you_3214/article/details/141465167
版权

报错如下

Could not create connection to database server. Attempted reconnect 3 times. Giving up.
Caused by: javax.net.ssl.SSLHandshakeException: java.security.cert.CertificateExpiredException: NotAfter: Fri Aug 23 01:08:50 CST 2024

java.sql.SQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up.
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:110)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:89)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:63)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:73)
	at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:905)
	at com.mysql.cj.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:830)
	at com.mysql.cj.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:455)
	at com.mysql.cj.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:240)
	at com.mysql.cj.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:207)
	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:156)
	at com.alibaba.druid.filter.stat.StatFilter.connection_connect(StatFilter.java:227)
	at com.alibaba.druid.filter.FilterChainImpl.connection_connect(FilterChainImpl.java:150)
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1654)
	at com.alibaba.druid.pool.DruidAbstractDataSource.createPhysicalConnection(DruidAbstractDataSource.java:1718)
	at com.alibaba.druid.pool.DruidDataSource.init(DruidDataSource.java:914)
	at com.zhichubao.slc.dal.configure.dbconfig.DataSourceMybatisAutoConfiguration.masterDateSource(DataSourceMybatisAutoConfiguration.java:66)
	at com.zhichubao.slc.dal.configure.dbconfig.DataSourceMybatisAutoConfiguration$$EnhancerBySpringCGLIB$$f4342508.CGLIB$masterDateSource$3(<generated>)
	at com.zhichubao.slc.dal.configure.dbconfig.DataSourceMybatisAutoConfiguration$$EnhancerBySpringCGLIB$$f4342508$$FastClassBySpringCGLIB$$f66f2617.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
	at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:358)
	at com.zhichubao.slc.dal.configure.dbconfig.DataSourceMybatisAutoConfiguration$$EnhancerBySpringCGLIB$$f4342508.masterDateSource(<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:498)
	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:197)
	at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.obtainBeanInstanceFromFactory(ConfigurationClassEnhancer.java:389)
	at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:361)
	at com.zhichubao.slc.dal.configure.dbconfig.DataSourceMybatisAutoConfiguration$$EnhancerBySpringCGLIB$$f4342508.masterDateSource(<generated>)
	at com.zhichubao.slc.dal.configure.dbconfig.DataSourceMybatisAutoConfiguration.dynamicDataSource(DataSourceMybatisAutoConfiguration.java:99)
	at com.zhichubao.slc.dal.configure.dbconfig.DataSourceMybatisAutoConfiguration$$EnhancerBySpringCGLIB$$f4342508.CGLIB$dynamicDataSource$0(<generated>)
	at com.zhichubao.slc.dal.configure.dbconfig.DataSourceMybatisAutoConfiguration$$EnhancerBySpringCGLIB$$f4342508$$FastClassBySpringCGLIB$$f66f2617.invoke(<generated>)
	at org.springframework.cglib.proxy.MethodProxy.invokeSuper(MethodProxy.java:228)
	at org.springframework.context.annotation.ConfigurationClassEnhancer$BeanMethodInterceptor.intercept(ConfigurationClassEnhancer.java:358)
	at com.zhichubao.slc.dal.configure.dbconfig.DataSourceMybatisAutoConfiguration$$EnhancerBySpringCGLIB$$f4342508.dynamicDataSource(<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:498)
	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.AbstractAutowireCapableBeanFactory.autowireByType(AbstractAutowireCapableBeanFactory.java:1342)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1249)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553)
	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.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:585)
	at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88)
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:366)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1264)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553)
	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.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:585)
	at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88)
	at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:366)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1264)
	at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:553)
	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.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:761)
	at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:867)
	at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:543)
	at org.springframework.boot.context.embedded.EmbeddedWebApplicationContext.refresh(EmbeddedWebApplicationContext.java:122)
	at org.springframework.boot.SpringApplication.refresh(SpringApplication.java:693)
	at org.springframework.boot.SpringApplication.refreshContext(SpringApplication.java:360)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:303)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1118)
	at org.springframework.boot.SpringApplication.run(SpringApplication.java:1107)
	at com.zhichubao.slc.web.ApplicationStarter.main(ApplicationStarter.java:43)
	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:498)
	at org.springframework.boot.loader.MainMethodRunner.run(MainMethodRunner.java:49)
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:107)
	at org.springframework.boot.loader.Launcher.launch(Launcher.java:58)
	at org.springframework.boot.loader.JarLauncher.main(JarLauncher.java:88)
Caused by: com.mysql.cj.exceptions.CJCommunicationsException: 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 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:423)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:61)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:105)
	at com.mysql.cj.exceptions.ExceptionFactory.createException(ExceptionFactory.java:151)
	at com.mysql.cj.exceptions.ExceptionFactory.createCommunicationsException(ExceptionFactory.java:167)
	at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:351)
	at com.mysql.cj.protocol.a.NativeAuthenticationProvider.negotiateSSLConnection(NativeAuthenticationProvider.java:777)
	at com.mysql.cj.protocol.a.NativeAuthenticationProvider.proceedHandshakeWithPluggableAuthentication(NativeAuthenticationProvider.java:486)
	at com.mysql.cj.protocol.a.NativeAuthenticationProvider.connect(NativeAuthenticationProvider.java:202)
	at com.mysql.cj.protocol.a.NativeProtocol.connect(NativeProtocol.java:1442)
	at com.mysql.cj.NativeSession.connect(NativeSession.java:165)
	at com.mysql.cj.jdbc.ConnectionImpl.connectWithRetries(ConnectionImpl.java:849)
	... 122 common frames omitted
Caused by: javax.net.ssl.SSLHandshakeException: java.security.cert.CertificateExpiredException: NotAfter: Fri Aug 23 01:08:50 CST 2024
	at sun.security.ssl.Alerts.getSSLException(Alerts.java:192)
	at sun.security.ssl.SSLSocketImpl.fatal(SSLSocketImpl.java:1949)
	at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:302)
	at sun.security.ssl.Handshaker.fatalSE(Handshaker.java:296)
	at sun.security.ssl.ClientHandshaker.serverCertificate(ClientHandshaker.java:1514)
	at sun.security.ssl.ClientHandshaker.processMessage(ClientHandshaker.java:216)
	at sun.security.ssl.Handshaker.processLoop(Handshaker.java:1026)
	at sun.security.ssl.Handshaker.process_record(Handshaker.java:961)
	at sun.security.ssl.SSLSocketImpl.readRecord(SSLSocketImpl.java:1062)
	at sun.security.ssl.SSLSocketImpl.performInitialHandshake(SSLSocketImpl.java:1375)
	at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1403)
	at sun.security.ssl.SSLSocketImpl.startHandshake(SSLSocketImpl.java:1387)
	at com.mysql.cj.protocol.ExportControlled.performTlsHandshake(ExportControlled.java:315)
	at com.mysql.cj.protocol.StandardSocketFactory.performTlsHandshake(StandardSocketFactory.java:188)
	at com.mysql.cj.protocol.a.NativeSocketConnection.performTlsHandshake(NativeSocketConnection.java:99)
	at com.mysql.cj.protocol.a.NativeProtocol.negotiateSSLConnection(NativeProtocol.java:347)
	... 128 common frames omitted
Caused by: java.security.cert.CertificateExpiredException: NotAfter: Fri Aug 23 01:08:50 CST 2024
	at sun.security.x509.CertificateValidity.valid(CertificateValidity.java:274)
	at sun.security.x509.X509CertImpl.checkValidity(X509CertImpl.java:629)
	at sun.security.x509.X509CertImpl.checkValidity(X509CertImpl.java:602)
	at com.mysql.cj.protocol.ExportControlled$X509TrustManagerWrapper.checkServerTrusted(ExportControlled.java:362)
	at sun.security.ssl.AbstractTrustManagerWrapper.checkServerTrusted(SSLContextImpl.java:984)
	at sun.security.ssl.ClientHandshaker.serverCertificate(ClientHandshaker.java:1496)
	... 139 common frames omitted

2024-08-23 11:37:01.222 ERROR 22 --- [           main] com.alibaba.druid.pool.DruidDataSource   : {dataSource-1} init error

解决方法

看到最后，发现是SSL证书过期，在msyql连接数处加上配置：useSSL=false，可解决

        url: jdbc:mysql://${MYSQL_HOST}:${MYSQL_PORT}/${MYSQL_DB}?serverTimezone=GMT%2b8&allowMultiQueries=true&characterEncoding=utf-8&autoReconnect=true&failOverReadOnly=false&useSSL=false
        username: ${MYSQL_USERNAME}
        password: ${MYSQL_PASSWORD}
大丽子
关注
专栏目录
[ERROR]-[Thread: main]-[com.alibaba.druid.pool.DruidDataSource.init()]: init datasource error, url:
易天海
07-11 1万+
[ERROR]-[Thread: main]-[com.alibaba.druid.pool.DruidDataSource.init()]: init datasource error, url: jdbc:mysql://47.92.116.76:3306/jfinal_demo?characterEncoding=utf8&zeroDateTimeBehavior=convertTo...
Java数据库连接池Druid报错com.alibaba.druid.pool.DruidDataSource error
emgexgb_sef的博客
06-05 1683
一.报错信息 二.我的配置如下 1.测试代码 2.maven中导包配置 3.druid.properties配置 三，解决方案将druid.properties中的user改成username求关注，谢谢！
ERROR [com.alibaba.druid.pool.DruidDataSource] - init datasource error url: jdbc:mysql://xxx 解决方法
热门推荐
samuelandkevin的专栏
04-03 9万+
拿了一个旧项目，运行一下。控制台报错，具体错误信息如下： 2018-04-03 16:39:23,391 ERROR [com.alibaba.druid.pool.DruidDataSource] - init datasource error, url: jdbc:mysql://192.168.1.143:3306/public_platform?useUnicode=true&amp...
链接数据库报错：ERROR 15822 --- com.alibaba.druid.pool.DruidDataSource : create connection error
噢，乖
12-19 4552
ERROR 15822 --- [eate-1550768117] com.alibaba.druid.pool.DruidDataSource : create connection error, url: jdbc:mysql://127.0.0.1:3de=true&characterEncoding=utf-8&useSSL=true, errorCode 0, sta...
com.alibaba.druid.pool.DruidDataSource error
最新发布
一条大河
09-11 319
com.alibaba.druid.pool.DruidDataSource
com.alibaba.druid.pool.DruidDataSource.init- init datasource error, url: jdbc:mysql: 数据库连接异常
weixin_44267840的博客
07-15 9299
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
com.alibaba.druid.pool.DruidDataSource - init error（已解决）
weixin_63566038的博客
10-16 7782
学习Druid+mysql+servlet，做尚硅谷的书城项目时，上述方法都试过了一遍，最后受到高人指引，看了百度和CSDN的很多文章，大部分说。
ERROR [com.alibaba.druid.pool.DruidDataSource] - init datasource error, url:
热爱我的热爱
08-07 4万+
今天连接数据库的时候报错了...原因如上ERROR [com.alibaba.druid.pool.DruidDataSource] - init datasource error, url:..... 这是url地址错误，所以连接不上数据库，把url填写正确就可以了。
com.alibaba.druid.pool.DruidDataSource - init datasource error
weixin_43222122的博客
07-27 1万+
今天遇到了这个错误，在网上找了半天答案都不适合我的。 错误的主要原因： 我的MySQL版本是8.0以上的版本，我pom.xml引用的mysql-connector-java.jar的版本是5.0的版本； 开始我用的JDBC是com.mysql.jdbc.Driver,而8.0以上版本的MySQL要用com.mysql.cj.jdbc.Driver； 而且Url必须加上时区，之前我没写； 修改后： jdbc.driver=com.mysql.cj.jdbc.Driver jd.
ERROR 14340 --- [ main] com.alibaba.druid.pool.DruidDataSource : init datasource error
GOOD LUCK
05-30 1653
报错信息： 2020-05-30 21:44:00.314 ERROR 14340 --- [ main] com.alibaba.druid.pool.DruidDataSource : init datasource error java.sql.SQLException: connect error, url xxxxxx, driverClass com.mysql.jdbc.Driver at com.alibaba.druid.pool.DruidAbstrac.
在线商城系统 报错 ERROR [com.alibaba.druid.pool.DruidDataSource] - create connection error
qq_40466305的博客
11-27 8595
系统使用Maven管理jar包，数据库为mysql 问题：系统换了台电脑运行报错，连接不上数据库，报下面的错误： 2019-11-27 22:43:18,418 ERROR [com.alibaba.druid.pool.DruidDataSource] - create connection error com.mysql.jdbc.exceptions.jdbc4.MySQLNonTran...
数据库链接报错init datasource error, url:.....
weixin_43803387的博客
10-13 1万+
init datasource error, url:.....数据库链接报错
ERROR [com.alibaba.druid.pool.DruidDataSource] - init datasource error url: jdbc:mysql://xxx;
hnnydxhxg的博客
05-17 5958
我出现的问题是You must configure either the server or JDBC driver (via the serverTimezone configuration property) 这是由于MySQL5.7使用高版本的连接桥后出现时区乱码的情况，然而红色字体的翻译大意：服务器的时区值”? ? ?你±e×? ?±? ?（乱码）“无法识别或代表多个时区。您必须配置服务...
ERROR [com.alibaba.druid.pool.DruidDataSource] - init datasource error url: jdbc:mysql://XXX 解决方法
qq_40523277的博客
10-30 1万+
数据库连接失败多半是导包不正确： 将包导入lib文件夹下； 但是我遇到的不是这样解决的，我这个错误有时有但是有时又莫名奇妙的出现，最后发现是驱动版本太低； 之前的低版本驱动和MySQL8.0不匹配，但是勉强能用 后换成 再更改一系列信息： mysql后需要加上cj 还需要更改时区： 打开mysql：输入 set global time_zone='+8:00'; 完美解决 ...
com.alibaba.druid.pool.DruidDataSource 初始化数据源错误
Eskiii的博客
03-02 3738
错误描述： ERROR 18520 — [main] com.alibaba.druid.pool.DruidDataSource : init datasource error, url: jdbc:mysql://xxx.xxx.xxx.xxx:3306/gulimall_admin?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai 解决： 在application-dev.yml 的 url 加
com.alibaba.druid.pool.DruidDataSource error 严重: init datasource error
HX1_0_0的博客
12-22 3265
这里写自定义目录标题欢迎使用Markdown编辑器新的改变功能快捷键合理的创建标题，有助于目录的生成如何改变文本的样式插入链接与图片如何插入一段漂亮的代码片生成一个适合你的列表创建一个表格设定内容居中、居左、居右SmartyPants创建一个自定义列表如何创建一个注脚注释也是必不可少的KaTeX数学公式新的甘特图功能，丰富你的文章UML 图表FLowchart流程图导出与导入导出导入 欢迎使用Markdown编辑器 你好！ 这是你第一次使用 Markdown编辑器 所展示的欢迎页。如果你想学习如何使用Mar
ERROR com.alibaba.druid.pool.DruidDataSource - {dataSource-1} init error
Obscurede的博客
03-13 5121
ERROR com.alibaba.druid.pool.DruidDataSource - {dataSource-1} init error解决方案
ERROR com.alibaba.druid.pool.DruidDataSource - init datasource error, url jdbcmysql
浪子寒的策略空间
11-18 2万+
部署一个开源项目报错 ERROR com.alibaba.druid.pool.DruidDataSource - init datasource error, url jdbcmysql:// 很明显是数据库连接错误 但排除一下错误后，我才算找到真正的错误原因 数据库连接地址错误 网络问题 用户名密码错误 最后发现是开源项目自带的mysql驱动版本有问题，和我安装的mysql对不上 解决方法： 去pom.xml中删除mysql的版本信息，默认即可，如下 <dependency> &
com.alibaba.druid.pool.DruidDataSource : init datasource error, url:
09-15
在引用中提到的错误信息是关于Druid连接池初始化数据源时的异常。根据引用和引用中的解决方法，可能的原因是数据库驱动与数据库不匹配导致无法正常连接。解决方法是在pom.xml中引入8版本的驱动，并在配置文件中修改数据源配置。你可以尝试在pom.xml中引入以下依赖项来解决此问题： ```xml <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.17</version> </dependency> ``` 另外，在配置文件中的数据源配置中，将`useSSL`设置为`false`： ``` datasource.driverClassName=com.mysql.cj.jdbc.Driver datasource.url=jdbc:mysql://xxx:3306/xxx?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC&useSSL=false ``` 希望这些解决方法能够帮助你解决此问题。
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值