Make sure you are releasing the connection in finally block.
Connection con=null;
try
{
con = pool.getConnection();
...
}
catch (Exception e) { }
finally {
pool.release(con);
}
----- Original Message -----
From: Sushil Singh <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 23, 2000 3:46 PM
Subject: WebSphere - Connection Pooling
> Hi,
> Can anybody help me, how to check how many connections are there in
> pool, how many are in use, held etc. I am using WebSphere Application
> Server 3.0 (Advance Edition) on AIX with DB2. After sometime my
> servlets/jsp are unable to get connection even though i am relasing the
> connection.
>
> Thanks in advance.
>
> Sushil
>
>
===========================================================================
> To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
> Some relevant FAQs on JSP/Servlets can be found at:
>
> http://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
Some relevant FAQs on JSP/Servlets can be found at:
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
