> From: "Marc Richards" <[EMAIL PROTECTED]>
> Subject: Performance degradation under load
>
> Tomcat is handling connection pooling to our iSeries
> database server (db2, jdbc), but I'm not sure it's
> working correctly because when I do netstat I see
> several thousand db connections sitting at TIME_WAIT
> (presumably abandoned and waiting to be cleaned up by
> the pool manager).

This really sounds like you're not using connection pooling, but instead
are opening a new connection for each request.  How many do you have
configured in the pool?  If it's less than the number you see with
netstat, that would be another indication that your app is getting its
own connections rather than ones from the pool.

Is your app closing the connections (and statements and result sets)
properly?  This usualy requires putting the close statements in finally
blocks, just to make sure that exceptions don't cause them to be
skipped.

 - Chuck


THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE PROPRIETARY
MATERIAL and is thus for use only by the intended recipient. If you
received this in error, please contact the sender and delete the e-mail
and its attachments from all computers.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to