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

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

Re: Getting the URL of a DataSource

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: connection pool maxActive = 0 != unlimited in new version

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: DelegatingCallableStatement.getInnermostDelegate() -- NoSuchMethodError

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: DBCP connections not in accordance with netstat output

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

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: Not supported by Basic Datasource

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: Error in DBCP Connection Pool with tomcat 6.x

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: Too Many Connections exceptions after moving to Tomcat 8

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

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

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: [OT] Too Many Connections exceptions after moving to Tomcat 8

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: Java stack trace, unable to connect to the database

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: AW: AW: AW: Tomcat 6, DB2 Driver Problems

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: tomcat 7 connection pool validation interval

> 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: tomcat 7 connection pool validation interval

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

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: LogAbandoned Stack Trace?

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?

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: /.well-known Hidden directory url returns 404

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: Trying to chase down "too many connection" problems with DB

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: Trying to chase down "too many connection" problems with DB

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

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: Tomcat JDBC Pool Cleaner Deadlock Problem

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

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

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: tomcat connection pool per database (postgres)

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: tomcat connection pool per database (postgres)

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: jdbc connction pool issues [EXTERNAL]

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: Details of connection pooling

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: troubled by "SEVERE: Cannot register null bean"

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: Tomcat JDBC Connection Pool question

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: Determining My Own IP address?

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: RemoveAbandoned Problems

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

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

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

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

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

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

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

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 dbcp2 connection pool configuration

On Tue, Jan 16, 2024 at 9:07 AM Christopher Schultz < ch...@christopherschultz.net> wrote: > Hello, > > On 1/11/24 11:08, அருள்ராஜன் அ லை wrote: > > Hi > > > > We are using Tomcat 9.0.84 and Tomcat DBCP2 connection pool and the DB is > > Oracle 19c. We are seeing the closed connections and the