> 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]