项目连接MySQL数据库，提示异常
16lz
2021-01-22
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException:Communicationslinkfailure
Thelastpacketsentsuccessfullytotheserverwas0millisecondsago.Thedriverhasnotreceivedanypacketsfromtheserver.
atsun.reflect.NativeConstructorAccessorImpl.newInstance0(NativeMethod)
atsun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
atjava.lang.reflect.Constructor.newInstance(Constructor.java:423)
atcom.mysql.jdbc.Util.handleNewInstance(Util.java:404)
atcom.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:981)
atcom.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:339)
atcom.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253)
atcom.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2286)
atcom.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2085)
atcom.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:795)
atcom.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)
atsun.reflect.NativeConstructorAccessorImpl.newInstance0(NativeMethod)
atsun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
atjava.lang.reflect.Constructor.newInstance(Constructor.java:423)
atcom.mysql.jdbc.Util.handleNewInstance(Util.java:404)
atcom.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400)
atcom.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:327)
atorg.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
atorg.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
atorg.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:710)
atorg.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:644)
atorg.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:466)
atorg.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:143)
atorg.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116)
atorg.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103)
atorg.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127)
atorg.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122)
atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)
atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
atorg.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
atorg.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
atorg.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
atorg.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
atorg.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:296)
atorg.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
atorg.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:1192)
atorg.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1116)
atorg.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1014)
atorg.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredMethodElement.inject(AutowiredAnnotationBeanPostProcessor.java:618)
atorg.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88)
atorg.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:331)
atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1214)
atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)
nRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
atorg.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
atorg.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
atorg.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
atorg.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1481)
atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1226)
atorg.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:356)
Causedby:java.net.ConnectException:Connectionrefused:connect
atjava.net.DualStackPlainSocketImpl.connect0(NativeMethod)
atjava.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
atjava.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
atjava.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
并不是网上说得那种连接超时错误，我还没有连上。根本不会提示MySQL8小时自动断开。
新手。
Thelastpacketsentsuccessfullytotheserverwas0millisecondsago.Thedriverhasnotreceivedanypacketsfromtheserver.
你的mysql服务启动了吗？
你可以看看任务管理器中有没有mysql字样的进程在运行。
Thelastpacketsentsuccessfullytotheserverwas0millisecondsago.Thedriverhasnotreceivedanypacketsfromtheserver.
atsun.reflect.NativeConstructorAccessorImpl.newInstance0(NativeMethod)
atsun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
atjava.lang.reflect.Constructor.newInstance(Constructor.java:423)
atcom.mysql.jdbc.Util.handleNewInstance(Util.java:404)
atcom.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:981)
atcom.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:339)
atcom.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2253)
atcom.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2286)
atcom.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2085)
atcom.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:795)
atcom.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:44)
atsun.reflect.NativeConstructorAccessorImpl.newInstance0(NativeMethod)
atsun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
atsun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
atjava.lang.reflect.Constructor.newInstance(Constructor.java:423)
atcom.mysql.jdbc.Util.handleNewInstance(Util.java:404)
atcom.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:400)
atcom.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:327)
atorg.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:278)
atorg.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:182)
atorg.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:710)
atorg.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:644)
atorg.apache.tomcat.jdbc.pool.ConnectionPool.init(ConnectionPool.java:466)
atorg.apache.tomcat.jdbc.pool.ConnectionPool.<init>(ConnectionPool.java:143)
atorg.apache.tomcat.jdbc.pool.DataSourceProxy.pCreatePool(DataSourceProxy.java:116)
atorg.apache.tomcat.jdbc.pool.DataSourceProxy.createPool(DataSourceProxy.java:103)
atorg.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:127)
atorg.hibernate.engine.jdbc.connections.internal.DatasourceConnectionProviderImpl.getConnection(DatasourceConnectionProviderImpl.java:122)
atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)
atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:482)
atorg.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:306)
atorg.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
atorg.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
atorg.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
atorg.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:296)
atorg.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
atorg.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:1192)
atorg.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:1116)
atorg.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:1014)
atorg.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredMethodElement.inject(AutowiredAnnotationBeanPostProcessor.java:618)
atorg.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88)
atorg.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:331)
atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1214)
atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:543)
nRegistry.getSingleton(DefaultSingletonBeanRegistry.java:230)
atorg.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:302)
atorg.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:197)
atorg.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:351)
atorg.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:108)
atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1481)
atorg.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1226)
atorg.codehaus.plexus.classworlds.launcher.Launcher.main(Launcher.java:356)
Causedby:java.net.ConnectException:Connectionrefused:connect
atjava.net.DualStackPlainSocketImpl.connect0(NativeMethod)
atjava.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
atjava.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
atjava.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
并不是网上说得那种连接超时错误，我还没有连上。根本不会提示MySQL8小时自动断开。
新手。
3 个解决方案
#1
Thelastpacketsentsuccessfullytotheserverwas0millisecondsago.Thedriverhasnotreceivedanypacketsfromtheserver.
你的mysql服务启动了吗？
你可以看看任务管理器中有没有mysql字样的进程在运行。
更多相关文章
- mysql使用kill无法杀死进程
- Android进程间（IPC机制）通信(Bundler,Messenger,AIDL,ContentProvi
- Android中bindService的细节之二：从进程的角度分析绑定Service的
- Android之进程间通信(IPC)-Messenger
- java线程实现与进程（二）
- 使用线程设置后台进程以处理Android中的工作
- 理解Android的本地Service和跨进程Service
- android init进程分析 ueventd — 设备节点的创建、固件更新过
- Linux上杀死eclipse进程