0 Replies Latest reply on May 11, 2005 11:00 PM by glbsuporte

    org.jboss.util.NestedSQLException: Failure to delist resourc

    glbsuporte Newbie

      Hi all!

      I´m running Jboss 3.2.7 under linux with oracle XA datasource.

      I´m getting the following exception on my logs:

      20:08:38,131 ERROR [LogInterceptor] RuntimeException in method: public abstract com.myapplication.controller.Command com.myapplication.client.CommandExecutorRemote.execute(com.myapplication.controller.Command) throws java.rmi.RemoteException,com.myapplication.e.CoreIspException
      com.myapplication.e.CoreIspRuntimeException
      at com.myapplication.model.dao.DatasourceDAOFactory.getConnection(DatasourceDAOFactory.java:70)
      at com.myapplication.model.mapper.finder.Finder.busca(Finder.java:161)
      at com.myapplication.model.mapper.promocao.PromocaoMapper.buscaPorVarios(PromocaoMapper.java:147)
      at com.myapplication.model.factory.promocao.PromocaoFactory.buscaParaCadastro(PromocaoFactory.java:303)
      at com.myapplication.model.facade.GerenciadorProdutosPromocoesFacade.buscaPromocoesEspecificasCadastro(GerenciadorProdutosPromocoesFacade.java:675)
      at com.myapplication.controller.commands.CmdBuscaPromocoesEspecificasCadastroSrv.processaAgora(CmdBuscaPromocoesEspecificasCadastroSrv.java:30)
      at com.myapplication.controller.CommandExecutorBean.aw$original$_AW_$execute$_AW_$com_globo_coreisp_controller_CommandExecutorBean(CommandExecutorBean.java:73)
      at com.myapplication.controller.CommandExecutorBean_1__1549766442_1208482710___AW_JoinPoint.invoke(Unknown Source)
      at com.myapplication.controller.CommandExecutorBean.execute(CommandExecutorBean.java)
      at sun.reflect.GeneratedMethodAccessor76.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
      at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
      at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
      at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:317)
      at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:150)
      at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:111)
      at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
      at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
      at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
      at org.jboss.ejb.Container.invoke(Container.java:709)
      at sun.reflect.GeneratedMethodAccessor73.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:62)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:54)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:82)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:198)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
      at org.jboss.invocation.pooled.server.PooledInvoker.invoke(PooledInvoker.java:346)
      at org.jboss.invocation.pooled.server.ServerThread.processInvocation(ServerThread.java:214)
      at org.jboss.invocation.pooled.server.ServerThread.dorun(ServerThread.java:269)
      at org.jboss.invocation.pooled.server.ServerThread.run(ServerThread.java:140)
      caused by:
      org.jboss.util.NestedSQLException: Failure to delist resource; - nested throwable: (javax.resource.ResourceException: Failure to delist resource)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:106)
      at com.myapplication.model.dao.DatasourceDAOFactory.getConnection(DatasourceDAOFactory.java:66)
      at com.myapplication.model.mapper.finder.Finder.busca(Finder.java:161)
      at com.myapplication.model.mapper.promocao.PromocaoMapper.buscaPorVarios(PromocaoMapper.java:147)
      at com.myapplication.model.factory.promocao.PromocaoFactory.buscaParaCadastro(PromocaoFactory.java:303)
      at com.myapplication.model.facade.GerenciadorProdutosPromocoesFacade.buscaPromocoesEspecificasCadastro(GerenciadorProdutosPromocoesFacade.java:675)
      at com.myapplication.controller.commands.CmdBuscaPromocoesEspecificasCadastroSrv.processaAgora(CmdBuscaPromocoesEspecificasCadastroSrv.java:30)
      at com.myapplication.controller.CommandExecutorBean.aw$original$_AW_$execute$_AW_$com_globo_coreisp_controller_CommandExecutorBean(CommandExecutorBean.java:73)
      at com.myapplication.controller.CommandExecutorBean_1__1549766442_1208482710___AW_JoinPoint.invoke(Unknown Source)
      at com.myapplication.controller.CommandExecutorBean.execute(CommandExecutorBean.java)
      at sun.reflect.GeneratedMethodAccessor76.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:683)
      at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
      at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:72)
      at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:84)
      at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:317)
      at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:150)
      at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:111)
      at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:192)
      at org.jboss.ejb.plugins.ProxyFactoryFinderInterceptor.invoke(ProxyFactoryFinderInterceptor.java:122)
      at org.jboss.ejb.StatelessSessionContainer.internalInvoke(StatelessSessionContainer.java:331)
      at org.jboss.ejb.Container.invoke(Container.java:709)
      at sun.reflect.GeneratedMethodAccessor73.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:324)
      at org.jboss.mx.server.ReflectedDispatcher.dispatch(ReflectedDispatcher.java:60)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:62)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:54)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:82)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:198)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:473)
      at org.jboss.invocation.pooled.server.PooledInvoker.invoke(PooledInvoker.java:346)
      at org.jboss.invocation.pooled.server.ServerThread.processInvocation(ServerThread.java:214)
      at org.jboss.invocation.pooled.server.ServerThread.dorun(ServerThread.java:269)
      at org.jboss.invocation.pooled.server.ServerThread.run(ServerThread.java:140)
      Caused by: javax.resource.ResourceException: Failure to delist resource
      at org.jboss.resource.connectionmanager.TxConnectionManager$TxConnectionEventListener.delist(TxConnectionManager.java:478)
      at org.jboss.resource.connectionmanager.TxConnectionManager.managedConnectionDisconnected(TxConnectionManager.java:338)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:507)
      at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:888)
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:102)
      ... 36 more



      It seems that my application wasn´t able to get a new connection from the pool, however, the connection count in the jmx-console is lower than the max-pool property.

      Does anyone knows why I am getting this exception?