14 Replies Latest reply on Oct 21, 2008 11:54 AM by jaikiran pai

    Exception in Distributed transaction in EJB3.0

    Ajay Kumar Newbie

      Hello All,
      I am evaluating distributed trransaction using JBOSS4.2.2.
      I have oracle9i database X and another oracle 9i database Y.
      Both the databse X and Y is located in the diffrent country and machine.
      I want to make changes in the databas X and database Y in one transaction.
      I have created a stateles session bean and using entity bean I tried to update the both database X and Y in one transaction.
      But I am getting following exeception at run time :-

      11:36:51,117 WARN [loggerI18N] [com.arjuna.ats.internal.jta.transaction.arjunacore.lastResource.disallow]
      [com.arjuna.ats.internal.jta.transaction.arjunacore.lastResource.disallow]
      Adding multiple last resources is disallowed. Current resource is org.jboss.resource.connectionmanager.
      TxConnectionManager$LocalXAResource@c0c6f6
      11:36:51,126 WARN [JDBCExceptionReporter] SQL Error: 0, SQLState: null
      11:36:51,126 ERROR [JDBCExceptionReporter] Could not enlist in transaction on entering meta-aware object!;
       - nested throwable: (javax.transaction.SystemException: java.lang.Throwable: Unabled to enlist resource,
       see the previous warnings. tx=TransactionImple < ac, BasicAction: -35fe69f3:d89f:48fc1fc2:31
       status: ActionStatus.ABORT_ONLY >); - nested throwable: (org.jboss.resource.JBossResourceException:
       Could not enlist in transaction on entering meta-aware object!;
      - nested throwable: (javax.transaction.SystemException: java.lang.Throwable:
      Unabled to enlist resource, see the previous warnings.
      tx=TransactionImple < ac, BasicAction: -35fe69f3:d89f:48fc1fc2:31 status: ActionStatus.ABORT_ONLY >))
      11:36:51,127 ERROR [AbstractFlushingEventListener] Could not synchronize database state with session
      org.hibernate.exception.GenericJDBCException: Cannot open connection
       at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
       at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
       at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
       at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
       at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)
       at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
       at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:94)
       at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.java:87)
       at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatcher.java:222)
       at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2224)
       at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2660)
       at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.java:56)
       at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:250)
       at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:234)
       at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:141)
       at org.hibernate.event.def.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:298)
       at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlushEventListener.java:27)
       at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
      exception in thread "main" java.lang.IllegalStateException: BaseTransaction.rollback - [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.rollback(BaseTransaction.java:158)
      at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.rollback(BaseTransactionManagerDelegate.java:126)
      at org.jboss.ejb3.tx.UserTransactionImpl.rollback(UserTransactionImpl.java:91)
      at itac.ccc.server.ASServerComp.callASService(ASServerComp.java:59)
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
      at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
      at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      at org.jboss.ejb3.tx.BMTInterceptor.handleStateless(BMTInterceptor.java:71)
      at org.jboss.ejb3.tx.BMTInterceptor.invoke(BMTInterceptor.java:131)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:95)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)
      at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:110)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:46)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:304)
      at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:106)
      at org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:82)
      at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:769)
      at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:573)
      at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:373)
      at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:166)
      at org.jboss.remoting.MicroRemoteClientInvoker.invoke(MicroRemoteClientInvoker.java:163)
      at org.jboss.remoting.Client.invoke(Client.java:1634)
      at org.jboss.remoting.Client.invoke(Client.java:548)
      at org.jboss.aspects.remoting.InvokeRemoteInterceptor.invoke(InvokeRemoteInterceptor.java:62)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      at org.jboss.aspects.tx.ClientTxPropagationInterceptor.invoke(ClientTxPropagationInterceptor.java:67)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      at org.jboss.aspects.security.SecurityClientInterceptor.invoke(SecurityClientInterceptor.java:53)
      at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
      at org.jboss.ejb3.remoting.IsLocalInterceptor.invoke(IsLocalInterceptor.java:74)
      


      Can any one help me out why I am not able to complete the distributed transaction. As per EJB3.0 specification, EJB3.0 should support the distributed transaction.
      Thnaks a lot in advance for your help in this matter.

      with best regards,
      Ajay Kumar,
      ST Microelectronics Ltd.
      India.

        • 1. Re: Exception in Distributed transaction in EJB3.0
          jaikiran pai Master

           

          and using entity bean


          You mean EJB3.0 entities, right? Or are you talking about EJB2.x entity beans?

          Please post your datasource configuration file (*-ds.xml) which has the configurations for database X and Y.




          • 2. Re: Exception in Distributed transaction in EJB3.0
            Ajay Kumar Newbie

            Thanks a lot for the reply.
            I have used EJB3.O entity bean in my session bean to update the databses's table.
            The XML configuration files of databases are put in the deploy directory of JBOSS which details are as follwos:-

            Databas X:
            ---------

            <?xml version="1.0" encoding="UTF-8"?>
            
            <!-- ===================================================================== -->
            <!-- -->
            <!-- JBoss Server Configuration -->
            <!-- -->
            <!-- ===================================================================== -->
            
            <!-- $Id: oracle-ds.xml 63175 2007-05-21 16:26:06Z rrajesh $ -->
            <!-- ==================================================================== -->
            <!-- Datasource config for Oracle originally from Steven Coy -->
            <!-- ==================================================================== -->
            
            
            <datasources>
             <local-tx-datasource>
             <jndi-name>ASDS</jndi-name>
             <connection-url>jdbc:oracle:thin:@pkgqcenv.dlh.st.com:1541:xcdb</connection-url>
             <!--
            
             Here are a couple of the possible OCI configurations.
             For more information, see http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/java.920/a96654/toc.htm
            
             <connection-url>jdbc:oracle:oci:@youroracle-tns-name</connection-url>
             or
             <connection-url>jdbc:oracle:oci:@(description=(address=(host=youroraclehost)(protocol=tcp)(port=1521))(connect_data=(SERVICE_NAME=yourservicename)))</connection-url>
            
             Clearly, its better to have TNS set up properly.
             -->
             <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
             <user-name>sicomdba</user-name>
             <password>useme123</password>
             <!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -->
             <!--valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name-->
             <!-- Checks the Oracle error codes and messages for fatal errors -->
             <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
             <!-- sql to call when connection is created
             <new-connection-sql>some arbitrary sql</new-connection-sql>
             -->
            
             <!-- sql to call on an existing pooled connection when it is obtained from pool - the OracleValidConnectionChecker is prefered
             <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
             -->
            
             <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml -->
             <metadata>
             <type-mapping>Oracle9i</type-mapping>
             </metadata>
             </local-tx-datasource>
            </datasources>
            


            Database Y
            -----------
            <?xml version="1.0" encoding="UTF-8"?>
            
            <!-- ===================================================================== -->
            <!-- -->
            <!-- JBoss Server Configuration -->
            <!-- -->
            <!-- ===================================================================== -->
            
            <!-- $Id: oracle-ds.xml 63175 2007-05-21 16:26:06Z rrajesh $ -->
            <!-- ==================================================================== -->
            <!-- Datasource config for Oracle originally from Steven Coy -->
            <!-- ==================================================================== -->
            
            <datasources>
             <local-tx-datasource>
             <jndi-name>euxDS</jndi-name>
             <connection-url>jdbc:oracle:thin:@eux074.sgp.st.com:2591:s2xy</connection-url>
             <!--
            
             Here are a couple of the possible OCI configurations.
             For more information, see http://otn.oracle.com/docs/products/oracle9i/doc_library/release2/java.920/a96654/toc.htm
            
             <connection-url>jdbc:oracle:oci:@youroracle-tns-name</connection-url>
             or
             <connection-url>jdbc:oracle:oci:@(description=(address=(host=youroraclehost)(protocol=tcp)(port=1521))(connect_data=(SERVICE_NAME=yourservicename)))</connection-url>
            
             Clearly, its better to have TNS set up properly.
             -->
             <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
             <user-name>xcomdba</user-name>
             <password>paxy99</password>
             <!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -->
             <!--valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name-->
             <!-- Checks the Oracle error codes and messages for fatal errors -->
             <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
             <!-- sql to call when connection is created
             <new-connection-sql>some arbitrary sql</new-connection-sql>
             -->
            
             <!-- sql to call on an existing pooled connection when it is obtained from pool - the OracleValidConnectionChecker is prefered
             <check-valid-connection-sql>some arbitrary sql</check-valid-connection-sql>
             -->
            
             <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml -->
             <metadata>
             <type-mapping>Oracle9i</type-mapping>
             </metadata>
             </local-tx-datasource>
            </datasources
            
            


            • 3. Re: Exception in Distributed transaction in EJB3.0
              jaikiran pai Master

               

              <local-tx-datasource>


              As i suspected, you are not using a XA datasource. See the datasource documentation for using XA datasources:

              http://www.jboss.org/community/docs/DOC-9498

              http://www.jboss.org/community/docs/DOC-9328

              • 4. Re: Exception in Distributed transaction in EJB3.0
                Ajay Kumar Newbie

                Thanks a lot for the reply.
                I have changed the datasouurce configuration file XA as follows :-

                <?xml version="1.0" encoding="UTF-8"?>
                
                <!-- ===================================================================== -->
                <!-- -->
                <!-- JBoss Server Configuration -->
                <!-- -->
                <!-- ===================================================================== -->
                
                <!-- $Id: oracle-xa-ds.xml 63175 2007-05-21 16:26:06Z rrajesh $ -->
                
                <!-- ===================================================================== -->
                <!-- ATTENTION: DO NOT FORGET TO SET Pad=true IN transaction-service.xml -->
                <!-- ===================================================================== -->
                
                <datasources>
                 <xa-datasource>
                 <jndi-name>ASDS1</jndi-name>
                 <track-connection-by-tx/>
                 <isSameRM-override-value>false</isSameRM-override-value>
                 <xa-datasource-class>oracle.jdbc.xa.client.OracleXADataSource</xa-datasource-class>
                 <xa-datasource-property name="URL">jdbc:oracle:thin:@pkgqcenv.dlh.st.com:1541:qcdb</xa-datasource-property>
                 <xa-datasource-property name="User">sicomdba</xa-datasource-property>
                 <xa-datasource-property name="Password">sched123</xa-datasource-property>
                 <!-- Uses the pingDatabase method to check a connection is still valid before handing it out from the pool -->
                 <!--valid-connection-checker-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleValidConnectionChecker</valid-connection-checker-class-name-->
                 <!-- Checks the Oracle error codes and messages for fatal errors -->
                 <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter</exception-sorter-class-name>
                 <!-- Oracles XA datasource cannot reuse a connection outside a transaction once enlisted in a global transaction and vice-versa -->
                 <no-tx-separate-pools/>
                
                 <!-- corresponding type-mapping in the standardjbosscmp-jdbc.xml -->
                 <metadata>
                 <type-mapping>Oracle9i</type-mapping>
                 </metadata>
                 </xa-datasource>
                
                 <mbean code="org.jboss.resource.adapter.jdbc.vendor.OracleXAExceptionFormatter"
                 name="jboss.jca:service=OracleXAExceptionFormatter">
                 <depends optional-attribute-name="TransactionManagerService">jboss:service=TransactionManager</depends>
                 </mbean>
                
                </datasources>
                
                


                But I am getting following exception while launching the JBOSS server :-

                java.io.IOException: No such file or directory
                 at java.io.UnixFileSystem.createFileExclusively(Native Method)
                 at java.io.File.checkAndCreate(File.java:1345)
                 at java.io.File.createTempFile(File.java:1434)
                 at org.jboss.deployment.MainDeployer.makeLocalCopy(MainDeployer.java:1185)
                 at org.jboss.deployment.MainDeployer.init(MainDeployer.java:851)
                 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:809)
                 at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
                 at sun.reflect.GeneratedMethodAccessor18.invoke(Unknown Source)
                 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                 at java.lang.reflect.Method.invoke(Method.java:585)
                 at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                 at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                 at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
                 at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                 at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
                 at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                 at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                 at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                 at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                 at $Proxy9.deploy(Unknown Source)
                 at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
                 at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:610)
                 at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
                 at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.loop(AbstractDeploymentScanner.java:274)
                 at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.run(AbstractDeploymentScanner.java:225)
                14:10:21,389 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=euxDS1' to JNDI name 'java:euxDS1'
                14:10:21,390 WARN [TransactionManagerService] XAExceptionFormatters are not supported by the JBossTS Transaction Service - this warning can safely be ignored
                
                


                what could be the reason for it.Could you please help me.


                • 5. Re: Exception in Distributed transaction in EJB3.0
                  jaikiran pai Master

                  I don't think this exception is related to the changes that you did to your -ds.xml. What else do you see on the console? Can you post the entire console logs?

                  • 6. Re: Exception in Distributed transaction in EJB3.0
                    Ajay Kumar Newbie

                    The below is complete tarce of error coming on the JBOSS console :-

                    15:29:32,307 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=ASDS1' to JNDI name 'java:ASDS1'
                    15:29:32,334 WARN [TransactionManagerService] XAExceptionFormatters are not supported by the JBossTS Transaction Service - this warning can safely be ignored
                    15:29:32,423 ERROR [MainDeployer] Could not create deployment: file:/app/jboss-4.2.2.GA/server/ajayks/deploy/oracle1-xa-ds.xml
                    org.jboss.deployment.DeploymentException: Trying to install an already registered mbean: jboss.jca:service=OracleXAExceptionFormatter
                     at org.jboss.system.ServiceCreator.install(ServiceCreator.java:103)
                     at org.jboss.system.ServiceConfigurator.internalInstall(ServiceConfigurator.java:451)
                     at org.jboss.system.ServiceConfigurator.install(ServiceConfigurator.java:171)
                     at org.jboss.system.ServiceController.install(ServiceController.java:226)
                     at sun.reflect.GeneratedMethodAccessor22.invoke(Unknown Source)
                     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                     at java.lang.reflect.Method.invoke(Method.java:585)
                     at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                     at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                     at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
                     at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                     at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                     at $Proxy4.install(Unknown Source)
                     at org.jboss.deployment.SARDeployer.create(SARDeployer.java:249)
                     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                     at java.lang.reflect.Method.invoke(Method.java:585)
                     at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                     at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                     at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
                     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                     at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
                     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                     at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                     at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                     at $Proxy42.create(Unknown Source)
                     at org.jboss.deployment.XSLSubDeployer.create(XSLSubDeployer.java:192)
                     at org.jboss.deployment.MainDeployer.create(MainDeployer.java:969)
                     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:818)
                     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
                     at sun.reflect.GeneratedMethodAccessor20.invoke(Unknown Source)
                     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                     at java.lang.reflect.Method.invoke(Method.java:585)
                     at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                     at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                     at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
                     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                     at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
                     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                     at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                     at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                     at $Proxy9.deploy(Unknown Source)
                     at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:421)
                     at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:634)
                     at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:263)
                     at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:336)
                     at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
                     at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
                     at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
                     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                     at java.lang.reflect.Method.invoke(Method.java:585)
                     at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                     at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                     at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
                     at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                     at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
                     at $Proxy0.start(Unknown Source)
                     at org.jboss.system.ServiceController.start(ServiceController.java:417)
                     at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
                     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                     at java.lang.reflect.Method.invoke(Method.java:585)
                     at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                     at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                     at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
                     at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                     at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                     at $Proxy4.start(Unknown Source)
                     at org.jboss.deployment.SARDeployer.start(SARDeployer.java:302)
                     at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
                     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
                     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
                     at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:766)
                     at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                     at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                     at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                     at java.lang.reflect.Method.invoke(Method.java:585)
                     at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
                     at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
                     at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
                     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                     at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
                     at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
                     at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
                     at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
                     at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
                     at $Proxy5.deploy(Unknown Source)
                     at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:482)
                     at org.jboss.system.server.ServerImpl.start(ServerImpl.java:362)
                     at org.jboss.Main.boot(Main.java:200)
                     at org.jboss.Main$1.run(Main.java:508)
                     at java.lang.Thread.run(Thread.java:595)
                    
                    ---------------------------------------------
                    15:29:37,932 INFO [JmxKernelAbstraction] installing MBean: jboss.j2ee:jar=tx2.jar,name=RemoteServiceBean,service=EJB3 with dependencies:
                    
                    15:29:37,876 INFO [JmxKernelAbstraction] persistence.units:jar=tx2.jar,unitName=ASDomain
                    15:29:37,917 INFO [EJBContainer] STARTED EJB: itac.ccc.server.LocalServiceBean ejbName: LocalServiceBean
                    15:29:37,932 INFO [JmxKernelAbstraction] creating wrapper delegate for: org.jboss.ejb3.stateless.StatelessContainer
                    15:29:37,932 INFO [JmxKernelAbstraction] installing MBean: jboss.j2ee:jar=tx2.jar,name=RemoteServiceBean,service=EJB3 with dependencies:
                    15:29:37,932 INFO [JmxKernelAbstraction] persistence.units:jar=tx2.jar,unitName=euxDomain
                    15:29:37,935 INFO [EJB3Deployer] Deployed: file:/app/jboss-4.2.2.GA/server/ajayks/deploy/tx2.jar
                    15:29:37,966 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=.../deploy/jmx-console.war/
                    15:29:38,076 ERROR [URLDeploymentScanner] Incomplete Deployment listing:
                    
                    --- Incompletely deployed packages ---
                    org.jboss.deployment.DeploymentInfo@ce3974bf { url=file:/app/jboss-4.2.2.GA/server/ajayks/deploy/oracle1-xa-ds.xml }
                     deployer: org.jboss.deployment.XSLSubDeployer@e76438
                     status: Deployment FAILED reason: Trying to install an already registered mbean: jboss.jca:service=OracleXAExceptionFormatter
                     state: FAILED
                     watch: file:/app/jboss-4.2.2.GA/server/ajayks/deploy/oracle1-xa-ds.xml
                     altDD: null
                     lastDeployed: 1224496772369
                     lastModified: 1224496772000
                     mbeans:
                    
                    --- MBeans waiting for other MBeans ---
                    ObjectName: jboss.mq:service=InvocationLayer,type=HTTP
                     State: CONFIGURED
                     I Depend On:
                     jboss.mq:service=Invoker
                     jboss.web:service=WebServer
                    
                    ObjectName: jboss.mq.destination:service=Topic,name=testTopic
                     State: CONFIGURED
                     I Depend On:
                     jboss.mq:service=DestinationManager
                     jboss.mq:service=SecurityManager
                    
                    ObjectName: jboss.mq.destination:service=Topic,name=securedTopic
                     State: CONFIGURED
                     I Depend On:
                     jboss.mq:service=DestinationManager
                     jboss.mq:service=SecurityManager
                    
                    ObjectName: jboss.mq.destination:service=Topic,name=testDurableTopic
                     State: CONFIGURED
                     I Depend On:
                     jboss.mq:service=DestinationManager
                     jboss.mq:service=SecurityManager
                    ObjectName: jboss.mq.destination:service=Queue,name=testQueue
                     State: CONFIGURED
                     I Depend On:
                     jboss.mq:service=DestinationManager
                     jboss.mq:service=SecurityManager
                    
                    ObjectName: jboss.mq.destination:service=Queue,name=A
                     State: CONFIGURED
                     I Depend On:
                     jboss.mq:service=DestinationManager
                    
                    ObjectName: jboss.mq.destination:service=Queue,name=B
                     State: CONFIGURED
                     I Depend On:
                     jboss.mq:service=DestinationManager
                    
                    ObjectName: jboss.mq.destination:service=Queue,name=C
                     State: CONFIGURED
                     I Depend On:
                     jboss.mq:service=DestinationManager
                    
                    ObjectName: jboss.mq.destination:service=Queue,name=D
                     State: CONFIGURED
                     I Depend On:
                     jboss.mq:service=DestinationManager
                    
                    ObjectName: jboss.mq.destination:service=Queue,name=ex
                     State: CONFIGURED
                     I Depend On:
                     jboss.mq:service=DestinationManager
                    
                    ObjectName: jboss.mq:service=Invoker
                     State: CONFIGURED
                     I Depend On:
                     jboss.mq:service=TracingInterceptor
                     jboss:service=Naming
                     Depends On Me:
                     jboss.mq:service=InvocationLayer,type=HTTP
                     jboss.mq:service=InvocationLayer,type=JVM
                     jboss.mq:service=InvocationLayer,type=UIL2
                    
                    ObjectName: jboss.mq:service=TracingInterceptor
                     State: CONFIGURED
                     I Depend On:
                     jboss.mq:service=SecurityManager
                     Depends On Me:
                     jboss.mq:service=Invoker
                    
                    ObjectName: jboss.mq:service=SecurityManager
                     State: CONFIGURED
                     I Depend On:
                     jboss.security:service=JaasSecurityManager
                     jboss.mq:service=DestinationManager
                     Depends On Me:
                    jboss.mq.destination:service=Topic,name=securedTopic
                     jboss.mq.destination:service=Topic,name=testDurableTopic
                     jboss.mq.destination:service=Queue,name=testQueue
                     jboss.mq:service=TracingInterceptor
                     jboss.mq.destination:service=Queue,name=DLQ
                    
                    ObjectName: jboss.mq.destination:service=Queue,name=DLQ
                     State: CONFIGURED
                     I Depend On:
                     jboss.mq:service=DestinationManager
                     jboss.mq:service=SecurityManager
                    
                    ObjectName: jboss.mq:service=InvocationLayer,type=JVM
                     State: CONFIGURED
                     I Depend On:
                     jboss.mq:service=Invoker
                    
                    ObjectName: jboss.mq:service=DestinationManager
                     State: CONFIGURED
                     I Depend On:
                     jboss.mq:service=MessageCache
                     jboss.mq:service=PersistenceManager
                     jboss.mq:service=StateManager
                     Depends On Me:
                     jboss.mq.destination:service=Topic,name=testTopic
                     jboss.mq.destination:service=Topic,name=securedTopic
                     jboss.mq.destination:service=Topic,name=testDurableTopic
                     jboss.mq.destination:service=Queue,name=testQueue
                     jboss.mq.destination:service=Queue,name=A
                     jboss.mq.destination:service=Queue,name=B
                     jboss.mq.destination:service=Queue,name=C
                     jboss.mq.destination:service=Queue,name=D
                     jboss.mq.destination:service=Queue,name=ex
                     jboss.mq:service=SecurityManager
                     jboss.mq.destination:service=Queue,name=DLQ
                    
                    ObjectName: jboss.mq:service=PersistenceManager
                     State: CONFIGURED
                     I Depend On:
                     jboss.jca:service=DataSourceBinding,name=ASDS
                     Depends On Me:
                     jboss.mq:service=DestinationManager
                    
                    ObjectName: jboss.mq:service=InvocationLayer,type=UIL2
                     State: CONFIGURED
                     I Depend On:
                     jboss.mq:service=Invoker
                    
                    ObjectName: persistence.units:jar=tx2.jar,unitName=euxDomain
                     State: NOTYETINSTALLED
                     I Depend On:
                     jboss.jca:name=euxDS1,service=DataSourceBinding
                     Depends On Me:
                     jboss.j2ee:jar=tx2.jar,name=RemoteServiceBean,service=EJB3
                    
                    ObjectName: jboss.j2ee:jar=tx2.jar,name=ASServerComp,service=EJB3
                     State: NOTYETINSTALLED
                     I Depend On:
                     jboss.j2ee:jar=tx2.jar,name=LocalServiceBean,service=EJB3
                     jboss.j2ee:jar=tx2.jar,name=RemoteServiceBean,service=EJB3
                    
                    ObjectName: jboss.j2ee:jar=tx2.jar,name=RemoteServiceBean,service=EJB3
                     State: NOTYETINSTALLED
                     I Depend On:
                     persistence.units:jar=tx2.jar,unitName=euxDomain
                     Depends On Me:
                     jboss.j2ee:jar=tx2.jar,name=ASServerComp,service=EJB3
                    
                    --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
                    ObjectName: jboss.jca:service=DataSourceBinding,name=ASDS
                     State: NOTYETINSTALLED
                     Depends On Me:
                     jboss.mq:service=PersistenceManager
                    
                    ObjectName: jboss.jca:name=euxDS1,service=DataSourceBinding
                     State: NOTYETINSTALLED
                     Depends On Me:
                     persistence.units:jar=tx2.jar,unitName=euxDomain
                    
                    
                    


                    • 7. Re: Exception in Distributed transaction in EJB3.0
                      jaikiran pai Master

                       

                      org.jboss.deployment.DeploymentException: Trying to install an already registered mbean: jboss.jca:service=OracleXAExceptionFormatter


                      Remove the following from your datasource files:

                      <mbean code="org.jboss.resource.adapter.jdbc.vendor.OracleXAExceptionFormatter"
                       name="jboss.jca:service=OracleXAExceptionFormatter">
                       <depends optional-attribute-name="TransactionManagerService">jboss:service=TransactionManager</depends>
                       </mbean>
                      




                      • 8. Re: Exception in Distributed transaction in EJB3.0
                        Ajay Kumar Newbie

                        After removing the part of datsource XML flle stating with "mbean code" there was no error at the time of deployment.
                        But I am getting following error message at run time after initiating distributed transaction from client :-

                        15:47:20,643 INFO [SessionFactoryObjectFactory] Factory name: persistence.units:jar=tx2.jar,unitName=euxDomain
                        15:47:20,644 INFO [NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces}
                        15:47:20,644 INFO [SessionFactoryObjectFactory] Bound factory to JNDI name: persistence.units:jar=tx2.jar,unitName=euxDomain
                        15:47:20,644 WARN [SessionFactoryObjectFactory] InitialContext did not implement EventContext
                        15:47:20,644 INFO [NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces}
                        15:47:20,651 INFO [EJBContainer] STARTED EJB: itac.ccc.server.RemoteServiceBean ejbName: RemoteServiceBean
                        15:47:20,669 INFO [EJBContainer] STARTED EJB: itac.ccc.server.ASServerComp ejbName: ASServerComp
                        15:56:26,988 ERROR [XAManagedConnectionFactory] End transaction failed for XAResource
                        oracle.jdbc.xa.OracleXAException
                         at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1270)
                         at oracle.jdbc.xa.client.OracleXAResource.end(OracleXAResource.java:480)
                         at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.end(XAManagedConnection.java:147)
                         at org.jboss.resource.connectionmanager.xa.JcaXAResourceWrapper.end(JcaXAResourceWrapper.java:58)
                         at com.arjuna.ats.internal.jta.resources.arjunacore.XAResourceRecord.topLevelPrepare(XAResourceRecord.java:259)
                         at com.arjuna.ats.arjuna.coordinator.BasicAction.doPrepare(BasicAction.java:2871)
                         at com.arjuna.ats.arjuna.coordinator.BasicAction.doPrepare(BasicAction.java:2828)
                         at com.arjuna.ats.arjuna.coordinator.BasicAction.prepare(BasicAction.java:2382)
                         at com.arjuna.ats.arjuna.coordinator.BasicAction.End(BasicAction.java:1783)
                         at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:88)
                         at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)
                         at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1389)
                         at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:135)
                         at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:87)
                         at org.jboss.ejb3.tx.UserTransactionImpl.commit(UserTransactionImpl.java:82)
                         at itac.ccc.server.ASServerComp.callASService(ASServerComp.java:36)
                         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                         at java.lang.reflect.Method.invoke(Method.java:585)
                         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
                         at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
                         at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
                         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                         at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)
                         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                         at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
                         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                         at org.jboss.ejb3.tx.BMTInterceptor.handleStateless(BMTInterceptor.java:71)
                         at org.jboss.ejb3.tx.BMTInterceptor.invoke(BMTInterceptor.java:131)
                         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                         at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:95)
                         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                         at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)
                         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                         at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)
                         at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:110)
                         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                         at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:46)
                         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                         at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
                         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                         at org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:82)
                         at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:769)
                         at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:573)
                         at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:373)
                         at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:166)
                        15:56:26,990 WARN [TxConnectionManager] Connection error occured: org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@422e25[state=NORMAL mc=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection@9fe45c handles=0 lastUse=1224498386742 permit=true trackByTx=true mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@14966cc context=org.jboss.resource.connectionmanager.InternalManagedConnectionPool@1fc1b56 xaResource=org.jboss.resource.connectionmanager.xa.JcaXAResourceWrapper@e38fae txSync=null]
                        oracle.jdbc.xa.OracleXAException
                         at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1270)
                         at oracle.jdbc.xa.client.OracleXAResource.end(OracleXAResource.java:480)
                         at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.end(XAManagedConnection.java:147)
                         at org.jboss.resource.connectionmanager.xa.JcaXAResourceWrapper.end(JcaXAResourceWrapper.java:58)
                         at com.arjuna.ats.internal.jta.resources.arjunacore.XAResourceRecord.topLevelPrepare(XAResourceRecord.java:259)
                         at com.arjuna.ats.arjuna.coordinator.BasicAction.doPrepare(BasicAction.java:2871)
                         at com.arjuna.ats.arjuna.coordinator.BasicAction.doPrepare(BasicAction.java:2828)
                         at com.arjuna.ats.arjuna.coordinator.BasicAction.prepare(BasicAction.java:2382)
                         at com.arjuna.ats.arjuna.coordinator.BasicAction.End(BasicAction.java:1783)
                         at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:88)
                         at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)
                         at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1389)
                         at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:135)
                         at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:87)
                         at org.jboss.ejb3.tx.UserTransactionImpl.commit(UserTransactionImpl.java:82)
                         at itac.ccc.server.ASServerComp.callASService(ASServerComp.java:36)
                         at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                         at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                         at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                         at java.lang.reflect.Method.invoke(Method.java:585)
                         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
                         at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
                         at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
                         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                         at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)
                         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                         at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
                         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                         at org.jboss.ejb3.tx.BMTInterceptor.handleStateless(BMTInterceptor.java:71)
                         at org.jboss.ejb3.tx.BMTInterceptor.invoke(BMTInterceptor.java:131)
                         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                         at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:95)
                         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                         at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)
                         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                         at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)
                         at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:110)
                         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                         at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:46)
                         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                         at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
                         at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                        
                        
                        


                        Could please help me out to find the problem.


                        • 9. Re: Exception in Distributed transaction in EJB3.0
                          jaikiran pai Master

                           

                          15:56:26,988 ERROR [XAManagedConnectionFactory] End transaction failed for XAResource oracle.jdbc.xa.OracleXAException


                          The console log does not have much information about the exception. You might want to check the server.log file to see if you find any clues.


                          • 10. Re: Exception in Distributed transaction in EJB3.0
                            Ajay Kumar Newbie

                            The following are extract of error message from the server.log file for your perusal :-


                            oracle.jdbc.xa.OracleXAException
                            at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1270)



                            6950 at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:573)
                            6953 Caused by: java.sql.SQLException: ORA-02089: COMMIT is not allowed in a subordinate session
                            6954

                             6790 oracle.jdbc.xa.OracleXAException
                             6791 at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1270)
                             6792 at oracle.jdbc.xa.client.OracleXAResource.end(OracleXAResource.java:480)
                             6793 at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.end(XAManagedConnection.java:147)
                             6794 at org.jboss.resource.connectionmanager.xa.JcaXAResourceWrapper.end(JcaXAResourceWrapper.java:58)
                             6795 at com.arjuna.ats.internal.jta.resources.arjunacore.XAResourceRecord.topLevelPrepare(XAResourceRecord.java:25 9)
                             6796 at com.arjuna.ats.arjuna.coordinator.BasicAction.doPrepare(BasicAction.java:2871)
                             6797 at com.arjuna.ats.arjuna.coordinator.BasicAction.doPrepare(BasicAction.java:2828)
                             6798 at com.arjuna.ats.arjuna.coordinator.BasicAction.prepare(BasicAction.java:2382)
                             6799 at com.arjuna.ats.arjuna.coordinator.BasicAction.End(BasicAction.java:1783)
                             6800 at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:88)
                             6801 at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)
                             6802 at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple .java:1389)
                             6803 at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:135)
                             6804 at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:87)
                             6805 at org.jboss.ejb3.tx.UserTransactionImpl.commit(UserTransactionImpl.java:82)
                             6806 at itac.ccc.server.ASServerComp.callASService(ASServerComp.java:36)
                             6807 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                             6808 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                             6809 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                             6810 at java.lang.reflect.Method.invoke(Method.java:585)
                             6811 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
                             6812 at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
                             6813 at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
                             6814 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                             6815 at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInter ceptor.java:54)
                             6816 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                             6817 at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
                             6818 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                             6819 at org.jboss.ejb3.tx.BMTInterceptor.handleStateless(BMTInterceptor.java:71)
                             6820 at org.jboss.ejb3.tx.BMTInterceptor.invoke(BMTInterceptor.java:131)
                             6821 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                             6822 at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:95)
                             6823 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                             6824 at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)
                             6825 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                             6826 at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)
                             6827 at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:110)
                             6828 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                             6829 at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:46)
                             6830 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                             6831 at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
                             6832 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                             6833 at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:304)
                             6834 at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:106)
                             6835 at org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:82)
                             6836 at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:769)
                             6837 at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:573)
                             6838 at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:373)
                             6839 at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:166)
                             6840 2008-10-20 18:46:34,823 WARN [org.jboss.resource.connectionmanager.TxConnectionManager] Connection error occured: or g.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@422e25[state=NORMAL mc=org.jboss.res ource.adapter.jdbc.xa.XAManagedConnection@66db4e handles=0 lastUse=1224508594610 permit=true trackByTx=true mcp=org.j boss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@c80825 context=org.jboss.resource.connectionmanage r.InternalManagedConnectionPool@8ee5c0 xaResource=org.jboss.resource.connectionmanager.xa.JcaXAResourceWrapper@e38fae txSync=null]
                             6841 oracle.jdbc.xa.OracleXAException
                             6842 at oracle.jdbc.xa.OracleXAResource.checkError(OracleXAResource.java:1270)
                             6843 at oracle.jdbc.xa.client.OracleXAResource.end(OracleXAResource.java:480)
                             6844 at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.end(XAManagedConnection.java:147)
                             6845 at org.jboss.resource.connectionmanager.xa.JcaXAResourceWrapper.end(JcaXAResourceWrapper.java:58)
                             6846 at com.arjuna.ats.internal.jta.resources.arjunacore.XAResourceRecord.topLevelPrepare(XAResourceRecord.java:25 9)
                             6847 at com.arjuna.ats.arjuna.coordinator.BasicAction.doPrepare(BasicAction.java:2871)
                             6848 at com.arjuna.ats.arjuna.coordinator.BasicAction.doPrepare(BasicAction.java:2828)
                             6849 at com.arjuna.ats.arjuna.coordinator.BasicAction.prepare(BasicAction.java:2382)
                             6850 at com.arjuna.ats.arjuna.coordinator.BasicAction.End(BasicAction.java:1783)
                             6851 at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:88)
                             6852 at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)
                             6853 at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple .java:1389)
                             6854 at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:135)
                             6855 at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:87)
                             6856 at org.jboss.ejb3.tx.UserTransactionImpl.commit(UserTransactionImpl.java:82)
                             6857 at itac.ccc.server.ASServerComp.callASService(ASServerComp.java:36)
                             6858 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                             6859 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                             6860 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                             6861 at java.lang.reflect.Method.invoke(Method.java:585)
                             6862 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
                             6863 at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
                             6864 at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
                             6865 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                             6866 at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInter ceptor.java:54)
                             6867 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                             6868 at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
                             6869 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                             6870 at org.jboss.ejb3.tx.BMTInterceptor.handleStateless(BMTInterceptor.java:71)
                             6871 at org.jboss.ejb3.tx.BMTInterceptor.invoke(BMTInterceptor.java:131)
                             6872 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                             6873 at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:95)
                             6874 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                             6875 at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)
                             6876 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                             6877 at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)
                             6878 at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:110)
                             6879 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                            s.internal.jta.resources.arjunacore.norecoveryxa] Could not find new XAResource to use for recovering non-serializable XAResource < 131075, 28, 26, 1--35fe69f3:cfb3:48fc5675:3d-35fe69f3:cfb3:48fc5675:48 >
                             18:50:09,886 WARN [loggerI18N] [com.arjuna.ats.internal.jta.resources.arjunacore.norecoveryxa] [com.arjuna.ats.internal.jta.resources.arjunacore.norecoveryxa] Could not find new XAResource to use for recovering non-serializable XAResource < 131075, 28, 26, 1--35fe69f3:cfb3:48fc5675:db-35fe69f3:cfb3:48fc5675:e6 >
                             18:50:09,889 WARN [loggerI18N] [com.arjuna.ats.internal.jta.resources.arjunacore.norecoveryxa] [com.arjuna.ats.internal.jta.resources.arjunacore.norecoveryxa] Could not find new XAResource to use for recovering non-serializable XAResource < 131075, 28, 26, 1--35fe69f3:9abf:48fc8469:10-35fe69f3:9abf:48fc8469:1b >
                             18:50:09,896 WARN [loggerI18N] [com.arjuna.ats.internal.jta.resources.arjunacore.norecoveryxa] [com.arjuna.ats.internal.jta.resources.arjunacore.norecoveryxa] Could not find new XAResource to use for recovering non-serializable XAResource < 131075, 28, 26, 1--35fe69f3:9a7b:48fc835b:11-35fe69f3:9a7b:48fc835b:1c >
                             6880 at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:46)
                             6881 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                             6882 at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
                             6883 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                             6884 at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:304)
                             6885 at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:106)
                             6886 at org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:82)
                             6887 at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:769)
                             6888 at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:573)
                             6889 at org.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:373)
                             6890 at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:166)
                             6891 2008-10-20 18:46:34,833 DEBUG [org.jboss.resource.connectionmanager.JBossManagedConnectionPool] Exception destroying ManagedConnection org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener@422e25[state=DES TROYED mc=org.jboss.resource.adapter.jdbc.xa.XAManagedConnection@66db4e handles=0 lastUse=1224508594610 permit=false trackByTx=false mcp=org.jboss.resource.connectionmanager.JBossManagedConnectionPool$OnePool@c80825 context=org.jboss. resource.connectionmanager.InternalManagedConnectionPool@8ee5c0 xaResource=org.jboss.resource.connectionmanager.xa.Jc aXAResourceWrapper@e38fae txSync=null]
                             6892 2008-10-20 18:46:34,835 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.parentTraceEnabled=true
                             6893 2008-10-20 18:46:34,836 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.nestedTraceEnabled=fals e
                             6894 2008-10-20 18:46:34,836 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.detectDuplicateNesting= true
                             6895 org.jboss.resource.JBossResourceException: SQLException; - nested throwable: (java.sql.SQLException: ORA-02089: COMMI T is not allowed in a subordinate session
                             6896 )
                             6897 at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.checkException(BaseWrapperManagedConnection.j ava:636)
                             6898 at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.destroy(XAManagedConnection.java:104)
                             6899 at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.doDestroy(InternalManagedConnectionPool .java:608)
                             6900 at org.jboss.resource.connectionmanager.InternalManagedConnectionPool.returnConnection(InternalManagedConnect ionPool.java:384)
                             6901 at org.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.returnConnection(JBossManagedConn ectionPool.java:629)
                             6902 at org.jboss.resource.connectionmanager.BaseConnectionManager2.returnManagedConnection(BaseConnectionManager2 .java:363)
                             6903 at org.jboss.resource.connectionmanager.BaseConnectionManager2$BaseConnectionEventListener.connectionErrorOcc urred(BaseConnectionManager2.java:756)
                             6904 at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.connectionErrorOccurred (TxConnectionManager.java:692)
                            6905 at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.broadcastConnectionError(BaseWrapperManagedCo nnection.java:305)
                             6906 at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.end(XAManagedConnection.java:152)
                             6907 at org.jboss.resource.connectionmanager.xa.JcaXAResourceWrapper.end(JcaXAResourceWrapper.java:58)
                             6908 at com.arjuna.ats.internal.jta.resources.arjunacore.XAResourceRecord.topLevelPrepare(XAResourceRecord.java:25 9)
                             6909 at com.arjuna.ats.arjuna.coordinator.BasicAction.doPrepare(BasicAction.java:2871)
                             6910 at com.arjuna.ats.arjuna.coordinator.BasicAction.doPrepare(BasicAction.java:2828)
                             6911 at com.arjuna.ats.arjuna.coordinator.BasicAction.prepare(BasicAction.java:2382)
                             6912 at com.arjuna.ats.arjuna.coordinator.BasicAction.End(BasicAction.java:1783)
                             6913 at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:88)
                             6914 at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:177)
                             6915 at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple .java:1389)
                             6916 at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:135)
                             6917 at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:87)
                             6918 at org.jboss.ejb3.tx.UserTransactionImpl.commit(UserTransactionImpl.java:82)
                             6919 at itac.ccc.server.ASServerComp.callASService(ASServerComp.java:36)
                             6920 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                             6921 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
                             6922 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                             6923 at java.lang.reflect.Method.invoke(Method.java:585)
                             6924 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)
                             6925 at org.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)
                             6926 at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)
                             6927 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                             6928 at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInter ceptor.java:54)
                             6929 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                             6930 at org.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)
                             6931 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                             6932 at org.jboss.ejb3.tx.BMTInterceptor.handleStateless(BMTInterceptor.java:71)
                             6933 at org.jboss.ejb3.tx.BMTInterceptor.invoke(BMTInterceptor.java:131)
                             6934 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                             6935 at org.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:95)
                             6936 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                             6937 at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)
                             6938 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                             6939 at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)
                             6940 at org.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:110)
                             6941 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                             6942 at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:46)
                             6943 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                             6944 at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)
                             6945 at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)
                             6946 at org.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:304)
                             6947 at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:106)
                             6948 at org.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:82)
                             6949 at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:769)
                             6950 at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:573)
                             6953 Caused by: java.sql.SQLException: ORA-02089: COMMIT is not allowed in a subordinate session
                             6954
                             6955 at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
                             6956 at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
                             6957 at oracle.jdbc.ttc7.Ocommoncall.receive(Ocommoncall.java:140)
                             6958 at oracle.jdbc.ttc7.TTC7Protocol.logoff(TTC7Protocol.java:396)
                             6959 at oracle.jdbc.driver.OracleConnection.close(OracleConnection.java:1518)
                             6960 at oracle.jdbc.pool.OraclePooledConnection.close(OraclePooledConnection.java:259)
                             6961 at org.jboss.resource.adapter.jdbc.xa.XAManagedConnection.destroy(XAManagedConnection.java:100)
                             6962 ... 54 more
                            
                            
                            


                            • 11. Re: Exception in Distributed transaction in EJB3.0
                              jaikiran pai Master

                              Not sure what the issue is. A google search for "ORA-02089: COMMIT is not allowed in a subordinate session" showed up a lot of posts for this error. You might want to have a look at those and also lookup the oracle documentation for more information about this error.

                              • 12. Re: Exception in Distributed transaction in EJB3.0
                                Ajay Kumar Newbie

                                I checked in the oracle documentation and I have found this type of error occured when one writes DDL statement in a transation. The DDL statement is auto commit.
                                But I have not written any DDL statement in my distributed trasaaction. I have simply updating two tables using Entity bean.

                                Coud you please help me to know what could be the possible cause of the problem.

                                • 13. Re: Exception in Distributed transaction in EJB3.0
                                  Ajay Kumar Newbie

                                  If any one want I can provide/share my all source code.I am doing commit/rollback at only one place in my code.
                                  My question is that even if I am doing mistake in the managing the distributed transaction, JBOSS should simply rollback everything ; why is it throwing run time exception.
                                  can any one help me out.

                                  best regards,
                                  Ajay Kumar
                                  ST Microelectronics Ltd.,
                                  India

                                  • 14. Re: Exception in Distributed transaction in EJB3.0
                                    jaikiran pai Master

                                    I would suggest that you attach a debugger and try to step through the code and see what exactly is causing the exception. This, at this point, looks too specific to your application and oracle driver than EJB3.