RE: Error: Cannot get a connection, pool exhausted

2005-10-27 Thread KUMAR, NANDA [AG-Contractor/1000]
Thanks for the reply... -Original Message- From: Steve Kirk [mailto:[EMAIL PROTECTED] Sent: Thursday, October 27, 2005 12:07 PM To: 'Tomcat Users List' Subject: RE: Error: Cannot get a connection, pool exhausted yes. in the same place you have set maxActive etc. >

RE: Error: Cannot get a connection, pool exhausted

2005-10-27 Thread Steve Kirk
yes. in the same place you have set maxActive etc. > -Original Message- > From: KUMAR, NANDA [AG-Contractor/1000] > [mailto:[EMAIL PROTECTED] > Sent: Thursday 27 October 2005 15:46 > To: 'Tomcat Users List' > Subject: RE: Error: Cannot get a connection, p

RE: Error: Cannot get a connection, pool exhausted

2005-10-27 Thread KUMAR, NANDA [AG-Contractor/1000]
Thanks Jan, Let me try this. I need to add these parameters in context.xml? Am I right? Thanks Nanda -Original Message- From: Jan Pernica [mailto:[EMAIL PROTECTED] Sent: Thursday, October 27, 2005 1:49 AM To: Tomcat Users List Subject: Re: Error: Cannot get a connection, pool exhausted

Re: Error: Cannot get a connection, pool exhausted

2005-10-26 Thread Jan Pernica
st place to call the close() method is in a finally() block. -Original Message- From: KUMAR, NANDA [AG-Contractor/1000] [mailto:[EMAIL PROTECTED] Sent: Wednesday 26 October 2005 16:13 To: users@tomcat.apache.org Subject: Error: Cannot get a connection, pool exhausted Frequently we we

RE: Error: Cannot get a connection, pool exhausted

2005-10-26 Thread KUMAR, NANDA [AG-Contractor/1000]
26, 2005 12:09 PM To: 'Tomcat Users List' Subject: RE: Error: Cannot get a connection, pool exhausted IMHO I would say that you just need to rearrange your code a little - I would move some code that you have in the try{} block to a finally{} block, so that it gets executed whether or

RE: Error: Cannot get a connection, pool exhausted

2005-10-26 Thread Steve Kirk
catch (Exception finEx4) {/*ignore*/} } conn = null; } } > -Original Message- > From: KUMAR, NANDA [AG-Contractor/1000] > [mailto:[EMAIL PROTECTED] > Sent: Wednesday 26 October 2005 16:56 > To: 'To

RE: Error: Cannot get a connection, pool exhausted

2005-10-26 Thread KUMAR, NANDA [AG-Contractor/1000]
, 2005 10:35 AM To: 'Tomcat Users List' Subject: RE: Error: Cannot get a connection, pool exhausted how many concurrent requests are you handling? you have configured > maxActive > 100 so as soon as 100 concurrent conns are reached, you will exhaust the pool. If

RE: Error: Cannot get a connection, pool exhausted

2005-10-26 Thread Steve Kirk
. The best place to call the close() method is in a finally() block. > -Original Message- > From: KUMAR, NANDA [AG-Contractor/1000] > [mailto:[EMAIL PROTECTED] > Sent: Wednesday 26 October 2005 16:13 > To: users@tomcat.apache.org > Subject: Error: Cannot get

Error: Cannot get a connection, pool exhausted

2005-10-26 Thread KUMAR, NANDA [AG-Contractor/1000]
Frequently we were getting "Cannot get a connection, pool exhausted" error on production. I know in our application, we are closing the connection after each connection. Here is our context.xml parameters and values. We set maxActive connection to 100. Please let me know what we are doing wrong or