Protocol: 27: 41.925 SEVERE [http-apr-8099-exec-12] org. apache. catalina. core. protocol. invokeServlet. service () forservlet [SpringWebController] incontextwithpath [] threwexception [Protocol; nestedexceptioni... mysqlspringmvc
26-Aug-2015 08:27:41. 925 SEVERE [http-apr-8099-exec-12] org. apache. catalina. core. standardWrapperValve. invoke Servlet. service () for servlet [SpringWebController] in context with path [] threw exception [Request processing failed; nested exception is org. springframework. transaction. cannotCreateTransactionException: cocould not open JDBC Connection for transaction; nested exception is com. mysql. jdbc. exceptions. jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.] with root cause
Java.net. SocketException: Software caused connection abort: socket write error
At java.net. SocketOutputStream. socketWrite0 (Native Method)
At java.net. SocketOutputStream. socketWrite (SocketOutputStream. java: 113)
At java.net. SocketOutputStream. write (SocketOutputStream. java: 159)
At java. io. BufferedOutputStream. flushBuffer (BufferedOutputStream. java: 82)
At java. io. BufferedOutputStream. flush (BufferedOutputStream. java: 140)
At com. mysql. jdbc. MysqlIO. send (MysqlIO. java: 3852)
At com. mysql. jdbc. MysqlIO. sendCommand (MysqlIO. java: 2484)
At com. mysql. jdbc. MysqlIO. sqlQueryDirect (MysqlIO. java: 2664)
At com.mysql.jdbc.ConnectionImpl.exe cSQL (ConnectionImpl. java: 2809)
At com. mysql. jdbc. ConnectionImpl. setReadOnlyInternal (ConnectionImpl. java: 5484)
At com. mysql. jdbc. ConnectionImpl. setReadOnly (ConnectionImpl. java: 5477)
At sun. reflect. GeneratedMethodAccessor145.invoke (Unknown Source)
At sun. reflect. DelegatingMethodAccessorImpl. invoke (DelegatingMethodAccessorImpl. java: 43)
At java. lang. reflect. Method. invoke (Method. java: 606)
At org. apache. tomcat. jdbc. pool. ProxyConnection. invoke (ProxyConnection. java: 126)
At org. apache. tomcat. jdbc. pool. JdbcInterceptor. invoke (JdbcInterceptor. java: 109)
At org. apache. tomcat. jdbc. pool. DisposableConnectionFacade. invoke (DisposableConnectionFacade. java: 80)
At com. sun. proxy. $ Proxy56.setReadOnly (Unknown Source)
At org. springframework. jdbc. datasource. performanceutils. prepareConnectionForTransaction (performanceutils. java: 155)
At org. springframework. jdbc. datasource. DataSourceTransactionManager. doBegin (DataSourceTransactionManager. java: 214)
At org. springframework. transaction. support. AbstractPlatformTransactionManager. getTransaction (AbstractPlatformTransactionManager. java: 373)
At org. springframework. transaction. interceptor. TransactionAspectSupport. createTransactionIfNecessary (TransactionAspectSupport. java: 457)
At org. springframework. transaction. interceptor. TransactionAspectSupport. invokeWithinTransaction (TransactionAspectSupport. java: 276)
At org. springframework. transaction. interceptor. TransactionInterceptor. invoke (TransactionInterceptor. java: 96)
At org. springframework. aop. framework. ReflectiveMethodInvocation. proceed (ReflectiveMethodInvocation. java: 179)
At org. springframework. aop. interceptor. ExposeInvocationInterceptor. invoke (ExposeInvocationInterceptor. java: 92)
At org. springframework. aop. framework. ReflectiveMethodInvocation. proceed (ReflectiveMethodInvocation. java: 179)
At org. springframework. aop. framework. CglibAopProxy $ DynamicAdvisedInterceptor. intercept (CglibAopProxy. java: 653)
At com. a30.endnote. systemic. service. ParametersService $ EnhancerBySpringCGLIB $ a0be71ae. findParameterlist ()
At com. a30.endnote. systemic. controller. IndexController. handleRequestInternal (IndexController. java: 83)
At sun. reflect. NativeMethodAccessorImpl. invoke0 (Native Method)
At sun. reflect. NativeMethodAccessorImpl. invoke (NativeMethodAccessorImpl. java: 57)
At sun. reflect. DelegatingMethodAccessorImpl. invoke (DelegatingMethodAccessorImpl. java: 43)
At java. lang. reflect. Method. invoke (Method. java: 606)
At org. springframework. web. method. support. InvocableHandlerMethod. doInvoke (InvocableHandlerMethod. java: 221)
At org. springframework. web. method. support. InvocableHandlerMethod. invokeForRequest (InvocableHandlerMethod. java: 137)
At org. springframework. web. servlet. mvc. method. annotation. ServletInvocableHandlerMethod. invokeAndHandle (ServletInvocableHandlerMethod. java: 110)
At org. springframework. web. servlet. mvc. method. annotation. RequestMappingHandlerAdapter. invokeHandleMethod (RequestMappingHandlerAdapter. java: 777)
At org. springframework. web. servlet. mvc. method. annotation. RequestMappingHandlerAdapter. handleInternal (RequestMappingHandlerAdapter. java: 706)
At org. springframework. web. servlet. mvc. method. AbstractHandlerMethodAdapter. handle (AbstractHandlerMethodAdapter. java: 85)
At org. springframework. web. servlet. DispatcherServlet. doDispatch (DispatcherServlet. java: 943)
At org. springframework. web. servlet. DispatcherServlet. doService (DispatcherServlet. java: 877)
At org. springframework. web. servlet. FrameworkServlet. processRequest (FrameworkServlet. java: 966)
At org. springframework. web. servlet. FrameworkServlet. doGet (FrameworkServlet. java: 857)
At javax. servlet. http. HttpServlet. service (HttpServlet. java: 618)
At org. springframework. web. servlet. FrameworkServlet. service (FrameworkServlet. java: 842)
At javax. servlet. http. HttpServlet. service (HttpServlet. java: 725)
At org. apache. catalina. core. ApplicationFilterChain. internalDoFilter (ApplicationFilterChain. java: 291)
At org. apache. catalina. core. ApplicationFilterChain. doFilter (ApplicationFilterChain. java: 206)
At org. apache. tomcat. websocket. server. WsFilter. doFilter (WsFilter. java: 52)
At org. apache. catalina. core. ApplicationFilterChain. internalDoFilter (ApplicationFilterChain. java: 239)
At org. apache. catalina. core. ApplicationFilterChain. doFilter (ApplicationFilterChain. java: 206)
At org. springframework. web. filter. CharacterEncodingFilter. doFilterInternal (CharacterEncodingFilter. java: 88)
At org. springframework. web. filter. OncePerRequestFilter. doFilter (OncePerRequestFilter. java: 107)
At org. apache. catalina. core. ApplicationFilterChain. internalDoFilter (ApplicationFilterChain. java: 239)
At org. apache. catalina. core. ApplicationFilterChain. doFilter (ApplicationFilterChain. java: 206)
At org. apache. catalina. core. StandardWrapperValve. invoke (StandardWrapperValve. java: 219)
At org. apache. catalina. core. StandardContextValve. invoke (StandardContextValve. java: 106)
At org. apache. catalina. authenticator. AuthenticatorBase. invoke (AuthenticatorBase. java: 501)
At org. apache. catalina. core. StandardHostValve. invoke (StandardHostValve. java: 142)
At org. apache. catalina. valves. ErrorReportValve. invoke (ErrorReportValve. java: 79)
At org. apache. catalina. valves. AbstractAccessLogValve. invoke (AbstractAccessLogValve. java: 610)
At org. apache. catalina. core. StandardEngineValve. invoke (StandardEngineValve. java: 88)
At org. apache. catalina. connector. CoyoteAdapter. service (CoyoteAdapter. java: 516)
At org. apache. coyote. http11.20.acthttp11processor. process (AbstractHttp11Processor. java: 1086)
At org. apache. coyote. AbstractProtocol $ AbstractConnectionHandler. process (AbstractProtocol. java: 659)
At org. apache. coyote. http11.Http11AprProtocol $ Http11ConnectionHandler. process (Http11AprProtocol. java: 285)
At org.apache.tomcat.util.net. AprEndpoint $ SocketProcessor. doRun (AprEndpoint. java: 2439)
At org.apache.tomcat.util.net. AprEndpoint $ SocketProcessor. run (AprEndpoint. java: 2428)
At java. util. concurrent. ThreadPoolExecutor. runWorker (ThreadPoolExecutor. java: 1145)
At java. util. concurrent. ThreadPoolExecutor $ Worker. run (ThreadPoolExecutor. java: 615)
At org. apache. tomcat. util. threads. TaskThread $ WrappingRunnable. run (TaskThread. java: 61)
At java. lang. Thread. run (Thread. java: 745)
The database link configuration is as follows:
The program will always report such an error the next day. restart tomcat and you will be OK ..