2 Replies Latest reply on May 4, 2007 10:05 AM by Pete Muir

    Transaction Timeout Exception

    Sunil Newbie

      Hi,
      I am trying to catch an exception and insert them into the database. when ever i try to get a database connection am getting Transaction timeout exception. you check error below.
      I am guessing this is occuring because of setRollback metod. This method is active when a exception is occered, i may be wrong.

      Enviranment (Jboss4.0.4, oracle10g, derby, NB)

      Any suggestions/workarounds regarding this transaction problem will be highly appreciated.

      Error:

      13:41:54,281 ERROR [STDERR] org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImpl:XidImpl[For
      matId=257, GlobalId=dcg00187/598, BranchQual=, localId=598]; - nested throwable: (javax.resource.ResourceException: Tran
      saction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=dcg00187/598, BranchQual=, localId=598])
      13:41:54,296 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.jav
      a:94)
      13:41:54,312 ERROR [STDERR] at ejb.mdc.dao.MdcDataImpl.getConnection(MdcDataImpl.java:138)
      13:41:54,312 ERROR [STDERR] at ejb.mdc.dao.MdcDataImpl.insertData(MdcDataImpl.java:42)
      13:41:54,312 ERROR [STDERR] at ejb.mdc.write.MDCWriteCatalogBean.insertData(MDCWriteCatalogBean.java:787)
      13:41:54,312 ERROR [STDERR] at ejb.mdc.write.MDCWriteCatalogBean.addOrUpdateMetaData(MDCWriteCatalogBean.java:514)
      13:41:54,328 ERROR [STDERR] at ejb.mdc.write.MDCWriteCatalogBean.writeMDCMessage(MDCWriteCatalogBean.java:278)
      13:41:54,328 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      13:41:54,328 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      13:41:54,343 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

      13:41:54,343 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585)
      13:41:54,359 ERROR [STDERR] at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
      13:41:54,359 ERROR [STDERR] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionC
      ontainer.java:237)
      13:41:54,359 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnect
      ionInterceptor.java:158)
      13:41:54,375 ERROR [STDERR] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInst
      anceInterceptor.java:169)
      13:41:54,390 ERROR [STDERR] at org.jboss.ws.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java
      :39)
      13:41:54,390 ERROR [STDERR] at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java
      :63)
      13:41:54,406 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121
      )
      13:41:54,406 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)

      13:41:54,421 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
      13:41:54,421 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
      13:41:54,437 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
      13:41:54,437 ERROR [STDERR] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderIntercep
      tor.java:136)
      13:41:54,453 ERROR [STDERR] at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
      13:41:54,453 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container.java:954)
      13:41:54,453 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      13:41:54,453 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      13:41:54,468 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

      13:41:54,468 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585)
      13:41:54,468 ERROR [STDERR] at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
      13:41:54,484 ERROR [STDERR] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      13:41:54,484 ERROR [STDERR] at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
      13:41:54,484 ERROR [STDERR] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
      13:41:54,500 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      13:41:54,500 ERROR [STDERR] at org.jboss.invocation.jrmp.server.JRMPInvoker$MBeanServerAction.invoke(JRMPInvoker.jav
      a:819)
      13:41:54,515 ERROR [STDERR] at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:420)
      13:41:54,515 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      13:41:54,515 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      13:41:54,531 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

      13:41:54,531 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585)
      13:41:54,531 ERROR [STDERR] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:294)
      13:41:54,546 ERROR [STDERR] at sun.rmi.transport.Transport$1.run(Transport.java:153)
      13:41:54,546 ERROR [STDERR] at java.security.AccessController.doPrivileged(Native Method)
      13:41:54,546 ERROR [STDERR] at sun.rmi.transport.Transport.serviceCall(Transport.java:149)
      13:41:54,562 ERROR [STDERR] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:466)
      13:41:54,562 ERROR [STDERR] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:707)
      13:41:54,562 ERROR [STDERR] at java.lang.Thread.run(Thread.java:595)
      13:41:54,578 ERROR [STDERR] Caused by: javax.resource.ResourceException: Transaction is not active: tx=TransactionImpl:X
      idImpl[FormatId=257, GlobalId=dcg00187/598, BranchQual=, localId=598]
      13:41:54,671 ERROR [STDERR] at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConne
      ctionManager.java:290)
      13:41:54,671 ERROR [STDERR] at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseCo
      nnectionManager2.java:379)
      13:41:54,671 ERROR [STDERR] at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.al
      locateConnection(BaseConnectionManager2.java:812)
      13:41:54,671 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.jav
      a:88)
      13:41:54,671 ERROR [STDERR] ... 45 more
      13:41:54,671 ERROR [STDERR] java.lang.NullPointerException
      13:41:54,671 ERROR [STDERR] at ejb.mdc.dao.MdcDataImpl.insertData(MdcDataImpl.java:71)
      13:41:54,671 ERROR [STDERR] at ejb.mdc.write.MDCWriteCatalogBean.insertData(MDCWriteCatalogBean.java:787)
      13:41:54,671 ERROR [STDERR] at ejb.mdc.write.MDCWriteCatalogBean.addOrUpdateMetaData(MDCWriteCatalogBean.java:514)
      13:41:54,671 ERROR [STDERR] at ejb.mdc.write.MDCWriteCatalogBean.writeMDCMessage(MDCWriteCatalogBean.java:278)
      13:41:54,671 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      13:41:54,671 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      13:41:54,671 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

      13:41:54,671 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585)
      13:41:54,671 ERROR [STDERR] at org.jboss.invocation.Invocation.performCall(Invocation.java:359)
      13:41:54,671 ERROR [STDERR] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionC
      ontainer.java:237)
      13:41:54,671 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnect
      ionInterceptor.java:158)
      13:41:54,671 ERROR [STDERR] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInst
      anceInterceptor.java:169)
      13:41:54,671 ERROR [STDERR] at org.jboss.ws.server.ServiceEndpointInterceptor.invoke(ServiceEndpointInterceptor.java
      :39)
      13:41:54,671 ERROR [STDERR] at org.jboss.ejb.plugins.CallValidationInterceptor.invoke(CallValidationInterceptor.java
      :63)
      13:41:54,671 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:121
      )
      13:41:54,671 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:350)

      13:41:54,671 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:181)
      13:41:54,671 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:168)
      13:41:54,671 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:205)
      13:41:54,671 ERROR [STDERR] at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderIntercep
      tor.java:136)
      13:41:54,671 ERROR [STDERR] at org.jboss.ejb.SessionContainer.internalInvoke(SessionContainer.java:648)
      13:41:54,671 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container.java:954)
      13:41:54,671 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      13:41:54,671 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      13:41:54,671 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

      13:41:54,671 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585)
      13:41:54,671 ERROR [STDERR] at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
      13:41:54,671 ERROR [STDERR] at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
      13:41:54,671 ERROR [STDERR] at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
      13:41:54,671 ERROR [STDERR] at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
      13:41:54,671 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
      13:41:54,671 ERROR [STDERR] at org.jboss.invocation.jrmp.server.JRMPInvoker$MBeanServerAction.invoke(JRMPInvoker.jav
      a:819)
      13:41:54,671 ERROR [STDERR] at org.jboss.invocation.jrmp.server.JRMPInvoker.invoke(JRMPInvoker.java:420)
      13:41:54,671 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
      13:41:54,671 ERROR [STDERR] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
      13:41:54,671 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

      13:41:54,671 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:585)
      13:41:54,671 ERROR [STDERR] at sun.rmi.server.UnicastServerRef.dispatch(UnicastServerRef.java:294)
      13:41:54,671 ERROR [STDERR] at sun.rmi.transport.Transport$1.run(Transport.java:153)
      13:41:54,671 ERROR [STDERR] at java.security.AccessController.doPrivileged(Native Method)
      13:41:54,671 ERROR [STDERR] at sun.rmi.transport.Transport.serviceCall(Transport.java:149)
      13:41:54,671 ERROR [STDERR] at sun.rmi.transport.tcp.TCPTransport.handleMessages(TCPTransport.java:466)
      13:41:54,671 ERROR [STDERR] at sun.rmi.transport.tcp.TCPTransport$ConnectionHandler.run(TCPTransport.java:707)
      13:41:54,671 ERROR [STDERR] at java.lang.Thread.run(Thread.java:595)


      Thanks you
      Sunil