Re: Tomcat jdbc connections

2022-01-26 Thread Phil Steitz
any queries mmm'kay"). I don't think dbcp does that kind of thing, so you'd have to crank-up the logging level on that application and/or Tomcat instance to see what's happening with the connection pool. Hope that helps, -chris -----Original Message- From: Phil Steitz Sent: 21 January 202

Re: Tomcat jdbc connections

2022-01-21 Thread Phil Steitz
al Message----- From: Phil Steitz Sent: 21 January 2022 16:10 To: users@tomcat.apache.org Subject: Re: Tomcat jdbc connections On 1/21/22 8:19 AM, Alan F wrote: Thanks John, Here is an example of a connection below I see timeBetweenEvictionRunsMillis but not maxConnLifetimeMillis if the server

Re: Tomcat jdbc connections

2022-01-21 Thread Phil Steitz
On 1/21/22 8:19 AM, Alan F wrote: Thanks John, Here is an example of a connection below I see timeBetweenEvictionRunsMillis but not maxConnLifetimeMillis if the server has no traffic does this mean So above does that mean every 60 secs Eviction runs, does this mean a server with no

Re: Tomcat jdbc connections

2022-01-21 Thread Phil Steitz
On 1/21/22 8:19 AM, Alan F wrote: Thanks John, Here is an example of a connection below I see timeBetweenEvictionRunsMillis but not maxConnLifetimeMillis if the server has no traffic does this mean So above does that mean every 60 secs Eviction runs, does this mean a server with no

Re: RemoveAbandoned Problems

2021-12-08 Thread Phil Steitz
On 12/8/21 1:44 PM, Christopher Schultz wrote: Phil, On 12/8/21 15:23, Phil Steitz wrote: On 12/8/21 6:36 AM, Christopher Schultz wrote: Jerry, On 12/7/21 20:59, Jerry Malcolm wrote: Chris, The way I thought it worked was if I configured 'RemoveAbandonedOnBorrow

Re: RemoveAbandoned Problems

2021-12-08 Thread Phil Steitz
On 12/8/21 6:36 AM, Christopher Schultz wrote: Jerry, On 12/7/21 20:59, Jerry Malcolm wrote: Chris, The way I thought it worked was if I configured 'RemoveAbandonedOnBorrow' and RemoveAbandonedTimeout="15" was that each time I requested a new connection from the pool, any connections that

Re: RemoveAbandoned Problems

2021-12-06 Thread Phil Steitz
Sorry again.  Docs are here (at the bottom in the abandoned config section): https://commons.apache.org/proper/commons-dbcp/configuration.html On 12/6/21 10:01 AM, Phil Steitz wrote: On 12/5/21 2:34 PM, Jerry Malcolm wrote: Phil, Thanks for the response.  I saw that note in the docs

Re: RemoveAbandoned Problems

2021-12-06 Thread Phil Steitz
in the pool and getNumActive() > getMaxTotal() - 3. Phil Jerry On 12/5/2021 12:19 PM, Phil Steitz wrote: In order for abandoned connection cleanup to happen, you have to have configured a maintenance (aka "evictor") thread to run.  You need to set the value of timeBetweenEvict

Re: RemoveAbandoned Problems

2021-12-05 Thread Phil Steitz
In order for abandoned connection cleanup to happen, you have to have configured a maintenance (aka "evictor") thread to run.  You need to set the value of timeBetweenEvictionRunsMillis to a positive number. Phil On 12/4/21 9:06 PM, Jerry Malcolm wrote: I had a db connection leak in my code

Re: Determining My Own IP address?

2021-04-01 Thread Phil Steitz
On 4/1/21 7:05 PM, Jerry Malcolm wrote: I am running several clustered Tomcat EC2 instances in an Amazon autoscaling group.  These instances come and go based on load and failure/restart.  IP addresses are assigned dynamically.  As far I can figure, the only determinable difference between

Re: Tomcat JDBC Connection Pool question

2021-02-10 Thread Phil Steitz
See maxWait for Tomcat JDBC Pool https://tomcat.apache.org/tomcat-9.0-doc/jdbc-pool.html Or for the default dbcp pool, maxWaitMillis https://commons.apache.org/proper/commons-dbcp/configuration.html Phil On 2/10/21 3:22 PM, xcorpius wrote: Hi Chris! ConnectionReserveTimeoutSeconds: The

Re: troubled by "SEVERE: Cannot register null bean"

2021-01-10 Thread Phil Steitz
The problem is what Mark pointed out above.  In the type attribute you use the commons package name, but then specify the tomcat factory.  Try changing the type attribute to type="org.apache.tomcat.dbcp.dbcp2.datasources.PerUserPoolPoolDataSource" Phil On 1/10/21 8:41 AM, Rob Sargent wrote:

Re: jdbc connction pool issues [EXTERNAL]

2020-12-15 Thread Phil Steitz
On 12/15/20 1:35 PM, Beard, Shawn wrote: No intitialSize is not defined. Im getting the data to verify from JMX, however we also have an APM called appdynamics loaded. Both verified the 8 max connections. Other tomcat servers with exact same jdbc connection pool config(only difference is

Re: tomcat connection pool per database (postgres)

2020-11-24 Thread Phil Steitz
is the safest longer term bet (my retirement is nigh, it shouldn't take the code with it :) ) On 11/24/20 8:28 AM, Phil Steitz wrote: On 11/24/20 8:14 AM, Rob Sargent wrote: Thanks. I get it. But... - seems this solution raises the footprint of the pooler, with number-of-users * minimum-conn

Re: tomcat connection pool per database (postgres)

2020-11-24 Thread Phil Steitz
On 11/24/20 8:14 AM, Rob Sargent wrote: Thanks. I get it. But... - seems this solution raises the footprint of the pooler, with number-of-users * minimum-connection-count etc - would it be beyond the pale for the pooler to maintain username-connectionList maps? Per response elsethread,

Re: Details of connection pooling

2020-11-20 Thread Phil Steitz
On 11/20/20 10:25 AM, Rob Sargent wrote: I'm using tomcat 9.0.+ and wish to use the built in connection pooling to connect to a postgres server. I would like to understand the lookup mechanism for the next available connection. I create a context    contextResource.setName("jdbc/sgsdb");   

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

2020-08-31 Thread Phil Steitz
use the dbcp2 pool.) Felix [1] https://lists.apache.org/thread.html/r598c0f654477372d112858af1c18bfc04008250156989647d883576f%40%3Cdev.commons.apache.org%3E On Sat, Aug 29, 2020 at 6:50 PM Phil Steitz wrote: On 8/27/20 2:47 AM, Gokhan Akgul wrote: Hi , I have been facing the deadlock

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

2020-08-29 Thread Phil Steitz
On 8/27/20 2:47 AM, Gokhan Akgul wrote: Hi , I have been facing the deadlock issue for the last 2 months about JDBCPoolCleaner Thread . Following config set in context.xml Thread dump Tomcat JDBC Pool Cleaner[63445188:1598345711425] id=16 state=BLOCKED - waiting to lock

Re: Reloading JNDI

2020-08-03 Thread Phil Steitz
On 7/24/20 10:46 AM, Christopher Schultz wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA256 All, I have a JNDI which is a JDBC DataSource. It is set to singleton="true" via defaults (not explicitly set). The JDBC Connections in this DataSource pool (using dbcp2 as provided by Tomcat)

Re: Trying to chase down "too many connection" problems with DB

2018-03-28 Thread Phil Steitz
On 3/28/18 11:29 AM, Christopher Schultz wrote: > Phil, > > On 3/27/18 1:03 PM, Phil Steitz wrote: > > On 3/26/18 10:28 AM, Christopher Schultz wrote: > >> Shawn, > >> > >> On 3/25/18 12:17 AM, Shawn Heisey wrote: > >>> On 3/24/2018 5:04 PM,

Re: Trying to chase down "too many connection" problems with DB

2018-03-28 Thread Phil Steitz
On 3/27/18 5:41 PM, Shawn Heisey wrote: > On 3/27/2018 11:03 AM, Phil Steitz wrote: >> Not exactly, if what you are using is the DBCP pool.  To see the > The factory in use right now is > "org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory".  Information > gathered pr

Re: Trying to chase down "too many connection" problems with DB

2018-03-27 Thread Phil Steitz
On 3/26/18 10:28 AM, Christopher Schultz wrote: > Shawn, > > On 3/25/18 12:17 AM, Shawn Heisey wrote: > > On 3/24/2018 5:04 PM, Mark Thomas wrote: > >> Regarding your configuration: >> auth="Container" > >> factory="org.apache.tomcat.dbcp.dbcp.BasicDataSourceFactory" > >>

Re: /.well-known Hidden directory url returns 404

2017-05-02 Thread Phil Steitz
On 5/1/17 12:11 PM, Ian Brown wrote: > I am trying to https/SSL enable my tomcat application server and have a > problem when I request verification from the CA. > Let's Encrypt requires the certificate request to be placed in > mydomain.tld/.well-known/acme-challenge/ which they query to check

Re: LogAbandoned Stack Trace?

2017-01-10 Thread Phil Steitz
On 1/10/17 12:48 PM, Christopher Schultz wrote: > Phil, > > On 1/8/17 5:41 PM, Phil Steitz wrote: > > On 1/6/17 3:44 PM, Jerry Malcolm wrote: > >> On 1/6/2017 4:30 PM, Christopher Schultz wrote: > >>> -BEGIN PGP SIGNED MESSAGE- Hash: SHA256 > >>

Re: LogAbandoned Stack Trace?

2017-01-08 Thread Phil Steitz
On 1/6/17 3:44 PM, Jerry Malcolm wrote: > On 1/6/2017 4:30 PM, Christopher Schultz wrote: >> -BEGIN PGP SIGNED MESSAGE- >> Hash: SHA256 >> >> Jerry, >> >> On 1/6/17 10:35 AM, Jerry Malcolm wrote: >>> I'm getting "too many connections" errors. >> Where? >> >> Can you provide an exact error

Re: tomcat 7 connection pool validation interval

2016-07-03 Thread Phil Steitz
On 7/1/16 11:35 PM, Nir Dweck wrote: > -Original Message- > From: Phil Steitz [mailto:phil.ste...@gmail.com] > Sent: Friday, July 01, 2016 9:16 PM > To: users@tomcat.apache.org > Subject: Re: tomcat 7 connection pool validation interval > > On 7/1/16 7:1

Re: tomcat 7 connection pool validation interval

2016-07-01 Thread Phil Steitz
On 7/1/16 7:14 AM, Nir Dweck wrote: > -Original Message- > From: Phil Steitz [mailto:phil.ste...@gmail.com] > Sent: Thursday, June 30, 2016 6:57 PM > To: Tomcat Users List > Subject: Re: tomcat 7 connection pool validation interval > > > >>> On Jun 3

Re: tomcat 7 connection pool validation interval

2016-06-30 Thread Phil Steitz
> On Jun 30, 2016, at 9:32 AM, Nir Dweck wrote: > > I am using tomcat connection pool (tomcat 7) in my application (java > application) to connect to a remote Oracle DB on an Azure machine. My > connection pool configuration is as follow: > >PoolProperties p = new

Re: AW: AW: AW: Tomcat 6, DB2 Driver Problems

2015-10-30 Thread Phil Steitz
On 10/29/15 7:14 AM, Christopher Schultz wrote: > Simon, > > On 10/29/15 4:28 AM, simone.rodenbach@devk.de wrote: >> Thx, >> >> I hope this information helps: (The >> org.apache.commons.pool.impl.GenericObjectPool starts a timer ... ) >> >> ava.util.TimerThread @ 0xc0772288

Re: [OT] Too Many Connections exceptions after moving to Tomcat 8

2015-08-04 Thread Phil Steitz
On 8/4/15 2:03 PM, Christopher Schultz wrote: Phil, On 8/1/15 9:34 PM, Phil Steitz wrote: On 8/1/15 6:14 PM, Christopher Schultz wrote: Phil, On 8/1/15 11:12 AM, Phil Steitz wrote: Sorry the docs are not that clear. The problem is that the config properties work together

Re: Too Many Connections exceptions after moving to Tomcat 8

2015-08-01 Thread Phil Steitz
On 7/31/15 8:16 AM, Christopher Schultz wrote: Phil, On 7/30/15 8:05 PM, Phil Steitz wrote: On 7/30/15 9:03 AM, Christopher Schultz wrote: Jerry, On 7/29/15 3:25 PM, Jerry Malcolm wrote: Well, it appears that we are slowly getting to the bottom of this. But with every answer, I get

Re: [OT] Too Many Connections exceptions after moving to Tomcat 8

2015-08-01 Thread Phil Steitz
On 8/1/15 6:14 PM, Christopher Schultz wrote: Phil, On 8/1/15 11:12 AM, Phil Steitz wrote: Sorry the docs are not that clear. The problem is that the config properties work together to determine behavior and documenting them individually makes it hard to put the whole picture together

Re: Too Many Connections exceptions after moving to Tomcat 8

2015-07-30 Thread Phil Steitz
On 7/30/15 9:03 AM, Christopher Schultz wrote: Jerry, On 7/29/15 3:25 PM, Jerry Malcolm wrote: Well, it appears that we are slowly getting to the bottom of this. But with every answer, I get a few more questions First, I installed the latest TC8 on my laptop, copied my server.conf

Re: Java stack trace, unable to connect to the database

2015-07-14 Thread Phil Steitz
On 7/14/15 1:11 PM, Christopher Schultz wrote: Laurence, On 7/14/15 2:32 PM, Laurence Cohen wrote: We are suddenly having a problem with our Tomcat WebApp connecting to the database. Unfortunately I can't give you the whole thing because the error is on a network that is restricted, and

Re: Error in DBCP Connection Pool with tomcat 6.x

2014-07-02 Thread Phil Steitz
On 7/1/14, 10:48 PM, Vijendra Pachoriya wrote: Hi Filip, This error comes at some point of time on production, when the server is on load. I am using hibernate and not closing any connection manually, its all managed by hibernate and tomcat dbcp connection pool. Two additional things to

Re: Not supported by Basic Datasource

2010-12-14 Thread Phil Steitz
On Tue, Dec 14, 2010 at 6:42 AM, SOPANMISHRA sopan.mis...@gmail.com wrote: 1. I have posted the exact tags that i'm using in my hibernate.cfg.xml 2. regarding the BasicDataSource.getConnection in DBCP-1.2.2 ,I have not mentioned username,password tag in my hibernate.cfg.xml so is there any

Re: DBCP connections not in accordance with netstat output

2010-10-20 Thread Phil Steitz
On 10/20/10 5:32 AM, Felix Schumacher wrote: Hi Marc, Am Mittwoch, den 20.10.2010, 00:54 +0200 schrieb Marc Wilmots: Hi List, I installed Lambda Probe to debug a problem that I'm having with a Liferay portal (5.1.2): Tomcat: 6.0.26 with dbcp JDK: 1.6.0_18 DB: Oracle 10.2.0.4 (ojdbc14) RHEL

Re: tomcat 6.0.29 hung

2010-10-20 Thread Phil Steitz
On 10/20/10 7:11 PM, Jason Britton wrote: Thankfully when I pulled up jvisualvm on the server and issued thread dumps, even though the stacktraces for the threads did not come up within jvisualvm the thread stacktraces were dumped to stdout. So I did get thread stacktraces in my tomcat log.

Re: DelegatingCallableStatement.getInnermostDelegate() -- NoSuchMethodError

2008-03-15 Thread Phil Steitz
On Fri, Mar 14, 2008 at 5:03 PM, Jim Garrison [EMAIL PROTECTED] wrote: I'm getting a NoSuchMethodError on org.apache.commons.dbcp.DelegatingCallableStatement.getInnermostDelegate (). AFAICT DelegatingCallableStatement inherits ultimately from DelegatingStatement, which DOES have such a

Re: connection pool maxActive = 0 != unlimited in new version

2008-03-08 Thread Phil Steitz
On Fri, Mar 7, 2008 at 3:41 PM, william kinney [EMAIL PROTECTED] wrote: Hi, After some painful research and code digging, I found that in commons-pool versions 1.2 (ie 1.3 and 1.4), the logic for maxActive changed for unlimited. 0 no longer means unlimited as it did in 1.2 and previous

Re: Getting the URL of a DataSource

2008-03-04 Thread Phil Steitz
On Mon, Mar 3, 2008 at 2:08 PM, Katilie, John [EMAIL PROTECTED] wrote: All, this may be a dumb question but I've exhausted my research and just wondering what other users out there are doing. I would like to get the URL for a DataSource to display for debugging and/or Informational

Re: DBCP: Threads sitting forever in getConnection()?

2008-01-27 Thread Phil Steitz
On Jan 27, 2008 4:32 PM, Clay Collier [EMAIL PROTECTED] wrote: Hi all- I'm running into a recurring problem with an application that uses DBCP pooling to access a database. The application initially seems to run fine; in the test environment, it has no problem dealing with a large volume of