8 Replies Latest reply on Apr 1, 2015 2:18 AM by mariaprabudass Edwin

    transaction is not active

    Stephan Pabinger Newbie

      Hi,

      I'm using envers 1.2.2, hibernate 3.2.2, seam 2.2.0 on a JBoss 4.2.3.

      I have a problem when retrieving some of my entities. The structure looks something like this:

      E1 - onetomany - E2 - manytoone - E3
       E2 - manytoone - E4
       - onetomany - E5 ....


      When I try to fetch a large number of entities and most of its relations (there is no other way to do it) I get an IllegalStateException when using envers.
      Fetching these entities without envers (just hibernate using eager fetch) the query is much faster (clear to me) and does not throw an exception.

      Does anybody know how I can somehow tweak the performance or what settings I need to apply in order to get rid of the IllegalStateException exception?


      Best regards
      Stephan

      Stacktrace:
      Caused by: java.sql.SQLException: Connection handle has been closed and is unusable
       at org.jboss.resource.adapter.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:845)
       at org.jboss.resource.adapter.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:825)
       at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:240)
       at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:534)
       at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:452)
       at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:161)
       at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1577)
       at org.hibernate.loader.Loader.doQuery(Loader.java:696)
       at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
       at org.hibernate.loader.Loader.loadEntity(Loader.java:1885)
       ... 165 more
      14:54:02,998 WARN [arjLoggerI18N] [com.arjuna.ats.arjuna.coordinator.BasicAction_40] - Abort called on already aborted atomic action 7f000001:90af:4b13cac0:7f
      14:54:02,998 WARN [SeamPhaseListener] uncaught exception, passing to exception handler
      java.lang.IllegalStateException: Could not commit transaction
       at org.jboss.seam.jsf.SeamPhaseListener.commitOrRollback(SeamPhaseListener.java:625)
       at org.jboss.seam.jsf.SeamPhaseListener.commitOrRollback(SeamPhaseListener.java:604)
       at org.jboss.seam.jsf.SeamPhaseListener.handleTransactionsAfterPhase(SeamPhaseListener.java:345)
       at org.jboss.seam.jsf.SeamPhaseListener.afterServletPhase(SeamPhaseListener.java:245)
       at org.jboss.seam.jsf.SeamPhaseListener.afterPhase(SeamPhaseListener.java:196)
       at com.sun.faces.lifecycle.Phase.handleAfterPhase(Phase.java:175)
       at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:114)
       at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
       at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
       at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:530)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
       at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
       at org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:40)
       at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
       at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:90)
       at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
       at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
       at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
       at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
       at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
       at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:73)
       at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:178)
       at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290)
       at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:388)
       at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:515)
       at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:56)
       at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
       at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:60)
       at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
       at org.jboss.seam.web.HotDeployFilter.doFilter(HotDeployFilter.java:53)
       at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
       at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
       at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
       at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
       at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
       at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
       at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
       at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
       at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
       at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
       at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
       at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
       at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
       at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
       at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
       at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
       at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
       at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
       at java.lang.Thread.run(Thread.java:619)
      Caused by: java.lang.IllegalStateException: [com.arjuna.ats.internal.jta.transaction.arjunacore.inactive] [com.arjuna.ats.internal.jta.transaction.arjunacore.inactive] The transaction is not active!
       at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.rollbackAndDisassociate(TransactionImple.java:1473)
       at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.rollback(BaseTransaction.java:163)
       at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.rollback(BaseTransactionManagerDelegate.java:126)
       at org.jboss.tm.usertx.client.ServerVMClientUserTransaction.rollback(ServerVMClientUserTransaction.java:148)
       at org.jboss.seam.transaction.UTTransaction.rollback(UTTransaction.java:66)
       at org.jboss.seam.jsf.SeamPhaseListener.commitOrRollback(SeamPhaseListener.java:621)
       ... 53 more
      


        • 1. Re: transaction is not active
          Adam Warski Master

          Hello,

          so this only happens when you load a large number of objects? Maybe there's an exception earlier explaining what's happening?

          Adam

          • 2. Re: transaction is not active
            Stephan Pabinger Newbie

            Hi Adam,

            thanks for the reply.

            Well, I don't think it has something to do with the amount of loaded objects but more with the time the loading takes.
            I've already turned down my log level to trace but wasn't able to find the reason of the exception.

            Do you know if I need to tune some kind of timeout (transaction, ...)?

            Thanks for your help
            Stephan

            I've included the beginning of the stacktrace:

            14:00:10,206 ERROR [STDERR] 379896 [Thread-3] INFO org.hibernate.jdbc.ConnectionManager - forcing batcher resource cleanup on transaction completion; forgot to close ScrollableResults/Iterator?
            14:00:10,299 INFO [STDOUT] Hibernate: select ...
            14:00:10,300 INFO [STDOUT] Hibernate: select ...
            14:00:10,302 INFO [STDOUT] Hibernate: select ...
            14:00:10,310 INFO [STDOUT] Hibernate: select ...
            14:00:10,315 INFO [STDOUT] Hibernate: select ...
            14:00:10,989 INFO [STDOUT] Hibernate: select ...
            14:00:10,990 INFO [STDOUT] Hibernate: select ...
            14:00:11,008 INFO [STDOUT] Hibernate: select ...
            14:00:11,008 ERROR [STDERR] 380698 [Thread-3] WARN org.hibernate.jdbc.AbstractBatcher - exception clearing maxRows/queryTimeout
            14:00:11,012 ERROR [STDERR] java.sql.SQLException: The statement is closed.
            14:00:11,012 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedStatement.checkState(WrappedStatement.java:888)
            14:00:11,012 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrappedStatement.getMaxRows(WrappedStatement.java:375)
            14:00:11,012 INFO [STDOUT] Hibernate: select ...
            14:00:11,012 ERROR [STDERR] at org.hibernate.jdbc.AbstractBatcher.closeQueryStatement(AbstractBatcher.java:298)
            14:00:11,019 ERROR [STDERR] at org.hibernate.jdbc.AbstractBatcher.closeStatements(AbstractBatcher.java:369)
            14:00:11,019 ERROR [STDERR] at org.hibernate.jdbc.ConnectionManager.afterTransaction(ConnectionManager.java:320)
            14:00:11,019 ERROR [STDERR] at org.hibernate.jdbc.JDBCContext.afterTransactionCompletion(JDBCContext.java:248)
            14:00:11,019 ERROR [STDERR] at org.hibernate.transaction.CacheSynchronization.afterCompletion(CacheSynchronization.java:117)
            14:00:11,019 ERROR [STDERR] at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.afterCompletion(SynchronizationImple.java:136)
            14:00:11,019 ERROR [STDERR] at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.afterCompletion(TwoPhaseCoordinator.java:340)
            14:00:11,019 ERROR [STDERR] at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.cancel(TwoPhaseCoordinator.java:107)
            14:00:11,020 ERROR [STDERR] at com.arjuna.ats.arjuna.AtomicAction.cancel(AtomicAction.java:230)
            14:00:11,020 ERROR [STDERR] at com.arjuna.ats.arjuna.coordinator.TransactionReaper.check(TransactionReaper.java:202)
            14:00:11,020 ERROR [STDERR] at com.arjuna.ats.internal.arjuna.coordinator.ReaperThread.run(ReaperThread.java:107)
            14:00:11,020 INFO [STDOUT] Hibernate: select ...
            14:00:11,028 INFO [STDOUT] Hibernate: select ...
            14:00:11,029 INFO [STDOUT] Hibernate: select ...
            14:00:11,031 INFO [STDOUT] Hibernate: select ...
            14:00:11,032 INFO [STDOUT] Hibernate: select ...
            14:00:11,055 ERROR [STDERR] 380745 [http-0.0.0.0-8080-5] INFO org.hibernate.type.LongType - could not read column value from result set: col_1_0_; The result set is closed.
            14:00:11,113 ERROR [STDERR] 380803 [http-0.0.0.0-8080-5] WARN org.hibernate.util.JDBCExceptionReporter - SQL Error: 0, SQLState: null
            14:00:11,113 ERROR [STDERR] 380803 [http-0.0.0.0-8080-5] ERROR org.hibernate.util.JDBCExceptionReporter - The result set is closed.
            14:00:11,134 ERROR [application] org.hibernate.exception.GenericJDBCException: could not execute query
            javax.faces.el.EvaluationException: org.hibernate.exception.GenericJDBCException: could not execute query
             at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:102)
             at com.sun.faces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:102)
             at javax.faces.component.UICommand.broadcast(UICommand.java:387)
             at org.ajax4jsf.component.AjaxActionComponent.broadcast(AjaxActionComponent.java:55)
             at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:324)
             at org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:299)
             at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:256)
             at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:469)
             at com.sun.faces.lifecycle.InvokeApplicationPhase.execute(InvokeApplicationPhase.java:82)
             at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
             at com.sun.faces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:118)
             at javax.faces.webapp.FacesServlet.service(FacesServlet.java:265)
             at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
             at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
             at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:530)
             at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
             at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
             at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
             at org.jboss.seam.web.IdentityFilter.doFilter(IdentityFilter.java:40)
             at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
             at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:90)
             at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
             at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
             at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
             at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
             at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
             at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:73)
             at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:178)
             at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290)
             at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:388)
             at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:515)
             at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:56)
             at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
             at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:60)
             at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
             at org.jboss.seam.web.HotDeployFilter.doFilter(HotDeployFilter.java:53)
             at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
             at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158)
             at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
             at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
             at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
             at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
             at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
             at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
             at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
             at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:182)
             at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
             at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
             at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
             at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
             at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
             at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
             at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
             at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
             at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
             at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
             at java.lang.Thread.run(Thread.java:619)
            Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
             at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:126)
             at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:114)
             at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
             at org.hibernate.loader.Loader.doList(Loader.java:2235)
             at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2129)
             at org.hibernate.loader.Loader.list(Loader.java:2124)
             at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:401)
             at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:363)
             at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:196)
             at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1149)
             at org.hibernate.impl.QueryImpl.list(QueryImpl.java:102)
             at org.hibernate.envers.entities.mapper.relation.lazy.initializor.AbstractCollectionInitializor.initialize(AbstractCollectionInitializor.java:62)
             at org.hibernate.envers.entities.mapper.relation.lazy.proxy.CollectionProxy.checkInit(CollectionProxy.java:47)
             at org.hibernate.envers.entities.mapper.relation.lazy.proxy.CollectionProxy.iterator(CollectionProxy.java:67)
             at at.tugraz.genome.memosys.reaction.entity.Reaction.getAllGenes(Reaction.java:587)
             at at.tugraz.genome.memosys.session.model.comparison.task.simple.SimpleModelComparison.compareGenes(SimpleModelComparison.java:289)
             at at.tugraz.genome.memosys.session.model.comparison.task.simple.SimpleModelComparison.compareModels(SimpleModelComparison.java:141)
             at at.tugraz.genome.memosys.session.model.comparison.CompareModels.compare(CompareModels.java:97)
             at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
             at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
             at java.lang.reflect.Method.invoke(Method.java:597)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
             at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
             at org.jboss.seam.intercept.EJBInvocationContext.proceed(EJBInvocationContext.java:44)
             at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
             at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28)
             at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
             at org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:77)
             at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
             at org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44)
             at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
             at org.jboss.seam.persistence.EntityManagerProxyInterceptor.aroundInvoke(EntityManagerProxyInterceptor.java:29)
             at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
             at org.jboss.seam.persistence.HibernateSessionProxyInterceptor.aroundInvoke(HibernateSessionProxyInterceptor.java:30)
             at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
             at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
             at org.jboss.seam.intercept.SessionBeanInterceptor.aroundInvoke(SessionBeanInterceptor.java:50)
             at sun.reflect.GeneratedMethodAccessor248.invoke(Unknown Source)
             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
             at java.lang.reflect.Method.invoke(Method.java:597)
             at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:118)
             at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
             at org.jboss.ejb3.entity.ExtendedPersistenceContextPropagationInterceptor.invoke(ExtendedPersistenceContextPropagationInterceptor.java:57)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
             at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
             at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
             at org.jboss.aspects.tx.TxPolicy.invokeInNoTx(TxPolicy.java:66)
             at org.jboss.aspects.tx.TxInterceptor$NotSupported.invoke(TxInterceptor.java:102)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
             at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:95)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
             at org.jboss.ejb3.stateful.StatefulInstanceInterceptor.invoke(StatefulInstanceInterceptor.java:83)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
             at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)
             at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:110)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
             at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:46)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
             at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
             at org.jboss.ejb3.stateful.StatefulContainer.localInvoke(StatefulContainer.java:206)
             at org.jboss.ejb3.stateful.StatefulLocalProxy.invoke(StatefulLocalProxy.java:119)
             at $Proxy127.compare(Unknown Source)
             at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
             at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
             at java.lang.reflect.Method.invoke(Method.java:597)
             at org.jboss.seam.util.Reflections.invoke(Reflections.java:22)
             at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:32)
             at org.jboss.seam.intercept.ClientSideInterceptor$1.proceed(ClientSideInterceptor.java:76)
             at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
             at org.jboss.seam.ejb.RemoveInterceptor.aroundInvoke(RemoveInterceptor.java:43)
             at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
             at org.jboss.seam.core.SynchronizationInterceptor.aroundInvoke(SynchronizationInterceptor.java:32)
             at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
             at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
             at org.jboss.seam.intercept.ClientSideInterceptor.invoke(ClientSideInterceptor.java:54)
             at org.javassist.tmp.java.lang.Object_$$_javassist_seam_6.compare(Object_$$_javassist_seam_6.java)
             at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
             at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
             at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
             at java.lang.reflect.Method.invoke(Method.java:597)
             at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:335)
             at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:348)
             at org.jboss.el.parser.AstPropertySuffix.invoke(AstPropertySuffix.java:58)
             at org.jboss.el.parser.AstValue.invoke(AstValue.java:96)
             at org.jboss.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
             at com.sun.facelets.el.TagMethodExpression.invoke(TagMethodExpression.java:68)
             at javax.faces.component.MethodBindingMethodExpressionAdapter.invoke(MethodBindingMethodExpressionAdapter.java:88)
             ... 56 more
            Caused by: java.sql.SQLException: The result set is closed.
             at org.jboss.resource.adapter.jdbc.WrappedResultSet.checkState(WrappedResultSet.java:1959)
             at org.jboss.resource.adapter.jdbc.WrappedResultSet.getLong(WrappedResultSet.java:721)
             at org.hibernate.type.LongType.get(LongType.java:51)
             at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:184)
             at org.hibernate.type.NullableType.nullSafeGet(NullableType.java:173)
             at org.hibernate.type.AbstractType.hydrate(AbstractType.java:105)
             at org.hibernate.type.ComponentType.hydrate(ComponentType.java:583)
             at org.hibernate.type.ComponentType.nullSafeGet(ComponentType.java:298)
             at org.hibernate.type.ManyToOneType.hydrate(ManyToOneType.java:126)
             at org.hibernate.type.EntityType.nullSafeGet(EntityType.java:227)
             at org.hibernate.loader.hql.QueryLoader.getResultColumnOrRow(QueryLoader.java:361)
             at org.hibernate.loader.Loader.getRowFromResultSet(Loader.java:629)
             at org.hibernate.loader.Loader.doQuery(Loader.java:724)
             at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)
             at org.hibernate.loader.Loader.doList(Loader.java:2232)
             ... 145 more


            • 3. Re: transaction is not active
              Adam Warski Master

              Well, maybe try increasing the TX timeout :) (either for the EJB or globally in Seam)

              Adam

              • 4. Re: transaction is not active
                Stephan Pabinger Newbie

                Hi Adam,

                thanks for your hint. I already tried to change the transaction timeout for my method but that didn't show any effect.
                Today I changed the global timeout and now my method finishes.

                Thanks for your help
                Stephan

                • 5. Re: transaction is not active
                  Prashant B Newbie

                  Hi Stephan,

                   

                  I am also facing same problem. It seems you had found the soultion. Can you please let me know what chagnes you did to make it work. What is global timeout ? is that configureation parameter?

                  • 6. Re: transaction is not active
                    mariaprabudass Edwin Newbie

                    Hi Adam/Stephan,

                     

                    Am facing same issue. Could you please help me to solve this issue...

                     

                    Thanks,

                    Maria

                    • 7. Re: transaction is not active
                      mariaprabudass Edwin Newbie

                      Hi All,

                       

                      Any update for my request?

                       

                      Thanks,

                      Maria

                      • 8. Re: transaction is not active
                        mariaprabudass Edwin Newbie

                        Anybody please explain how to solve this issue...