1 Reply Latest reply on May 8, 2013 11:08 PM by georgesg

    Jboss 7.1.3.Final (eap 6.0.1)  javax.resource.ResourceException: IJ000459: Transaction is not active

    georgesg

      I am trying to migrate applications using ejb2.1 from jboss 4.3 to Jboss 7.1.3. final.  We are using Oracle 10g database and ojdbc6.jar as oracle driver. Attached is my standalone-full.xml and complete console logs for your reference. I am getting the below exception when the EJB tries to get database connection though jboss connection pool

       

       

      15:35:47,337 ERROR [stderr] (Thread-123) java.sql.SQLException: javax.resource.ResourceException: IJ000460: Error checking for a transaction

      15:35:47,337 ERROR [stderr] (Thread-123)        at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:147)

      15:35:47,337 ERROR [stderr] (Thread-123)        at com.cassis.cx.base.JDBCPersistenceManagerBase.getConnection(JDBCPersistenceManagerBase.java:211)

      15:35:47,337 ERROR [stderr] (Thread-123)        at com.cassis.cx.job.JobJDBCMgr.updateWithActiveJob(JobJDBCMgr.java:318)

      15:35:47,337 ERROR [stderr] (Thread-123)        at com.cassis.cx.job.Job_Bean.ejbPassivate(Job_Bean.java:84)

      15:35:47,337 ERROR [stderr] (Thread-123)        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

      15:35:47,338 ERROR [stderr] (Thread-123)        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

      15:35:47,338 ERROR [stderr] (Thread-123)        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

      15:35:47,338 ERROR [stderr] (Thread-123)        at java.lang.reflect.Method.invoke(Method.java:597)

      15:35:47,338 ERROR [stderr] (Thread-123)        at org.jboss.as.ejb3.component.InvokeMethodOnTargetInterceptor.processInvocation(InvokeMethodOnTargetInterceptor.java:57)

      15:35:47,338 ERROR [stderr] (Thread-123)        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      15:35:47,338 ERROR [stderr] (Thread-123)        at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)

      15:35:47,338 ERROR [stderr] (Thread-123)        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      15:35:47,338 ERROR [stderr] (Thread-123)        at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)

      15:35:47,338 ERROR [stderr] (Thread-123)        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      15:35:47,339 ERROR [stderr] (Thread-123)        at org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)

      15:35:47,339 ERROR [stderr] (Thread-123)        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      15:35:47,339 ERROR [stderr] (Thread-123)        at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)

      15:35:47,339 ERROR [stderr] (Thread-123)        at org.jboss.as.ejb3.component.entity.EntityBeanComponentInstance.passivate(EntityBeanComponentInstance.java:200)

      15:35:47,339 ERROR [stderr] (Thread-123)        at org.jboss.as.ejb3.component.entity.entitycache.ReferenceCountingEntityCache.release(ReferenceCountingEntityCache.java:109)

      15:35:47,339 ERROR [stderr] (Thread-123)        at org.jboss.as.ejb3.component.entity.interceptors.EntityBeanEjbCreateMethodInterceptorFactory$1$1.afterCompletion(EntityBeanEjbCreateMethodInterceptorFactory.java:115)

      15:35:47,339 ERROR [stderr] (Thread-123)        at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.afterCompletion(SynchronizationImple.java:96)

      15:35:47,339 ERROR [stderr] (Thread-123)        at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.afterCompletion(TwoPhaseCoordinator.java:402)

      15:35:47,339 ERROR [stderr] (Thread-123)        at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:103)

      15:35:47,340 ERROR [stderr] (Thread-123)        at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:164)

      15:35:47,340 ERROR [stderr] (Thread-123)        at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1165)

      15:35:47,340 ERROR [stderr] (Thread-123)        at com.arjuna.ats.internal.jta.transaction.arjunacore.BaseTransaction.commit(BaseTransaction.java:117)

      15:35:47,340 ERROR [stderr] (Thread-123)        at com.arjuna.ats.jbossatx.BaseTransactionManagerDelegate.commit(BaseTransactionManagerDelegate.java:75)

      15:35:47,340 ERROR [stderr] (Thread-123)        at org.jboss.as.ejb3.tx.CMTTxInterceptor.endTransaction(CMTTxInterceptor.java:90)

      15:35:47,340 ERROR [stderr] (Thread-123)        at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:230)

      15:35:47,340 ERROR [stderr] (Thread-123)        at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:302)

      15:35:47,340 ERROR [stderr] (Thread-123)        at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:188)

      15:35:47,341 ERROR [stderr] (Thread-123)        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      15:35:47,341 ERROR [stderr] (Thread-123)        at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41)

      15:35:47,341 ERROR [stderr] (Thread-123)        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      15:35:47,341 ERROR [stderr] (Thread-123)        at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:42)

      15:35:47,341 ERROR [stderr] (Thread-123)        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      15:35:47,341 ERROR [stderr] (Thread-123)        at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59)

      15:35:47,341 ERROR [stderr] (Thread-123)        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      15:35:47,341 ERROR [stderr] (Thread-123)        at org.jboss.as.ejb3.component.interceptors.EjbExceptionTransformingInterceptorFactories$2.processInvocation(EjbExceptionTransformingInterceptorFactories.java:89)

      15:35:47,341 ERROR [stderr] (Thread-123)        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      15:35:47,342 ERROR [stderr] (Thread-123)        at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50)

      15:35:47,342 ERROR [stderr] (Thread-123)        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      15:35:47,342 ERROR [stderr] (Thread-123)        at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:32)

      15:35:47,342 ERROR [stderr] (Thread-123)        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      15:35:47,342 ERROR [stderr] (Thread-123)        at org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45)

      15:35:47,342 ERROR [stderr] (Thread-123)        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      15:35:47,342 ERROR [stderr] (Thread-123)        at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)

      15:35:47,342 ERROR [stderr] (Thread-123)        at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165)

      15:35:47,342 ERROR [stderr] (Thread-123)        at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:181)

      15:35:47,343 ERROR [stderr] (Thread-123)        at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)

      15:35:47,343 ERROR [stderr] (Thread-123)        at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)

      15:35:47,343 ERROR [stderr] (Thread-123)        at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:72)

      15:35:47,343 ERROR [stderr] (Thread-123)        at com.cassis.cx.base.Dispatcher_Local$$$view75.dispatch(Unknown Source)

      15:35:47,343 ERROR [stderr] (Thread-123)        at com.cassis.cx.dcrypto.EJBMobilematrixSystemMessageHandlerContext.dispatch(EJBMobilematrixSystemMessageHandlerContext.java:60)

      15:35:47,343 ERROR [stderr] (Thread-123)        at com.cassis.dcrypto.MobilematrixSystemMessageHandler.dispatch(MobilematrixSystemMessageHandler.java:318)

      15:35:47,343 ERROR [stderr] (Thread-123)        at com.cassis.dcrypto.MobilematrixSystemMessageHandler.receiveMessage(MobilematrixSystemMessageHandler.java:139)

      15:35:47,343 ERROR [stderr] (Thread-123)        at com.cassis.membership.MemberMessageChannel$Receiver.run(MemberMessageChannel.java:1436)

      15:35:47,344 ERROR [stderr] (Thread-123) Caused by: javax.resource.ResourceException: IJ000460: Error checking for a transaction

      15:35:47,344 ERROR [stderr] (Thread-123)        at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:362)

      15:35:47,344 ERROR [stderr] (Thread-123)        at org.jboss.jca.core.connectionmanager.AbstractConnectionManager.allocateConnection(AbstractConnectionManager.java:464)

      15:35:47,344 ERROR [stderr] (Thread-123)        at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:139)

      15:35:47,344 ERROR [stderr] (Thread-123)        ... 56 more

      15:35:47,345 ERROR [stderr] (Thread-123) Caused by: javax.resource.ResourceException: IJ000459: Transaction is not active: tx=TransactionImple < ac, BasicAction: 0:ffff0a4109f0:5b1fa7c8:518a0041:70 status: ActionStatus.COMMITTED >

      15:35:47,345 ERROR [stderr] (Thread-123)        at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:352)

      15:35:47,345 ERROR [stderr] (Thread-123)        ... 58 more

      15:35:47,345 WARN  [com.arjuna.ats.jta] (Thread-123) ARJUNA016029: SynchronizationImple.afterCompletion - failed for org.jboss.as.ejb3.component.entity.interceptors.EntityBeanEjbCreateMethodInterceptorFactory$1$1@e71207 with exception: javax.ejb.EJBException: java.sql.SQLException: javax.resource.ResourceException: IJ000460: Error checking for a transaction

              at com.cassis.cx.base.JDBCPersistenceManagerBase.getConnection(JDBCPersistenceManagerBase.java:218) [MobileMatrixCX-1.0.0-SNAPSHOT.jar:]

              at com.cassis.cx.job.JobJDBCMgr.updateWithActiveJob(JobJDBCMgr.java:318) [MobileMatrixCX-1.0.0-SNAPSHOT.jar:]

              at com.cassis.cx.job.Job_Bean.ejbPassivate(Job_Bean.java:84) [MobileMatrixCX-1.0.0-SNAPSHOT.jar:]

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

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

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

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

              at org.jboss.as.ejb3.component.InvokeMethodOnTargetInterceptor.processInvocation(InvokeMethodOnTargetInterceptor.java:57) [jboss-as-ejb3-7.1.3.Final-redhat-4.jar:7.1.3.Final-redhat-4]

              at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]

              at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) [jboss-as-ejb3-7.1.3.Final-redhat-4.jar:7.1.3.Final-redhat-4]

              at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]

              at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) [jboss-as-ee-7.1.3.Final-redhat-4.jar:7.1.3.Final-redhat-4]

              at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]

              at org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45) [jboss-as-ee-7.1.3.Final-redhat-4.jar:7.1.3.Final-redhat-4]

              at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]

              at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]

              at org.jboss.as.ejb3.component.entity.EntityBeanComponentInstance.passivate(EntityBeanComponentInstance.java:200) [jboss-as-ejb3-7.1.3.Final-redhat-4.jar:7.1.3.Final-redhat-4]

              at org.jboss.as.ejb3.component.entity.entitycache.ReferenceCountingEntityCache.release(ReferenceCountingEntityCache.java:109) [jboss-as-ejb3-7.1.3.Final-redhat-4.jar:7.1.3.Final-redhat-4]

              at org.jboss.as.ejb3.component.entity.interceptors.EntityBeanEjbCreateMethodInterceptorFactory$1$1.afterCompletion(EntityBeanEjbCreateMethodInterceptorFactory.java:115) [jboss-as-ejb3-7.1.3.Final-redhat-4.jar:7.1.3.Final-redhat-4]

              at com.arjuna.ats.internal.jta.resources.arjunacore.SynchronizationImple.afterCompletion(SynchronizationImple.java:96)

              at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.afterCompletion(TwoPhaseCoordinator.java:402)

              at com.arjuna.ats.arjuna.coordinator.TwoPhaseCoordinator.end(TwoPhaseCoordinator.java:103)

              at com.arjuna.ats.arjuna.AtomicAction.commit(AtomicAction.java:164)

              at com.arjuna.ats.internal.jta.transaction.arjunacore.TransactionImple.commitAndDisassociate(TransactionImple.java:1165)

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

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

              at org.jboss.as.ejb3.tx.CMTTxInterceptor.endTransaction(CMTTxInterceptor.java:90) [jboss-as-ejb3-7.1.3.Final-redhat-4.jar:7.1.3.Final-redhat-4]

              at org.jboss.as.ejb3.tx.CMTTxInterceptor.invokeInOurTx(CMTTxInterceptor.java:230) [jboss-as-ejb3-7.1.3.Final-redhat-4.jar:7.1.3.Final-redhat-4]

              at org.jboss.as.ejb3.tx.CMTTxInterceptor.required(CMTTxInterceptor.java:302) [jboss-as-ejb3-7.1.3.Final-redhat-4.jar:7.1.3.Final-redhat-4]

              at org.jboss.as.ejb3.tx.CMTTxInterceptor.processInvocation(CMTTxInterceptor.java:188) [jboss-as-ejb3-7.1.3.Final-redhat-4.jar:7.1.3.Final-redhat-4]

              at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]

              at org.jboss.as.ejb3.component.interceptors.CurrentInvocationContextInterceptor.processInvocation(CurrentInvocationContextInterceptor.java:41) [jboss-as-ejb3-7.1.3.Final-redhat-4.jar:7.1.3.Final-redhat-4]

              at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]

              at org.jboss.as.ejb3.component.interceptors.ShutDownInterceptorFactory$1.processInvocation(ShutDownInterceptorFactory.java:42) [jboss-as-ejb3-7.1.3.Final-redhat-4.jar:7.1.3.Final-redhat-4]

              at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]

              at org.jboss.as.ejb3.component.interceptors.LoggingInterceptor.processInvocation(LoggingInterceptor.java:59) [jboss-as-ejb3-7.1.3.Final-redhat-4.jar:7.1.3.Final-redhat-4]

              at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]

              at org.jboss.as.ejb3.component.interceptors.EjbExceptionTransformingInterceptorFactories$2.processInvocation(EjbExceptionTransformingInterceptorFactories.java:89) [jboss-as-ejb3-7.1.3.Final-redhat-4.jar:7.1.3.Final-redhat-4]

              at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]

              at org.jboss.as.ee.component.NamespaceContextInterceptor.processInvocation(NamespaceContextInterceptor.java:50) [jboss-as-ee-7.1.3.Final-redhat-4.jar:7.1.3.Final-redhat-4]

              at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]

              at org.jboss.as.ejb3.component.interceptors.AdditionalSetupInterceptor.processInvocation(AdditionalSetupInterceptor.java:32) [jboss-as-ejb3-7.1.3.Final-redhat-4.jar:7.1.3.Final-redhat-4]

              at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]

              at org.jboss.as.ee.component.TCCLInterceptor.processInvocation(TCCLInterceptor.java:45) [jboss-as-ee-7.1.3.Final-redhat-4.jar:7.1.3.Final-redhat-4]

              at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]

              at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]

              at org.jboss.as.ee.component.ViewService$View.invoke(ViewService.java:165) [jboss-as-ee-7.1.3.Final-redhat-4.jar:7.1.3.Final-redhat-4]

              at org.jboss.as.ee.component.ViewDescription$1.processInvocation(ViewDescription.java:181) [jboss-as-ee-7.1.3.Final-redhat-4.jar:7.1.3.Final-redhat-4]

              at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]

              at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61) [jboss-invocation-1.1.1.Final-redhat-2.jar:1.1.1.Final-redhat-2]

              at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:72) [jboss-as-ee-7.1.3.Final-redhat-4.jar:7.1.3.Final-redhat-4]

              at com.cassis.cx.base.Dispatcher_Local$$$view75.dispatch(Unknown Source) [MobileMatrixCX-1.0.0-SNAPSHOT.jar:]

              at com.cassis.cx.dcrypto.EJBMobilematrixSystemMessageHandlerContext.dispatch(EJBMobilematrixSystemMessageHandlerContext.java:60) [MobileMatrixCX-1.0.0-SNAPSHOT.jar:]

              at com.cassis.dcrypto.MobilematrixSystemMessageHandler.dispatch(MobilematrixSystemMessageHandler.java:318) [mmtx_base-1.0.0-SNAPSHOT.jar:]

              at com.cassis.dcrypto.MobilematrixSystemMessageHandler.receiveMessage(MobilematrixSystemMessageHandler.java:139) [mmtx_base-1.0.0-SNAPSHOT.jar:]

              at com.cassis.membership.MemberMessageChannel$Receiver.run(MemberMessageChannel.java:1436) [mmtx_base-1.0.0-SNAPSHOT.jar:]

      Caused by: java.sql.SQLException: javax.resource.ResourceException: IJ000460: Error checking for a transaction

              at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:147) [ironjacamar-jdbc-1.0.13.Final-redhat-1.jar:1.0.13.Final-redhat-1]

              at com.cassis.cx.base.JDBCPersistenceManagerBase.getConnection(JDBCPersistenceManagerBase.java:211) [MobileMatrixCX-1.0.0-SNAPSHOT.jar:]

              ... 55 more

      Caused by: javax.resource.ResourceException: IJ000460: Error checking for a transaction

              at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:362)

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

              at org.jboss.jca.adapters.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:139) [ironjacamar-jdbc-1.0.13.Final-redhat-1.jar:1.0.13.Final-redhat-1]

              ... 56 more

      Caused by: javax.resource.ResourceException: IJ000459: Transaction is not active: tx=TransactionImple < ac, BasicAction: 0:ffff0a4109f0:5b1fa7c8:518a0041:70 status: ActionStatus.COMMITTED >

              at org.jboss.jca.core.connectionmanager.tx.TxConnectionManagerImpl.getManagedConnection(TxConnectionManagerImpl.java:352)

              ... 58 more

        • 1. Re: Jboss 7.1.3.Final (eap 6.0.1)  javax.resource.ResourceException: IJ000459: Transaction is not active
          georgesg

          Finally , I managed to find the root cause of the problem !!

           

          I have used Iron Jacamar Tool to convert the *-ds.xml from jboss 4.3.GA to jboss 7.1.3 Final.  So i noticed that though JTA is not used for the local-datasource in jboss 4.3.GA, this jta element got introduced after Irom Jacamar Migration. I know that JTA is used for distributed transactions. So to solve this problem i disabled the jta parameter by setting it to "false" and now no more errors and the problem is solved.

           

          If anything is wrong in this solution, kindly correct me.

           

           

          I noticed that  the local-datasource is converted as follows,

           

          <datasource jta="true" jndi-name="java:jboss/datasources/MM5_REQMGR" pool-name="MM5_REQMGR" enabled="true" use-java-context="false" use-ccm="true">

                              <connection-url>jdbc:oracle:thin:@ota-db-nfcdb1:1521:NFCDVDB1</connection-url>

                              <driver>OracleDriver</driver>

                              <transaction-isolation>TRANSACTION_READ_COMMITTED</transaction-isolation>

                              <pool>

                                  <min-pool-size>3</min-pool-size>

                                  <max-pool-size>200</max-pool-size>

                                  <prefill>false</prefill>

                                  <use-strict-min>false</use-strict-min>

                                  <flush-strategy>FailingConnectionOnly</flush-strategy>

                              </pool>

                              <security>

                                  <security-domain>SecuredREQMGRLogin</security-domain>

                              </security>

                              <validation>

                                  <valid-connection-checker class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker"/>

                                  <validate-on-match>false</validate-on-match>

                                  <background-validation>false</background-validation>

                                  <use-fast-fail>false</use-fast-fail>

                                  <exception-sorter class-name="org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter"/>

                              </validation>

                              <timeout>

                                  <idle-timeout-minutes>15</idle-timeout-minutes>

                              </timeout>

                              <statement>

                                  <track-statements>false</track-statements>

                              </statement>

                          </datasource>