Type Exception Report
Message Request processing failed; nested exception is org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
Description The server encountered an unexpected condition that prevented it from fulfilling the request.
Exception
org.springframework.web.util.NestedServletException: Request processing failed; nested exception is 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. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:982) org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861) javax.servlet.http.HttpServlet.service(HttpServlet.java:635) org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) javax.servlet.http.HttpServlet.service(HttpServlet.java:742) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
Root 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. org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:80) org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:619) org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:684) org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:716) org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:726) org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:794) org.springframework.jdbc.core.JdbcTemplate.queryForMap(JdbcTemplate.java:828) com.juzhencms.apps.common.persistence.JdbcDao.queryRow(JdbcDao.java:45) com.juzhencms.apps.common.interceptor.UserInterceptor.preHandle(UserInterceptor.java:91) org.springframework.web.servlet.HandlerExecutionChain.applyPreHandle(HandlerExecutionChain.java:133) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:962) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861) javax.servlet.http.HttpServlet.service(HttpServlet.java:635) org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) javax.servlet.http.HttpServlet.service(HttpServlet.java:742) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
Root Cause
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. sun.reflect.GeneratedConstructorAccessor69.newInstance(Unknown Source) sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) java.lang.reflect.Constructor.newInstance(Constructor.java:423) com.mysql.jdbc.Util.handleNewInstance(Util.java:425) com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:989) com.mysql.jdbc.MysqlIO.(MysqlIO.java:341) com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2189) com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2222) com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2017) com.mysql.jdbc.ConnectionImpl. (ConnectionImpl.java:779) com.mysql.jdbc.JDBC4Connection. (JDBC4Connection.java:47) sun.reflect.GeneratedConstructorAccessor54.newInstance(Unknown Source) sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) java.lang.reflect.Constructor.newInstance(Constructor.java:423) com.mysql.jdbc.Util.handleNewInstance(Util.java:425) com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389) com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330) org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:310) org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:203) org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:735) org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:667) org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:198) org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:132) org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111) org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77) org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:619) org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:684) org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:716) org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:726) org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:794) org.springframework.jdbc.core.JdbcTemplate.queryForMap(JdbcTemplate.java:828) com.juzhencms.apps.common.persistence.JdbcDao.queryRow(JdbcDao.java:45) com.juzhencms.apps.common.interceptor.UserInterceptor.preHandle(UserInterceptor.java:91) org.springframework.web.servlet.HandlerExecutionChain.applyPreHandle(HandlerExecutionChain.java:133) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:962) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861) javax.servlet.http.HttpServlet.service(HttpServlet.java:635) org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) javax.servlet.http.HttpServlet.service(HttpServlet.java:742) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
Root Cause
java.net.ConnectException: Connection refused (Connection refused) java.net.PlainSocketImpl.socketConnect(Native Method) java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350) java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206) java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188) java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392) java.net.Socket.connect(Socket.java:589) com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211) com.mysql.jdbc.MysqlIO.(MysqlIO.java:300) com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2189) com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2222) com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2017) com.mysql.jdbc.ConnectionImpl. (ConnectionImpl.java:779) com.mysql.jdbc.JDBC4Connection. (JDBC4Connection.java:47) sun.reflect.GeneratedConstructorAccessor54.newInstance(Unknown Source) sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) java.lang.reflect.Constructor.newInstance(Constructor.java:423) com.mysql.jdbc.Util.handleNewInstance(Util.java:425) com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389) com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330) org.apache.tomcat.jdbc.pool.PooledConnection.connectUsingDriver(PooledConnection.java:310) org.apache.tomcat.jdbc.pool.PooledConnection.connect(PooledConnection.java:203) org.apache.tomcat.jdbc.pool.ConnectionPool.createConnection(ConnectionPool.java:735) org.apache.tomcat.jdbc.pool.ConnectionPool.borrowConnection(ConnectionPool.java:667) org.apache.tomcat.jdbc.pool.ConnectionPool.getConnection(ConnectionPool.java:198) org.apache.tomcat.jdbc.pool.DataSourceProxy.getConnection(DataSourceProxy.java:132) org.springframework.jdbc.datasource.DataSourceUtils.doGetConnection(DataSourceUtils.java:111) org.springframework.jdbc.datasource.DataSourceUtils.getConnection(DataSourceUtils.java:77) org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:619) org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:684) org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:716) org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:726) org.springframework.jdbc.core.JdbcTemplate.queryForObject(JdbcTemplate.java:794) org.springframework.jdbc.core.JdbcTemplate.queryForMap(JdbcTemplate.java:828) com.juzhencms.apps.common.persistence.JdbcDao.queryRow(JdbcDao.java:45) com.juzhencms.apps.common.interceptor.UserInterceptor.preHandle(UserInterceptor.java:91) org.springframework.web.servlet.HandlerExecutionChain.applyPreHandle(HandlerExecutionChain.java:133) org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:962) org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:901) org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:970) org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:861) javax.servlet.http.HttpServlet.service(HttpServlet.java:635) org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:846) javax.servlet.http.HttpServlet.service(HttpServlet.java:742) org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:197) org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)
Note The full stack trace of the root cause is available in the server logs.