Re: [DBCP] troubleshooting pool activity (tomcat version)

2018-03-23 Thread Bernd Eckenfels
https://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html#Introduction) Gruss Bernd -- http://bernd.eckenfels.net From: Shawn Heisey Sent: Saturday, March 24, 2018 2:09:59 AM To: user@commons.apache.org Subject: Re: [DBCP] troubleshooting pool activity (tomcat version) On

Re: [DBCP] troubleshooting pool activity (tomcat version)

2018-03-23 Thread Shawn Heisey
On 3/23/2018 5:19 PM, Phil Steitz wrote: > That's the documentation for the alternative pool.  Use this instead: > https://tomcat.apache.org/tomcat-7.0-doc/jndi-datasource-examples-howto.html#Database_Connection_Pool_(DBCP)_Configurations This does not really explain how to configure Tomcat.  It s

Re: [DBCP] troubleshooting pool activity (tomcat version)

2018-03-23 Thread Phil Steitz
On 3/22/18 6:14 PM, Shawn Heisey wrote: > First thing to do is thank you again for taking the time to help me.  > Apache has great communities. > > On 3/22/2018 5:38 PM, Phil Steitz wrote: >> You must be looking at documentation describing how to use the >> alternative pool mentioned above (tomcat-

Re: [DBCP] troubleshooting pool activity (tomcat version)

2018-03-22 Thread Shawn Heisey
First thing to do is thank you again for taking the time to help me.  Apache has great communities. On 3/22/2018 5:38 PM, Phil Steitz wrote: > You must be looking at documentation describing how to use the > alternative pool mentioned above (tomcat-jdbc).  The config you > posted is correct for DB

Re: [DBCP] troubleshooting pool activity (tomcat version)

2018-03-22 Thread Phil Steitz
On 3/21/18 12:15 PM, Shawn Heisey wrote: > On 3/21/2018 1:31 AM, Mark Thomas wrote: >>> and that we need to >>> change the factory on our pool definitions. >> I believe not. > Tomcat's documentation seems to disagree with this point. It > specifically says to use org.apache.tomcat.jdbc.pool.DataSou

Re: [DBCP] troubleshooting pool activity (tomcat version)

2018-03-21 Thread Shawn Heisey
On 3/21/2018 1:31 AM, Mark Thomas wrote: >> and that we need to >> change the factory on our pool definitions. > I believe not. Tomcat's documentation seems to disagree with this point. It specifically says to use org.apache.tomcat.jdbc.pool.DataSourceFactory, and doesn't list any other valid choi

Re: [DBCP] troubleshooting pool activity (tomcat version)

2018-03-21 Thread Mark Thomas
On 21/03/18 04:49, Shawn Heisey wrote: > On 3/20/2018 9:49 PM, Phil Steitz wrote: >> First, find out what version of tomcat you are running.  Then look >> in the tomcat build file sources for the properties that define the >> dbcp and pool versions being used.  In TC 7, I am pretty sure the >> repa

Re: [DBCP] troubleshooting pool activity (tomcat version)

2018-03-20 Thread Shawn Heisey
On 3/20/2018 9:49 PM, Phil Steitz wrote: First, find out what version of tomcat you are running.  Then look in the tomcat build file sources for the properties that define the dbcp and pool versions being used.  In TC 7, I am pretty sure the repackaged sources were always from release tags.  Ask

Re: [DBCP] troubleshooting pool activity (tomcat version)

2018-03-20 Thread Phil Steitz
On 3/20/18 7:21 PM, Shawn Heisey wrote: > I've written before, trying to track down problems with our > database server getting too many connections. > > Based on what I can see of how my programs (using dbcp2) are > working, everything seems to be fine there.  I've added logging to > tell me how m

Re: [DBCP] troubleshooting pool activity (tomcat version)

2018-03-20 Thread Matt Sicker
On Tue, Mar 20, 2018 at 21:21, Shawn Heisey wrote: > Main Question: Does dbcp by chance record a stacktrace of the code that > requests a connection from the pool? I would like to poke my way > through the active connections (entry point being the DataSource > implementation), and ask them wher

[DBCP] troubleshooting pool activity (tomcat version)

2018-03-20 Thread Shawn Heisey
I've written before, trying to track down problems with our database server getting too many connections. Based on what I can see of how my programs (using dbcp2) are working, everything seems to be fine there.  I've added logging to tell me how many idle and active connections there are in th