Discussion:
[jboss-user] [Datasource Configuration] - Jboss 7.1.3.Final (eap 6.0.1) javax.resource.ResourceException: IJ000459: Transaction is not active
ANAND KUMAR GEORGE PREM KUMAR
2013-05-08 10:37:00 UTC
Permalink
ANAND KUMAR GEORGE PREM KUMAR [https://community.jboss.org/people/georgesg] created the discussion

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

To view the discussion, visit: https://community.jboss.org/message/816716#816716

--------------------------------------------------------------
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$***@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
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/816716#816716]

Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]
ANAND KUMAR GEORGE PREM KUMAR
2013-05-09 03:08:05 UTC
Permalink
ANAND KUMAR GEORGE PREM KUMAR [https://community.jboss.org/people/georgesg] created the discussion

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

To view the discussion, visit: https://community.jboss.org/message/816906#816906

--------------------------------------------------------------
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>
--------------------------------------------------------------

Reply to this message by going to Community
[https://community.jboss.org/message/816906#816906]

Start a new discussion in Datasource Configuration at Community
[https://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2077]
Loading...