Re: Clarification on behaviour after pool exhaustion happen in tomcat jdbc pool 9.0.16

Sampath, On 8/12/21 07:02, Sampath Rajapakshe wrote: Hi Chris, Thanks for the detailed explanation, yes, we tried with abandoned true logs and found an issue with our code base as well. It seems we had a case where a single thread creates a new connection and before closing that connection crea

Re: Clarification on behaviour after pool exhaustion happen in tomcat jdbc pool 9.0.16

Hi Chris, Thanks for the detailed explanation, yes, we tried with abandoned true logs and found an issue with our code base as well. It seems we had a case where a single thread creates a new connection and before closing that connection creates a new connection and closes that new connection and

Re: Clarification on behaviour after pool exhaustion happen in tomcat jdbc pool 9.0.16

Sampath, On 8/9/21 01:45, Sampath Rajapakshe wrote: In our case, we know the reason for the pool exhausted behaviour, there are slow queries and also due to high TPS where pool is not enough. So we are expected to get pool exhaustion with current configurations. Ok. What we wanted to verify w

Re: Clarification on behaviour after pool exhaustion happen in tomcat jdbc pool 9.0.16

Hi Chris, Thanks for the clarification. I've gone through the blog, In our case, we know the reason for the pool exhausted behaviour, there are slow queries and also due to high TPS where pool is not enough. So we are expected to get pool exhaustion with current configurations. What we wanted to v

Re: Clarification on behaviour after pool exhaustion happen in tomcat jdbc pool 9.0.16

Sampath, On 8/6/21 08:37, Sampath Rajapakshe wrote: Hi All, In my local setup before pool exhaustion exception is thrown, all the connections seem to be in freezed and when checking processList in mysql, those connections are in sleep state and doesn't execute any queries. After waiting for max

Clarification on behaviour after pool exhaustion happen in tomcat jdbc pool 9.0.16

Hi All, In my local setup before pool exhaustion exception is thrown, all the connections seem to be in freezed and when checking processList in mysql, those connections are in sleep state and doesn't execute any queries. After waiting for maxWait period the pool exhausted exception gets thrown an

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

   minIdle="10" >>>>>    maxWait="3" >>>>>    timeBetweenEvictionRunsMillis="5000" >>>>>    minEvictableIdleTimeMillis="6" >>>>>    removeAbandoned

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

testWhileIdle="true" testOnBorrow="true" testOnReturn="false" validationQuery="/* ping */ SELECT 1" validationInterval="3" jmxEnabled="true" jdbcInter

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

000" >>> timeBetweenEvictionRunsMillis="5000" >>> minEvictableIdleTimeMillis="6" >>> removeAbandonedTimeout="600" >>> removeAbandoned="true" >>>

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

>>> timeBetweenEvictionRunsMillis="5000" >>> minEvictableIdleTimeMillis="6" >>> removeAbandonedTimeout="600" >>> removeAbandoned="true" >>>

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

ot;600" > > removeAbandoned="true" > > logAbandoned="false" > > testWhileIdle="true" > > testOnBorrow="true" > > testOnRe

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

uot;6" > > removeAbandonedTimeout="600" > > removeAbandoned="true" > > logAbandoned="false" > > testWhileIdle="true" > > testOnBorrow="true" >

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

" > removeAbandoned="true" > logAbandoned="false" > testWhileIdle="true" > testOnBorrow="true" > testOnReturn="false" > validationQuery="/* ping */ SELECT

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

aracterEncoding > =latin5&characterResultSet=latin5&zeroDateTimeBehavior=convertTo > Null&autoReconnect=true&interactiveClient=true" > > > > > username="user" > > password="pass" initialSize="10" maxActive="30" maxIdle="

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

inEvictableIdleTimeMillis="6" removeAbandonedTimeout="600" > removeAbandoned="true" logAbandoned="false" testWhileIdle="true" > testOnBorrow="true" testOnReturn="false" validationQuery="/* ping > */ SELECT 1&qu

Tomcat JDBC Pool Cleaner Deadlock Problem

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 <0x57dcb0b7> (a com.mysql.jdbc.JDBC4PreparedSta

RE: Tomcat JDBC Pool memory leak when using StatementFinalizer interceptor

> From: Felix Schumacher [mailto:felix.schumac...@internetallee.de] > Subject: Re: Tomcat JDBC Pool memory leak when using StatementFinalizer interceptor > Am 11.07.2018 um 16:22 schrieb Martin Knoblauch: > > Now it might be, that we are just using the StatementFinalizer in a w

Re: Tomcat JDBC Pool memory leak when using StatementFinalizer interceptor

Am 11.07.2018 um 16:22 schrieb Martin Knoblauch: Hi, while analyzing some heap dump for other reasons, I found that our application is apparently aggregating a considerable amount of memory in "org.apache.tomcat.jdbc.pool.TrapException", which is never cleaned by GC. Digging deeper, it seem

Tomcat JDBC Pool memory leak when using StatementFinalizer interceptor

Hi, while analyzing some heap dump for other reasons, I found that our application is apparently aggregating a considerable amount of memory in "org.apache.tomcat.jdbc.pool.TrapException", which is never cleaned by GC. Digging deeper, it seems that the entries of the "statements" linked list in t

Re: Tomcat JDBC pool - too many connections in TIME_WAIT state

net/ipv4/tcp_fin_timeoutecho 15 > > > /proc/sys/net/ipv4/tcp_fin_timeout > > > > > > On Wed, Nov 5, 2014 at 7:36 AM, Daniel Mikusa > wrote: > > > > > On Wed, Nov 5, 2014 at 9:13 AM, Vasily Kukhta > > > wrote: > > > > > > >

Re: Tomcat JDBC pool - too many connections in TIME_WAIT state

On 6 November 2014 05:36, Vasily Kukhta wrote: > I have received additional details - the application starts getting > "java.sql.SQLException: Listener refused the connection with the following > error: ORA-12519, TNS:no appropriate service handler found", although the > amount of listeners in the

Re: Tomcat JDBC pool - too many connections in TIME_WAIT state

/tcp_fin_timeout > > > On Wed, Nov 5, 2014 at 7:36 AM, Daniel Mikusa wrote: > > > On Wed, Nov 5, 2014 at 9:13 AM, Vasily Kukhta > > wrote: > > > > > Hello all! > > > > > > I have developed an application using Tomcat JDBC pool. Eve

Re: Tomcat JDBC pool - too many connections in TIME_WAIT state

014 at 7:36 AM, Daniel Mikusa wrote: > On Wed, Nov 5, 2014 at 9:13 AM, Vasily Kukhta > wrote: > > > Hello all! > > > > I have developed an application using Tomcat JDBC pool. Everything is > fine > > except that the pool leaves hundreds of TCP connections in T

Re: Tomcat JDBC pool - too many connections in TIME_WAIT state

On Wed, Nov 5, 2014 at 9:13 AM, Vasily Kukhta wrote: > Hello all! > > I have developed an application using Tomcat JDBC pool. Everything is fine > except that the pool leaves hundreds of TCP connections in TIME_WAIT state, > I have to ask, but are you sure it's the pool? TC

Tomcat JDBC pool - too many connections in TIME_WAIT state

Hello all! I have developed an application using Tomcat JDBC pool. Everything is fine except that the pool leaves hundreds of TCP connections in TIME_WAIT state, which kills the server sooner or later... Could you please suggest what to fix, my configuration is below: PoolProperties

Re: Tomcat JDBC pool - auto reconnect

On Fri, Oct 10, 2014 at 9:51 AM, Vasily Kukhta wrote: > Hi friends, > > I have a question regarding the ability of Tomcat JDBC pool to reconnect > automatically to a database in case of temporarily network failures. > > I'm developing a high-load application which uses

Tomcat JDBC pool - auto reconnect

Hi friends, I have a question regarding the ability of Tomcat JDBC pool to reconnect automatically to a database in case of temporarily network failures. I'm developing a high-load application which uses Oracle 11g database. It may happen that the DB can become unavailable for several mi

Re: Debugging Tomcat JDBC pool disconnects.

> > > > > -BEGIN PGP SIGNED MESSAGE- > > > Hash: SHA256 > > > > > > Todd, > > > > > > On 9/23/14 11:41 AM, Todd Chapman wrote: > > > > My application uses the Tomcat JDBC pool. While using net

Re: Debugging Tomcat JDBC pool disconnects.

p 24, 2014 at 9:36 AM, Christopher Schultz < > ch...@christopherschultz.net> wrote: > > > -BEGIN PGP SIGNED MESSAGE- > > Hash: SHA256 > > > > Todd, > > > > On 9/23/14 11:41 AM, Todd Chapman wrote: > > > My application uses the Tomcat JDBC pool. While using n

Re: Debugging Tomcat JDBC pool disconnects.

:36 AM, Christopher Schultz < ch...@christopherschultz.net> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 > > Todd, > > On 9/23/14 11:41 AM, Todd Chapman wrote: > > My application uses the Tomcat JDBC pool. While using netstat and > > tcpdump to di

Re: Debugging Tomcat JDBC pool disconnects.

uses the Tomcat JDBC pool. While using netstat and tcpdump > to diagnose connection problems I noticed that the client side occasionally > closes a DB connection and opens a new one. That is unexpected based on my > configuration. > > poolProperties.setInitialSize(10); >

Re: Debugging Tomcat JDBC pool disconnects.

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Todd, On 9/23/14 11:41 AM, Todd Chapman wrote: > My application uses the Tomcat JDBC pool. While using netstat and > tcpdump to diagnose connection problems I noticed that the client > side occasionally closes a DB connection and opens

Debugging Tomcat JDBC pool disconnects.

Hi, My application uses the Tomcat JDBC pool. While using netstat and tcpdump to diagnose connection problems I noticed that the client side occasionally closes a DB connection and opens a new one. That is unexpected based on my configuration. poolProperties.setInitialSize(10

Re: tomcat jdbc pool, creating a pool of pools, single connection memory footprint

2 years later ... OK this sounds like the best approach as it lets you scale things out as you grow and actually need more servers (then you just have to manage which database to switch too). The cons of this approach is that most ORM's don't support this. On Fri, Jun 1, 2012 at 2:37 PM, Christ

Re: Query timeouts using tomcat jdbc pool

maxAge is not a timeout setting. It simply means the connection gets retired(closed) instead of returned to the pool after a certain amount of time timeBetweenEvictionRunsMillis is not a timeout either. It is the interval that the thread checks for timeouts, but not query, connection checkout time

Re: Query timeouts using tomcat jdbc pool

So, it means that if the timeout is detected not using setQueryTimeout method, but by the tomcat pool settings (setMaxAge or setTimeBetweenEvictionRunsMillis), it means that no exception can be thrown at all? Vasily 2014-07-23 12:14 GMT+04:00 Filip Hanik : > Vasily, the exception depends on wh

Re: Query timeouts using tomcat jdbc pool

Vasily, the exception depends on where the timeout occurs. If the timeout is triggered by the driver, because you hit the setQueryTimeout limit http://docs.oracle.com/javase/7/docs/api/java/sql/Statement.html#setQueryTimeout(int) then yes, as per javadoc, it is up to the JDBC driver to throw an ex

Re: Query timeouts using tomcat jdbc pool

Thank you, I have changed timeBetweenEvictionRunsMillis value and it is working properly now. Another problem has appeared: although the timeout is handled correctly, no exception is thrown. I thought an SQLException would be thrown if query takes too long. Maybe pool does not throw exceptions at a

Re: Query timeouts using tomcat jdbc pool

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Vasily, On 7/21/14, 11:05 AM, Vasily Kukhta wrote: > Oracle database. It is very important to ensure my app to have very > small DB query timeouts (no longer than 3 seconds) to prevent > long-running queries or database slowness from blocking all my

Re: Query timeouts using tomcat jdbc pool

On Mon, Jul 21, 2014 at 11:05 AM, Vasily Kukhta wrote: > Hello, dear tomcat users! > > I am developing high-load application using tomcat jdbc connection pool and > Oracle database. It is very important to ensure my app to have very small > DB query timeouts (no longer than 3 seconds) to prevent

Query timeouts using tomcat jdbc pool

Hello, dear tomcat users! I am developing high-load application using tomcat jdbc connection pool and Oracle database. It is very important to ensure my app to have very small DB query timeouts (no longer than 3 seconds) to prevent long-running queries or database slowness from blocking all my app

Re: PooledConnection.getConnection - Tomcat JDBC Pool

Jonathan opened up the following bug https://issues.apache.org/bugzilla/show_bug.cgi?id=56310 and I do believe our pool is incorrectly implementing the ConnectionPoolDatasource. I do believe it shouldn't implement that interface at all. On Wed, Mar 26, 2014 at 10:41 AM, Christopher Schultz < ch

Re: PooledConnection.getConnection - Tomcat JDBC Pool

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Jonathan, On 3/26/14, 9:16 AM, Pierce, Jonathan D wrote: > I agree that it is counter-intuitive. I also agree that the > application should not need to use the PooledConnection interface. > > However, XAConnection is needed to be used by a transac

RE: PooledConnection.getConnection - Tomcat JDBC Pool

: PooledConnection.getConnection - Tomcat JDBC Pool > From: Christopher Schultz [mailto:ch...@christopherschultz.net] > Subject: Re: PooledConnection.getConnection - Tomcat JDBC Pool > On 3/25/14, 10:53 AM, Pierce, Jonathan D wrote: > > In the Aries class, the expectation is that > > XACon

RE: PooledConnection.getConnection - Tomcat JDBC Pool

> From: Christopher Schultz [mailto:ch...@christopherschultz.net] > Subject: Re: PooledConnection.getConnection - Tomcat JDBC Pool > On 3/25/14, 10:53 AM, Pierce, Jonathan D wrote: > > In the Aries class, the expectation is that > > XAConnection.getConnection().cl

Re: PooledConnection.getConnection - Tomcat JDBC Pool

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Jonathan, On 3/25/14, 10:53 AM, Pierce, Jonathan D wrote: > In the Aries class, the expectation is that > XAConnection.getConnection().close() will return the connection to > the pool, and that XAConnection.close() would close the physical > conn

RE: PooledConnection.getConnection - Tomcat JDBC Pool

I've created Bug 56310 for this issue. Jonathan -Original Message- From: Pierce, Jonathan D Sent: Tuesday, March 25, 2014 10:54 AM To: Tomcat Users List Subject: RE: PooledConnection.getConnection - Tomcat JDBC Pool In the Aries class, the expectation is that XAConnection.getConne

RE: PooledConnection.getConnection - Tomcat JDBC Pool

n...@gmail.com] Sent: Tuesday, March 25, 2014 10:42 AM To: Tomcat Users List Subject: Re: PooledConnection.getConnection - Tomcat JDBC Pool On Tue, Mar 25, 2014 at 9:54 AM, Filip Hanik wrote: > Please open a bug, and we will get this taken care of. I do have one > question,Aries library, on wh

Re: PooledConnection.getConnection - Tomcat JDBC Pool

> > Jonathan, Filip, If it is a bug then my answer is way off the mark. I'm sorry. If it's not a problem, could you explain, in this case, what acts as the connection pool manager when the Tomcat jdbc pool library is used outside of Tomcat? Best, John

Re: PooledConnection.getConnection - Tomcat JDBC Pool

ing to use the tomcat jdbc pool library (outside of tomcat) > along with the Apache Aries Transaction library in an OSGi environment > to handle distributed transactions. > > One of the classes (XADataSourceEnlistingWrapper) provided by the > Aries Transaction wrappers library is a

Re: PooledConnection.getConnection - Tomcat JDBC Pool

> If that is the case the tomcat jdbc > pooling library handling the call incorrectly and its a bug. > I'd be suspect of this. Are you actually using *org.apache.tomcat.jdbc.pool*? Since it's a Tomcat module it seems an odd choice to use outside of Tomcat. http://docs.oracle.com/javase/7/docs/ap

PooledConnection.getConnection - Tomcat JDBC Pool

I am trying to use the tomcat jdbc pool library (outside of tomcat) along with the Apache Aries Transaction library in an OSGi environment to handle distributed transactions. One of the classes (XADataSourceEnlistingWrapper) provided by the Aries Transaction wrappers library is a DataSource

Re: NPE in ResultSetImpl.next() using tomcat jdbc pool

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Henning, On 10/10/13 10:01 AM, Henning Rohlfs wrote: > I've been trying to figure this problem out for some time now and > I'm totally stuck. The Exception in question is the following: > Caused by: java.lang.NullPointerException at > com.mysql.jdb

NPE in ResultSetImpl.next() using tomcat jdbc pool

Hello, I've been trying to figure this problem out for some time now and I'm totally stuck. The Exception in question is the following: Caused by: java.lang.NullPointerException at com.mysql.jdbc.ResultSetImpl.next(ResultSetImpl.java:7009) at com.server.persistence.state.connectors

Re: Fwd: Tomcat Jdbc Pool - NumActive vs actual Established Connections

oblem. Regards Kiren -- View this message in context: http://tomcat.10.x6.nabble.com/Fwd-Tomcat-Jdbc-Pool-NumActive-vs-actual-Established-Connections-tp4997798p4997849.html Sent from the Tomcat - User mailing list archive at Nabbl

Re: Tomcat Jdbc Pool - NumActive vs actual Established Connections

2013/4/16 Kiren Pillay > Hi All, > > I am using the tomcat-jdpc-pool from within my spring application. I am > noticing a discrepancy between the numActive/numIdle values that the pool > reports versus the actual number of established connections to the > database. > > For example, the pool repor

Re: Fwd: Tomcat Jdbc Pool - NumActive vs actual Established Connections

Regards -- View this message in context: http://tomcat.10.x6.nabble.com/Fwd-Tomcat-Jdbc-Pool-NumActive-vs-actual-Established-Connections-tp4997798p4997845.html Sent from the Tomcat - User mailing list archive at

Fwd: Tomcat Jdbc Pool - NumActive vs actual Established Connections

Hi All, I am using the tomcat-jdpc-pool from within my spring application. I am noticing a discrepancy between the numActive/numIdle values that the pool reports versus the actual number of established connections to the database. For example, the pool reports 0 active and 4 idle connections whil

Re: Tomcat jdbc-pool not closing statements

Bug reported at https://issues.apache.org/bugzilla/show_bug.cgi?id=54732 Due to another bug in TomEE, StatementCache is always enabled. That bug is reported here: https://issues.apache.org/jira/browse/TOMEE-837 Thanks for your help On 20/03/2013 7:28 AM, Felix Schumacher wrote: Am 19.03.2013

Re: Tomcat jdbc-pool not closing statements

Bug reported at https://issues.apache.org/bugzilla/show_bug.cgi?id=54732 Due to another bug in TomEE, StatementCache is always enabled. That bug is reported here: https://issues.apache.org/jira/browse/TOMEE-837 Thanks for your help On 20/03/2013 7:28 AM, Felix Schumacher wrote: Am 19.03.2013

Re: Tomcat jdbc-pool not closing statements

Am 19.03.2013 22:20, schrieb Bertrand Guay-Paquet: On 19/03/2013 5:05 PM, Felix Schumacher wrote: Have you looked at http://grokbase.com/t/openejb/users/13135d2a0v/jdbc-connection-pool-memory-leak ? It seems like your problem. Regards Felix Indeed, this is extremely similar to my issue. Thank

Re: Tomcat jdbc-pool not closing statements

On 19/03/2013 5:05 PM, Felix Schumacher wrote: Have you looked at http://grokbase.com/t/openejb/users/13135d2a0v/jdbc-connection-pool-memory-leak ? It seems like your problem. Regards Felix Indeed, this is extremely similar to my issue. Thanks for sharing this. It does seem however like the S

Re: Tomcat jdbc-pool not closing statements

Bertrand Guay-Paquet schrieb: >Hello, > >I'm using Tomcat 7.0.34 via TomEE 1.5.1 with MySQL. I noticed a memory >leak in my web application which uses jdbc connection pooling with >Tomcat's jdbc-pool. > >The com.mysql.jdbc.JDBC4Connection class has a field named >"openStatements" which holds

Re: Tomcat jdbc-pool not closing statements

Can you post some example of your code? Can you also post your pool's configuration? Here is my configuration from tomee.xml. I'm not 100% sure how it maps to Tomcat values though. JdbcDriver=com.mysql.jdbc.Driver JdbcUrl=jdbc:mysql://localhost:3306/DBNAME UserName= Password=

Re: Tomcat jdbc-pool not closing statements

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Bertrand, On 3/19/13 3:48 PM, Bertrand Guay-Paquet wrote: > I'm using Tomcat 7.0.34 via TomEE 1.5.1 with MySQL. I noticed a > memory leak in my web application which uses jdbc connection > pooling with Tomcat's jdbc-pool. > > The com.mysql.jdbc.JDB

Tomcat jdbc-pool not closing statements

Hello, I'm using Tomcat 7.0.34 via TomEE 1.5.1 with MySQL. I noticed a memory leak in my web application which uses jdbc connection pooling with Tomcat's jdbc-pool. The com.mysql.jdbc.JDBC4Connection class has a field named "openStatements" which holds, as you can imagine, open sql statement

Re: Tomcat jdbc pool connection failover

er. >> >> > I am not sure that I totally follow the arguments here, but it seems that > there exist > - a JDBC pool with good performance, but no fail-over > - a JDBC pool with failover, but bad performance > Why not move the problem one

Re: Tomcat jdbc pool connection failover

Rainer Frey wrote: On 12.03.2013, at 17:14, Christopher Schultz wrote: On 3/12/13 7:54 AM, amit shah wrote: I am using Oracle. Oracle JDBC Driver provides the Oracle Universal Connection Pool (UCP) which includes this featureo

Re: Tomcat jdbc pool connection failover

On 12.03.2013, at 17:14, Christopher Schultz wrote: > On 3/12/13 7:54 AM, amit shah wrote: >> I am using Oracle. Oracle JDBC Driver provides the Oracle >> Universal Connection Pool (UCP) which includes this >> featureof >> >> >

Re: Tomcat jdbc pool connection failover

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Amit, On 3/12/13 7:54 AM, amit shah wrote: > I am using Oracle. Oracle JDBC Driver provides the Oracle > Universal Connection Pool (UCP) which includes this > featureof > > connecti

Re: Tomcat jdbc pool connection failover

oadbalancer listing both database servers with one inactive - then you > mark the secondary server as active, and the primary as inactive during > maintenance of the primary database server. > > Thanks. > > -Shanti > > > > > > >> On Mo

Re: Tomcat jdbc pool connection failover

> On 3/11/13 12:52 AM, amit shah wrote: > > Hello, I would like to know if the tomcat jdbc pool (7.0.34+) > > provides connection failover capabilities i.e. to transparently > > close all the open database connections and switch to a another > > database server on an plan

Re: Tomcat jdbc pool connection failover

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Amit, On 3/11/13 12:52 AM, amit shah wrote: > Hello, I would like to know if the tomcat jdbc pool (7.0.34+) > provides connection failover capabilities i.e. to transparently > close all the open database connections and switch to

Re: Tomcat jdbc pool connection failover

unless it couldn't get a connection. Then it would use the secondary. Not a great solution, but sounds similar to what you mentioned. Dan > > Thanks. > > > On Mon, Mar 11, 2013 at 6:15 PM, Daniel Mikusa wrote: > >> On Mar 11, 2013, at 12:52 AM, amit shah wrote:

Re: Tomcat jdbc pool connection failover

nd the primary as inactive during maintenance of the primary database server. Thanks. -Shanti > > >> On Mon, Mar 11, 2013 at 6:15 PM, Daniel Mikusa >> wrote: >> >> On Mar 11, 2013, at 12:52 AM, amit shah wrote: >>> >>> Hell

Re: Tomcat jdbc pool connection failover

a possibility that even your backup database server would also be unreachable, no ? Thanks. On Mon, Mar 11, 2013 at 6:15 PM, Daniel Mikusa wrote: On Mar 11, 2013, at 12:52 AM, amit shah wrote: Hello, I would like to know if the tomcat jdbc pool (7.0.34+) provides connection failov

Re: Tomcat jdbc pool connection failover

; > Hello, > >I would like to know if the tomcat jdbc pool (7.0.34+) provides > > connection failover capabilities i.e. to transparently close all the open > > database connections and switch to a another database server on an > > planned/unplanned database server outage

Re: Tomcat jdbc pool connection failover

On Mar 11, 2013, at 12:52 AM, amit shah wrote: > Hello, >I would like to know if the tomcat jdbc pool (7.0.34+) provides > connection failover capabilities i.e. to transparently close all the open > database connections and switch to a another database server on an > pl

Re: Tomcat jdbc pool connection failover

amit shah wrote: Hello, I would like to know if the tomcat jdbc pool (7.0.34+) provides connection failover capabilities i.e. to transparently close all the open database connections and switch to a another database server on an planned/unplanned database server outage event. I

Re: Increase load and decrease performance while replace DBCP to Tomcat jdbc-pool

quot;jdbc-pool". https://tomcat.apache.org/tomcat-7.0-doc/changelog.html > > After problems with connection leak and deadlocks in DBCP we made a decision > to replace it with Tomcat JDBC-pool. Of course migration was really simple. > > But after deploy it on a production env

Increase load and decrease performance while replace DBCP to Tomcat jdbc-pool

Hi all, We are using Tomcat 7.0.25 on CentOS 5.5 64b. After problems with connection leak and deadlocks in DBCP we made a decision to replace it with Tomcat JDBC-pool. Of course migration was really simple. But after deploy it on a production environment I noticed, that load on a server

?????? tomcat jdbc pool stackoverflow error used with spring

Thanks for help. I submit a bug here: https://issues.apache.org/bugzilla/show_bug.cgi?id=54235 Yanky -- -- ??: "Konstantin Kolinko"; : 2012??12??2??(??) 6:24 ??: "Tomcat Users List"; ????: Re: tomcat jdb

Re: tomcat jdbc pool, creating a pool of pools, single connection memory footprint

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ahmed, On 5/31/12 9:33 AM, S Ahmed wrote: >> It would be easier if all databases were hosted by a single >> instance of MySQL -- then you could use Tomcat-pool's feature of >> being able to provide credentials when obtaining connections from >> the po

Re: tomcat jdbc pool, creating a pool of pools, single connection memory footprint

>It would be easier if all databases were hosted by a single instance >of MySQL -- then you could use Tomcat-pool's feature of being able to >provide credentials when obtaining connections from the pool -- and >get the right database. That way, a much smaller number of connections >could be maintai

Re: tomcat jdbc pool, creating a pool of pools, single connection memory footprint

On 31 May 2012, at 00:49, Christopher Schultz wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > André, > > On 5/30/12 6:18 PM, André Warnier wrote: >> Taking the same hypothetical case and figures : >> >> Assuming that you need a total of (1 * 4 connections) = 4 >> connections.

Re: tomcat jdbc pool, creating a pool of pools, single connection memory footprint

On 30 May 2012, at 23:19, "André Warnier" wrote: >> On Wed, May 30, 2012 at 10:07 AM, Christopher Schultz < >> ch...@christopherschultz.net> wrote: > .. >>> >>> If my environment and requirements match yours, you'd need 1 * >>> max_pool_size * 66KiB at peak usage. That's about 640MiB for each

Re: tomcat jdbc pool, creating a pool of pools, single connection memory footprint

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 André, On 5/30/12 6:18 PM, André Warnier wrote: > Taking the same hypothetical case and figures : > > Assuming that you need a total of (1 * 4 connections) = 4 > connections. Assuming that it takes 10ms to set up one such > connection, and

Re: tomcat jdbc pool, creating a pool of pools, single connection memory footprint

On Wed, May 30, 2012 at 10:07 AM, Christopher Schultz < ch...@christopherschultz.net> wrote: .. If my environment and requirements match yours, you'd need 1 * max_pool_size * 66KiB at peak usage. That's about 640MiB for each connection you want in 10k pools. For a (uniform) max pool size o

Re: tomcat jdbc pool, creating a pool of pools, single connection memory footprint

Chris, Great thanks that is exactly what I was looking for, just to get an idea at this point. And yes it was for mysql. I was thinking one could create a smarter pool, one that created more connections for sites used more often, and less for others. Much appreciated. On Wed, May 30, 2012 at 1

Re: tomcat jdbc pool, creating a pool of pools, single connection memory footprint

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ahmed, On 5/29/12 9:29 AM, S Ahmed wrote: > If my requirement for a hosted application is to give each > customer a separate instance of mysql, I am curious how feasible > that would be. You can certainly do this. > What is the memory footprint for

Re: tomcat jdbc pool

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 S Ahmed, On 3/25/12 6:57 PM, S Ahmed wrote: > Why would you want to use a future? > > Say in a web application, I can't really think of a reason why I > would use the future (asych) connection retrieval pattern. The # > of connections is always fix

Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32)

app holding on to the flawed connection, cause there > > would have been several validations during the 2 hour period :) I think > > there is a loop somewhere that when it fails it just retries and retries, > > logAbandoned will show that though. > > > > Filip > >

Re: tomcat jdbc pool

Why would you want to use a future? Say in a web application, I can't really think of a reason why I would use the future (asych) connection retrieval pattern. The # of connections is always fixed, I guess in a very high traffic environment where the # of connections is the pool are used up, cal

Re: tomcat jdbc pool

2012/3/26 S Ahmed : > Is the jdbc pool somehow married to tomcat or can I use it with other > containers potentially? ( 1. You certainly can use it with other containers. But it depends on Tomcat version of logging library (That is tomcat-juli.jar). You have to copy that jar as well. >> http://

Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32)

ed will show that though. > > Filip > > > > > - Original Message - > > From: "Colin Ingarfield" > > To: "Tomcat Users List" > > Sent: Thursday, March 22, 2012 8:06:14 AM > > Subject: Re: how to enable debug logging for Tomc

Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32)

tions during the 2 hour period :) I think > there is a loop somewhere that when it fails it just retries and retries, > logAbandoned will show that though. > > Filip > > > > > ----- Original Message - > > From: "Colin Ingarfield" > > To: "Tomcat Users List&quo

Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32)

there is a loop somewhere that when it fails it just retries and retries, logAbandoned will show that though. Filip - Original Message - > From: "Colin Ingarfield" > To: "Tomcat Users List" > Sent: Thursday, March 22, 2012 8:06:14 AM > Subject: Re: how t

Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32)

iginal Message - > > From: "Colin Ingarfield" > > To: "Tomcat Users List" > > Sent: Wednesday, March 21, 2012 10:11:43 AM > > Subject: Re: how to enable debug logging for Tomcat jdbc pool (Tomcat > 6.0.32) > > > > I added the 3 abandon

Re: how to enable debug logging for Tomcat jdbc pool (Tomcat 6.0.32)

Chris, On Thu, Mar 22, 2012 at 7:40 AM, Christopher Schultz < ch...@christopherschultz.net> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Colin, > > On 3/21/12 12:11 PM, Colin Ingarfield wrote: > > I added the 3 abandoned settings but I don't see any indication in > > the tomcat lo

  1   2   >