Could not get JDBC Connection；java.net.ConnectException: Connection refused: connect

原文地址：http://blog.csdn.net/u011731544/article/details/78986522

连接被拒绝。出现这种问题的原因是：数据库服务没打开。启动数据库服务就好了

    Caused by: com.mysql.jdbc.exceptions.jdbc4.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 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:411)  
        at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1129)  
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:358)  
        at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2498)  
        at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2535)  
        at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2320)  
        at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:834)  
        at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)  
        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:411)  
        at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:416)  
        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:347)  
        at java.sql.DriverManager.getConnection(DriverManager.java:664)  
        at java.sql.DriverManager.getConnection(DriverManager.java:208)  
        at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:153)  
        at org.springframework.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriver(DriverManagerDataSource.java:144)  
        at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnectionFromDriver(AbstractDriverBasedDataSource.java:196)  
        at org.springframework.jdbc.datasource.AbstractDriverBasedDataSource.getConnection(AbstractDriverBasedDataSource.java:159)  
        at org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111)  
        at org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77)  
        ... 86 more  
    Caused by: java.net.ConnectException: Connection refused: connect  
        at java.net.DualStackPlainSocketImpl.connect0(Native Method)  
        at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)  
        at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:345)  
        at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)  
        at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)  
        at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)  
        at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)  
        at java.net.Socket.connect(Socket.java:589)  
        at java.net.Socket.connect(Socket.java:538)  
        at java.net.Socket.<init>(Socket.java:434)  
        at java.net.Socket.<init>(Socket.java:244)  
        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)  
        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:308)  
        ... 106 more  
    06-Jan-2018 09:01:09.255 SEVERE [http-nio-8080-exec-8] org.apache.catalina.core.StandardWrapperValve.invoke Servlet.service() for servlet [springMVC] in context with path [] threw exception [Request processing failed; nested exception is org.mybatis.spring.MyBatisSystemException: nested exception is org.apache.ibatis.exceptions.PersistenceException:   
    ### Error querying database.  Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.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.  
    ### The error may exist in file [E:\1715\ssm-blog-admin\target\ssm-blog-admin\WEB-INF\classes\com\ssm\blog\dao\mapper\BlogMappper.xml]  
    ### The error may involve com.ssm.blog.dao.BlogDAO.getBlogList_COUNT  
    ### The error occurred while executing a query  
    ### Cause: org.springframework.jdbc.CannotGetJdbcConnectionException: <span style="color:#FF0000;">Could not get JDBC Connection</span>; nested exception is com.mysql.jdbc.exceptions.jdbc4.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.] with root cause  
     java.net.ConnectException: <span style="color:#FF0000;">Connection refused: connect</span>  
        at java.net.DualStackPlainSocketImpl.connect0(Native Method)