1 2 Previous Next 21 Replies Latest reply on May 23, 2012 11:52 AM by gamvi01

    Teiid Embedded connections.

    gamvi01

      Hi

       

      We are planning to use teiid embedded connections as suggested in forum (https://community.jboss.org/thread/198360).

       

      we have nullified the serverName and port no for TeiidDataSource. But we are getting the below error during launch of our application (where the UI is done using GWT)  .It fails during one of our service call which works fine on socketConnection instead of LocalConnection.

      Are we missing anything ?

       

      [14:03:37.976][info][talledLocalContainer] 16 May 2012 14:03:37,975 PDT ERROR [CoyoteAdapter] An exception or error occurred in the container during the request processing

      [14:03:37.976][info][talledLocalContainer] java.lang.IllegalStateException: Security Context is null

      [14:03:37.976][info][talledLocalContainer]     at org.jboss.web.tomcat.security.SecurityAssociationActions$PopRunAsRoleAction.run(SecurityAssociationActions.java:156)

      [14:03:37.976][info][talledLocalContainer]     at java.security.AccessController.doPrivileged(Native Method)

      [14:03:37.976][info][talledLocalContainer]     at org.jboss.web.tomcat.security.SecurityAssociationActions.popRunAsIdentity(SecurityAssociationActions.java:302)

      [14:03:37.976][info][talledLocalContainer]     at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:193)

      [14:03:37.976][info][talledLocalContainer]     at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)

      [14:03:37.977][info][talledLocalContainer]     at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)

      [14:03:37.977][info][talledLocalContainer]     at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)

      [14:03:37.977][info][talledLocalContainer]     at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

      [14:03:37.977][info][talledLocalContainer]     at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

      [14:03:37.977][info][talledLocalContainer]     at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)

      [14:03:37.977][info][talledLocalContainer]     at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

      [14:03:37.977][info][talledLocalContainer]     at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)

      [14:03:37.977][info][talledLocalContainer]     at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)

      [14:03:37.977][info][talledLocalContainer]     at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)

      [14:03:37.977][info][talledLocalContainer]     at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

      [14:03:37.977][info][talledLocalContainer]     at java.lang.Thread.run(Thread.java:722)

      [14:03:51.572][info][talledLocalContainer] 16 May 2012 14:03:51,572 PDT WARNING [BrowserLogger] Client side exception: Uncaught exception

      [14:03:51.572][info][talledLocalContainer] com.google.gwt.user.client.rpc.InvocationException:  from ObjectsService_Proxy.getObjects   Unknown.Nm(Unknown Source)

      [14:03:51.573][info][talledLocalContainer]    Unknown.kFh(Unknown Source)

      [14:03:51.573][info][talledLocalContainer]    Unknown.KLh(Unknown Source)

      [14:03:51.573][info][talledLocalContainer]    Unknown.nrg(Unknown Source)

      [14:03:51.573][info][talledLocalContainer]    Unknown.Prg(Unknown Source)

      [14:03:51.573][info][talledLocalContainer]    Unknown.anonymous(Unknown Source)

      [14:03:51.573][info][talledLocalContainer]    Unknown.Beg(Unknown Source)

      [14:03:51.573][info][talledLocalContainer]    Unknown.Eeg(Unknown Source)

      [14:03:51.573][info][talledLocalContainer]    Unknown.anonymous(Unknown Source)

      [14:03:51.573][info][talledLocalContainer]    Unknown.anonymous(Unknown Source)

      [14:03:51.573][info][talledLocalContainer]

      [14:03:51.573][info][talledLocalContainer]

      [14:03:51.612][info][talledLocalContainer] 16 May 2012 14:03:51,612 PDT WARNING [BrowserLogger] Client side exception: Uncaught exception

      [14:03:51.612][info][talledLocalContainer] com.google.gwt.user.client.rpc.InvocationException:  from ObjectsService_Proxy.getObjects   Unknown.Nm(Unknown Source)

      [14:03:51.612][info][talledLocalContainer]    Unknown.kFh(Unknown Source)

      [14:03:51.612][info][talledLocalContainer]    Unknown.KLh(Unknown Source)

      [14:03:51.612][info][talledLocalContainer]    Unknown.nrg(Unknown Source)

      [14:03:51.612][info][talledLocalContainer]    Unknown.Prg(Unknown Source)

      [14:03:51.612][info][talledLocalContainer]    Unknown.anonymous(Unknown Source)

      [14:03:51.612][info][talledLocalContainer]    Unknown.Beg(Unknown Source)

      [14:03:51.612][info][talledLocalContainer]    Unknown.Eeg(Unknown Source)

      [14:03:51.612][info][talledLocalContainer]    Unknown.anonymous(Unknown Source)

      [14:03:51.613][info][talledLocalContainer]    Unknown.anonymous(Unknown Source)

      [14:03:51.613][info][talledLocalContainer]

      [14:03:51.613][info][talledLocalContainer]

        • 1. Re: Teiid Embedded connections.
          rareddy

          Vineela,

           

          They are called Local Connections, not embedded connection. You can find details for this at http://docs.jboss.org/teiid/7.7.0.Final/client-developers-guide/en-US/html_single/#local_connection

           

          If you want u can also use driver class to create a Local Connection, just use "jdbc:teiid:<vdb-name>" as URL and pass in user name and password.

           

           

          Ramesh..

          • 2. Re: Teiid Embedded connections.
            shawkins

            Vinneela,

             

            What version are you using?  Does the exception above only occur when Teiid is accessed?  What is the security flow (web-tier, teiid pass-through)?

             

            As Ramesh is getting at the terminology is a little confusing.  Even the term local is not unabiguous as you can also make a local socket connection.  We may want to go further and use a term like "local JNDI" connection to avoid confusion since that is what the driver is doing to lookup the Teiid runtime.

             

            Steve

            • 3. Re: Teiid Embedded connections.
              gamvi01

              Hi Steve

               

              We are using teiid 7.7.1. Yes this exception occurs only when teiid is accessed. when i commented out the code where the access to teiid is required , page launched up just fine.

               

              our application flow is UI (GWT Layer) -> GWT RPC Services (our service) -> TEIID (translator / database).  we are hitting the exception shown above when we launch up our application where GWT is making call to one of the GWT service which internally makes connections to teiid to retrieve the data..

               

              Is there anything we need to configure to make their jndi lookup work?  [14:03:37.976][info][talledLocalContainer] java.lang.IllegalStateException: Security Context is null exception occurs after our servlet exits control and is now at tomcat rendering.

              • 4. Re: Teiid Embedded connections.
                shawkins

                Vineela,

                 

                I think there is an issue here.  Is there a different security domain for Teiid and the web tier? When using a local connection a switch in security contexts will remove the original security context from the calling thread.  Can you log a JIRA?

                 

                Steve

                • 5. Re: Teiid Embedded connections.
                  rareddy

                  Workaround is not define any security domain for Teiid and use "PassthroughAuthentication=true" for the Teiid's Local connection, that will use the Security Context from the web tier. Since this all the same VM security is not issue with Teiid.

                   

                  Ramesh..

                  • 6. Re: Teiid Embedded connections.
                    gamvi01

                    Steve,

                     

                    we have these 2 defined. Should i include this information in JIRA ?

                     

                    <bean name="SessionService" class="org.teiid.services.SessionServiceImpl">

                            <property name="VDBRepository"><inject bean="VDBRepository"/></property>

                            <property name="securityHelper"><inject bean="SecurityHelper"/></property>

                            <!-- Comma separated list of domains to be used to login into Teiid using JDBC connection-->

                            <property name="securityDomains">teiid-security,chorus-teiid-security</property>

                    • 7. Re: Teiid Embedded connections.
                      gamvi01

                      sure will give that a try.

                      • 8. Re: Teiid Embedded connections.
                        rareddy

                        Vineela,

                         

                        Sure, provide all the information. Refer to this thread in the JIRA. We will post the fix right away.

                         

                        Thanks

                         

                        Ramesh..

                        • 9. Re: Teiid Embedded connections.
                          gamvi01
                          • 10. Re: Teiid Embedded connections.
                            rareddy

                            Vineela,

                             

                            I commited the fix, can you check your usecase and let me if it got fixed or not?

                             

                            Thanks.

                             

                            Ramesh..

                            • 11. Re: Teiid Embedded connections.
                              gamvi01

                              Ramesh

                               

                              Previous error is gone. But iam getting the below exception now.

                               

                              21 May 2012 12:25:46,248 PDT ERROR [org.teiid.PROCESSOR] (http-localhost%2F127.0.0.1-8080-1) Unexpected exception for request lfeiquiNqHtR.72

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

                                  at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:132)

                                  at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)

                                  at org.teiid.dqp.internal.process.TransactionServerImpl.commitDirect(TransactionServerImpl.java:390)

                                  at org.teiid.dqp.internal.process.TransactionServerImpl.commit(TransactionServerImpl.java:483)

                                  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                                  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

                                  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 $Proxy393.commit(Unknown Source)

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

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

                                  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.GeneratedMethodAccessor466.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 $Proxy396.executeRequest(Unknown Source)

                                  at sun.reflect.GeneratedMethodAccessor466.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 $Proxy396.executeRequest(Unknown Source)

                                  at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:611)

                                  at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:541)

                                  at org.teiid.jdbc.PreparedStatementImpl.executeBatch(PreparedStatementImpl.java:221)

                                  at com.ca.chorus.db.LeakDetectingStatement.executeBatch(LeakDetectingStatement.java:283)

                                  at com.ca.chorus.db.DbExecutor.addBatch(DbExecutor.java:952)

                                  at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl$5.next(ObjectsServiceImpl.java:2386)

                                  at com.ca.chorus.db.DbExecutor.withResultSet(DbExecutor.java:345)

                                  at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjectsUsingQueries(ObjectsServiceImpl.java:2363)

                                  at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjectsUsingQueries(ObjectsServiceImpl.java:689)

                                  at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjectsUsingQueries(ObjectsServiceImpl.java:664)

                                  at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjects(ObjectsServiceImpl.java:465)

                                  at sun.reflect.GeneratedMethodAccessor501.invoke(Unknown Source)

                                  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                                  at java.lang.reflect.Method.invoke(Method.java:601)

                                  at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet.processCall(ChorusGWTServlet.java:235)

                                  at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet$$EnhancerByGuice$$8edb9a4c.CGLIB$processCall$1(<generated>)

                                  at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet$$EnhancerByGuice$$8edb9a4c$$FastClassByGuice$$b4c8c34a.invoke(<generated>)

                                  at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)

                                  at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)

                                  at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:71)

                                  at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:88)

                                  at com.ca.chorus.aop.guice.PerfTracerMethodInterceptor.invoke(PerfTracerMethodInterceptor.java:25)

                                  at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)

                                  at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)

                                  at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet$$EnhancerByGuice$$8edb9a4c.processCall(<generated>)

                                  at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)

                                  at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)

                                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

                                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

                                  at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)

                                  at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)

                                  at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)

                                  at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)

                                  at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)

                                  at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)

                                  at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)

                                  at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)

                                  at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:40)

                                  at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:35)

                                  at com.ca.chorus.server.transaction.TransactionRunner.invoke(TransactionRunner.java:23)

                                  at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$52b45a35.CGLIB$invoke$1(<generated>)

                                  at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$52b45a35$$FastClassByGuice$$7fd67847.invoke(<generated>)

                                  at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)

                                  at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)

                                  at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:71)

                                  at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:88)

                                  at com.ca.chorus.server.transaction.TransactionalMethodInterceptor.invoke(TransactionalMethodInterceptor.java:31)

                                  at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)

                                  at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)

                                  at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$52b45a35.invoke(<generated>)

                                  at com.ca.mfui.chorusR2.servlet.TransactionFilter.doFilter(TransactionFilter.java:34)

                                  at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163)

                                  at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)

                                  at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)

                                  at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)

                                  at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)

                                  at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)

                                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                                  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                                  at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

                                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                                  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                                  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)

                                  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

                                  at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)

                                  at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)

                                  at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)

                                  at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)

                                  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

                                  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

                                  at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)

                                  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

                                  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)

                                  at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)

                                  at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)

                                  at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

                                  at java.lang.Thread.run(Thread.java:722)

                              21 May 2012 12:25:46,254 PDT DEBUG [com.ca.chorus.db.DbExecutor] (http-localhost%2F127.0.0.1-8080-1) 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 OuvwEGqx("zip","phone","name","userid","sysid") VALUES(?,?,?,?,?) with parameters [zip 2, phone 25, name 25, user 1024, sysid 2]

                              org.teiid.jdbc.TeiidSQLException: BaseTransaction.commit - [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] no transaction!

                                  at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)

                                  at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)

                                  at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:636)

                                  at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)

                                  at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:547)

                                  at org.teiid.client.util.ResultsFuture.addCompletionListener(ResultsFuture.java:139)

                                  at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:543)

                                  at org.teiid.jdbc.PreparedStatementImpl.executeBatch(PreparedStatementImpl.java:221)

                                  at com.ca.chorus.db.LeakDetectingStatement.executeBatch(LeakDetectingStatement.java:283)

                                  at com.ca.chorus.db.DbExecutor.addBatch(DbExecutor.java:952)

                                  at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl$5.next(ObjectsServiceImpl.java:2386)

                                  at com.ca.chorus.db.DbExecutor.withResultSet(DbExecutor.java:345)

                                  at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjectsUsingQueries(ObjectsServiceImpl.java:2363)

                                  at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjectsUsingQueries(ObjectsServiceImpl.java:689)

                                  at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjectsUsingQueries(ObjectsServiceImpl.java:664)

                                  at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjects(ObjectsServiceImpl.java:465)

                                  at sun.reflect.GeneratedMethodAccessor501.invoke(Unknown Source)

                                  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                                  at java.lang.reflect.Method.invoke(Method.java:601)

                                  at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet.processCall(ChorusGWTServlet.java:235)

                                  at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet$$EnhancerByGuice$$8edb9a4c.CGLIB$processCall$1(<generated>)

                                  at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet$$EnhancerByGuice$$8edb9a4c$$FastClassByGuice$$b4c8c34a.invoke(<generated>)

                                  at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)

                                  at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)

                                  at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:71)

                                  at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:88)

                                  at com.ca.chorus.aop.guice.PerfTracerMethodInterceptor.invoke(PerfTracerMethodInterceptor.java:25)

                                  at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)

                                  at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)

                                  at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet$$EnhancerByGuice$$8edb9a4c.processCall(<generated>)

                                  at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)

                                  at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)

                                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

                                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

                                  at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)

                                  at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)

                                  at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)

                                  at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)

                                  at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)

                                  at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)

                                  at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)

                                  at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)

                                  at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:40)

                                  at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:35)

                                  at com.ca.chorus.server.transaction.TransactionRunner.invoke(TransactionRunner.java:23)

                                  at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$52b45a35.CGLIB$invoke$1(<generated>)

                                  at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$52b45a35$$FastClassByGuice$$7fd67847.invoke(<generated>)

                                  at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)

                                  at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)

                                  at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:71)

                                  at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:88)

                                  at com.ca.chorus.server.transaction.TransactionalMethodInterceptor.invoke(TransactionalMethodInterceptor.java:31)

                                  at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)

                                  at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)

                                  at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$52b45a35.invoke(<generated>)

                                  at com.ca.mfui.chorusR2.servlet.TransactionFilter.doFilter(TransactionFilter.java:34)

                                  at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163)

                                  at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)

                                  at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)

                                  at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)

                                  at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)

                                  at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)

                                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                                  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                                  at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

                                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                                  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                                  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)

                                  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

                                  at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)

                                  at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)

                                  at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)

                                  at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)

                                  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

                                  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

                                  at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)

                                  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

                                  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)

                                  at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)

                                  at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)

                                  at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

                                  at java.lang.Thread.run(Thread.java:722)

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

                              1 [IllegalStateException]BaseTransaction.commit - [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] no transaction!

                                  at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:172)

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

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

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

                                  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.GeneratedMethodAccessor466.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 $Proxy396.executeRequest(Unknown Source)

                                  at sun.reflect.GeneratedMethodAccessor466.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 $Proxy396.executeRequest(Unknown Source)

                                  at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:611)

                                  at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:541)

                                  ... 75 more

                              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!

                                  at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:132)

                                  at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)

                                  at org.teiid.dqp.internal.process.TransactionServerImpl.commitDirect(TransactionServerImpl.java:390)

                                  at org.teiid.dqp.internal.process.TransactionServerImpl.commit(TransactionServerImpl.java:483)

                                  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                                  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

                                  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 $Proxy393.commit(Unknown Source)

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

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

                                  ... 96 more

                              21 May 2012 12:25:46,256 PDT DEBUG [com.ca.chorus.db.DbExecutor] (http-localhost%2F127.0.0.1-8080-1) 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 OuvwEGqx("zip","phone","name","userid","sysid") VALUES(?,?,?,?,?) occurred on statement Execute query:SELECT * FROM demodata."user" AS CHORUS_B with parameters []

                              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 OuvwEGqx("zip","phone","name","userid","sysid") VALUES(?,?,?,?,?)

                                  at com.ca.chorus.db.DbExecutor.handleSqlException(DbExecutor.java:451)

                                  at com.ca.chorus.db.DbExecutor.addBatch(DbExecutor.java:960)

                                  at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl$5.next(ObjectsServiceImpl.java:2386)

                                  at com.ca.chorus.db.DbExecutor.withResultSet(DbExecutor.java:345)

                                  at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjectsUsingQueries(ObjectsServiceImpl.java:2363)

                                  at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjectsUsingQueries(ObjectsServiceImpl.java:689)

                                  at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjectsUsingQueries(ObjectsServiceImpl.java:664)

                                  at com.ca.mfui.chorusR2.server.service.ObjectsServiceImpl.getObjects(ObjectsServiceImpl.java:465)

                                  at sun.reflect.GeneratedMethodAccessor501.invoke(Unknown Source)

                                  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)

                                  at java.lang.reflect.Method.invoke(Method.java:601)

                                  at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet.processCall(ChorusGWTServlet.java:235)

                                  at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet$$EnhancerByGuice$$8edb9a4c.CGLIB$processCall$1(<generated>)

                                  at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet$$EnhancerByGuice$$8edb9a4c$$FastClassByGuice$$b4c8c34a.invoke(<generated>)

                                  at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)

                                  at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)

                                  at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:71)

                                  at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:88)

                                  at com.ca.chorus.aop.guice.PerfTracerMethodInterceptor.invoke(PerfTracerMethodInterceptor.java:25)

                                  at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)

                                  at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)

                                  at com.ca.mfui.chorusR2.servlet.ChorusGWTServlet$$EnhancerByGuice$$8edb9a4c.processCall(<generated>)

                                  at com.google.gwt.user.server.rpc.RemoteServiceServlet.processPost(RemoteServiceServlet.java:248)

                                  at com.google.gwt.user.server.rpc.AbstractRemoteServiceServlet.doPost(AbstractRemoteServiceServlet.java:62)

                                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:637)

                                  at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

                                  at com.google.inject.servlet.ServletDefinition.doService(ServletDefinition.java:263)

                                  at com.google.inject.servlet.ServletDefinition.service(ServletDefinition.java:178)

                                  at com.google.inject.servlet.ManagedServletPipeline.service(ManagedServletPipeline.java:91)

                                  at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:62)

                                  at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)

                                  at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)

                                  at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)

                                  at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)

                                  at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:40)

                                  at com.ca.mfui.chorusR2.servlet.TransactionFilter$1.call(TransactionFilter.java:35)

                                  at com.ca.chorus.server.transaction.TransactionRunner.invoke(TransactionRunner.java:23)

                                  at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$52b45a35.CGLIB$invoke$1(<generated>)

                                  at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$52b45a35$$FastClassByGuice$$7fd67847.invoke(<generated>)

                                  at com.google.inject.internal.cglib.proxy.$MethodProxy.invokeSuper(MethodProxy.java:228)

                                  at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)

                                  at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:71)

                                  at com.ca.chorus.aop.guice.PerfTracer.trace(PerfTracer.java:88)

                                  at com.ca.chorus.server.transaction.TransactionalMethodInterceptor.invoke(TransactionalMethodInterceptor.java:31)

                                  at com.google.inject.internal.InterceptorStackCallback$InterceptedMethodInvocation.proceed(InterceptorStackCallback.java:72)

                                  at com.google.inject.internal.InterceptorStackCallback.intercept(InterceptorStackCallback.java:52)

                                  at com.ca.chorus.server.transaction.TransactionRunner$$EnhancerByGuice$$52b45a35.invoke(<generated>)

                                  at com.ca.mfui.chorusR2.servlet.TransactionFilter.doFilter(TransactionFilter.java:34)

                                  at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:163)

                                  at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)

                                  at com.google.inject.servlet.FilterDefinition.doFilter(FilterDefinition.java:168)

                                  at com.google.inject.servlet.FilterChainInvocation.doFilter(FilterChainInvocation.java:58)

                                  at com.google.inject.servlet.ManagedFilterPipeline.dispatch(ManagedFilterPipeline.java:118)

                                  at com.google.inject.servlet.GuiceFilter.doFilter(GuiceFilter.java:113)

                                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                                  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                                  at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)

                                  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)

                                  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

                                  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)

                                  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)

                                  at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)

                                  at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)

                                  at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)

                                  at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)

                                  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

                                  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)

                                  at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)

                                  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

                                  at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)

                                  at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)

                                  at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)

                                  at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)

                                  at java.lang.Thread.run(Thread.java:722)

                              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!

                                  at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:113)

                                  at org.teiid.jdbc.TeiidSQLException.create(TeiidSQLException.java:70)

                                  at org.teiid.jdbc.StatementImpl.postReceiveResults(StatementImpl.java:636)

                                  at org.teiid.jdbc.StatementImpl.access$100(StatementImpl.java:62)

                                  at org.teiid.jdbc.StatementImpl$2.onCompletion(StatementImpl.java:547)

                                  at org.teiid.client.util.ResultsFuture.addCompletionListener(ResultsFuture.java:139)

                                  at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:543)

                                  at org.teiid.jdbc.PreparedStatementImpl.executeBatch(PreparedStatementImpl.java:221)

                                  at com.ca.chorus.db.LeakDetectingStatement.executeBatch(LeakDetectingStatement.java:283)

                                  at com.ca.chorus.db.DbExecutor.addBatch(DbExecutor.java:952)

                                  ... 72 more

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

                              1 [IllegalStateException]BaseTransaction.commit - [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] [com.arjuna.ats.internal.jta.transaction.arjunacore.notx] no transaction!

                                  at org.teiid.client.ResultsMessage.setException(ResultsMessage.java:172)

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

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

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

                                  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.GeneratedMethodAccessor466.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 $Proxy396.executeRequest(Unknown Source)

                                  at sun.reflect.GeneratedMethodAccessor466.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 $Proxy396.executeRequest(Unknown Source)

                                  at org.teiid.jdbc.StatementImpl.execute(StatementImpl.java:611)

                                  at org.teiid.jdbc.StatementImpl.executeSql(StatementImpl.java:541)

                                  ... 75 more

                              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!

                                  at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:132)

                                  at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)

                                  at org.teiid.dqp.internal.process.TransactionServerImpl.commitDirect(TransactionServerImpl.java:390)

                                  at org.teiid.dqp.internal.process.TransactionServerImpl.commit(TransactionServerImpl.java:483)

                                  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

                                  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)

                                  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 $Proxy393.commit(Unknown Source)

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

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

                              • 12. Re: Teiid Embedded connections.
                                rareddy

                                Teiid is failing to do a commit on your source. This may be because you may have configured your -ds.xml file for source configured in-correctly.  Please read and make sure your configuration is correct http://docs.jboss.org/teiid/7.7.0.Final/reference/en-US/html_single/#d0e6159

                                 

                                Ramesh..

                                • 13. Re: Teiid Embedded connections.
                                  gamvi01

                                  will refer to that. But my current configuation is :

                                   

                                   

                                  <connection-factories>

                                     

                                     <no-tx-connection-factory>

                                        <jndi-name>DEMODATA-FILE-DS</jndi-name>

                                        <rar-name>teiid-connector-file.rar</rar-name>

                                        <connection-definition>javax.resource.cci.ConnectionFactory</connection-definition>     

                                              

                                       

                                        <config-property name="ParentDirectory" type="java.lang.String">${jboss.server.home.dir}/deploy/chorus/demo-data</config-property>

                                             

                                       

                                   

                                        <max-pool-size>20</max-pool-size>

                                      </no-tx-connection-factory>

                                  </connection-factories>

                                  • 14. Re: Teiid Embedded connections.
                                    shawkins

                                    This appears to be a REQUEST scoped transaction.  What is your setting for autoCommitTxn?  Assuming that you are in the default autoCommitTxn=DETECT mode, what does your processor plan look like?  And are there any higher level transactions present and are you using Teiid through TeiidDataSource with an XA config?

                                     

                                    Steve

                                    1 2 Previous Next