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 run

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

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, Sha

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

2003-10-30 Thread Shapira, Yoav
#x27;m assuming you're using DBCP. If you're using another connection pool, the above code must be modified accordingly. Yoav Shapira Millennium ChemInformatics >-Original Message- >From: john-paul delaney [mailto:[EMAIL PROTECTED] >Sent: Thursday, October 30,

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

2003-10-30 Thread Oscar Carrillo
onnection > pool, 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 U

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, proprieta

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 solut