0 Replies Latest reply on Feb 10, 2004 2:01 PM by hilton

    No Managed Connections

    hilton

      Hi I am getting this no managed connections again and again. I am using jboss bundled tomcat as an app server and SQL2000 as the database. here is the error.

      Please advise as this is a very serious problem to us.
      Thanks in advance
      Sridhar


      13:14:28,450 INFO [RequestProcessor] Processing a 'POST' for path '/menu'
      13:14:28,466 INFO [PropertyMessageResources] Initializing, config='com.hilton.i
      nfocus.properties.global', returnNull=true
      13:14:30,357 WARN [WrappedConnection] Closing a statement you left open, please
      do your own housekeeping
      13:14:30,357 WARN [WrappedConnection] Closing a statement you left open, please
      do your own housekeeping
      13:14:30,357 WARN [WrappedConnection] Closing a statement you left open, please
      do your own housekeeping
      13:14:30,357 ERROR [infocus] Loading Demand Pool Failed: java.sql.SQLException:
      [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Transaction (Process ID 83
      ) was deadlocked on lock resources with another process and has been chosen as t
      he deadlock victim. Rerun the transaction.
      13:14:30,357 INFO [STDOUT] getting demand
      13:14:30,357 INFO [PropertyMessageResources] Initializing, config='com.hilton.i
      nfocus.properties.global', returnNull=true
      13:14:31,435 INFO [ChannelSocket] connection timeout reached
      13:14:31,435 ERROR [STDERR] org.jboss.util.NestedSQLException: No ManagedConnect
      ions Available!; - nested throwable: (javax.resource.ResourceException: No Manag
      edConnections Available!)
      13:14:31,435 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrapperDataSo
      urce.getConnection(WrapperDataSource.java:106)
      13:14:31,435 ERROR [STDERR] at com.hilton.infocus.db.ConnectDb_dsn.getConnec
      tion(ConnectDb_dsn.java:61)
      13:14:31,435 ERROR [STDERR] at com.hilton.infocus.db.ConnectDb.getConnection
      (ConnectDb.java:62)
      13:14:31,435 ERROR [STDERR] at com.hilton.infocus.db.Peer.getObjectsFromQuer
      y(Peer.java:475)
      13:14:31,435 ERROR [STDERR] at com.hilton.infocus.workflow.WorkflowManager.g
      etAllAvailableTransitions(WorkflowManager.java:205)
      13:14:31,435 ERROR [STDERR] at com.hilton.infocus.workflow.LoadWorkflowTag.d
      oStartTag(LoadWorkflowTag.java:175)
      13:14:31,435 ERROR [STDERR] at org.apache.jsp.proposal_jsp._jspx_meth_work_l
      oadWorkflow_0(proposal_jsp.java:1345)
      13:14:31,435 ERROR [STDERR] at org.apache.jsp.proposal_jsp._jspx_meth_logic_
      notEqual_2(proposal_jsp.java:1274)
      13:14:31,435 ERROR [STDERR] at org.apache.jsp.proposal_jsp._jspService(propo
      sal_jsp.java:453)
      13:14:31,435 ERROR [STDERR] at org.apache.jasper.runtime.HttpJspBase.service
      (HttpJspBase.java:137)
      13:14:31,435 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpSe
      rvlet.java:853)
      13:14:31,435 ERROR [STDERR] at org.apache.jasper.servlet.JspServletWrapper.s
      ervice(JspServletWrapper.java:210)
      13:14:31,435 ERROR [STDERR] at org.apache.jasper.servlet.JspServlet.serviceJ
      spFile(JspServlet.java:295)
      13:14:31,435 ERROR [STDERR] at org.apache.jasper.servlet.JspServlet.service(
      JspServlet.java:241)
      13:14:31,435 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpSe
      rvlet.java:853)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.core.ApplicationDispatche
      r.invoke(ApplicationDispatcher.java:684)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.core.ApplicationDispatche
      r.doForward(ApplicationDispatcher.java:432)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.core.ApplicationDispatche
      r.forward(ApplicationDispatcher.java:356)
      13:14:31,435 ERROR [STDERR] at org.apache.struts.action.RequestProcessor.doF
      orward(RequestProcessor.java:1033)
      13:14:31,435 ERROR [STDERR] at org.apache.struts.tiles.TilesRequestProcessor
      .doForward(TilesRequestProcessor.java:269)
      13:14:31,435 ERROR [STDERR] at org.apache.struts.action.RequestProcessor.pro
      cessForwardConfig(RequestProcessor.java:436)
      13:14:31,435 ERROR [STDERR] at org.apache.struts.tiles.TilesRequestProcessor
      .processForwardConfig(TilesRequestProcessor.java:312)
      13:14:31,435 ERROR [STDERR] at org.apache.struts.action.RequestProcessor.pro
      cessActionForward(RequestProcessor.java:401)
      13:14:31,435 ERROR [STDERR] at org.apache.struts.action.RequestProcessor.pro
      cess(RequestProcessor.java:279)
      13:14:31,435 ERROR [STDERR] at org.apache.struts.action.ActionServlet.proces
      s(ActionServlet.java:1422)
      13:14:31,435 ERROR [STDERR] at org.apache.struts.action.ActionServlet.doGet(
      ActionServlet.java:505)
      13:14:31,435 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpSe
      rvlet.java:740)
      13:14:31,435 ERROR [STDERR] at com.hilton.infocus.auth.AuthActionServlet.ser
      vice(AuthActionServlet.java:29)
      13:14:31,435 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpSe
      rvlet.java:853)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterCha
      in.internalDoFilter(ApplicationFilterChain.java:247)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterCha
      in.doFilter(ApplicationFilterChain.java:193)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve
      .invoke(StandardWrapperValve.java:256)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$Sta
      ndardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.inv
      oke(StandardPipeline.java:480)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke
      (ContainerBase.java:995)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve
      .invoke(StandardContextValve.java:191)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$Sta
      ndardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.valves.CertificatesValve.
      invoke(CertificatesValve.java:246)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$Sta
      ndardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.inv
      oke(StandardPipeline.java:480)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke
      (ContainerBase.java:995)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.core.StandardContext.invo
      ke(StandardContext.java:2415)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.in
      voke(StandardHostValve.java:180)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$Sta
      ndardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.valves.ErrorDispatcherVal
      ve.invoke(ErrorDispatcherValve.java:171)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$Sta
      ndardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.i
      nvoke(ErrorReportValve.java:172)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$Sta
      ndardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.valves.AccessLogValve.inv
      oke(AccessLogValve.java:509)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$Sta
      ndardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.inv
      oke(StandardPipeline.java:480)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke
      (ContainerBase.java:995)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.core.StandardEngineValve.
      invoke(StandardEngineValve.java:174)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$Sta
      ndardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.inv
      oke(StandardPipeline.java:480)
      13:14:31,435 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke
      (ContainerBase.java:995)
      13:14:31,435 ERROR [STDERR] at org.apache.coyote.tomcat4.CoyoteAdapter.servi
      ce(CoyoteAdapter.java:223)
      13:14:31,435 ERROR [STDERR] at org.apache.jk.server.JkCoyoteHandler.invoke(J
      kCoyoteHandler.java:261)
      13:14:31,435 ERROR [STDERR] at org.apache.jk.common.HandlerRequest.invoke(Ha
      ndlerRequest.java:360)
      13:14:31,435 ERROR [STDERR] at org.apache.jk.common.ChannelSocket.invoke(Cha
      nnelSocket.java:604)
      13:14:31,435 ERROR [STDERR] at org.apache.jk.common.ChannelSocket.processCon
      nection(ChannelSocket.java:562)
      13:14:31,435 ERROR [STDERR] at org.apache.jk.common.SocketConnection.runIt(C
      hannelSocket.java:679)
      13:14:31,435 ERROR [STDERR] at org.apache.tomcat.util.threads.ThreadPool$Con
      trolRunnable.run(ThreadPool.java:619)
      13:14:31,435 ERROR [STDERR] at java.lang.Thread.run(Thread.java:536)
      13:14:31,435 ERROR [STDERR] Caused by: javax.resource.ResourceException: No Mana
      gedConnections Available!
      13:14:31,435 ERROR [STDERR] at org.jboss.resource.connectionmanager.Internal
      ManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:183)
      13:14:31,435 ERROR [STDERR] at org.jboss.resource.connectionmanager.JBossMan
      agedConnectionPool$OnePool.getConnection(JBossManagedConnectionPool.java:643)
      13:14:31,435 ERROR [STDERR] at org.jboss.resource.connectionmanager.BaseConn
      ectionManager2.getManagedConnection(BaseConnectionManager2.java:413)
      13:14:31,435 ERROR [STDERR] at org.jboss.resource.connectionmanager.TxConnec
      tionManager.getManagedConnection(TxConnectionManager.java:331)
      13:14:31,435 ERROR [STDERR] at org.jboss.resource.connectionmanager.BaseConn
      ectionManager2.allocateConnection(BaseConnectionManager2.java:488)
      13:14:31,435 ERROR [STDERR] at org.jboss.resource.connectionmanager.BaseConn
      ectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.
      java:798)
      13:14:31,435 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.WrapperDataSo
      urce.getConnection(WrapperDataSource.java:102)
      13:14:31,435 ERROR [STDERR] ... 63 more
      13:14:31,435 INFO [STDOUT] null
      13:14:31,450 ERROR [STDERR] com.hilton.infocus.db.DbException: Error getting con
      nection from database: org.jboss.util.NestedSQLException: No ManagedConnections
      Available!; - nested throwable: (javax.resource.ResourceException: No ManagedCon
      nections Available!)
      13:14:31,450 ERROR [STDERR] at com.hilton.infocus.db.ConnectDb_dsn.getConnec
      tion(ConnectDb_dsn.java:66)
      13:14:31,450 ERROR [STDERR] at com.hilton.infocus.db.ConnectDb.getConnection
      (ConnectDb.java:62)
      13:14:31,450 ERROR [STDERR] at com.hilton.infocus.db.Peer.getObjectsFromQuer
      y(Peer.java:475)
      13:14:31,450 ERROR [STDERR] at com.hilton.infocus.workflow.WorkflowManager.g
      etAllAvailableTransitions(WorkflowManager.java:205)
      13:14:31,450 ERROR [STDERR] at com.hilton.infocus.workflow.LoadWorkflowTag.d
      oStartTag(LoadWorkflowTag.java:175)
      13:14:31,450 ERROR [STDERR] at org.apache.jsp.proposal_jsp._jspx_meth_work_l
      oadWorkflow_0(proposal_jsp.java:1345)
      13:14:31,450 ERROR [STDERR] at org.apache.jsp.proposal_jsp._jspx_meth_logic_
      notEqual_2(proposal_jsp.java:1274)
      13:14:31,450 ERROR [STDERR] at org.apache.jsp.proposal_jsp._jspService(propo
      sal_jsp.java:453)
      13:14:31,450 ERROR [STDERR] at org.apache.jasper.runtime.HttpJspBase.service
      (HttpJspBase.java:137)
      13:14:31,450 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpSe
      rvlet.java:853)
      13:14:31,450 ERROR [STDERR] at org.apache.jasper.servlet.JspServletWrapper.s
      ervice(JspServletWrapper.java:210)
      13:14:31,450 ERROR [STDERR] at org.apache.jasper.servlet.JspServlet.serviceJ
      spFile(JspServlet.java:295)
      13:14:31,450 ERROR [STDERR] at org.apache.jasper.servlet.JspServlet.service(
      JspServlet.java:241)
      13:14:31,450 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpSe
      rvlet.java:853)
      13:14:31,450 ERROR [STDERR] at org.apache.catalina.core.ApplicationDispatche
      r.invoke(ApplicationDispatcher.java:684)
      13:14:31,450 ERROR [STDERR] at org.apache.catalina.core.ApplicationDispatche
      r.doForward(ApplicationDispatcher.java:432)
      13:14:31,450 ERROR [STDERR] at org.apache.catalina.core.ApplicationDispatche
      r.forward(ApplicationDispatcher.java:356)
      13:14:31,450 ERROR [STDERR] at org.apache.struts.action.RequestProcessor.doF
      orward(RequestProcessor.java:1033)
      13:14:31,450 ERROR [STDERR] at org.apache.struts.tiles.TilesRequestProcessor
      .doForward(TilesRequestProcessor.java:269)
      13:14:31,450 ERROR [STDERR] at org.apache.struts.action.RequestProcessor.pro
      cessForwardConfig(RequestProcessor.java:436)
      13:14:31,450 ERROR [STDERR] at org.apache.struts.tiles.TilesRequestProcessor
      .processForwardConfig(TilesRequestProcessor.java:312)
      13:14:31,450 ERROR [STDERR] at org.apache.struts.action.RequestProcessor.pro
      cessActionForward(RequestProcessor.java:401)
      13:14:31,450 ERROR [STDERR] at org.apache.struts.action.RequestProcessor.pro
      cess(RequestProcessor.java:279)
      13:14:31,450 ERROR [STDERR] at org.apache.struts.action.ActionServlet.proces
      s(ActionServlet.java:1422)
      13:14:31,450 ERROR [STDERR] at org.apache.struts.action.ActionServlet.doGet(
      ActionServlet.java:505)
      13:14:31,450 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpSe
      rvlet.java:740)
      13:14:31,450 ERROR [STDERR] at com.hilton.infocus.auth.AuthActionServlet.ser
      vice(AuthActionServlet.java:29)
      13:14:31,450 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpSe
      rvlet.java:853)
      13:14:31,450 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterCha
      in.internalDoFilter(ApplicationFilterChain.java:247)
      13:14:31,450 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterCha