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