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

Google Groups | 황진식 | 12 months ago
  1. 0

    spring + jboss datasource 설정 문의 드립니다.

    Google Groups | 12 months ago | 황진식
    org.springframework.transaction.TransactionSystemException: Could not roll back JDBC transaction; nested exception is org.postgresql.util.PSQLException: This connection has been closed.
  2. 0

    Occurred SQLException at Connection#setReadOnly(true)

    GitHub | 2 years ago | btshimizukza
    org.postgresql.util.PSQLException: Cannot change transaction read-only property in the middle of a transaction.
  3. 0

    Playframework 2.1/Ebean error doing insert to pgsql : Cannot change transaction read-only property in the middle of a transaction

    Stack Overflow | 3 years ago | Maxime A
    org.postgresql.util.PSQLException: Cannot change transaction read-only property in the middle of a transaction.
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Transactional evolutions in Play

    Stack Overflow | 3 years ago | Alexander Zolotko
    org.postgresql.util.PSQLException: Cannot change transaction read-only property in the middle of a transaction.
  6. 0

    PostgreSQL archive reader exception

    GitHub | 9 months ago | jbobnar
    org.postgresql.util.PSQLException: Cannot change transaction read-only property in the middle of a transaction.

    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. org.postgresql.util.PSQLException

      This connection has been closed.

      at org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed()
    2. PostgreSQL JDBC Driver
      AbstractJdbc2Connection.setReadOnly
      1. org.postgresql.jdbc2.AbstractJdbc2Connection.checkClosed(AbstractJdbc2Connection.java:837)[postgresql-9.3-1101-jdbc4.jar:na]
      2. org.postgresql.jdbc2.AbstractJdbc2Connection.setReadOnly(AbstractJdbc2Connection.java:733)[postgresql-9.3-1101-jdbc4.jar:na]
      2 frames
    3. IronJacamar
      WrappedConnection.rollback
      1. org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkState(BaseWrapperManagedConnection.java:943)[na:na]
      2. org.jboss.jca.adapters.jdbc.BaseWrapperManagedConnection.checkTransaction(BaseWrapperManagedConnection.java:929)[na:na]
      3. org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1633)[na:na]
      4. org.jboss.jca.adapters.jdbc.WrappedConnection.rollback(WrappedConnection.java:780)[na:na]
      4 frames
    4. Spring Framework
      DataSourceTransactionManager.doRollback
      1. org.springframework.jdbc.datasource.DataSourceTransactionManager.doRollback(DataSourceTransactionManager.java:283)[spring-jdbc-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      1 frame
    5. Spring Tx
      TransactionInterceptor.invoke
      1. org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:846)[spring-tx-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      2. org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:823)[spring-tx-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      3. org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:493)[spring-tx-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      4. org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:264)[spring-tx-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      5. org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:94)[spring-tx-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      5 frames
    6. Spring AOP
      CglibAopProxy$DynamicAdvisedInterceptor.intercept
      1. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)[spring-aop-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      2. org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:91)[spring-aop-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      3. org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172)[spring-aop-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      4. org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:634)[spring-aop-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      4 frames
    7. com.rb.front
      ShoppingController.sortList
      1. com.rb.front.service.impl.ShoppingServiceImpl$$EnhancerByCGLIB$$33c59a75.getShoppingListInfo(<generated>)[spring-core-3.2.6.RELEASE.jar:na]
      2. com.rb.front.controller.ShoppingController.sortList(ShoppingController.java:90)[classes:na]
      2 frames
    8. Java RT
      Method.invoke
      1. sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)[na:1.7.0_65]
      2. sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)[na:1.7.0_65]
      3. sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)[na:1.7.0_65]
      4. java.lang.reflect.Method.invoke(Method.java:606)[na:1.7.0_65]
      4 frames
    9. Spring
      InvocableHandlerMethod.invokeForRequest
      1. org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:219)[spring-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      2. org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:132)[spring-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      2 frames
    10. Spring MVC
      FrameworkServlet.doGet
      1. org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:104)[spring-webmvc-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      2. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandleMethod(RequestMappingHandlerAdapter.java:745)[spring-webmvc-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      3. org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:686)[spring-webmvc-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      4. org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)[spring-webmvc-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      5. org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:925)[spring-webmvc-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      6. org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:856)[spring-webmvc-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      7. org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:936)[spring-webmvc-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      8. org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:827)[spring-webmvc-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      8 frames
    11. JavaServlet
      HttpServlet.service
      1. 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]
      1 frame
    12. Spring MVC
      FrameworkServlet.service
      1. org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:812)[spring-webmvc-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      1 frame
    13. JavaServlet
      HttpServlet.service
      1. 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]
      1 frame
    14. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1]
      2 frames
    15. com.rb.front
      SitePreferenceFilter.doFilter
      1. com.rb.front.core.web.filter.SitePreferenceFilter.doFilter(SitePreferenceFilter.java:63)[classes:na]
      1 frame
    16. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1]
      2 frames
    17. Spring Security
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      2. org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      3. org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      4. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      5. org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      6. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      7. org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      8. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      9. org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      10. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      11. org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:139)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      12. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      13. org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:154)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      14. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      15. org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      16. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      17. org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:199)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      18. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      19. org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:110)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      20. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      20 frames
    18. org.springframework.security
      CsrfFilter.doFilterInternal
      1. org.springframework.security.web.csrf.CsrfFilter.doFilterInternal(CsrfFilter.java:85)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      1 frame
    19. Spring
      OncePerRequestFilter.doFilter
      1. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)[spring-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      1 frame
    20. Spring Security
      FilterChainProxy$VirtualFilterChain.doFilter
      1. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      1 frame
    21. org.springframework.security
      WebAsyncManagerIntegrationFilter.doFilterInternal
      1. org.springframework.security.web.context.request.async.WebAsyncManagerIntegrationFilter.doFilterInternal(WebAsyncManagerIntegrationFilter.java:50)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      1 frame
    22. Spring
      OncePerRequestFilter.doFilter
      1. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)[spring-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      1 frame
    23. Spring Security
      FilterChainProxy.doFilter
      1. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      2. org.springframework.security.web.session.ConcurrentSessionFilter.doFilter(ConcurrentSessionFilter.java:125)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      3. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      4. org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      5. org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      6. org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      7. org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160)[spring-security-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      7 frames
    24. Spring
      DelegatingFilterProxy.doFilter
      1. org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:343)[spring-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      2. org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:260)[spring-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      2 frames
    25. Glassfish Core
      ApplicationFilterChain.doFilter
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1]
      2 frames
    26. Spring
      OncePerRequestFilter.doFilter
      1. org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)[spring-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      2. org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:107)[spring-web-3.2.6.RELEASE.jar:3.2.6.RELEASE]
      2 frames
    27. Glassfish Core
      StandardContextValve.invoke
      1. org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1]
      2. org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1]
      3. org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1]
      4. org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1]
      4 frames
    28. JBoss Web
      SecurityContextAssociationValve.invoke
      1. 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]
      2. 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]
      3. 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]
      4. 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]
      5. 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]
      5 frames
    29. Glassfish Core
      CoyoteAdapter.service
      1. org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:150)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1]
      2. org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1]
      3. org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1]
      4. org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1]
      4 frames
    30. org.apache.coyote
      AjpProtocol$AjpConnectionHandler.process
      1. org.apache.coyote.ajp.AjpProcessor.process(AjpProcessor.java:490)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1]
      2. org.apache.coyote.ajp.AjpProtocol$AjpConnectionHandler.process(AjpProtocol.java:420)[jbossweb-7.5.12.Final-redhat-1.jar!/:7.5.12.Final-redhat-1]
      2 frames
    31. Grizzly HTTP
      JIoEndpoint$Worker.run
      1. 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]
      1 frame
    32. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:745)[na:1.7.0_65]
      1 frame