org.springframework.transaction.TransactionSystemException

Could not roll back JDBC transaction; nested exception is org.postgresql.util.PSQLException: This connection has been closed.

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web70

Stack trace

  • org.springframework.transaction.TransactionSystemException: Could not roll back JDBC transaction; nested exception is org.postgresql.util.PSQLException: This connection has been closed. at org.springframework.jdbc.datasource.DataSourceTransactionManager.doRollback(DataSourceTransactionManager.java:286)[spring-jdbc-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:846)[spring-tx-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:823)[spring-tx-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:493)[spring-tx-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:264)[spring-tx-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)[spring-tx-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)[spring-aop-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)[spring-aop-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)[spring-aop-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:634)[spring-aop-3.2.6.RELEASE.jar:3.2.6.RELEASE] at com.rb.front.service.impl.ShoppingServiceImpl$$EnhancerByCGLIB$$33c59a75.getShoppingListInfo(<generated>)[spring-core-3.2.6.RELEASE.jar:na] at com.rb.front.controller.ShoppingController.sortList(ShoppingController.java:90)[classes:na] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.7.0_65] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)[na:1.7.0_65] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.7.0_65] at java.lang.reflect.Method.invoke(Method.java:606)[na:1.7.0_65] at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)[spring-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)[spring-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)[spring-webmvc-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)[spring-webmvc-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686)[spring-webmvc-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)[spring-webmvc-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)[spring-webmvc-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)[spring-webmvc-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)[spring-webmvc-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:827)[spring-webmvc-3.2.6.RELEASE.jar:3.2.6.RELEASE] at javax.servlet.http.HttpServlet.service(HttpServlet.java:734)[jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-2.jar!/:1.0.2.Final-redhat-2] at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)[spring-webmvc-3.2.6.RELEASE.jar:3.2.6.RELEASE] at javax.servlet.http.HttpServlet.service(HttpServlet.java:847)[jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-2.jar!/:1.0.2.Final-redhat-2] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1] at com.rb.front.core.web.filter.SitePreferenceFilter.doFilter(SitePreferenceFilter.java:63)[classes:na] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:139)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:85)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)[spring-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)[spring-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.session.ConcurrentSessionFilter.doFilter(ConcurrentSessionFilter.java:125)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)[spring-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)[spring-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1] at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)[spring-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)[spring-web-3.2.6.RELEASE.jar:3.2.6.RELEASE] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1] at org.jboss.as.web.session.ClusteredSessionValve.handleRequest(ClusteredSessionValve.java:134)[jboss-as-web-7.5.5.Final-redhat-3.jar!/:7.5.5.Final-redhat-3] at org.jboss.as.web.session.ClusteredSessionValve.invoke(ClusteredSessionValve.java:99)[jboss-as-web-7.5.5.Final-redhat-3.jar!/:7.5.5.Final-redhat-3] at org.jboss.as.web.session.JvmRouteValve.invoke(JvmRouteValve.java:92)[jboss-as-web-7.5.5.Final-redhat-3.jar!/:7.5.5.Final-redhat-3] at org.jboss.as.web.session.LockingValve.invoke(LockingValve.java:64)[jboss-as-web-7.5.5.Final-redhat-3.jar!/:7.5.5.Final-redhat-3] at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169)[jboss-as-web-7.5.5.Final-redhat-3.jar!/:7.5.5.Final-redhat-3] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:150)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1] at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1] at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1] at org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:490)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1] at org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:420)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1] at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1] at java.lang.Thread.run(Thread.java:745)[na:1.7.0_65] Caused by: org.postgresql.util.PSQLException: This connection has been closed. at org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:837)[postgresql-9.3-1101-jdbc4.jar:na] at org.postgresql.jdbc2.AbstractJdbc2Connection.setReadOnly(AbstractJdbc2Connection.java:733)[postgresql-9.3-1101-jdbc4.jar:na] at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkState(BaseWrapperManagedConnection.java:943)[na:na] at org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:929)[na:na] at org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1633)[na:na] at org.jboss.jca.adapters.jdbc.WrappedConnection.rollback(WrappedConnection.java:780)[na:na] at org.springframework.jdbc.datasource.DataSourceTransactionManager.doRollback(DataSourceTransactionManager.java:283)[spring-jdbc-3.2.6.RELEASE.jar:3.2.6.RELEASE] ... 88 more

Write tip

You have a different solution? A short tip here would help you and many other users who saw this issue last week.

Users with the same issue

nasimknasimk
4 times, last one
Unknown visitor
Unknown visitorOnce,
MalcshourMalcshour
Once,
Unknown visitor
Unknown visitorOnce,
Unknown visitor
Unknown visitorOnce,
7 more bugmates