Re: OT: db pool problems - jdbc connection count?

2003-10-30 Thread Oscar Carrillo
How about just watching the processes for postgresql while you access the site?: ps auxw | grep postgres Oscar On Thu, 30 Oct 2003, john-paul delaney wrote: Hello List... Sorry if this is off-topic. Although I think I'm following the jndi-resources-howto fairly well, I find I'm running

RE: OT: db pool problems - jdbc connection count?

2003-10-30 Thread Shapira, Yoav
. getNumActive() / getNumIdle() for org.apache.commons.dbcp.BasicDataSource, to look at values. Yoav Shapira Millennium ChemInformatics -Original Message- From: Oscar Carrillo [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 1:18 PM To: Tomcat Users List Subject: Re: OT: db pool

Re: OT: db pool problems - jdbc connection count?

2003-10-30 Thread john-paul delaney
Thanks Oscar... I ran some servlets and observed the postgres processes going over the maxActive (33 to 30) limit set in server.xml and also those processes marked idle topped the maxIdle value (21 to 15). The number of processes then dropped to 25, and I don't experience any problems with db

RE: OT: db pool problems - jdbc connection count?

2003-10-30 Thread john-paul delaney
Thanks Yoav... sorry it's a wee bit above my immediate understanding (e.g lookup my connection pool by JNDI name - I could do with an example of what this means) plese be patient and point me to a resource that will give me some lead to catch up with you. regards /j-p. On Thu, 30 Oct 2003,

RE: OT: db pool problems - jdbc connection count?

2003-10-30 Thread Shapira, Yoav
, the above code must be modified accordingly. Yoav Shapira Millennium ChemInformatics -Original Message- From: john-paul delaney [mailto:[EMAIL PROTECTED] Sent: Thursday, October 30, 2003 6:30 PM To: Tomcat Users List Subject: RE: OT: db pool problems - jdbc connection count? Thanks Yoav... sorry

RE: OT: db pool problems - jdbc connection count?

2003-10-30 Thread Oscar Carrillo
, October 30, 2003 6:30 PM To: Tomcat Users List Subject: RE: OT: db pool problems - jdbc connection count? Thanks Yoav... sorry it's a wee bit above my immediate understanding (e.g lookup my connection pool by JNDI name - I could do with an example of what this means) plese be patient

RE: OT: db pool problems - jdbc connection count?

2003-10-30 Thread Shapira, Yoav
Howdy, Can I put your example up on my site when I finally get to doing a HOWTO on how to do connection pools? Of course, no problem. Yoav Shapira This e-mail, including any attachments, is a confidential business communication, and may contain information that is confidential,

RE: OT: db pool problems - jdbc connection count?

2003-10-30 Thread john-paul delaney
Oscar... I'll keep a close lookout for when you publish your HOWTO. In the meantime, I'll try to follow Yoav's instructions, and get back to the list with any eventual errors I make. thanks again to you both, /j-p. On Thu, 30 Oct 2003, Oscar Carrillo wrote: Thanks for a more complete