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