mysqlspringspringmvc
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: could 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.execsql(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.datasourceutils.prepareconnectionfortransaction(datasourceutils.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.abstracthttp11processor.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)
数据库链接配置如下：
程序第二天总会报这样的错．．重启tomcat就ＯＫ了．．求大神指点．．
