org.springframework.dao.RecoverableDataAccessException: StatementCallback; SQL [SELECT user_num,user_id,user_name,user_email,recom_id ,DATE_FORMAT(update_date, "%Y%m%d%H%i%s") update_date ,DATE_FORMAT(create_date, "%Y%m%d%H%i%s") create_date FROM user_info where user_num ='01094221111']; The last packet successfully received from the server was 496,986,673 milliseconds ago. The last packet sent successfully to the server was 497,037,321 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 496,986,673 milliseconds ago. The last packet sent successfully to the server was 497,037,321 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.

GitHub | JHHJYJ | 2 months ago
  1. 0

    사용자 등록시

    GitHub | 2 months ago | JHHJYJ
    org.springframework.dao.RecoverableDataAccessException: StatementCallback; SQL [SELECT user_num,user_id,user_name,user_email,recom_id ,DATE_FORMAT(update_date, "%Y%m%d%H%i%s") update_date ,DATE_FORMAT(create_date, "%Y%m%d%H%i%s") create_date FROM user_info where user_num ='01094221111']; The last packet successfully received from the server was 496,986,673 milliseconds ago. The last packet sent successfully to the server was 497,037,321 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.; nested exception is com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 496,986,673 milliseconds ago. The last packet sent successfully to the server was 497,037,321 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
  2. 0

    MySQL-Register Reloaded - Bukkit

    bukkit.org | 8 months ago
    com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.Connection was implicitly closed by the driver.
  3. 0

    GitHub comment 18#31208214

    GitHub | 3 years ago | linusgjersvold
    com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 38,430,053 milliseconds ago. The last packet sent successfully to the server was 38,430,053 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Sporadic ConnectException shuts down the whole connect process

    Google Groups | 1 month ago | Sagar Rao
    com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 1,855 milliseconds ago. The last packet sent successfully to the server was 557 milliseconds ago.
  6. 0

    Sporadic ConnectException leads to non processing of table data

    GitHub | 1 month ago | vamossagar12
    com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure The last packet successfully received from the server was 1,855 milliseconds ago. The last packet sent successfully to the server was 557 milliseconds ago.

  1. kuldeep 4 times, last 2 months ago
  2. esaar 1 times, last 4 months ago
  3. mauritius 2 times, last 9 months ago
16 unregistered visitors
Not finding the right solution?
Take a tour to get the most out of Samebug.

Tired of useless tips?

Automated exception search integrated into your IDE

Root Cause Analysis

  1. java.net.SocketException

    Broken pipe

    at java.net.SocketOutputStream.socketWrite0()
  2. Java RT
    BufferedOutputStream.flush
    1. java.net.SocketOutputStream.socketWrite0(Native Method)
    2. java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:113)
    3. java.net.SocketOutputStream.write(SocketOutputStream.java:159)
    4. java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:82)
    5. java.io.BufferedOutputStream.flush(BufferedOutputStream.java:140)
    5 frames
  3. MySQL jdbc
    StatementImpl.executeQuery
    1. com.mysql.jdbc.MysqlIO.send(MysqlIO.java:3964)
    2. com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2596)
    3. com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2776)
    4. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2832)
    5. com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2781)
    6. com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1569)
    6 frames
  4. Spring Framework
    JdbcTemplate.query
    1. org.springframework.jdbc.core.JdbcTemplate$1QueryStatementCallback.doInStatement(JdbcTemplate.java:452)
    2. org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:402)
    3. org.springframework.jdbc.core.JdbcTemplate.query(JdbcTemplate.java:468)
    3 frames
  5. com.eclues.ringcatcher
    JSONController.registerUser
    1. com.eclues.ringcatcher.dao.UserInfoDAOImpl.get(UserInfoDAOImpl.java:87)
    2. com.eclues.ringcatcher.ctrl.JSONController.registerUser(JSONController.java:170)
    2 frames
  6. Java RT
    Method.invoke
    1. sun.reflect.GeneratedMethodAccessor161.invoke(Unknown Source)
    2. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
    3. java.lang.reflect.Method.invoke(Method.java:606)
    3 frames
  7. Spring
    InvocableHandlerMethod.invokeForRequest
    1. org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:215)
    2. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)
    2 frames
  8. Spring MVC
    FrameworkServlet.doPost
    1. org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)
    2. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:749)
    3. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:689)
    4. org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:83)
    5. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:938)
    6. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:870)
    7. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:961)
    8. org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:863)
    8 frames
  9. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:646)
    1 frame
  10. Spring MVC
    FrameworkServlet.service
    1. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:837)
    1 frame
  11. JavaServlet
    HttpServlet.service
    1. javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
    1 frame
  12. Glassfish Core
    CoyoteAdapter.service
    1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:303)
    2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:208)
    3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:220)
    4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:122)
    5. org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:501)
    6. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:170)
    7. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
    8. org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:950)
    9. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:116)
    10. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:408)
    10 frames
  13. Grizzly HTTP
    JIoEndpoint$SocketProcessor.run
    1. org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1041)
    2. org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:607)
    3. org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:313)
    3 frames
  14. Java RT
    Thread.run
    1. java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    2. java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    3. java.lang.Thread.run(Thread.java:745)
    3 frames