Are you getting a "Connection does not exist" message?
Well, if you browse Websphere classes documentation, you'll fin some methods
that let you know the status of pool, such as getConnectCount, getFreeCount,
getIdleCount, getOpenCount, etc... (all from class
com.ibm.servlet.connmgr.IBMConnMgr)
You may find this documentation under (this for websphere for nt)
/websphere/appserver/web/doc/apidocs/
The only thing I don't like about this documentation is that it's not very
explaining.
Something I discovered is that connections are still valid even after
releasing them, I mean, you can create statements (I haven't tried executing
a SQL sentence).
I was getting that "Connection does not exist" message, and it was very
annoying, so I made sure to close connections, and removing them from the
pool instead of releasing them. (maybe it will work fine just closing the
connection, but I wanted to make sure that the problem will disappear, I was
getting into trouble because users couldn't work because of this message)
I'm still investigating this, so if you find a better solution, please let
me know.
Luis Javier
----- Original Message -----
From: "Sushil Singh" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, October 23, 2000 5: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
