1 2 Previous Next 21 Replies Latest reply on May 23, 2012 11:52 AM by gamvi01 Go to original post
      • 15. Re: Teiid Embedded connections.
        rareddy

        Steve,

         

        If there is GLOBAL transaction, wouldn't it supercede any autoCommitTxn settings? This case looks little odd.

         

        Ramesh..

        • 16. Re: Teiid Embedded connections.
          gamvi01

          Hi Steve,

           

          autoCommitTxn is true for us. There arent any high level transaction. We are using teiid through TeiidDatasource api with no XA config.

           

          if (serverName != null && serverName.equals("localhost"))

                  {

                      this.teiidDataSource.setServerName(this.serverName);

                      this.teiidDataSource.setPortNumber(this.port);

                  }else{

                      //this.teiidDataSource.setPassthroughAuthentication(true);

                     

                  }

                  this.teiidDataSource.setDatabaseName(this.vdb);

                  this.teiidDataSource.setUser("xxxx");

                  this.teiidDataSource.setPassword("xxxx");

           

           

          <view name="username">

                      <columns>

                          <column name="context" type="varchar"/>

                          <column name="username" type="username"/>

                          <column name="password" type="password"/>

                      </columns>

                      <definition>

                          SELECT context, username, password

                          FROM (call demo.username()) t

                      </definition>

                  </view>

           

          I observed this error too. For the query below, i get the below exception

          21 May 2012 23:02:09,019 PDT DEBUG Execute query:SELECT CHORUS_B."username", CHORUS_B."context", CHORUS_B."password", 'demodata.username' as "__objecttype__" FROM "demodata.username" as CHORUS_B  WHERE (CHORUS_B."username" = ? AND CHORUS_B."context" = ?)   LIMIT 1 -- With params:[NULL_QUERY_CONTEXT, Query Context]

           

          ... 74 more

          Caused by: [QueryValidatorException]Expressions of type OBJECT, CLOB, BLOB, or XML cannot be used in comparison: CHORUS_B.username = ?.

          at org.teiid.dqp.internal.process.Request.validateWithVisitor(Request.java:334)
          at org.teiid.dqp.internal.process.Request.validateQuery(Request.java:300)
          at org.teiid.dqp.internal.process.Request.generatePlan(Request.java:405)
          at org.teiid.dqp.internal.process.PreparedStatementRequest.generatePlan(PreparedStatementRequest.java:154)
          at org.teiid.dqp.internal.process.Request.processRequest(Request.java:460)
          at org.teiid.dqp.internal.process.RequestWorkItem.processNew(RequestWorkItem.java:520)
          at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:277)
          at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)
          at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)
          at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:390)
          at sun.reflect.GeneratedMethodAccessor305.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
          at java.lang.reflect.Method.invoke(Method.java:601)
          at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121)
          at org.teiid.jboss.deployers.RuntimeEngineDeployer$3.invoke(RuntimeEngineDeployer.java:396)
          at $Proxy394.executeRequest(Unknown Source)
          at sun.reflect.GeneratedMethodAccessor305.invoke(Unknown Source)
          at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
          at java.lang.reflect.Method.invoke(Method.java:601)
          at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:112)
          at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
          at java.util.concurrent.FutureTask.run(FutureTask.java:166)
          at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:233)
          at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:220)
          at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:110)
          at $Proxy394.executeRequest(Unknown Source)
          at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:611)
          at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:541)
          ... 77 more
          • 17. Re: Teiid Embedded connections.
            shawkins

            Ramesh,

             

            Yes, if we were enlisted in a global transaction, then we shouldn't initiate a request scoped transaction.  Also if there were a thread bound transaction and we attempted to start a request scoped transaction, then I would expect an earlier error.  Mainly I was just trying to confirm that this was a simple scenario.

             

            Vineela,

             

            Do you mean autoCommitTxn (a Teiid connection/datasource property) is ON?  true is not a valid setting.  Also what does the processor plan look like from SET SHOWPLAN ON?  Also the transaction error message is general enough that an intervening error may have already occurred such that the transaction is no longer valid.  Are there any transaction related log messages prior to the commit error?

             

            As for the the error shown, what is the Teiid type for the username column?  The message indicates that it must be one of OBJECT, XML, CLOB, BLOB or OBJECT, XML if comparable lobs is enabled.

             

            Steve

            • 18. Re: Teiid Embedded connections.
              gamvi01

              Hi Steve,

               

              Yes autoCommitTxn is ON (i guess this is the default value for it right). Basically we are executing insert statements in batch (during inserts to temp table , crete temp table and then insert them ) . Iam unable to capture the processor plan for executeBatch. I enabled DEBUG LOG for com.arjuna but i dont see any additional logs.

               

              after preparedStatement.executeBatch() - > its executing org.teiid.dqp.internal.process.TransactionServerImpl--> public void commit(final String threadId, XidImpl xid, boolean onePhase, boolean singleTM)

               

              6:34:12.816][info][talledLocalContainer] 22 May 2012 16:34:12,814 PDT ERROR [PROCESSOR] Unexpected exception for request m512rznXs9IF.27

               

              [16:34:12.817][info][talledLocalContainer] java.lang.IllegalStateException: BaseTransaction.commit - [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] no transaction!

               

              [16:34:12.817][info][talledLocalContainer]     at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:132)

               

              [16:34:12.817][info][talledLocalContainer]     at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)

               

              [16:34:12.817][info][talledLocalContainer]     at org.teiid.dqp.internal.process.TransactionServerImpl.commitDirect(TransactionServerImpl.java:390)

               

              [16:34:12.817][info][talledLocalContainer]     at org.teiid.dqp.internal.process.TransactionServerImpl.commit(TransactionServerImpl.java:483)

               

              [16:34:12.817][info][talledLocalContainer]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

               

              [16:34:12.817][info][talledLocalContainer]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

               

              [16:34:12.817][info][talledLocalContainer]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

               

              [16:34:12.817][info][talledLocalContainer]     at java.lang.reflect.Method.invoke(Method.java:601)

               

              [16:34:12.818][info][talledLocalContainer]     at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121)

               

              [16:34:12.818][info][talledLocalContainer]     at $Proxy388.commit(Unknown Source)

               

              [16:34:12.818][info][talledLocalContainer]     at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:401)

               

              [16:34:12.818][info][talledLocalContainer]     at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:288)

               

              [16:34:12.818][info][talledLocalContainer]     at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)

               

              [16:34:12.818][info][talledLocalContainer]     at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)

               

              [16:34:12.818][info][talledLocalContainer]     at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:390)

               

              [16:34:12.818][info][talledLocalContainer]     at sun.reflect.GeneratedMethodAccessor466.invoke(Unknown Source)

               

              [16:34:12.818][info][talledLocalContainer]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

               

              [16:34:12.818][info][talledLocalContainer]     at java.lang.reflect.Method.invoke(Method.java:601)

               

              [16:34:12.818][info][talledLocalContainer]     at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121)

               

              [16:34:12.819][info][talledLocalContainer]     at org.teiid.jboss.deployers.RuntimeEngineDeployer$3.invoke(RuntimeEngineDeployer.java:396)

               

              [16:34:12.819][info][talledLocalContainer]     at $Proxy391.executeRequest(Unknown Source)

               

              [16:34:12.819][info][talledLocalContainer]     at sun.reflect.GeneratedMethodAccessor466.invoke(Unknown Source)

               

              [16:34:12.819][info][talledLocalContainer]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

               

              [16:34:12.819][info][talledLocalContainer]     at java.lang.reflect.Method.invoke(Method.java:601)

               

              [16:34:12.819][info][talledLocalContainer]     at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:112)

               

              [16:34:12.819][info][talledLocalContainer]     at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)

               

              [16:34:12.819][info][talledLocalContainer]     at java.util.concurrent.FutureTask.run(FutureTask.java:166)

               

              [16:34:12.819][info][talledLocalContainer]     at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:233)

               

              [16:34:12.819][info][talledLocalContainer]     at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:220)

               

              [16:34:12.819][info][talledLocalContainer]     at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:110)

               

              [16:34:12.819][info][talledLocalContainer]     at $Proxy391.executeRequest(Unknown Source)

               

              [16:34:12.819][info][talledLocalContainer]     at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:611)

               

              [16:34:12.819][info][talledLocalContainer]     at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:541)

               

              [16:34:12.819][info][talledLocalContainer]     at org.teiid.jdbc.PreparedStatementImpl.executeBatch(PreparedStatementImpl.java:221)

               

              [16:34:12.819][info][talledLocalContainer]     at com.ca.chorus.db.LeakDetectingStatement.executeBatch(LeakDetectingStatement.java:283)

               

              [16:34:12.819][info][talledLocalContainer]     at com.ca.chorus.db.DbExecutor.addBatch(DbExecutor.java:995)

               

              [16:34:12.820][info][talledLocalContainer]     at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl$5.next(ObjectsServiceImpl.java:2383)

               

              [16:34:12.820][info][talledLocalContainer]     at com.ca.chorus.db.DbExecutor.withResultSet(DbExecutor.java:345)

               

              [16:34:12.820][info][talledLocalContainer]     at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjectsUsingQueries(ObjectsServiceImpl.java:2360)

               

              [16:34:12.820][info][talledLocalContainer]     at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjectsUsingQueries(ObjectsServiceImpl.java:686)

               

              [16:34:12.820][info][talledLocalContainer]     at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjectsUsingQueries(ObjectsServiceImpl.java:661)

               

              [16:34:12.820][info][talledLocalContainer]     at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjects(ObjectsServiceImpl.java:462)

               

              [16:34:12.820][info][talledLocalContainer]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

               

              [16:34:12.820][info][talledLocalContainer]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

               

              [16:34:12.820][info][talledLocalContainer]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

               

              [16:34:12.820][info][talledLocalContainer]     at java.lang.reflect.Method.invoke(Method.java:601)

               

              [16:34:12.820][info][talledLocalContainer]     at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet.processCall(ChorusGWTServlet.java:235)

               

              [16:34:12.820][info][talledLocalContainer]     at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet$$EnhancerByGuice$$4e542e3e.CGLIB$processCall$4(<generated>)

               

              [16:34:12.820][info][talledLocalContainer]     at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet$$EnhancerByGuice$$4e542e3e$$FastClassByGuice$$c284f1bd.invoke(<generated>)

               

              [16:34:12.820][info][talledLocalContainer]     at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)

               

              [16:34:12.820][info][talledLocalContainer]     at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)

               

              [16:34:12.821][info][talledLocalContainer]     at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:71)

               

              [16:34:12.821][info][talledLocalContainer]     at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:88)

               

              [16:34:12.821][info][talledLocalContainer]     at com.ca.chorus.aop.guice.PerfTracerMethodInterceptor.invoke(PerfTracerMethodInterceptor.java:25)

               

              [16:34:12.821][info][talledLocalContainer]     at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)

               

              [16:34:12.821][info][talledLocalContainer]     at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)

               

              [16:34:12.821][info][talledLocalContainer]     at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet$$EnhancerByGuice$$4e542e3e.processCall(<generated>)

               

              [16:34:12.821][info][talledLocalContainer]     at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)

               

              [16:34:12.821][info][talledLocalContainer]     at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)

               

              [16:34:12.821][info][talledLocalContainer]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

               

              [16:34:12.821][info][talledLocalContainer]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

               

              [16:34:12.821][info][talledLocalContainer]     at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)

               

              [16:34:12.821][info][talledLocalContainer]     at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)

               

              [16:34:12.821][info][talledLocalContainer]     at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)

               

              [16:34:12.821][info][talledLocalContainer]     at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)

               

              [16:34:12.822][info][talledLocalContainer]     at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)

               

              [16:34:12.822][info][talledLocalContainer]     at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)

               

              [16:34:12.822][info][talledLocalContainer]     at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)

               

              [16:34:12.822][info][talledLocalContainer]     at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)

               

              [16:34:12.822][info][talledLocalContainer]     at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:40)

               

              [16:34:12.822][info][talledLocalContainer]     at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:35)

               

              [16:34:12.822][info][talledLocalContainer]     at com.ca.chorus.server.transaction.TransactionRunner.invoke(TransactionRunner.java:23)

               

              [16:34:12.822][info][talledLocalContainer]     at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$9527011e.CGLIB$invoke$1(<generated>)

               

              [16:34:12.822][info][talledLocalContainer]     at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$9527011e$$FastClassByGuice$$6c4c8c20.invoke(<generated>)

               

              [16:34:12.822][info][talledLocalContainer]     at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)

               

              [16:34:12.822][info][talledLocalContainer]     at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)

               

              [16:34:12.822][info][talledLocalContainer]     at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:71)

               

              [16:34:12.822][info][talledLocalContainer]     at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:88)

               

              [16:34:12.822][info][talledLocalContainer]     at com.ca.chorus.server.transaction.TransactionalMethodInterceptor.invoke(TransactionalMethodInterceptor.java:31)

               

              [16:34:12.822][info][talledLocalContainer]     at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)

               

              [16:34:12.822][info][talledLocalContainer]     at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)

               

              [16:34:12.823][info][talledLocalContainer]     at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$9527011e.invoke(<generated>)

               

              [16:34:12.823][info][talledLocalContainer]     at com.ca.mfui.chorusR2.servlet.TransactionFilter.doFilter(TransactionFilter.java:34)

               

              [16:34:12.823][info][talledLocalContainer]     at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163)

               

              [16:34:12.823][info][talledLocalContainer]     at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)

               

              [16:34:12.823][info][talledLocalContainer]     at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)

               

              [16:34:12.823][info][talledLocalContainer]     at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)

               

              [16:34:12.823][info][talledLocalContainer]     at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)

               

              [16:34:12.823][info][talledLocalContainer]     at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)

               

              [16:34:12.823][info][talledLocalContainer]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

               

              [16:34:12.823][info][talledLocalContainer]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

               

              [16:34:12.823][info][talledLocalContainer]     at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

               

              [16:34:12.823][info][talledLocalContainer]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

               

              [16:34:12.823][info][talledLocalContainer]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

               

              [16:34:12.823][info][talledLocalContainer]     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)

               

              [16:34:12.823][info][talledLocalContainer]     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

               

              [16:34:12.823][info][talledLocalContainer]     at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)

               

              [16:34:12.823][info][talledLocalContainer]     at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)

               

              [16:34:12.823][info][talledLocalContainer]     at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)

               

              [16:34:12.824][info][talledLocalContainer]     at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)

               

              [16:34:12.824][info][talledLocalContainer]     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

               

              [16:34:12.824][info][talledLocalContainer]     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

               

              [16:34:12.824][info][talledLocalContainer]     at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)

               

              [16:34:12.824][info][talledLocalContainer]     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

               

              [16:34:12.824][info][talledLocalContainer]     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)

               

              [16:34:12.824][info][talledLocalContainer]     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)

               

              [16:34:12.824][info][talledLocalContainer]     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)

               

              [16:34:12.824][info][talledLocalContainer]     at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

               

              [16:34:12.824][info][talledLocalContainer]     at java.lang.Thread.run(Thread.java:722)

               

              [16:34:12.833][info][talledLocalContainer] 22 May 2012 16:34:12,832 PDT ERROR [ChorusGWTServlet] Exception while processing public abstract com.ca.mfui.chorusR2.client.ChorusResultSetResponse com.ca.mfui.chorusR2.client.service.ObjectsService.getObjects(java.lang.String,com.ca.mfui.chorusR2.client.dataviews.table.FilteringPagingLoadConfig,java.lang.String,java.util.Map,java.lang.String) throws java.lang.Exception,com.ca.mfui.client.UserSessionException

               

              [16:34:12.833][info][talledLocalContainer] java.lang.Exception: Exception java.lang.Exception: Exception org.teiid.jdbc.TeiidSQLException: BaseTransaction.commit - [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] no transaction! occurred on statement Execute query:INSERT INTO oyqDexny("zip","phone","name","userid","sysid") VALUES(?,?,?,?,?) occurred on statement Execute query:SELECT * FROM demodata."user" AS CHORUS_B

               

              [16:34:12.834][info][talledLocalContainer]     at com.ca.chorus.db.DbExecutor.handleSqlException(DbExecutor.java:464)

               

              [16:34:12.834][info][talledLocalContainer]     at com.ca.chorus.db.DbExecutor.withResultSet(DbExecutor.java:397)

               

              [16:34:12.834][info][talledLocalContainer]     at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjectsUsingQueries(ObjectsServiceImpl.java:2360)

               

              [16:34:12.834][info][talledLocalContainer]     at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjectsUsingQueries(ObjectsServiceImpl.java:686)

               

              [16:34:12.834][info][talledLocalContainer]     at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjectsUsingQueries(ObjectsServiceImpl.java:661)

               

              [16:34:12.834][info][talledLocalContainer]     at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjects(ObjectsServiceImpl.java:462)

               

              [16:34:12.834][info][talledLocalContainer]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

               

              [16:34:12.834][info][talledLocalContainer]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

               

              [16:34:12.834][info][talledLocalContainer]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

               

              [16:34:12.834][info][talledLocalContainer]     at java.lang.reflect.Method.invoke(Method.java:601)

               

              [16:34:12.834][info][talledLocalContainer]     at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet.processCall(ChorusGWTServlet.java:235)

               

              [16:34:12.834][info][talledLocalContainer]     at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet$$EnhancerByGuice$$4e542e3e.CGLIB$processCall$4(<generated>)

               

              [16:34:12.834][info][talledLocalContainer]     at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet$$EnhancerByGuice$$4e542e3e$$FastClassByGuice$$c284f1bd.invoke(<generated>)

               

              [16:34:12.835][info][talledLocalContainer]     at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)

               

              [16:34:12.835][info][talledLocalContainer]     at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)

               

              [16:34:12.835][info][talledLocalContainer]     at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:71)

               

              [16:34:12.835][info][talledLocalContainer]     at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:88)

               

              [16:34:12.835][info][talledLocalContainer]     at com.ca.chorus.aop.guice.PerfTracerMethodInterceptor.invoke(PerfTracerMethodInterceptor.java:25)

               

              [16:34:12.835][info][talledLocalContainer]     at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)

               

              [16:34:12.835][info][talledLocalContainer]     at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)

               

              [16:34:12.835][info][talledLocalContainer]     at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet$$EnhancerByGuice$$4e542e3e.processCall(<generated>)

               

              [16:34:12.835][info][talledLocalContainer]     at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)

               

              [16:34:12.835][info][talledLocalContainer]     at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)

               

              [16:34:12.835][info][talledLocalContainer]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

               

              [16:34:12.835][info][talledLocalContainer]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

               

              [16:34:12.836][info][talledLocalContainer]     at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)

               

              [16:34:12.836][info][talledLocalContainer]     at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)

               

              [16:34:12.836][info][talledLocalContainer]     at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)

               

              [16:34:12.836][info][talledLocalContainer]     at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)

               

              [16:34:12.836][info][talledLocalContainer]     at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)

               

              [16:34:12.836][info][talledLocalContainer]     at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)

               

              [16:34:12.836][info][talledLocalContainer]     at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)

               

              [16:34:12.836][info][talledLocalContainer]     at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)

               

              [16:34:12.836][info][talledLocalContainer]     at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:40)

               

              [16:34:12.836][info][talledLocalContainer]     at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:35)

               

              [16:34:12.836][info][talledLocalContainer]     at com.ca.chorus.server.transaction.TransactionRunner.invoke(TransactionRunner.java:23)

               

              [16:34:12.836][info][talledLocalContainer]     at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$9527011e.CGLIB$invoke$1(<generated>)

               

              [16:34:12.836][info][talledLocalContainer]     at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$9527011e$$FastClassByGuice$$6c4c8c20.invoke(<generated>)

               

              [16:34:12.836][info][talledLocalContainer]     at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)

               

              [16:34:12.836][info][talledLocalContainer]     at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)

               

              [16:34:12.836][info][talledLocalContainer]     at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:71)

               

              [16:34:12.837][info][talledLocalContainer]     at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:88)

               

              [16:34:12.837][info][talledLocalContainer]     at com.ca.chorus.server.transaction.TransactionalMethodInterceptor.invoke(TransactionalMethodInterceptor.java:31)

               

              [16:34:12.837][info][talledLocalContainer]     at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)

               

              [16:34:12.837][info][talledLocalContainer]     at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)

               

              [16:34:12.837][info][talledLocalContainer]     at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$9527011e.invoke(<generated>)

               

              [16:34:12.837][info][talledLocalContainer]     at com.ca.mfui.chorusR2.servlet.TransactionFilter.doFilter(TransactionFilter.java:34)

               

              [16:34:12.837][info][talledLocalContainer]     at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163)

               

              [16:34:12.837][info][talledLocalContainer]     at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)

               

              [16:34:12.837][info][talledLocalContainer]     at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)

               

              [16:34:12.837][info][talledLocalContainer]     at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)

               

              [16:34:12.837][info][talledLocalContainer]     at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)

               

              [16:34:12.837][info][talledLocalContainer]     at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)

               

              [16:34:12.837][info][talledLocalContainer]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

               

              [16:34:12.837][info][talledLocalContainer]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

               

              [16:34:12.838][info][talledLocalContainer]     at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

               

              [16:34:12.838][info][talledLocalContainer]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

               

              [16:34:12.838][info][talledLocalContainer]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

               

              [16:34:12.838][info][talledLocalContainer]     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)

               

              [16:34:12.838][info][talledLocalContainer]     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

               

              [16:34:12.838][info][talledLocalContainer]     at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)

               

              [16:34:12.838][info][talledLocalContainer]     at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)

               

              [16:34:12.838][info][talledLocalContainer]     at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)

               

              [16:34:12.838][info][talledLocalContainer]     at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)

               

              [16:34:12.838][info][talledLocalContainer]     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

               

              [16:34:12.838][info][talledLocalContainer]     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

               

              [16:34:12.838][info][talledLocalContainer]     at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)

               

              [16:34:12.838][info][talledLocalContainer]     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

               

              [16:34:12.838][info][talledLocalContainer]     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)

               

              [16:34:12.838][info][talledLocalContainer]     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)

               

              [16:34:12.838][info][talledLocalContainer]     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)

               

              [16:34:12.839][info][talledLocalContainer]     at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

               

              [16:34:12.839][info][talledLocalContainer]     at java.lang.Thread.run(Thread.java:722)

               

              [16:34:12.839][info][talledLocalContainer] Caused by: java.lang.Exception: Exception org.teiid.jdbc.TeiidSQLException: BaseTransaction.commit - [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] no transaction! occurred on statement Execute query:INSERT INTO oyqDexny("zip","phone","name","userid","sysid") VALUES(?,?,?,?,?)

               

              [16:34:12.839][info][talledLocalContainer]     at com.ca.chorus.db.DbExecutor.handleSqlException(DbExecutor.java:464)

               

              [16:34:12.839][info][talledLocalContainer]     at com.ca.chorus.db.DbExecutor.addBatch(DbExecutor.java:1003)

               

              [16:34:12.839][info][talledLocalContainer]     at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl$5.next(ObjectsServiceImpl.java:2383)

               

              [16:34:12.839][info][talledLocalContainer]     at com.ca.chorus.db.DbExecutor.withResultSet(DbExecutor.java:345)

               

              [16:34:12.839][info][talledLocalContainer]     ... 71 more

               

              [16:34:12.839][info][talledLocalContainer] Caused by: org.teiid.jdbc.TeiidSQLException: BaseTransaction.commit - [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] no transaction!

               

              [16:34:12.839][info][talledLocalContainer]     at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)

               

              [16:34:12.839][info][talledLocalContainer]     at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)

               

              [16:34:12.839][info][talledLocalContainer]     at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:636)

               

              [16:34:12.839][info][talledLocalContainer]     at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)

               

              [16:34:12.839][info][talledLocalContainer]     at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:547)

               

              [16:34:12.839][info][talledLocalContainer]     at org.teiid.client.util.ResultsFuture.addCompletionListener(ResultsFuture.java:139)

               

              [16:34:12.839][info][talledLocalContainer]     at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:543)

               

              [16:34:12.839][info][talledLocalContainer]     at org.teiid.jdbc.PreparedStatementImpl.executeBatch(PreparedStatementImpl.java:221)

               

              [16:34:12.840][info][talledLocalContainer]     at com.ca.chorus.db.LeakDetectingStatement.executeBatch(LeakDetectingStatement.java:283)

               

              [16:34:12.840][info][talledLocalContainer]     at com.ca.chorus.db.DbExecutor.addBatch(DbExecutor.java:995)

               

              [16:34:12.840][info][talledLocalContainer]     ... 73 more

               

              [16:34:12.840][info][talledLocalContainer] Caused by: [TeiidException]BaseTransaction.commit - [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] no transaction!

               

              [16:34:12.840][info][talledLocalContainer] 1 [IllegalStateException]BaseTransaction.commit - [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] no transaction!

               

              [16:34:12.840][info][talledLocalContainer]     at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:172)

               

              [16:34:12.840][info][talledLocalContainer]     at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:745)

               

              [16:34:12.840][info][talledLocalContainer]     at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:473)

               

              [16:34:12.840][info][talledLocalContainer]     at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:315)

               

              [16:34:12.840][info][talledLocalContainer]     at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)

               

              [16:34:12.840][info][talledLocalContainer]     at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)

               

              [16:34:12.840][info][talledLocalContainer]     at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:390)

               

              [16:34:12.840][info][talledLocalContainer]     at sun.reflect.GeneratedMethodAccessor466.invoke(Unknown Source)

               

              [16:34:12.840][info][talledLocalContainer]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

               

              [16:34:12.840][info][talledLocalContainer]     at java.lang.reflect.Method.invoke(Method.java:601)

               

              [16:34:12.840][info][talledLocalContainer]     at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121)

               

              [16:34:12.841][info][talledLocalContainer]     at org.teiid.jboss.deployers.RuntimeEngineDeployer$3.invoke(RuntimeEngineDeployer.java:396)

               

              [16:34:12.841][info][talledLocalContainer]     at $Proxy391.executeRequest(Unknown Source)

               

              [16:34:12.841][info][talledLocalContainer]     at sun.reflect.GeneratedMethodAccessor466.invoke(Unknown Source)

               

              [16:34:12.841][info][talledLocalContainer]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

               

              [16:34:12.841][info][talledLocalContainer]     at java.lang.reflect.Method.invoke(Method.java:601)

               

              [16:34:12.841][info][talledLocalContainer]     at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:112)

               

              [16:34:12.841][info][talledLocalContainer]     at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)

               

              [16:34:12.841][info][talledLocalContainer]     at java.util.concurrent.FutureTask.run(FutureTask.java:166)

               

              [16:34:12.841][info][talledLocalContainer]     at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:233)

               

              [16:34:12.841][info][talledLocalContainer]     at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:220)

               

              [16:34:12.841][info][talledLocalContainer]     at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:110)

               

              [16:34:12.841][info][talledLocalContainer]     at $Proxy391.executeRequest(Unknown Source)

               

              [16:34:12.841][info][talledLocalContainer]     at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:611)

               

              [16:34:12.841][info][talledLocalContainer]     at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:541)

               

              [16:34:12.842][info][talledLocalContainer]     ... 76 more

               

              [16:34:12.842][info][talledLocalContainer] Caused by: java.lang.IllegalStateException: BaseTransaction.commit - [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] no transaction!

               

              [16:34:12.842][info][talledLocalContainer]     at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:132)

               

              [16:34:12.842][info][talledLocalContainer]     at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)

               

              [16:34:12.842][info][talledLocalContainer]     at org.teiid.dqp.internal.process.TransactionServerImpl.commitDirect(TransactionServerImpl.java:390)

               

              [16:34:12.842][info][talledLocalContainer]     at org.teiid.dqp.internal.process.TransactionServerImpl.commit(TransactionServerImpl.java:483)

               

              [16:34:12.842][info][talledLocalContainer]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

               

              [16:34:12.842][info][talledLocalContainer]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

               

              [16:34:12.842][info][talledLocalContainer]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

               

              [16:34:12.842][info][talledLocalContainer]     at java.lang.reflect.Method.invoke(Method.java:601)

               

              [16:34:12.842][info][talledLocalContainer]     at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121)

               

              [16:34:12.842][info][talledLocalContainer]     at $Proxy388.commit(Unknown Source)

               

              [16:34:12.842][info][talledLocalContainer]     at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:401)

               

              [16:34:12.842][info][talledLocalContainer]     at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:288)

               

              [16:34:12.

               

              [16:44:06.357][info][talledLocalContainer] 22 May 2012 16:44:06,355 PDT ERROR [PROCESSOR] Unexpected exception for request m512rznXs9IF.35

               

              [16:44:06.357][info][talledLocalContainer] java.lang.IllegalStateException: BaseTransaction.commit - [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] no transaction!

               

              [16:44:06.357][info][talledLocalContainer]     at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:132)

               

              [16:44:06.357][info][talledLocalContainer]     at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)

               

              [16:44:06.357][info][talledLocalContainer]     at org.teiid.dqp.internal.process.TransactionServerImpl.commitDirect(TransactionServerImpl.java:390)

               

              [16:44:06.357][info][talledLocalContainer]     at org.teiid.dqp.internal.process.TransactionServerImpl.commit(TransactionServerImpl.java:483)

               

              [16:44:06.357][info][talledLocalContainer]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

               

              [16:44:06.357][info][talledLocalContainer]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

               

              [16:44:06.358][info][talledLocalContainer]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

               

              [16:44:06.358][info][talledLocalContainer]     at java.lang.reflect.Method.invoke(Method.java:601)

               

              [16:44:06.358][info][talledLocalContainer]     at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121)

               

              [16:44:06.358][info][talledLocalContainer]     at $Proxy388.commit(Unknown Source)

               

              [16:44:06.358][info][talledLocalContainer]     at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:401)

               

              [16:44:06.358][info][talledLocalContainer]     at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:288)

               

              [16:44:06.358][info][talledLocalContainer]     at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)

               

              [16:44:06.358][info][talledLocalContainer]     at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)

               

              [16:44:06.358][info][talledLocalContainer]     at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:390)

               

              [16:44:06.358][info][talledLocalContainer]     at sun.reflect.GeneratedMethodAccessor466.invoke(Unknown Source)

               

              [16:44:06.358][info][talledLocalContainer]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

               

              [16:44:06.358][info][talledLocalContainer]     at java.lang.reflect.Method.invoke(Method.java:601)

               

              [16:44:06.359][info][talledLocalContainer]     at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121)

               

              [16:44:06.359][info][talledLocalContainer]     at org.teiid.jboss.deployers.RuntimeEngineDeployer$3.invoke(RuntimeEngineDeployer.java:396)

               

              [16:44:06.359][info][talledLocalContainer]     at $Proxy391.executeRequest(Unknown Source)

               

              [16:44:06.359][info][talledLocalContainer]     at sun.reflect.GeneratedMethodAccessor466.invoke(Unknown Source)

               

              [16:44:06.359][info][talledLocalContainer]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

               

              [16:44:06.359][info][talledLocalContainer]     at java.lang.reflect.Method.invoke(Method.java:601)

               

              [16:44:06.359][info][talledLocalContainer]     at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:112)

               

              [16:44:06.359][info][talledLocalContainer]     at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)

               

              [16:44:06.359][info][talledLocalContainer]     at java.util.concurrent.FutureTask.run(FutureTask.java:166)

               

              [16:44:06.359][info][talledLocalContainer]     at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:233)

               

              [16:44:06.359][info][talledLocalContainer]     at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:220)

               

              [16:44:06.359][info][talledLocalContainer]     at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:110)

               

              [16:44:06.360][info][talledLocalContainer]     at $Proxy391.executeRequest(Unknown Source)

               

              [16:44:06.360][info][talledLocalContainer]     at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:611)

               

              [16:44:06.360][info][talledLocalContainer]     at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:541)

               

              [16:44:06.360][info][talledLocalContainer]     at org.teiid.jdbc.PreparedStatementImpl.executeBatch(PreparedStatementImpl.java:221)

               

              [16:44:06.360][info][talledLocalContainer]     at com.ca.chorus.db.LeakDetectingStatement.executeBatch(LeakDetectingStatement.java:283)

               

              [16:44:06.360][info][talledLocalContainer]     at com.ca.chorus.db.DbExecutor.addBatch(DbExecutor.java:995)

               

              [16:44:06.360][info][talledLocalContainer]     at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl$5.next(ObjectsServiceImpl.java:2383)

               

              [16:44:06.360][info][talledLocalContainer]     at com.ca.chorus.db.DbExecutor.withResultSet(DbExecutor.java:345)

               

              [16:44:06.360][info][talledLocalContainer]     at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjectsUsingQueries(ObjectsServiceImpl.java:2360)

               

              [16:44:06.360][info][talledLocalContainer]     at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjectsUsingQueries(ObjectsServiceImpl.java:686)

               

              [16:44:06.361][info][talledLocalContainer]     at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjectsUsingQueries(ObjectsServiceImpl.java:661)

               

              [16:44:06.361][info][talledLocalContainer]     at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjects(ObjectsServiceImpl.java:462)

               

              [16:44:06.361][info][talledLocalContainer]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

               

              [16:44:06.361][info][talledLocalContainer]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

               

              [16:44:06.361][info][talledLocalContainer]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

               

              [16:44:06.361][info][talledLocalContainer]     at java.lang.reflect.Method.invoke(Method.java:601)

               

              [16:44:06.361][info][talledLocalContainer]     at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet.processCall(ChorusGWTServlet.java:235)

               

              [16:44:06.361][info][talledLocalContainer]     at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet$$EnhancerByGuice$$4e542e3e.CGLIB$processCall$4(<generated>)

               

              [16:44:06.361][info][talledLocalContainer]     at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet$$EnhancerByGuice$$4e542e3e$$FastClassByGuice$$c284f1bd.invoke(<generated>)

               

              [16:44:06.361][info][talledLocalContainer]     at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)

               

              [16:44:06.362][info][talledLocalContainer]     at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)

               

              [16:44:06.362][info][talledLocalContainer]     at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:71)

               

              [16:44:06.362][info][talledLocalContainer]     at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:88)

               

              [16:44:06.362][info][talledLocalContainer]     at com.ca.chorus.aop.guice.PerfTracerMethodInterceptor.invoke(PerfTracerMethodInterceptor.java:25)

               

              [16:44:06.362][info][talledLocalContainer]     at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)

               

              [16:44:06.362][info][talledLocalContainer]     at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)

               

              [16:44:06.362][info][talledLocalContainer]     at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet$$EnhancerByGuice$$4e542e3e.processCall(<generated>)

               

              [16:44:06.362][info][talledLocalContainer]     at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)

               

              [16:44:06.362][info][talledLocalContainer]     at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)

               

              [16:44:06.362][info][talledLocalContainer]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

               

              [16:44:06.362][info][talledLocalContainer]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

               

              [16:44:06.363][info][talledLocalContainer]     at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)

               

              [16:44:06.363][info][talledLocalContainer]     at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)

               

              [16:44:06.363][info][talledLocalContainer]     at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)

               

              [16:44:06.363][info][talledLocalContainer]     at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)

               

              [16:44:06.363][info][talledLocalContainer]     at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)

               

              [16:44:06.363][info][talledLocalContainer]     at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)

               

              [16:44:06.363][info][talledLocalContainer]     at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)

               

              [16:44:06.363][info][talledLocalContainer]     at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)

               

              [16:44:06.363][info][talledLocalContainer]     at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:40)

               

              [16:44:06.363][info][talledLocalContainer]     at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:35)

               

              [16:44:06.364][info][talledLocalContainer]     at com.ca.chorus.server.transaction.TransactionRunner.invoke(TransactionRunner.java:23)

               

              [16:44:06.364][info][talledLocalContainer]     at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$9527011e.CGLIB$invoke$1(<generated>)

               

              [16:44:06.364][info][talledLocalContainer]     at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$9527011e$$FastClassByGuice$$6c4c8c20.invoke(<generated>)

               

              [16:44:06.364][info][talledLocalContainer]     at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)

               

              [16:44:06.364][info][talledLocalContainer]     at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)

               

              [16:44:06.364][info][talledLocalContainer]     at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:71)

               

              [16:44:06.364][info][talledLocalContainer]     at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:88)

               

              [16:44:06.364][info][talledLocalContainer]     at com.ca.chorus.server.transaction.TransactionalMethodInterceptor.invoke(TransactionalMethodInterceptor.java:31)

               

              [16:44:06.364][info][talledLocalContainer]     at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)

               

              [16:44:06.365][info][talledLocalContainer]     at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)

               

              [16:44:06.365][info][talledLocalContainer]     at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$9527011e.invoke(<generated>)

               

              [16:44:06.365][info][talledLocalContainer]     at com.ca.mfui.chorusR2.servlet.TransactionFilter.doFilter(TransactionFilter.java:34)

               

              [16:44:06.365][info][talledLocalContainer]     at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163)

               

              [16:44:06.365][info][talledLocalContainer]     at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)

               

              [16:44:06.365][info][talledLocalContainer]     at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)

               

              [16:44:06.365][info][talledLocalContainer]     at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)

               

              [16:44:06.365][info][talledLocalContainer]     at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)

               

              [16:44:06.365][info][talledLocalContainer]     at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)

               

              [16:44:06.365][info][talledLocalContainer]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

               

              [16:44:06.365][info][talledLocalContainer]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

               

              [16:44:06.365][info][talledLocalContainer]     at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

               

              [16:44:06.365][info][talledLocalContainer]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

               

              [16:44:06.366][info][talledLocalContainer]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

               

              [16:44:06.366][info][talledLocalContainer]     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)

               

              [16:44:06.366][info][talledLocalContainer]     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

               

              [16:44:06.366][info][talledLocalContainer]     at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)

               

              [16:44:06.366][info][talledLocalContainer]     at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)

               

              [16:44:06.366][info][talledLocalContainer]     at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)

               

              [16:44:06.366][info][talledLocalContainer]     at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)

               

              [16:44:06.366][info][talledLocalContainer]     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

               

              [16:44:06.366][info][talledLocalContainer]     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

               

              [16:44:06.366][info][talledLocalContainer]     at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)

               

              [16:44:06.366][info][talledLocalContainer]     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

               

              [16:44:06.366][info][talledLocalContainer]     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)

               

              [16:44:06.366][info][talledLocalContainer]     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)

               

              [16:44:06.366][info][talledLocalContainer]     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)

               

              [16:44:06.366][info][talledLocalContainer]     at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

               

              [16:44:06.366][info][talledLocalContainer]     at java.lang.Thread.run(Thread.java:722)

               

              [16:44:06.369][info][talledLocalContainer] 22 May 2012 16:44:06,368 PDT ERROR [ChorusGWTServlet] Exception while processing public abstract com.ca.mfui.chorusR2.client.ChorusResultSetResponse com.ca.mfui.chorusR2.client.service.ObjectsService.getObjects(java.lang.String,com.ca.mfui.chorusR2.client.dataviews.table.FilteringPagingLoadConfig,java.lang.String,java.util.Map,java.lang.String) throws java.lang.Exception,com.ca.mfui.client.UserSessionException

               

              [16:44:06.370][info][talledLocalContainer] java.lang.Exception: Exception java.lang.Exception: Exception org.teiid.jdbc.TeiidSQLException: BaseTransaction.commit - [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] no transaction! occurred on statement Execute query:INSERT INTO IytFdNZU("zip","phone","name","userid","sysid") VALUES(?,?,?,?,?) occurred on statement Execute query:SELECT * FROM demodata."user" AS CHORUS_B

               

              [16:44:06.370][info][talledLocalContainer]     at com.ca.chorus.db.DbExecutor.handleSqlException(DbExecutor.java:464)

               

              [16:44:06.370][info][talledLocalContainer]     at com.ca.chorus.db.DbExecutor.withResultSet(DbExecutor.java:397)

               

              [16:44:06.370][info][talledLocalContainer]     at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjectsUsingQueries(ObjectsServiceImpl.java:2360)

               

              [16:44:06.370][info][talledLocalContainer]     at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjectsUsingQueries(ObjectsServiceImpl.java:686)

               

              [16:44:06.370][info][talledLocalContainer]     at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjectsUsingQueries(ObjectsServiceImpl.java:661)

               

              [16:44:06.370][info][talledLocalContainer]     at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjects(ObjectsServiceImpl.java:462)

               

              [16:44:06.370][info][talledLocalContainer]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

               

              [16:44:06.370][info][talledLocalContainer]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

               

              [16:44:06.370][info][talledLocalContainer]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

               

              [16:44:06.370][info][talledLocalContainer]     at java.lang.reflect.Method.invoke(Method.java:601)

               

              [16:44:06.370][info][talledLocalContainer]     at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet.processCall(ChorusGWTServlet.java:235)

               

              [16:44:06.370][info][talledLocalContainer]     at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet$$EnhancerByGuice$$4e542e3e.CGLIB$processCall$4(<generated>)

               

              [16:44:06.370][info][talledLocalContainer]     at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet$$EnhancerByGuice$$4e542e3e$$FastClassByGuice$$c284f1bd.invoke(<generated>)

               

              [16:44:06.370][info][talledLocalContainer]     at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)

               

              [16:44:06.370][info][talledLocalContainer]     at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)

               

              [16:44:06.370][info][talledLocalContainer]     at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:71)

               

              [16:44:06.370][info][talledLocalContainer]     at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:88)

               

              [16:44:06.370][info][talledLocalContainer]     at com.ca.chorus.aop.guice.PerfTracerMethodInterceptor.invoke(PerfTracerMethodInterceptor.java:25)

               

              [16:44:06.371][info][talledLocalContainer]     at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)

               

              [16:44:06.371][info][talledLocalContainer]     at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)

               

              [16:44:06.371][info][talledLocalContainer]     at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet$$EnhancerByGuice$$4e542e3e.processCall(<generated>)

               

              [16:44:06.371][info][talledLocalContainer]     at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)

               

              [16:44:06.371][info][talledLocalContainer]     at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)

               

              [16:44:06.371][info][talledLocalContainer]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

               

              [16:44:06.371][info][talledLocalContainer]     at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

               

              [16:44:06.371][info][talledLocalContainer]     at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)

               

              [16:44:06.371][info][talledLocalContainer]     at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)

               

              [16:44:06.371][info][talledLocalContainer]     at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)

               

              [16:44:06.371][info][talledLocalContainer]     at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)

               

              [16:44:06.371][info][talledLocalContainer]     at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)

               

              [16:44:06.371][info][talledLocalContainer]     at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)

               

              [16:44:06.371][info][talledLocalContainer]     at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)

               

              [16:44:06.371][info][talledLocalContainer]     at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)

               

              [16:44:06.371][info][talledLocalContainer]     at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:40)

               

              [16:44:06.371][info][talledLocalContainer]     at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:35)

               

              [16:44:06.371][info][talledLocalContainer]     at com.ca.chorus.server.transaction.TransactionRunner.invoke(TransactionRunner.java:23)

               

              [16:44:06.372][info][talledLocalContainer]     at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$9527011e.CGLIB$invoke$1(<generated>)

               

              [16:44:06.372][info][talledLocalContainer]     at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$9527011e$$FastClassByGuice$$6c4c8c20.invoke(<generated>)

               

              [16:44:06.372][info][talledLocalContainer]     at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)

               

              [16:44:06.372][info][talledLocalContainer]     at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)

               

              [16:44:06.372][info][talledLocalContainer]     at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:71)

               

              [16:44:06.372][info][talledLocalContainer]     at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:88)

               

              [16:44:06.372][info][talledLocalContainer]     at com.ca.chorus.server.transaction.TransactionalMethodInterceptor.invoke(TransactionalMethodInterceptor.java:31)

               

              [16:44:06.372][info][talledLocalContainer]     at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)

               

              [16:44:06.372][info][talledLocalContainer]     at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)

               

              [16:44:06.372][info][talledLocalContainer]     at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$9527011e.invoke(<generated>)

               

              [16:44:06.372][info][talledLocalContainer]     at com.ca.mfui.chorusR2.servlet.TransactionFilter.doFilter(TransactionFilter.java:34)

               

              [16:44:06.372][info][talledLocalContainer]     at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163)

               

              [16:44:06.372][info][talledLocalContainer]     at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)

               

              [16:44:06.372][info][talledLocalContainer]     at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)

               

              [16:44:06.372][info][talledLocalContainer]     at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)

               

              [16:44:06.372][info][talledLocalContainer]     at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)

               

              [16:44:06.372][info][talledLocalContainer]     at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)

               

              [16:44:06.372][info][talledLocalContainer]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

               

              [16:44:06.373][info][talledLocalContainer]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

               

              [16:44:06.373][info][talledLocalContainer]     at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

               

              [16:44:06.373][info][talledLocalContainer]     at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

               

              [16:44:06.373][info][talledLocalContainer]     at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

               

              [16:44:06.373][info][talledLocalContainer]     at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)

               

              [16:44:06.373][info][talledLocalContainer]     at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

               

              [16:44:06.373][info][talledLocalContainer]     at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)

               

              [16:44:06.373][info][talledLocalContainer]     at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)

               

              [16:44:06.373][info][talledLocalContainer]     at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)

               

              [16:44:06.373][info][talledLocalContainer]     at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)

               

              [16:44:06.373][info][talledLocalContainer]     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

               

              [16:44:06.373][info][talledLocalContainer]     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

               

              [16:44:06.373][info][talledLocalContainer]     at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)

               

              [16:44:06.373][info][talledLocalContainer]     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

               

              [16:44:06.373][info][talledLocalContainer]     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)

               

              [16:44:06.373][info][talledLocalContainer]     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)

               

              [16:44:06.373][info][talledLocalContainer]     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)

               

              [16:44:06.373][info][talledLocalContainer]     at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

               

              [16:44:06.373][info][talledLocalContainer]     at java.lang.Thread.run(Thread.java:722)

               

              [16:44:06.374][info][talledLocalContainer] Caused by: java.lang.Exception: Exception org.teiid.jdbc.TeiidSQLException: BaseTransaction.commit - [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] no transaction! occurred on statement Execute query:INSERT INTO IytFdNZU("zip","phone","name","userid","sysid") VALUES(?,?,?,?,?)

               

              [16:44:06.374][info][talledLocalContainer]     at com.ca.chorus.db.DbExecutor.handleSqlException(DbExecutor.java:464)

               

              [16:44:06.374][info][talledLocalContainer]     at com.ca.chorus.db.DbExecutor.addBatch(DbExecutor.java:1003)

               

              [16:44:06.375][info][talledLocalContainer]     at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl$5.next(ObjectsServiceImpl.java:2383)

               

              [16:44:06.375][info][talledLocalContainer]     at com.ca.chorus.db.DbExecutor.withResultSet(DbExecutor.java:345)

               

              [16:44:06.375][info][talledLocalContainer]     ... 71 more

               

              [16:44:06.375][info][talledLocalContainer] Caused by: org.teiid.jdbc.TeiidSQLException: BaseTransaction.commit - [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] no transaction!

               

              [16:44:06.376][info][talledLocalContainer]     at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)

               

              [16:44:06.376][info][talledLocalContainer]     at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)

               

              [16:44:06.376][info][talledLocalContainer]     at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:636)

               

              [16:44:06.376][info][talledLocalContainer]     at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)

               

              [16:44:06.376][info][talledLocalContainer]     at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:547)

               

              [16:44:06.376][info][talledLocalContainer]     at org.teiid.client.util.ResultsFuture.addCompletionListener(ResultsFuture.java:139)

               

              [16:44:06.376][info][talledLocalContainer]     at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:543)

               

              [16:44:06.376][info][talledLocalContainer]     at org.teiid.jdbc.PreparedStatementImpl.executeBatch(PreparedStatementImpl.java:221)

               

              [16:44:06.376][info][talledLocalContainer]     at com.ca.chorus.db.LeakDetectingStatement.executeBatch(LeakDetectingStatement.java:283)

               

              [16:44:06.376][info][talledLocalContainer]     at com.ca.chorus.db.DbExecutor.addBatch(DbExecutor.java:995)

               

              [16:44:06.376][info][talledLocalContainer]     ... 73 more

               

              [16:44:06.376][info][talledLocalContainer] Caused by: [TeiidException]BaseTransaction.commit - [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] no transaction!

               

              [16:44:06.376][info][talledLocalContainer] 1 [IllegalStateException]BaseTransaction.commit - [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] no transaction!

               

              [16:44:06.376][info][talledLocalContainer]     at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:172)

               

              [16:44:06.376][info][talledLocalContainer]     at org.teiid.dqp.internal.process.RequestWorkItem.sendError(RequestWorkItem.java:745)

               

              [16:44:06.376][info][talledLocalContainer]     at org.teiid.dqp.internal.process.RequestWorkItem.close(RequestWorkItem.java:473)

               

              [16:44:06.376][info][talledLocalContainer]     at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:315)

               

              [16:44:06.376][info][talledLocalContainer]     at org.teiid.dqp.internal.process.AbstractWorkItem.run(AbstractWorkItem.java:49)

               

              [16:44:06.376][info][talledLocalContainer]     at org.teiid.dqp.internal.process.RequestWorkItem.run(RequestWorkItem.java:216)

               

              [16:44:06.377][info][talledLocalContainer]     at org.teiid.dqp.internal.process.DQPCore.executeRequest(DQPCore.java:390)

               

              [16:44:06.377][info][talledLocalContainer]     at sun.reflect.GeneratedMethodAccessor466.invoke(Unknown Source)

               

              [16:44:06.377][info][talledLocalContainer]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

               

              [16:44:06.377][info][talledLocalContainer]     at java.lang.reflect.Method.invoke(Method.java:601)

               

              [16:44:06.377][info][talledLocalContainer]     at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121)

               

              [16:44:06.377][info][talledLocalContainer]     at org.teiid.jboss.deployers.RuntimeEngineDeployer$3.invoke(RuntimeEngineDeployer.java:396)

               

              [16:44:06.377][info][talledLocalContainer]     at $Proxy391.executeRequest(Unknown Source)

               

              [16:44:06.377][info][talledLocalContainer]     at sun.reflect.GeneratedMethodAccessor466.invoke(Unknown Source)

               

              [16:44:06.377][info][talledLocalContainer]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

               

              [16:44:06.377][info][talledLocalContainer]     at java.lang.reflect.Method.invoke(Method.java:601)

               

              [16:44:06.377][info][talledLocalContainer]     at org.teiid.transport.LocalServerConnection$1$1.call(LocalServerConnection.java:112)

               

              [16:44:06.377][info][talledLocalContainer]     at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)

               

              [16:44:06.377][info][talledLocalContainer]     at java.util.concurrent.FutureTask.run(FutureTask.java:166)

               

              [16:44:06.377][info][talledLocalContainer]     at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:233)

               

              [16:44:06.377][info][talledLocalContainer]     at org.teiid.dqp.internal.process.DQPWorkContext.runInContext(DQPWorkContext.java:220)

               

              [16:44:06.377][info][talledLocalContainer]     at org.teiid.transport.LocalServerConnection$1.invoke(LocalServerConnection.java:110)

               

              [16:44:06.377][info][talledLocalContainer]     at $Proxy391.executeRequest(Unknown Source)

               

              [16:44:06.378][info][talledLocalContainer]     at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:611)

               

              [16:44:06.378][info][talledLocalContainer]     at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:541)

               

              [16:44:06.378][info][talledLocalContainer]     ... 76 more

               

              [16:44:06.378][info][talledLocalContainer] Caused by: java.lang.IllegalStateException: BaseTransaction.commit - [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] no transaction!

               

              [16:44:06.378][info][talledLocalContainer]     at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:132)

               

              [16:44:06.378][info][talledLocalContainer]     at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)

               

              [16:44:06.378][info][talledLocalContainer]     at org.teiid.dqp.internal.process.TransactionServerImpl.commitDirect(TransactionServerImpl.java:390)

               

              [16:44:06.378][info][talledLocalContainer]     at org.teiid.dqp.internal.process.TransactionServerImpl.commit(TransactionServerImpl.java:483)

               

              [16:44:06.378][info][talledLocalContainer]     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

               

              [16:44:06.378][info][talledLocalContainer]     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

               

              [16:44:06.378][info][talledLocalContainer]     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

               

              [16:44:06.378][info][talledLocalContainer]     at java.lang.reflect.Method.invoke(Method.java:601)

               

              [16:44:06.378][info][talledLocalContainer]     at org.teiid.logging.LogManager$LoggingProxy.invoke(LogManager.java:121)

               

              [16:44:06.378][info][talledLocalContainer]     at $Proxy388.commit(Unknown Source)

               

              [16:44:06.378][info][talledLocalContainer]     at org.teiid.dqp.internal.process.RequestWorkItem.processMore(RequestWorkItem.java:401)

               

              [16:44:06.378][info][talledLocalContainer]     at org.teiid.dqp.internal.process.RequestWorkItem.process(RequestWorkItem.java:288)

               

              [16:44:06.378][info][talledLocalContainer]     ... 97 more

              • 19. Re: Teiid Embedded connections.
                gamvi01

                Steve

                 

                Normal inserts are fine. But we are experiencing this exception only during batch inserts.

                • 20. Re: Teiid Embedded connections.
                  shawkins

                  Vineela,

                   

                  To sum up, you are in autoCommit = true with autoCommitTxn = DETECT (the default).  Since multiple inserts are batched together that are not pushed together the DETECT setting starts a transaction at the request scope.  I believe that arjuna is then barking because no transactional resource was ever enlisted.  One workaround is to set autoCommitTxn = OFF to disable the creation of request scoped transactions, see TeiidDataSource.setAutoCommitTxn.  An enhancement would be to directly support batched updates in the temp logic.  I'll also reproduce this scenario and see if I get a similar exception.

                   

                  Steve

                  • 21. Re: Teiid Embedded connections.
                    gamvi01

                    Hi Steve,

                     

                    I tried the same and it worked. Thanks.

                     

                    I observed few more issue. Will post once i confirm.

                    1 2 Previous Next