-
15. Re: Teiid Embedded connections.
rareddy May 21, 2012 11:16 PM (in response to shawkins)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 May 22, 2012 2:27 AM (in response to shawkins)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 May 22, 2012 2:28 PM (in response to gamvi01)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 May 22, 2012 8:17 PM (in response to shawkins)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 May 23, 2012 1:06 AM (in response to gamvi01)Steve
Normal inserts are fine. But we are experiencing this exception only during batch inserts.
-
20. Re: Teiid Embedded connections.
shawkins May 23, 2012 9:48 AM (in response to gamvi01)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 May 23, 2012 11:52 AM (in response to shawkins)Hi Steve,
I tried the same and it worked. Thanks.
I observed few more issue. Will post once i confirm.