You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@jackrabbit.apache.org by Chris Poulsen <ch...@dezide.com> on 2012/09/24 13:02:38 UTC

How to configure transactions properly with jackrabbit 2.4.3?

Hi,

I've been trying to get jackrabbit up and running with transactions, but 
so far without success.

Environment:

Jboss as 5.1
Oracle XE
Jackrabbit 2.4.3 (using JCA package)

If I call my service method "normally" (not from an EJB) everything 
works. But if I perform that call to the service method from a stateless 
ejb, it gives me an error about being unable to set autocommit during a 
managed transaction (trace included last in this email). It looks 
similar to

https://issues.apache.org/jira/browse/JCR-3258

Jackrabbit connectors are looking up their datasources using jndi and 
I've tried both <local-tx-datasource> and <no-tx-datasource> without 
success.

Does anyone have some insights to offer on how to get this up and 
running? - I've googled a lot, but haven't found anything useful. The 
FAQ mentions a mailing list message, but I have not been able to find 
anything useful.

Thanks!
-- 
Chris


2012-09-24 11:48:39,142 WARN 
[org.jboss.resource.connectionmanager.JBossManagedConnectionPool] 
(http-0.0.0.0-80-1) Destroying connection that could not be successfully 
matched: 
org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@2d30b676[state=NORMAL 
mc=org.apache.jackrabbit.jca.JCAManagedConnection@45c69c37 handles=0 
lastUse=1348480076460 permit=false trackByTx=false 
mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@723a02aa 
context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@3e85217c 
xaResource=org.apache.jackrabbit.jca.TransactionBoundXAResource@165973f5 
txSync=null]
2012-09-24 11:48:49,337 ERROR 
[org.apache.jackrabbit.core.util.db.ConnectionHelper] 
(http-0.0.0.0-80-1) Failed to execute SQL (stacktrace on DEBUG log 
level): java.sql.SQLException: You cannot set autocommit during a 
managed transaction!
2012-09-24 11:48:49,437 ERROR 
[org.apache.jackrabbit.core.util.db.ConnectionHelper] 
(http-0.0.0.0-80-1) Failed to execute SQL (stacktrace on DEBUG log 
level): java.sql.SQLException: You cannot set autocommit during a 
managed transaction!
2012-09-24 11:48:49,437 ERROR 
[org.apache.jackrabbit.core.persistence.pool.BundleDbPersistenceManager] 
(http-0.0.0.0-80-1) failed to read bundle: 
f0458a73-445a-4970-98dc-79743df6b217: java.sql.SQLException: You cannot 
set autocommit during a managed transaction!
2012-09-24 11:48:49,438 ERROR [org.apache.jackrabbit.core.ItemManager] 
(http-0.0.0.0-80-1) failed to retrieve item state of item 
f0458a73-445a-4970-98dc-79743df6b217
org.apache.jackrabbit.core.state.ItemStateException: failed to read 
bundle: f0458a73-445a-4970-98dc-79743df6b217: java.sql.SQLException: You 
cannot set autocommit during a managed transaction!
     at 
org.apache.jackrabbit.core.persistence.pool.BundleDbPersistenceManager.loadBundle(BundleDbPersistenceManager.java:843)
     at 
org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.getBundleCacheMiss(AbstractBundlePersistenceManager.java:737)
     at 
org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.getBundle(AbstractBundlePersistenceManager.java:720)
     at 
org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.load(AbstractBundlePersistenceManager.java:461)
     at 
org.apache.jackrabbit.core.state.SharedItemStateManager.loadItemState(SharedItemStateManager.java:1829)
     at 
org.apache.jackrabbit.core.state.SharedItemStateManager.getNonVirtualItemState(SharedItemStateManager.java:1749)
     at 
org.apache.jackrabbit.core.state.SharedItemStateManager.getItemState(SharedItemStateManager.java:269)
     at 
org.apache.jackrabbit.core.state.LocalItemStateManager.getNodeState(LocalItemStateManager.java:110)
     at 
org.apache.jackrabbit.core.state.LocalItemStateManager.getItemState(LocalItemStateManager.java:175)
     at 
org.apache.jackrabbit.core.state.XAItemStateManager.getItemState(XAItemStateManager.java:260)
     at 
org.apache.jackrabbit.core.state.SessionItemStateManager.getItemState(SessionItemStateManager.java:161)
     at 
org.apache.jackrabbit.core.ItemManager.getItemData(ItemManager.java:382)
     at org.apache.jackrabbit.core.ItemManager.getItem(ItemManager.java:328)
     at org.apache.jackrabbit.core.ItemManager.getItem(ItemManager.java:622)
     at 
org.apache.jackrabbit.core.SessionImpl.getNodeById(SessionImpl.java:536)
     at 
org.apache.jackrabbit.core.query.lucene.LuceneQueryFactory.execute(LuceneQueryFactory.java:227)
     at 
org.apache.jackrabbit.core.query.lucene.join.QueryEngine.execute(QueryEngine.java:465)
     at 
org.apache.jackrabbit.core.query.lucene.join.QueryEngine.execute(QueryEngine.java:126)
     at 
org.apache.jackrabbit.core.query.lucene.join.QueryEngine.execute(QueryEngine.java:115)
     at 
org.apache.jackrabbit.core.query.QueryObjectModelImpl$2.perform(QueryObjectModelImpl.java:129)
     at 
org.apache.jackrabbit.core.query.QueryObjectModelImpl$2.perform(QueryObjectModelImpl.java:124)
     at 
org.apache.jackrabbit.core.session.SessionState.perform(SessionState.java:216)
     at 
org.apache.jackrabbit.core.query.QueryObjectModelImpl.execute(QueryObjectModelImpl.java:123)
     at com.dezide.webauthor.core.dao.FAQDAO$3.doInJcr(FAQDAO.java:164)
     at com.dezide.webauthor.core.dao.FAQDAO$3.doInJcr(FAQDAO.java:127)
     at 
com.dezide.webauthor.core.jcr.JcrTemplate.execute(JcrTemplate.java:33)
     at 
com.dezide.webauthor.core.jcr.JcrTemplate.execute(JcrTemplate.java:19)
     at com.dezide.webauthor.core.dao.FAQDAO.getPagedFAQs(FAQDAO.java:127)
     at 
com.dezide.webauthor.api.service.impl.FAQServiceImpl.getPagedFAQs(FAQServiceImpl.java:41)
     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.invokeTarget(MethodInvocation.java:122)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:111)
     at 
org.jboss.ejb3.EJBContainerInvocationWrapper.invokeNext(EJBContainerInvocationWrapper.java:69)
     at 
org.jboss.ejb3.interceptors.aop.InterceptorSequencer.invoke(InterceptorSequencer.java:73)
     at 
org.jboss.ejb3.interceptors.aop.InterceptorSequencer.aroundInvoke(InterceptorSequencer.java:59)
     at sun.reflect.GeneratedMethodAccessor240.invoke(Unknown Source)
     at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     at java.lang.reflect.Method.invoke(Method.java:597)
     at 
org.jboss.aop.advice.PerJoinpointAdvice.invoke(PerJoinpointAdvice.java:174)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at 
org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.fillMethod(InvocationContextInterceptor.java:72)
     at 
org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_fillMethod_2036170959.invoke(InvocationContextInterceptor_z_fillMethod_2036170959.java)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at 
org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.setup(InvocationContextInterceptor.java:88)
     at 
org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_setup_2036170959.invoke(InvocationContextInterceptor_z_setup_2036170959.java)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at 
org.jboss.ejb3.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:62)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at 
org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:56)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at 
org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at 
org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:68)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
     at 
org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:190)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at 
org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at 
org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(Ejb3AuthenticationInterceptorv2.java:186)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at 
org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:41)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at 
org.jboss.ejb3.BlockContainerShutdownInterceptor.invoke(BlockContainerShutdownInterceptor.java:67)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at 
org.jboss.aspects.currentinvocation.CurrentInvocationInterceptor.invoke(CurrentInvocationInterceptor.java:67)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at 
org.jboss.ejb3.session.SessionSpecContainer.invoke(SessionSpecContainer.java:176)
     at 
org.jboss.ejb3.session.SessionSpecContainer.invoke(SessionSpecContainer.java:216)
     at 
org.jboss.ejb3.proxy.impl.handler.session.SessionProxyInvocationHandlerBase.invoke(SessionProxyInvocationHandlerBase.java:207)
     at 
org.jboss.ejb3.proxy.impl.handler.session.SessionProxyInvocationHandlerBase.invoke(SessionProxyInvocationHandlerBase.java:164)
     at $Proxy187.getPagedFAQs(Unknown Source)
     at com.dezide.webauthor.gui.bean.faq.FAQIndex$1.load(FAQIndex.java:48)
     at 
org.primefaces.component.datatable.DataTable.loadLazyData(DataTable.java:601)
     at 
org.primefaces.component.datatable.DataTableRenderer.encodeMarkup(DataTableRenderer.java:159)
     at 
org.primefaces.component.datatable.DataTableRenderer.encodeEnd(DataTableRenderer.java:74)
     at 
javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875)
     at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1786)
     at javax.faces.render.Renderer.encodeChildren(Renderer.java:168)
     at 
javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:845)
     at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1779)
     at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1782)
     at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1782)
     at 
com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(FaceletViewHandlingStrategy.java:424)
     at 
com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:124)
     at 
com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:121)
     at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
     at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
     at javax.faces.webapp.FacesServlet.service(FacesServlet.java:594)
     at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
     at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
     at 
com.dezide.webauthor.gui.servlet.AuthenticationFilter.doFilter(AuthenticationFilter.java:73)
     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.ApplicationDispatcher.invoke(ApplicationDispatcher.java:638)
     at 
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:444)
     at 
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:382)
     at 
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:310)
     at 
com.dezide.webauthor.gui.servlet.SiteFilter.doFilter(SiteFilter.java:100)
     at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
     at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
     at 
org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79)
     at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
     at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
     at 
com.dezide.webauthor.gui.servlet.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:18)
     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:235)
     at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
     at 
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
     at 
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
     at 
org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
     at 
org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
     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:158)
     at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
     at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
     at 
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
     at 
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
     at 
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
     at java.lang.Thread.run(Thread.java:662)
Caused by: java.sql.SQLException: You cannot set autocommit during a 
managed transaction!
     at 
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.setJdbcAutoCommit(BaseWrapperManagedConnection.java:598)
     at 
org.jboss.resource.adapter.jdbc.WrappedConnection.setAutoCommit(WrappedConnection.java:458)
     at 
org.apache.jackrabbit.core.util.db.ConnectionHelper.getConnection(ConnectionHelper.java:439)
     at 
org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyExec(ConnectionHelper.java:390)
     at 
org.apache.jackrabbit.core.util.db.ConnectionHelper$3.call(ConnectionHelper.java:378)
     at 
org.apache.jackrabbit.core.util.db.ConnectionHelper$3.call(ConnectionHelper.java:374)
     at 
org.apache.jackrabbit.core.util.db.ConnectionHelper$RetryManager.doTry(ConnectionHelper.java:567)
     at 
org.apache.jackrabbit.core.util.db.ConnectionHelper.exec(ConnectionHelper.java:374)
     at 
org.apache.jackrabbit.core.persistence.pool.BundleDbPersistenceManager.loadBundle(BundleDbPersistenceManager.java:827)
     ... 131 more
2012-09-24 11:48:49,442 ERROR 
[com.dezide.webauthor.core.jcr.JcrTemplate] (http-0.0.0.0-80-1) Error 
caught while executing JcrCallback.
javax.jcr.RepositoryException: failed to retrieve item state of item 
f0458a73-445a-4970-98dc-79743df6b217
     at 
org.apache.jackrabbit.core.ItemManager.getItemData(ItemManager.java:388)
     at org.apache.jackrabbit.core.ItemManager.getItem(ItemManager.java:328)
     at org.apache.jackrabbit.core.ItemManager.getItem(ItemManager.java:622)
     at 
org.apache.jackrabbit.core.SessionImpl.getNodeById(SessionImpl.java:536)
     at 
org.apache.jackrabbit.core.query.lucene.LuceneQueryFactory.execute(LuceneQueryFactory.java:227)
     at 
org.apache.jackrabbit.core.query.lucene.join.QueryEngine.execute(QueryEngine.java:465)
     at 
org.apache.jackrabbit.core.query.lucene.join.QueryEngine.execute(QueryEngine.java:126)
     at 
org.apache.jackrabbit.core.query.lucene.join.QueryEngine.execute(QueryEngine.java:115)
     at 
org.apache.jackrabbit.core.query.QueryObjectModelImpl$2.perform(QueryObjectModelImpl.java:129)
     at 
org.apache.jackrabbit.core.query.QueryObjectModelImpl$2.perform(QueryObjectModelImpl.java:124)
     at 
org.apache.jackrabbit.core.session.SessionState.perform(SessionState.java:216)
     at 
org.apache.jackrabbit.core.query.QueryObjectModelImpl.execute(QueryObjectModelImpl.java:123)
     at com.dezide.webauthor.core.dao.FAQDAO$3.doInJcr(FAQDAO.java:164)
     at com.dezide.webauthor.core.dao.FAQDAO$3.doInJcr(FAQDAO.java:127)
     at 
com.dezide.webauthor.core.jcr.JcrTemplate.execute(JcrTemplate.java:33)
     at 
com.dezide.webauthor.core.jcr.JcrTemplate.execute(JcrTemplate.java:19)
     at com.dezide.webauthor.core.dao.FAQDAO.getPagedFAQs(FAQDAO.java:127)
     at 
com.dezide.webauthor.api.service.impl.FAQServiceImpl.getPagedFAQs(FAQServiceImpl.java:41)
     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.invokeTarget(MethodInvocation.java:122)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:111)
     at 
org.jboss.ejb3.EJBContainerInvocationWrapper.invokeNext(EJBContainerInvocationWrapper.java:69)
     at 
org.jboss.ejb3.interceptors.aop.InterceptorSequencer.invoke(InterceptorSequencer.java:73)
     at 
org.jboss.ejb3.interceptors.aop.InterceptorSequencer.aroundInvoke(InterceptorSequencer.java:59)
     at sun.reflect.GeneratedMethodAccessor240.invoke(Unknown Source)
     at 
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
     at java.lang.reflect.Method.invoke(Method.java:597)
     at 
org.jboss.aop.advice.PerJoinpointAdvice.invoke(PerJoinpointAdvice.java:174)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at 
org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.fillMethod(InvocationContextInterceptor.java:72)
     at 
org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_fillMethod_2036170959.invoke(InvocationContextInterceptor_z_fillMethod_2036170959.java)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at 
org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor.setup(InvocationContextInterceptor.java:88)
     at 
org.jboss.aop.advice.org.jboss.ejb3.interceptors.aop.InvocationContextInterceptor_z_setup_2036170959.invoke(InvocationContextInterceptor_z_setup_2036170959.java)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at 
org.jboss.ejb3.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:62)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at 
org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:56)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at 
org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at 
org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:68)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)
     at 
org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:190)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at 
org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:76)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at org.jboss.ejb3.tx.NullInterceptor.invoke(NullInterceptor.java:42)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at 
org.jboss.ejb3.security.Ejb3AuthenticationInterceptorv2.invoke(Ejb3AuthenticationInterceptorv2.java:186)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at 
org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:41)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at 
org.jboss.ejb3.BlockContainerShutdownInterceptor.invoke(BlockContainerShutdownInterceptor.java:67)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at 
org.jboss.aspects.currentinvocation.CurrentInvocationInterceptor.invoke(CurrentInvocationInterceptor.java:67)
     at 
org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:102)
     at 
org.jboss.ejb3.session.SessionSpecContainer.invoke(SessionSpecContainer.java:176)
     at 
org.jboss.ejb3.session.SessionSpecContainer.invoke(SessionSpecContainer.java:216)
     at 
org.jboss.ejb3.proxy.impl.handler.session.SessionProxyInvocationHandlerBase.invoke(SessionProxyInvocationHandlerBase.java:207)
     at 
org.jboss.ejb3.proxy.impl.handler.session.SessionProxyInvocationHandlerBase.invoke(SessionProxyInvocationHandlerBase.java:164)
     at $Proxy187.getPagedFAQs(Unknown Source)
     at com.dezide.webauthor.gui.bean.faq.FAQIndex$1.load(FAQIndex.java:48)
     at 
org.primefaces.component.datatable.DataTable.loadLazyData(DataTable.java:601)
     at 
org.primefaces.component.datatable.DataTableRenderer.encodeMarkup(DataTableRenderer.java:159)
     at 
org.primefaces.component.datatable.DataTableRenderer.encodeEnd(DataTableRenderer.java:74)
     at 
javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:875)
     at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1786)
     at javax.faces.render.Renderer.encodeChildren(Renderer.java:168)
     at 
javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:845)
     at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1779)
     at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1782)
     at javax.faces.component.UIComponent.encodeAll(UIComponent.java:1782)
     at 
com.sun.faces.application.view.FaceletViewHandlingStrategy.renderView(FaceletViewHandlingStrategy.java:424)
     at 
com.sun.faces.application.view.MultiViewHandler.renderView(MultiViewHandler.java:124)
     at 
com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:121)
     at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:101)
     at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
     at javax.faces.webapp.FacesServlet.service(FacesServlet.java:594)
     at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
     at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
     at 
com.dezide.webauthor.gui.servlet.AuthenticationFilter.doFilter(AuthenticationFilter.java:73)
     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.ApplicationDispatcher.invoke(ApplicationDispatcher.java:638)
     at 
org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:444)
     at 
org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:382)
     at 
org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:310)
     at 
com.dezide.webauthor.gui.servlet.SiteFilter.doFilter(SiteFilter.java:100)
     at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
     at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
     at 
org.primefaces.webapp.filter.FileUploadFilter.doFilter(FileUploadFilter.java:79)
     at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
     at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
     at 
com.dezide.webauthor.gui.servlet.CharacterEncodingFilter.doFilter(CharacterEncodingFilter.java:18)
     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:235)
     at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
     at 
org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
     at 
org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
     at 
org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
     at 
org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
     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:158)
     at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
     at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
     at 
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
     at 
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
     at 
org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
     at java.lang.Thread.run(Thread.java:662)
Caused by: org.apache.jackrabbit.core.state.ItemStateException: failed 
to read bundle: f0458a73-445a-4970-98dc-79743df6b217: 
java.sql.SQLException: You cannot set autocommit during a managed 
transaction!
     at 
org.apache.jackrabbit.core.persistence.pool.BundleDbPersistenceManager.loadBundle(BundleDbPersistenceManager.java:843)
     at 
org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.getBundleCacheMiss(AbstractBundlePersistenceManager.java:737)
     at 
org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.getBundle(AbstractBundlePersistenceManager.java:720)
     at 
org.apache.jackrabbit.core.persistence.bundle.AbstractBundlePersistenceManager.load(AbstractBundlePersistenceManager.java:461)
     at 
org.apache.jackrabbit.core.state.SharedItemStateManager.loadItemState(SharedItemStateManager.java:1829)
     at 
org.apache.jackrabbit.core.state.SharedItemStateManager.getNonVirtualItemState(SharedItemStateManager.java:1749)
     at 
org.apache.jackrabbit.core.state.SharedItemStateManager.getItemState(SharedItemStateManager.java:269)
     at 
org.apache.jackrabbit.core.state.LocalItemStateManager.getNodeState(LocalItemStateManager.java:110)
     at 
org.apache.jackrabbit.core.state.LocalItemStateManager.getItemState(LocalItemStateManager.java:175)
     at 
org.apache.jackrabbit.core.state.XAItemStateManager.getItemState(XAItemStateManager.java:260)
     at 
org.apache.jackrabbit.core.state.SessionItemStateManager.getItemState(SessionItemStateManager.java:161)
     at 
org.apache.jackrabbit.core.ItemManager.getItemData(ItemManager.java:382)
     ... 120 more
Caused by: java.sql.SQLException: You cannot set autocommit during a 
managed transaction!
     at 
org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.setJdbcAutoCommit(BaseWrapperManagedConnection.java:598)
     at 
org.jboss.resource.adapter.jdbc.WrappedConnection.setAutoCommit(WrappedConnection.java:458)
     at 
org.apache.jackrabbit.core.util.db.ConnectionHelper.getConnection(ConnectionHelper.java:439)
     at 
org.apache.jackrabbit.core.util.db.ConnectionHelper.reallyExec(ConnectionHelper.java:390)
     at 
org.apache.jackrabbit.core.util.db.ConnectionHelper$3.call(ConnectionHelper.java:378)
     at 
org.apache.jackrabbit.core.util.db.ConnectionHelper$3.call(ConnectionHelper.java:374)
     at 
org.apache.jackrabbit.core.util.db.ConnectionHelper$RetryManager.doTry(ConnectionHelper.java:567)
     at 
org.apache.jackrabbit.core.util.db.ConnectionHelper.exec(ConnectionHelper.java:374)
     at 
org.apache.jackrabbit.core.persistence.pool.BundleDbPersistenceManager.loadBundle(BundleDbPersistenceManager.java:827)
     ... 131 more