Thanks for your reply.
I am using WebSphere Connection pool only. I am unable to find any pane in admin
console. I am seeing the ResourceAnalizer under Tasks-Performance. If I select
DBPOOLS, its giving information about Pool, but I am unable to understand it
properly:
User=db2inst1
DataSource=dsmserdb2
Size=1
Percent in Use=
Creates=
Destroys=
Waiting=0
WaitTime=0
Preempted=
Time Held=0.368
Time Available=4,341.204
If I put load through WebLoad, its working fine for sometime, after that my program
start getting "NullPointerException". In that case above values will be very high.
Also my conn.close() is in finally.
I would like to know detailed information like total connection, connection in use
(along with resource name which is helding the connection) etc.
Any help will be appreciated.
Thanks.
Sushil
"Hines, Bill" wrote:
> If you want the info real-time, there is a pane in the WebSphere Admin
> Console that will show you all connection pool info, as long as you're using
> WebSphere's pooling and not writing your own.
>
> -----Original Message-----
> From: Sushil Singh [mailto:[EMAIL PROTECTED]]
> Sent: Monday, October 23, 2000 6:47 PM
> To: [EMAIL PROTECTED]
> 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
===========================================================================
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
