6 Replies Latest reply on Dec 2, 2015 11:11 AM by Guido Lombardi

    TEIID30517 Client thread already involved in a transaction.

    Guido Lombardi Newbie

      Hi, I'm using teiid 8.10.0 and hibernate. I have 2 entities related with a @ManyToMany annotation.

      When i tried to get one of this entities i get the following error:

      18:01:00,717 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-localhost/127.0.0.1:8080-1) null SQL Error: 30517, SQLState: 50000

      18:01:00,717 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-localhost/127.0.0.1:8080-1) null TEIID30517 Client thread already involved in a transaction. Transaction nesting is not supported. The current transaction must be completed first.

       

      Can somebody help me with this? I tried using configurating in standalone-teiid.xml AutoCommitTxn=OFF, but it didn't work.

       

      Thanks!

        • 1. Re: TEIID30517 Client thread already involved in a transaction.
          Steven Hawkins Master

          Can you provide a debug log?  In particular at the debug level the org.teiid.TXN_LOG context will show all of the calls made into our transaction layer.

          • 2. Re: TEIID30517 Client thread already involved in a transaction.
            Ramesh Reddy Master

            Guido,

            I tried using configurating in standalone-teiid.xml AutoCommitTxn=OFF, but it didn't work.

            You can NOT configure AutoCommitTxn=OFF in standalone-teiid.xml file, it is JDBC URL connection property, so needs to configured on JDBC URL. BTW, when you do this transaction is not wrapped around for any operation that involves Teiid, which may or may not be desired depending upon your usecase.

             

            Are you using Hibernate on top Teiid in JBoss EAP container? I believe, your client code already started the transaction and Teiid needs to participate in the on-going transaction. Also are accessing multiple data sources from your client or just Teiid? This document gives info on it Sessions and transactions

             

            Ramesh..

            • 3. Re: TEIID30517 Client thread already involved in a transaction.
              Guido Lombardi Newbie

              Hello Steven, thank you very much in advance.

               

              To catch this log I've inserted these lines on standalone-teiid.xml under profile tag.

               

              <logger category="org.teiid.TXN_LOG">

                              <level name="DEBUG"/>

              </logger>

               

              This is the log when I try to get a many to many relation.

               

               

              17:14:37,283 DEBUG [org.hibernate.SQL] (http-localhost/127.0.0.1:8080-1)  select base0_.baseID as baseID1_4_, base0_.anio as anio2_4_, base0_.nombreBase as nombreBa3_4_ from JDVirtualVDL.Base base0_ where base0_.anio=2015

              17:14:37,287 DEBUG [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (http-localhost/127.0.0.1:8080-1)  JDVirtualVDB: getConnection(null, WrappedConnectionRequestInfo@69730f59[userName=user]) [0/20]

              17:14:37,318 DEBUG [org.teiid.TXN_LOG] (http-localhost/127.0.0.1:8080-1) FA0eWYWFmcug before begin:org.teiid.dqp.internal.process.TransactionServerImpl@2cb19345(FA0eWYWFmcug)

              17:14:37,327 DEBUG [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-localhost/127.0.0.1:8080-1) null could not extract ResultSet [n/a]: org.teiid.jdbc.TeiidSQLException: TEIID30517 Client thread already involved in a transaction. Transaction nesting is not supported. The current transaction must be completed first.

                at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:135) [teiid-client-8.9.0.Final.jar:8.9.0.Final]

                at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:71) [teiid-client-8.9.0.Final.jar:8.9.0.Final]

                at org.teiid.jdbc.ConnectionImpl.beginLocalTxnIfNeeded(ConnectionImpl.java:363) [teiid-client-8.9.0.Final.jar:8.9.0.Final]

                at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:602) [teiid-client-8.9.0.Final.jar:8.9.0.Final]

                at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:509) [teiid-client-8.9.0.Final.jar:8.9.0.Final]

                at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) [teiid-client-8.9.0.Final.jar:8.9.0.Final]

                at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:73) [teiid-client-8.9.0.Final.jar:8.9.0.Final]

                at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)

                at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.loader.Loader.getResultSet(Loader.java:2066) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.loader.Loader.doQuery(Loader.java:910) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.loader.Loader.doList(Loader.java:2554) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.loader.Loader.doList(Loader.java:2540) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.loader.Loader.list(Loader.java:2365) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1264) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:573) [hibernate-entitymanager-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:449) [hibernate-entitymanager-4.3.8.Final.jar:4.3.8.Final]

                at com.panel.softtek.dao.BaseDAO.getBasesByAnio(BaseDAO.java:60) [classes:]

                at com.panel.softtek.dao.BaseDAO$$FastClassByCGLIB$$325ed630.invoke(<generated>) [cglib-2.2.jar:]

                at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191) [cglib-2.2.jar:]

                at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) [spring-tx-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at com.panel.softtek.dao.BaseDAO$$EnhancerByCGLIB$$379d8f9f.getBasesByAnio(<generated>) [cglib-2.2.jar:]

                at com.panel.softtek.bo.BaseBO.getBasesByAnio(BaseBO.java:54) [classes:]

                at com.panel.softtek.manager.BaseManager.getBasesByAnio(BaseManager.java:42) [classes:]

                at com.panel.softtek.ws.BaseRestService.getBasesByAnio(BaseRestService.java:53) [classes:]

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_18]

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_18]

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_18]

                at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_18]

                at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:167) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:269) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:227) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:216) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:542) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:524) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:126) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-1.jar:1.0.2.Final-redhat-1]

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:205) [cors-filter-1.3.2.jar:]

                at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:266) [cors-filter-1.3.2.jar:]

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa-7.4.0.Final-redhat-4.jar:7.4.0.Final-redhat-4]

                at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa-7.4.0.Final-redhat-4.jar:7.4.0.Final-redhat-4]

                at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.4.0.Final-redhat-4.jar:7.4.0.Final-redhat-4]

                at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:340) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at java.lang.Thread.run(Thread.java:619) [rt.jar:1.6.0_18]

              Caused by: org.teiid.client.xa.XATransactionException: TEIID30517 Client thread already involved in a transaction. Transaction nesting is not supported. The current transaction must be completed first.

                at org.teiid.dqp.internal.process.TransactionServerImpl.checkLocalTransactionState(TransactionServerImpl.java:371)

                at org.teiid.dqp.internal.process.TransactionServerImpl.begin(TransactionServerImpl.java:473)

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_18]

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_18]

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_18]

                at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_18]

                at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.9.0.Final.jar:8.9.0.Final]

                at $Proxy19.begin(Unknown Source) at org.teiid.dqp.internal.process.DQPCore.begin(DQPCore.java:673)

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_18]

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_18]

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_18]

                at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_18]

                at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.9.0.Final.jar:8.9.0.Final]

                at org.teiid.jboss.TransportService$2.invoke(TransportService.java:226)

                at $Proxy20.begin(Unknown Source) at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_18]

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_18]

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_18]

                at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_18]

                at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:173)

                at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_18]

                at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_18]

                at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274)

                at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:258)

                at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:171)

                at $Proxy20.begin(Unknown Source) at org.teiid.jdbc.ConnectionImpl.beginLocalTxnIfNeeded(ConnectionImpl.java:361) [teiid-client-8.9.0.Final.jar:8.9.0.Final]

                ... 68 more

               

               

              17:14:37,363 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-localhost/127.0.0.1:8080-1) null SQL Error: 30517, SQLState: 50000

              17:14:37,364 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-localhost/127.0.0.1:8080-1) null TEIID30517 Client thread already involved in a transaction. Transaction nesting is not supported. The current transaction must be completed first.

              17:14:37,398 FINE  [org.teiid.jdbc] (http-localhost/127.0.0.1:8080-1) null Statement closed successfully.

              17:14:37,399 DEBUG [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-localhost/127.0.0.1:8080-1) null could not log warnings: java.sql.SQLException: Transaction cannot proceed STATUS_MARKED_ROLLBACK

                at org.jboss.jca.adapters.jdbc.WrapperDataSource.checkTransactionActive(WrapperDataSource.java:254)

                at org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransactionActive(WrappedConnection.java:1604)

                at org.jboss.jca.adapters.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:1619)

                at org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1593)

                at org.jboss.jca.adapters.jdbc.WrappedConnection.getWarnings(WrappedConnection.java:944)

                at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.handleAndClearWarnings(SqlExceptionHelper.java:289) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logAndClearWarnings(SqlExceptionHelper.java:269) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.releaseConnection(LogicalConnectionImpl.java:252) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.close(LogicalConnectionImpl.java:182) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.close(JdbcCoordinatorImpl.java:205) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl.close(TransactionCoordinatorImpl.java:297) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.internal.SessionImpl.close(SessionImpl.java:369) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.jpa.internal.EntityManagerImpl.close(EntityManagerImpl.java:153) [hibernate-entitymanager-4.3.8.Final.jar:4.3.8.Final]

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_18]

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_18]

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_18]

                at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_18]

                at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:365) [spring-orm-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at $Proxy117.close(Unknown Source) at org.springframework.orm.jpa.EntityManagerFactoryUtils.closeEntityManager(EntityManagerFactoryUtils.java:331) [spring-orm-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at org.springframework.orm.jpa.EntityManagerFactoryUtils$EntityManagerSynchronization.releaseResource(EntityManagerFactoryUtils.java:394) [spring-orm-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at org.springframework.orm.jpa.EntityManagerFactoryUtils$EntityManagerSynchronization.releaseResource(EntityManagerFactoryUtils.java:1) [spring-orm-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at org.springframework.transaction.support.ResourceHolderSynchronization.beforeCompletion(ResourceHolderSynchronization.java:72) [spring-tx-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCompletion(TransactionSynchronizationUtils.java:106) [spring-tx-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCompletion(AbstractPlatformTransactionManager.java:940) [spring-tx-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:834) [spring-tx-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:822) [spring-tx-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:411) [spring-tx-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:114) [spring-tx-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at com.panel.softtek.dao.BaseDAO$$EnhancerByCGLIB$$379d8f9f.getBasesByAnio(<generated>) [cglib-2.2.jar:]

                at com.panel.softtek.bo.BaseBO.getBasesByAnio(BaseBO.java:54) [classes:]

                at com.panel.softtek.manager.BaseManager.getBasesByAnio(BaseManager.java:42) [classes:]

                at com.panel.softtek.ws.BaseRestService.getBasesByAnio(BaseRestService.java:53) [classes:]

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_18]

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_18]

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_18]

                at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_18]

                at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:167) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:269) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:227) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:216) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:542) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:524) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:126) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-1.jar:1.0.2.Final-redhat-1]

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:205) [cors-filter-1.3.2.jar:]

                at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:266) [cors-filter-1.3.2.jar:]

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa-7.4.0.Final-redhat-4.jar:7.4.0.Final-redhat-4]

                at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa-7.4.0.Final-redhat-4.jar:7.4.0.Final-redhat-4]

                at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.4.0.Final-redhat-4.jar:7.4.0.Final-redhat-4]

                at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:340) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at java.lang.Thread.run(Thread.java:619) [rt.jar:1.6.0_18]

               

               

              17:14:37,402 DEBUG [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (http-localhost/127.0.0.1:8080-1) null could not clear warnings: java.sql.SQLException: Transaction cannot proceed STATUS_MARKED_ROLLBACK

                at org.jboss.jca.adapters.jdbc.WrapperDataSource.checkTransactionActive(WrapperDataSource.java:254)

                at org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransactionActive(WrappedConnection.java:1604)

                at org.jboss.jca.adapters.jdbc.WrappedConnection.checkStatus(WrappedConnection.java:1619)

                at org.jboss.jca.adapters.jdbc.WrappedConnection.checkTransaction(WrappedConnection.java:1593)

                at org.jboss.jca.adapters.jdbc.WrappedConnection.clearWarnings(WrappedConnection.java:972)

                at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.handleAndClearWarnings(SqlExceptionHelper.java:297) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.logAndClearWarnings(SqlExceptionHelper.java:269) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.releaseConnection(LogicalConnectionImpl.java:252) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.engine.jdbc.internal.LogicalConnectionImpl.close(LogicalConnectionImpl.java:182) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.engine.jdbc.internal.JdbcCoordinatorImpl.close(JdbcCoordinatorImpl.java:205) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.engine.transaction.internal.TransactionCoordinatorImpl.close(TransactionCoordinatorImpl.java:297) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.internal.SessionImpl.close(SessionImpl.java:369) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                at org.hibernate.jpa.internal.EntityManagerImpl.close(EntityManagerImpl.java:153) [hibernate-entitymanager-4.3.8.Final.jar:4.3.8.Final]

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_18]

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_18]

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_18]

                at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_18]

                at org.springframework.orm.jpa.ExtendedEntityManagerCreator$ExtendedEntityManagerInvocationHandler.invoke(ExtendedEntityManagerCreator.java:365) [spring-orm-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at $Proxy117.close(Unknown Source) at org.springframework.orm.jpa.EntityManagerFactoryUtils.closeEntityManager(EntityManagerFactoryUtils.java:331) [spring-orm-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at org.springframework.orm.jpa.EntityManagerFactoryUtils$EntityManagerSynchronization.releaseResource(EntityManagerFactoryUtils.java:394) [spring-orm-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at org.springframework.orm.jpa.EntityManagerFactoryUtils$EntityManagerSynchronization.releaseResource(EntityManagerFactoryUtils.java:1) [spring-orm-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at org.springframework.transaction.support.ResourceHolderSynchronization.beforeCompletion(ResourceHolderSynchronization.java:72) [spring-tx-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at org.springframework.transaction.support.TransactionSynchronizationUtils.triggerBeforeCompletion(TransactionSynchronizationUtils.java:106) [spring-tx-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at org.springframework.transaction.support.AbstractPlatformTransactionManager.triggerBeforeCompletion(AbstractPlatformTransactionManager.java:940) [spring-tx-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at org.springframework.transaction.support.AbstractPlatformTransactionManager.processRollback(AbstractPlatformTransactionManager.java:834) [spring-tx-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at org.springframework.transaction.support.AbstractPlatformTransactionManager.rollback(AbstractPlatformTransactionManager.java:822) [spring-tx-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at org.springframework.transaction.interceptor.TransactionAspectSupport.completeTransactionAfterThrowing(TransactionAspectSupport.java:411) [spring-tx-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:114) [spring-tx-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                at com.panel.softtek.dao.BaseDAO$$EnhancerByCGLIB$$379d8f9f.getBasesByAnio(<generated>) [cglib-2.2.jar:]

                at com.panel.softtek.bo.BaseBO.getBasesByAnio(BaseBO.java:54) [classes:]

                at com.panel.softtek.manager.BaseManager.getBasesByAnio(BaseManager.java:42) [classes:]

                at com.panel.softtek.ws.BaseRestService.getBasesByAnio(BaseRestService.java:53) [classes:]

                at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_18]

                at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_18]

                at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_18]

                at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_18]

                at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:167) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:269) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:227) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:216) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:542) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:524) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:126) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-1.jar:1.0.2.Final-redhat-1]

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:205) [cors-filter-1.3.2.jar:]

                at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:266) [cors-filter-1.3.2.jar:]

                at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa-7.4.0.Final-redhat-4.jar:7.4.0.Final-redhat-4]

                at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa-7.4.0.Final-redhat-4.jar:7.4.0.Final-redhat-4]

                at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.4.0.Final-redhat-4.jar:7.4.0.Final-redhat-4]

                at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:340) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                at java.lang.Thread.run(Thread.java:619) [rt.jar:1.6.0_18]

              • 4. Re: TEIID30517 Client thread already involved in a transaction.
                Guido Lombardi Newbie

                Hello Ramesh, thank you for your answer.

                 

                I put AutoCommitTxn=OFF because I'm a little bit desperate, hahaha.

                 

                But before putting that, this variable wasn't configured at all, just by default as Teiid Designer configures it.

                 

                I'm using hibernate to communicate to Teiid, which is my only "data base".

                 

                I ran some basics querys from Hibernate such as a "get all" from an entity, just to ensure that information is populating well.

                 

                I'm getting this error, I'm not sure what is on about. If I run a HQL query, to get a simple result set, there is no problem.

                 

                 

                 

                18:05:28,001 WARN  [org.teiid.PROCESSOR] (http-localhost/127.0.0.1:8080-1) +bN02degV6Eg TEIID30020 Processing exception for request +bN02degV6Eg.74 'TEIID30498 Capabilities for Panel_Control_Dev were not available.  The command could not be planned properly.'. Originally QueryPlannerException 'IJ000356: Failed to enlist: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: 0:ffffc0a8076e:-633b63bd:565e0a29:26 status: ActionStatus.ABORT_ONLY >' TxConnectionListener.java:653.: org.teiid.api.exception.query.QueryPlannerException: TEIID30498 Capabilities for Panel_Control_Dev were not available.  The command could not be planned properly.

                  at org.teiid.query.optimizer.relational.PlanToProcessConverter.convertNode(PlanToProcessConverter.java:321)

                  at org.teiid.query.optimizer.relational.PlanToProcessConverter.convertPlan(PlanToProcessConverter.java:138)

                  at org.teiid.query.optimizer.relational.PlanToProcessConverter.convert(PlanToProcessConverter.java:115)

                  at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:223)

                  at org.teiid.query.optimizer.QueryOptimizer.optimizePlan(QueryOptimizer.java:159)

                  at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:411)

                  at org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:115)

                  at org.teiid.dqp.internal.process.Request.processRequest(Request.java:438)

                  at org.teiid.dqp.internal.process.PreparedStatementRequest.processRequest(PreparedStatementRequest.java:289)

                  at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:614)

                  at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:320)

                  at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:51)

                  at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:259)

                  at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:297)

                  at sun.reflect.GeneratedMethodAccessor81.invoke(Unknown Source) [:1.6.0_18]

                  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_18]

                  at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_18]

                  at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121) [teiid-api-8.9.0.Final.jar:8.9.0.Final]

                  at org.teiid.jboss.TransportService$2.invoke(TransportService.java:226)

                  at $Proxy20.executeRequest(Unknown Source) at sun.reflect.GeneratedMethodAccessor81.invoke(Unknown Source) [:1.6.0_18]

                  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_18]

                  at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_18]

                  at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:173)

                  at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:303) [rt.jar:1.6.0_18]

                  at java.util.concurrent.FutureTask.run(FutureTask.java:138) [rt.jar:1.6.0_18]

                  at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:274)

                  at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:258)

                  at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:171)

                  at $Proxy20.executeRequest(Unknown Source) at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:634) [teiid-client-8.9.0.Final.jar:8.9.0.Final]

                  at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:509) [teiid-client-8.9.0.Final.jar:8.9.0.Final]

                  at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:261) [teiid-client-8.9.0.Final.jar:8.9.0.Final]

                  at org.teiid.jdbc.PreparedStatementImpl.executeQuery(PreparedStatementImpl.java:73) [teiid-client-8.9.0.Final.jar:8.9.0.Final]

                  at org.jboss.jca.adapters.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:462)

                  at org.hibernate.engine.jdbc.internal.ResultSetReturnImpl.extract(ResultSetReturnImpl.java:82) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                  at org.hibernate.loader.Loader.getResultSet(Loader.java:2066) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                  at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1863) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                  at org.hibernate.loader.Loader.executeQueryStatement(Loader.java:1839) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                  at org.hibernate.loader.Loader.doQuery(Loader.java:910) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                  at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:355) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                  at org.hibernate.loader.Loader.doList(Loader.java:2554) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                  at org.hibernate.loader.Loader.doList(Loader.java:2540) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                  at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2370) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                  at org.hibernate.loader.Loader.list(Loader.java:2365) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                  at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:497) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                  at org.hibernate.hql.internal.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:387) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                  at org.hibernate.engine.query.spi.HQLQueryPlan.performList(HQLQueryPlan.java:236) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                  at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1264) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                  at org.hibernate.internal.QueryImpl.list(QueryImpl.java:103) [hibernate-core-4.3.8.Final.jar:4.3.8.Final]

                  at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:573) [hibernate-entitymanager-4.3.8.Final.jar:4.3.8.Final]

                  at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:449) [hibernate-entitymanager-4.3.8.Final.jar:4.3.8.Final]

                  at com.panel.softtek.dao.BaseDAO.getBasesByAnio(BaseDAO.java:62) [classes:]

                  at com.panel.softtek.dao.BaseDAO$$FastClassByCGLIB$$325ed630.invoke(<generated>) [cglib-2.2.jar:]

                  at net.sf.cglib.proxy.MethodProxy.invoke(MethodProxy.java:191) [cglib-2.2.jar:]

                  at org.springframework.aop.framework.Cglib2AopProxy$CglibMethodInvocation.invokeJoinpoint(Cglib2AopProxy.java:688) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:150) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                  at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:110) [spring-tx-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                  at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:172) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                  at org.springframework.aop.framework.Cglib2AopProxy$DynamicAdvisedInterceptor.intercept(Cglib2AopProxy.java:621) [spring-aop-3.0.5.RELEASE.jar:3.0.5.RELEASE]

                  at com.panel.softtek.dao.BaseDAO$$EnhancerByCGLIB$$d6100286.getBasesByAnio(<generated>) [cglib-2.2.jar:]

                  at com.panel.softtek.bo.BaseBO.getBasesByAnio(BaseBO.java:54) [classes:]

                  at com.panel.softtek.manager.BaseManager.getBasesByAnio(BaseManager.java:42) [classes:]

                  at com.panel.softtek.ws.BaseRestService.getBasesByAnio(BaseRestService.java:53) [classes:]

                  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.6.0_18]

                  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) [rt.jar:1.6.0_18]

                  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) [rt.jar:1.6.0_18]

                  at java.lang.reflect.Method.invoke(Method.java:597) [rt.jar:1.6.0_18]

                  at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:167) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                  at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:269) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                  at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:227) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                  at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:216) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                  at org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:542) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                  at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:524) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                  at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:126) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                  at org.jboss.resteasy.plugins.server.servlet.ServletContainerDispatcher.service(ServletContainerDispatcher.java:208) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                  at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:55) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                  at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:50) [resteasy-jaxrs-2.3.8.Final-redhat-1.jar:]

                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:847) [jboss-servlet-api_3.0_spec-1.0.2.Final-redhat-1.jar:1.0.2.Final-redhat-1]

                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:295) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                  at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:205) [cors-filter-1.3.2.jar:]

                  at com.thetransactioncompany.cors.CORSFilter.doFilter(CORSFilter.java:266) [cors-filter-1.3.2.jar:]

                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:246) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:214) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:231) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:149) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                  at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa-7.4.0.Final-redhat-4.jar:7.4.0.Final-redhat-4]

                  at org.jboss.as.jpa.interceptor.WebNonTxEmCloserValve.invoke(WebNonTxEmCloserValve.java:50) [jboss-as-jpa-7.4.0.Final-redhat-4.jar:7.4.0.Final-redhat-4]

                  at org.jboss.as.web.security.SecurityContextAssociationValve.invoke(SecurityContextAssociationValve.java:169) [jboss-as-web-7.4.0.Final-redhat-4.jar:7.4.0.Final-redhat-4]

                  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:145) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:97) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:102) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:340) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                  at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:856) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                  at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:653) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                  at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:926) [jbossweb-7.4.0.Beta4.jar:7.4.0.Beta4]

                  at java.lang.Thread.run(Thread.java:619) [rt.jar:1.6.0_18]

                Caused by: org.teiid.translator.TranslatorException: TEIID11009 java.sql.SQLException: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@76ecfedf[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@55e1e7e3 connection handles=0 lastUse=1449003927997 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@63b6f0eb pool internal context=SemaphoreArrayListManagedConnectionPool@545ee78d[pool=Panel_Control_Dev] xaResource=LocalXAResourceImpl@7d698506[connectionListener=76ecfedf connectionManager=d707658 warned=false currentXid=null productName=Microsoft SQL Server productVersion=11.00.5058 jndiName=java:/Panel_Control_Dev] txSync=null]

                  at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:285)

                  at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:57)

                  at org.teiid.translator.ExecutionFactory.getConnection(ExecutionFactory.java:194) [teiid-api-8.9.0.Final.jar:8.9.0.Final]

                  at org.teiid.dqp.internal.datamgr.ConnectorManager.buildCapabilities(ConnectorManager.java:179)

                  at org.teiid.dqp.internal.datamgr.ConnectorManager.getCapabilities(ConnectorManager.java:163)

                  at org.teiid.dqp.internal.process.CachedFinder.findCapabilities(CachedFinder.java:107)

                  at org.teiid.query.metadata.TempCapabilitiesFinder.findCapabilities(TempCapabilitiesFinder.java:67)

                  at org.teiid.query.optimizer.relational.rules.CapabilitiesUtil.getCapabilities(CapabilitiesUtil.java:439)

                  at org.teiid.query.optimizer.relational.rules.CapabilitiesUtil.supports(CapabilitiesUtil.java:459)

                  at org.teiid.query.optimizer.relational.rules.CapabilitiesUtil.requiresCriteria(CapabilitiesUtil.java:444)

                  at org.teiid.query.optimizer.relational.rules.RulePlaceAccess.addAccessNode(RulePlaceAccess.java:195)

                  at org.teiid.query.optimizer.relational.rules.RulePlaceAccess.execute(RulePlaceAccess.java:85)

                  at org.teiid.query.optimizer.relational.RelationalPlanner.executeRules(RelationalPlanner.java:739)

                  at org.teiid.query.optimizer.relational.RelationalPlanner.optimize(RelationalPlanner.java:221)

                  ... 94 more

                Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@76ecfedf[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@55e1e7e3 connection handles=0 lastUse=1449003927997 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@63b6f0eb pool internal context=SemaphoreArrayListManagedConnectionPool@545ee78d[pool=Panel_Control_Dev] xaResource=LocalXAResourceImpl@7d698506[connectionListener=76ecfedf connectionManager=d707658 warned=false currentXid=null productName=Microsoft SQL Server productVersion=11.00.5058 jndiName=java:/Panel_Control_Dev] txSync=null]

                  at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:147)

                  at org.teiid.translator.jdbc.JDBCExecutionFactory.getConnection(JDBCExecutionFactory.java:281)

                  ... 107 more

                Caused by: javax.resource.ResourceException: IJ000457: Unchecked throwable in managedConnectionReconnected() cl=org.jboss.jca.core.connectionmanager.listener.TxConnectionListener@76ecfedf[state=NORMAL managed connection=org.jboss.jca.adapters.jdbc.local.LocalManagedConnection@55e1e7e3 connection handles=0 lastUse=1449003927997 trackByTx=false pool=org.jboss.jca.core.connectionmanager.pool.strategy.OnePool@63b6f0eb pool internal context=SemaphoreArrayListManagedConnectionPool@545ee78d[pool=Panel_Control_Dev] xaResource=LocalXAResourceImpl@7d698506[connectionListener=76ecfedf connectionManager=d707658 warned=false currentXid=null productName=Microsoft SQL Server productVersion=11.00.5058 jndiName=java:/Panel_Control_Dev] txSync=null]

                  at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.reconnectManagedConnection(AbstractConnectionManager.java:628)

                  at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:491)

                  at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:139)

                  ... 108 more

                Caused by: javax.resource.ResourceException: IJ000461: Could not enlist in transaction on entering meta-aware object

                  at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.managedConnectionReconnected(TxConnectionManagerImpl.java:474)

                  at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.reconnectManagedConnection(AbstractConnectionManager.java:623)

                  ... 110 more

                Caused by: javax.transaction.SystemException: IJ000356: Failed to enlist: java.lang.Throwable: Unabled to enlist resource, see the previous warnings. tx=TransactionImple < ac, BasicAction: 0:ffffc0a8076e:-633b63bd:565e0a29:26 status: ActionStatus.ABORT_ONLY >

                  at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener$TransactionSynchronization.checkEnlisted(TxConnectionListener.java:653)

                  at org.jboss.jca.core.connectionmanager.listener.TxConnectionListener.enlist(TxConnectionListener.java:356)

                  at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.managedConnectionReconnected(TxConnectionManagerImpl.java:467)

                  ... 111 more

                • 5. Re: TEIID30517 Client thread already involved in a transaction.
                  Steven Hawkins Master

                  > 17:14:37,318 DEBUG [org.teiid.TXN_LOG] (http-localhost/127.0.0.1:8080-1) FA0eWYWFmcug before begin:org.teiid.dqp.internal.process.TransactionServerImpl@2cb19345(FA0eWYWFmcug)

                   

                  This shows that our JDBC driver is in autocommit=false and thus is attempting to start a transaction.  We need more of the TXN_LOG from before this point to determine why the server still thinks there is a transaction associated with the FA0eWYWFmcug session.

                  • 6. Re: TEIID30517 Client thread already involved in a transaction.
                    Guido Lombardi Newbie

                    Steven, the lines before those are:

                    17:14:27,958 DEBUG [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (http-localhost/127.0.0.1:8080-1)  Panel_Control_Dev: returnConnection(533824d3, false) [0/20]

                    17:14:31,807 DEBUG [org.jboss.resteasy.core.SynchronousDispatcher] (http-localhost/127.0.0.1:8080-1)  PathInfo: /BaseRestService/basesPorAnio

                    17:14:31,979 DEBUG [org.apache.catalina.session] (ContainerBackgroundProcessor[StandardEngine[jboss.web]])  Start expire sessions StandardManager at 1449000871979 sessioncount 0

                    17:14:31,979 DEBUG [org.apache.catalina.session] (ContainerBackgroundProcessor[StandardEngine[jboss.web]])  End expire sessions StandardManager processingTime 0 expired sessions: 0

                    17:14:37,283 DEBUG [org.hibernate.SQL] (http-localhost/127.0.0.1:8080-1)  select base0_.baseID as baseID1_4_, base0_.anio as anio2_4_, base0_.nombreBase as nombreBa3_4_ from JDVirtualVDL.Base base0_ where base0_.anio=2015

                    17:14:37,287 DEBUG [org.jboss.jca.core.connectionmanager.pool.strategy.OnePool] (http-localhost/127.0.0.1:8080-1)  JDVirtualVDB: getConnection(null, WrappedConnectionRequestInfo@69730f59[userName=user]) [0/20]

                    17:14:37,318 DEBUG [org.teiid.TXN_LOG] (http-localhost/127.0.0.1:8080-1) FA0eWYWFmcug before begin:org.teiid.dqp.internal.process.TransactionServerImpl@2cb19345(FA0eWYWFmcug)