Re: Tomcat JDBC CP: Exponential backoff?

Thomas, On 1/26/23 03:00, Thomas Meyer wrote: Am 18. Januar 2023 23:20:29 MEZ schrieb Christopher Schultz : Thomas, On 1/17/23 13:33, Thomas Meyer wrote: Does Tomcat's CP support exponential backoff in case DB is unavailable for some reason? I didn't find anything in the documentation in

Re: Tomcat JDBC CP: Exponential backoff?

Am 18. Januar 2023 23:20:29 MEZ schrieb Christopher Schultz : >Thomas, > >On 1/17/23 13:33, Thomas Meyer wrote: >> Does Tomcat's CP support exponential backoff in case DB is unavailable for >> some reason? >> I didn't find anything in the documentation in this regards. > >I don't think is supp

Re: Tomcat JDBC CP: Exponential backoff?

Thomas, On 1/17/23 13:33, Thomas Meyer wrote: Does Tomcat's CP support exponential backoff in case DB is unavailable for some reason? I didn't find anything in the documentation in this regards. I don't think is supports any such thing. What would be the purpose of exponential back-off... do

Re: Tomcat jdbc connections

Christopher Schultz Sent: 24 January 2022 22:42 To: users@tomcat.apache.org Subject: Re: Tomcat jdbc connections Alan, On 1/23/22 09:17, Alan F wrote: Can I just follow up here what would be the next steps how would I go about capturing the root cause of these very short connection times t

Re: Tomcat jdbc connections

Schultz Sent: 24 January 2022 22:42 To: users@tomcat.apache.org Subject: Re: Tomcat jdbc connections Alan, On 1/23/22 09:17, Alan F wrote: Can I just follow up here what would be the next steps how would I go about capturing the root cause of these very short connection times to Oracle from To

RE: [External] Re: Tomcat jdbc connections

> Would it be along the lines of Wireshark or TCP dump to see what's > occurring as I gather this won't be captured in tomcat logging via > Catalina.out? Or can it be. Have you explored Oracle listener / client tracing? Ref: https://docs.oracle.com/cd/E11882_01/network.112/e10835/sqlnet.htm#NETRF3

RE: Tomcat jdbc connections

s due to connections being used! -Original Message- From: Christopher Schultz Sent: 24 January 2022 22:42 To: users@tomcat.apache.org Subject: Re: Tomcat jdbc connections Alan, On 1/23/22 09:17, Alan F wrote: > Can I just follow up here what would be the next steps how would I go

Re: Tomcat jdbc connections

nk 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 2022 17:50 To: users@

RE: Tomcat jdbc connections

ogging via Catalina.out? Or can it be. -Original Message- From: Phil Steitz Sent: 21 January 2022 17:50 To: users@tomcat.apache.org Subject: Re: Tomcat jdbc connections On 1/21/22 9:28 AM, Alan F wrote: > Ok thanks Phil ok I checked other connections in the same host and see

RE: Tomcat jdbc connections

Thanks for your input Phil! Arghh will keep looking. -Original Message- From: Phil Steitz Sent: 21 January 2022 17:50 To: users@tomcat.apache.org Subject: Re: Tomcat jdbc connections On 1/21/22 9:28 AM, Alan F wrote: > Ok thanks Phil ok I checked other connections in the same h

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

inutes! And diff is identical apart from Cluster ips. -Original 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 exampl

Re: Tomcat jdbc connections

2022 14:50 To: users@tomcat.apache.org Subject: RE: Tomcat jdbc connections Alan, -Original Message- From: Alan F Sent: Friday, January 21, 2022 6:53 AM To: Tomcat Users List Subject: RE: Tomcat jdbc connections Hi Christopher Thanks for your time here. You mean like, a connection is

Re: Tomcat jdbc connections

-Original Message- From:john.e.gr...@wellsfargo.com.INVALID Sent: 21 January 2022 14:50 To:users@tomcat.apache.org Subject: RE: Tomcat jdbc connections Alan, -Original Message- From: Alan F Sent: Friday, January 21, 2022 6:53 AM To: Tomcat Users List Subject: RE: Tomcat jdbc

RE: Tomcat jdbc connections

? -Original Message- From: john.e.gr...@wellsfargo.com.INVALID Sent: 21 January 2022 14:50 To: users@tomcat.apache.org Subject: RE: Tomcat jdbc connections Alan, > -Original Message- > From: Alan F > Sent: Friday, January 21, 2022 6:53 AM > To: Tomcat Users List &

RE: Tomcat jdbc connections

Alan, > -Original Message- > From: Alan F > Sent: Friday, January 21, 2022 6:53 AM > To: Tomcat Users List > Subject: RE: Tomcat jdbc connections > > Hi Christopher > > Thanks for your time here. > > You mean like, a connection is made, no q

RE: Tomcat jdbc connections

: users@tomcat.apache.org Subject: Re: Tomcat jdbc connections Alan, On 1/20/22 09:33, Alan F wrote: > I have an issue with connections on Tomcat9 Oracle showing connections > made for about 2seconds then dropped again. Is this normal when the > server is not being used? You mean like

Re: Tomcat jdbc connections

Alan, On 1/20/22 09:33, Alan F wrote: I have an issue with connections on Tomcat9 Oracle showing connections made for about 2seconds then dropped again. Is this normal when the server is not being used? You mean like, a connection is made, no queries are executed, and then the connection is ter

Re: Tomcat jdbc connections

On 20/01/2022 14:33, Alan F wrote: I have an issue with connections on Tomcat9 Oracle showing connections made for about 2seconds then dropped again. Is this normal when the server is not being used? Seems unlikely. Can you provide the DataSource configuration? Remember to obfuscate any sen

Re: Tomcat JDBC Connection Pool question

Thanks Phil! Mensaje original On 11 feb. 2021 2:54, Phil Steitz escribió: > 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/configurati

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 num

Re: Tomcat JDBC Connection Pool question

Hi Chris! ConnectionReserveTimeoutSeconds: The number of seconds after which a call to reserve a connection from the connection pool will timeout. When set to 0, a call will never timeout. When set to -1, a call will timeout immediately. Admin Console field label: Connection Reserve Timeout

Re: Tomcat JDBC Connection Pool question

Xcorpius, On 2/10/21 07:15, xcorpius wrote: Is there a parameter in "Tomcat JDBC Connection Pool" 9 equivalent to the ConnectionReserveTimeoutSeconds parameter from Weblogic? Maybe. What does that parameter actually do? -chris

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

Am 31.08.20 um 18:53 schrieb Phil Steitz: > > On 8/31/20 3:21 AM, Felix Schumacher wrote: >> Am 31.08.20 um 06:15 schrieb Gokhan Akgul: >>> Dear Phil , >>> Thanks for your feedback. I forgot to mention the mysql driver >>> version. The >>> Mysql driver version is 5.1.32. >>> My plan is to upgrade

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

On 8/31/20 3:21 AM, Felix Schumacher wrote: Am 31.08.20 um 06:15 schrieb Gokhan Akgul: Dear Phil , Thanks for your feedback. I forgot to mention the mysql driver version. The Mysql driver version is 5.1.32. My plan is to upgrade the mysql driver to 5.1.46 version and monitor for a while. If I

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

Am 31.08.20 um 06:15 schrieb Gokhan Akgul: > Dear Phil , > Thanks for your feedback. I forgot to mention the mysql driver version. The > Mysql driver version is 5.1.32. > My plan is to upgrade the mysql driver to 5.1.46 version and monitor for a > while. If I read the bug report correctly, MySQL

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

Am 31.08.20 um 06:26 schrieb Gokhan Akgul: > Dear Felix, > > Thanks for your feedback , the health check period is so aggressive now. > SRE team's and apm monitor tools call internally and externally endpoint > and health indicators. > I asked the sre guys to decrease the frequency of those calls

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

Dear Felix, Thanks for your feedback , the health check period is so aggressive now. SRE team's and apm monitor tools call internally and externally endpoint and health indicators. I asked the sre guys to decrease the frequency of those calls. They made some decrease on calls but nothing changed.

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

Dear Phil , Thanks for your feedback. I forgot to mention the mysql driver version. The Mysql driver version is 5.1.32. My plan is to upgrade the mysql driver to 5.1.46 version and monitor for a while. On Sat, Aug 29, 2020 at 6:50 PM Phil Steitz wrote: > > On 8/27/20 2:47 AM, Gokhan Akgul wrote:

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 <0x57dcb0b

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

Am 27.08.20 um 11:47 schrieb Gokhan Akgul: > Hi , > > I have been facing the deadlock issue for the last 2 months about > JDBCPoolCleaner Thread . > > Following config set in context.xml > > auth="Container" > type="javax.sql.DataSource" > factory="org.apa

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

I had a similar issue with JDBC and it got fixed by adding this parameter 'numTestsPerEvictionRun'=> '3', 'auth' => 'Container', 'driverClassName' => 'oracle.jdbc.OracleDriver', 'maxActive' =>

Re: Tomcat JDBC Pool Cleaner Deadlock Problem

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Gokhan, On 8/27/20 05:47, 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 > > type="javax.sql.DataSource" > factory="org.apache.tom

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

Re: Tomcat JDBC Connection Pool - Stand Alone Logging

On 16 February 2017 17:26:18 GMT+00:00, Chris Keilitz wrote: >I've implemented Tomcat JDBC connection pool stand-alone, outside of >Tomcat >or any app server or container and cannot get the Juli logging working >- >console or file. The connection pool works great, but I cannot get >the >logging

Re: Tomcat JDBC Connection Pool - Stand Alone Logging

I will look into both suggestions, conflicting property files and the debug version. I am connecting to MS SQL Server 2008 R2 (SP1), using the sqljdbc41.jar file. The access to SQL Server works great, insert, updates, queries, stored procedures...no issues. I am just trying to activate the loggin

Re: Tomcat JDBC Connection Pool - Stand Alone Logging

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Chris, On 2/16/17 1:08 PM, Chris Keilitz wrote: > I'm assuming, once configured properly, the Tomcat JDBC connection > pool would output log messages. Unfortunately, I currently get no > console or file output...even after trying numerous > logging.

Re: Tomcat JDBC Connection Pool - Stand Alone Logging

What database are you connecting to ? Oracle ? MySQL ? If Oracle, then you're probably using its specific driver, and there is a debug version (the "_g" version) that logs. According to you, what kind of log the Tomcat driver should write ? 2017-02-16 19:08 GMT+01:00 Chris Keilitz : > I'm assumi

Re: Tomcat JDBC Connection Pool - Stand Alone Logging

I'm assuming, once configured properly, the Tomcat JDBC connection pool would output log messages. Unfortunately, I currently get no console or file output...even after trying numerous logging.properties changes. I'm hoping for a little help to understand the proper way to configure a stand alone

Re: Tomcat JDBC Connection Pool - Stand Alone Logging

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Chris, On 2/16/17 12:26 PM, Chris Keilitz wrote: > I've implemented Tomcat JDBC connection pool stand-alone, outside > of Tomcat or any app server or container and cannot get the Juli > logging working - console or file. The connection pool works

Re: [TOMCAT-JDBC] rs.absolute() throws "Invalid operation for forward only resultset: absolute"

I've created Bug 60099 2016-09-08 17:20 GMT+02:00 Christopher Schultz : > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 > > Mohamad, > > On 9/8/16 4:20 AM, Mohamad Abbas wrote: > > Hello, > > > > I am working on a legacy web application r

Re: [TOMCAT-JDBC] rs.absolute() throws "Invalid operation for forward only resultset: absolute"

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Mohamad, On 9/8/16 4:20 AM, Mohamad Abbas wrote: > Hello, > > I am working on a legacy web application running on a tomcat > 8.0.37, and i am getting an error "Invalid operation for forward > only resultset: absolute" when trying to use an > Insens

Re: [TOMCAT-JDBC] rs.absolute() throws "Invalid operation for forward only resultset: absolute"

The ojdbc7-12.1.0.2.0 support TYPE_SCROLL_INSENSITIVE. I already made the test by calling only the second method who creates a Statement with a SCROLL_INSENSITIVE type, and it worked. Regards, 2016-09-08 11:29 GMT+02:00 Terence M. Bandoian : > On 9/8/2016 3:20 AM, Mohamad Abbas wrote: > >> Hello

Re: [TOMCAT-JDBC] rs.absolute() throws "Invalid operation for forward only resultset: absolute"

On 9/8/2016 3:20 AM, Mohamad Abbas wrote: Hello, I am working on a legacy web application running on a tomcat 8.0.37, and i am getting an error "Invalid operation for forward only resultset: absolute" when trying to use an InsensitiveScrollableResultSet (to paginate results). To make it simple

Re: [Tomcat-JDBC] RemovedAbandoned doesn't trigger JdbcInterceptors

Thanks, Keiichi. 2015-12-18 3:21 GMT-03:00 Keiichi Fujino : > 2015-12-17 22:25 GMT+09:00 Robert Anderson : > > > Hi, > > > > When a connection is closed by "ResetAbandoned" the invoke() method from > > JdbcInterceptor is not called. Is it the expected behaviour? > > > > > Yes. > > The JdbcInterce

Re: [Tomcat-JDBC] RemovedAbandoned doesn't trigger JdbcInterceptors

2015-12-17 22:25 GMT+09:00 Robert Anderson : > Hi, > > When a connection is closed by "ResetAbandoned" the invoke() method from > JdbcInterceptor is not called. Is it the expected behaviour? > > Yes. The JdbcInterceptor.invoke() method is not called when removeAbandoned. The Connection(PooledConn

Re: Tomcat JDBC configuration does not encrypt the database password

Dave, On 10/26/15 7:22 AM, Dave Cronin wrote: > In the JNDI DataSource HowTo page, it describes how to configure the > DataSource in the application Context. I see that the password is not > encrypted. Is there any way to configure this with an encrypted password? > > A JDBC resource is configure

Re: Tomcat JDBC vs DBCP2?

On 03.06.2015 21:57, Mark Thomas wrote: On 03/06/2015 20:50, Christopher Schultz wrote: Bjørn, On 6/3/15 2:52 PM, Bjørn T Johansen wrote: Just saw a discussion about Tomcat DBCP 8.0.18 issue, where Tomcat JDBC pooling vs Commons DBCP 2 pooling was briefly discussed.. So now I am a bit curious.

Re: Tomcat JDBC vs DBCP2?

On 03/06/2015 20:50, Christopher Schultz wrote: > Bjørn, > > On 6/3/15 2:52 PM, Bjørn T Johansen wrote: >> Just saw a discussion about Tomcat DBCP 8.0.18 issue, where Tomcat >> JDBC pooling vs Commons DBCP 2 pooling was briefly discussed.. So >> now I am a bit curious... I am using Tomcat JDBC, be

Re: Tomcat JDBC vs DBCP2?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Bjørn, On 6/3/15 2:52 PM, Bjørn T Johansen wrote: > Just saw a discussion about Tomcat DBCP 8.0.18 issue, where Tomcat > JDBC pooling vs Commons DBCP 2 pooling was briefly discussed.. So > now I am a bit curious... I am using Tomcat JDBC, because I

Re: tomcat-jdbc PoolCleaner deadlock

thank you Robert! On Fri, Feb 6, 2015 at 11:14 AM, Robert Anderson wrote: > Hi, > > After a full week of normal usage, no deadlocks were found. > > > Thank you very much. > > Robert > > > > 2015-01-30 16:38 GMT-03:00 Robert Anderson : > > > Ok, Filip! > > > > Thanks, > > > > Robert > > > > 2015-

Re: tomcat-jdbc PoolCleaner deadlock

Hi, After a full week of normal usage, no deadlocks were found. Thank you very much. Robert 2015-01-30 16:38 GMT-03:00 Robert Anderson : > Ok, Filip! > > Thanks, > > Robert > > 2015-01-30 16:31 GMT-03:00 Filip Hanik : > > Robert, kindly let us know if disabling the pool cleaner does resolve

Re: tomcat-jdbc PoolCleaner deadlock

Ok, Filip! Thanks, Robert 2015-01-30 16:31 GMT-03:00 Filip Hanik : > Robert, kindly let us know if disabling the pool cleaner does resolve your > dead lock > > Filip > > > On Fri, Jan 30, 2015 at 12:25 PM, Robert Anderson > wrote: > > > Great, Filip! > > > > "Returns true if the pool sweeper i

Re: tomcat-jdbc PoolCleaner deadlock

Robert, kindly let us know if disabling the pool cleaner does resolve your dead lock Filip On Fri, Jan 30, 2015 at 12:25 PM, Robert Anderson wrote: > Great, Filip! > > "Returns true if the pool sweeper is enabled for the connection pool. The > pool sweeper is enabled if any settings that requi

Re: tomcat-jdbc PoolCleaner deadlock

Great, Filip! "Returns true if the pool sweeper is enabled for the connection pool. The pool sweeper is enabled if any settings that require async intervention in the pool are turned on boolean result = getTimeBetweenEvictionRunsMillis()>0; result = result && (isRemoveAbandoned() && getRemoveAband

Re: tomcat-jdbc PoolCleaner deadlock

Are you seeing that message, cause it seems to be a defensive check, but wouldn't happen due to 509 public void initializePoolCleaner(PoolConfiguration properties) { 510 //if the evictor thread is supposed to run, start it now 511 if (properties. isPoolSweeperEnabled()) { 512 poolCleaner = new Poo

Re: tomcat-jdbc PoolCleaner deadlock

Robert, it should say, if you set a positive value, the value should not be less than 1000ms. Otherwise you are hammering the system with eviction checks. Setting the value to 0, disables the check all together. There are other ways to disable the same check by setting other flags, 918 @Override 9

Re: tomcat-jdbc PoolCleaner deadlock

Filip, timeBetweenEvictionRunsMillis=0 does not disable PoolCleaner [1]. if (sleepTime <= 0) { log.warn("Database connection pool evicter thread interval is set to 0, defaulting to 30 seconds"); this.sleepTime = 1000 * 30; } else if (sleepTi

Re: tomcat-jdbc PoolCleaner deadlock

Sorry, [1] https://people.apache.org/~fhanik/jdbc-pool/jdbc-pool.html 2015-01-30 15:15 GMT-03:00 Robert Anderson : > Filip, > > however, disabling the pool cleaner it should yield better results. > > The documention[1] says: > > "This value should not be set under 1 second" > > Isn't true? > > >

Re: tomcat-jdbc PoolCleaner deadlock

Filip, however, disabling the pool cleaner it should yield better results. The documention[1] says: "This value should not be set under 1 second" Isn't true? 2015-01-30 15:07 GMT-03:00 Filip Hanik : > Looking at the locks that are involved in the dead lock, it's all in the > intersys traces

Re: tomcat-jdbc PoolCleaner deadlock

Looking at the locks that are involved in the dead lock, it's all in the intersys traces. Furthermore, it seems as intersys may already be doing pooling inside the driver. If that is the case, you have two options 1. disable pooling in intersys OR 2. don't use tomcat's jdbc pool since intersys alr

Re: tomcat-jdbc PoolCleaner deadlock

Disable the pool cleaner timeBetweenEvictionRunsMillis=0

Re: tomcat-jdbc PoolCleaner deadlock

Am 30.01.2015 um 18:44 schrieb Robert Anderson: Could you post a full stacktrace, or threaddump? "ajp-apr-8009-exec-13 ^ 30/01/2015 - 09:39:58 - DB:DATASOURCE(java:/comp/env/jdbc/cacheapp)" daemon prio=10 tid=0x13bb nid=0x7a6d waiting for monitor entry [0x5125b000] java.l

Re: tomcat-jdbc PoolCleaner deadlock

Could you post a full stacktrace, or threaddump? "ajp-apr-8009-exec-13 ^ 30/01/2015 - 09:39:58 - DB:DATASOURCE(java:/comp/env/jdbc/cacheapp)" daemon prio=10 tid=0x13bb nid=0x7a6d waiting for monitor entry [0x5125b000] java.lang.Thread.State: BLOCKED (on object monitor)

Re: tomcat-jdbc PoolCleaner deadlock

Thanks, Chris. In general, I would expect validationInterval="0" to disable validation, but the documentation does not say anything about a zero value. Is it possible that you are /constantly/ validating? If you change that number to something higher (in ms: maybe "1" for 10s) you will reduce

Re: tomcat-jdbc PoolCleaner deadlock

Am 30.01.2015 um 18:19 schrieb Robert Anderson: Every day we are getting deadlocks like that: Found one Java-level deadlock: = "ajp-apr-8009-exec-13 ^ 30/01/2015 - 09:39:58 - DB:DATASOURCE(java:/comp/env/jdbc/cacheapp)": waiting to lock monitor 0x1504e6d8 (

Re: tomcat-jdbc PoolCleaner deadlock

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Robert, On 1/30/15 12:19 PM, Robert Anderson wrote: > Every day we are getting deadlocks like that: > > Found one Java-level deadlock: = > "ajp-apr-8009-exec-13 ^ 30/01/2015 - 09:39:58 - > DB:DATASOURCE(java:/comp/env/

RE: Tomcat JDBC connection pool: Using initSql together with validatorClassName

the original validator. It’s a bit unintuitive to use the validator like that, but I’m glad to have it working ☺ Thanks for your responses! From: Filip Hanik [mailto:fi...@hanik.com] Sent: woensdag 3 december 2014 19:47 To: Tomcat Users List Cc: Iris Hupkens Subject: Re: Tomcat JDBC connection pool

Re: Tomcat JDBC connection pool: Using initSql together with validatorClassName

You should be able to run init SQL commands yourself in your custom validator https://tomcat.apache.org/tomcat-7.0-doc/api/org/apache/tomcat/jdbc/pool/Validator.html On Wed, Dec 3, 2014 at 11:42 AM, Wes Clark wrote: > These actions seems to incorrectly conflated in the code. I'd also like >

RE: Tomcat JDBC connection pool: Using initSql together with validatorClassName

These actions seems to incorrectly conflated in the code. I'd also like to do the same thing, so if you get it working, keep me posted. -Original Message- From: Iris Hupkens [mailto:i.hupk...@topdesk.com] Sent: Wednesday, December 03, 2014 5:14 AM To: 'users@tomcat.apache.org' Subject:

Re: tomcat-jdbc vs. tomcat-dbcp

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Christian, On 11/28/14 7:57 AM, Christian wrote: > reading tomcat 8.x documentation, I don't find anything about > tomcat-dbcp. The use of tomcat-jdbc is described at [1]. Some of > the disadvantages just apply for DBCP 1.x. Is the use of > tomca

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

On Thu, Nov 6, 2014 at 2:36 AM, 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

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

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 DB is large enough. I have some concerns about the "rem

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

this is part of the TCP lifecycle, you can adjust this timeout yourself on the Operating system level http://www.cs.northwestern.edu/~agupta/cs340/project2/TCPIP_State_Transition_Diagram.pdf cat /proc/sys/net/ipv4/tcp_fin_timeoutecho 15 > /proc/sys/net/ipv4/tcp_fin_timeout On Wed, Nov 5, 2014 a

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? TCP connections in the

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 Oracle 11g database. It > m

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

lix.schumac...@internetallee.de] Sent: Tuesday, July 22, 2014 11:07 PM To: Tomcat Users List Subject: Re: Tomcat JDBC Connection Pool initialization question On 23. Juli 2014 01:20:27 MESZ, Wes Clark wrote: >I want to initialized a new connection being added to the pool with >more than

Re: Tomcat JDBC Connection Pool initialization question

On 23. Juli 2014 01:20:27 MESZ, Wes Clark wrote: >I want to initialized a new connection being added to the pool with >more than one SQL statement. I cannot see how to override the existing >methods to do this. Has anyone done this, or have a suggestion for me? Have you tried to separate them

Re: Tomcat JDBC Connection Pool Resource Name Issue

On Mar 3, 2014, at 7:04 PM, Scott Dudley wrote: > > I'm using the Tomcat JDBC connection pool on apache-tomcat-7.0.30. > > My context xml resource name is as follows: > > > When running under Tomcat, calling ConnectionPool.getName() from my custom > JdbcInterceptor returns "Tomcat Connectio

Re: Tomcat JDBC Error

Hi Chris, What type of script is this? I'm on a linux box and keep getting and error: [javadev@corpjbdev01 apache-tomcat-6.0.26]$ for /apps/tomcat/apache-tomcat-6.0.26/lib/*.jar \ ? /apps/tomcat/apache-tomcat-6.0.26/webapps/rbacx/WEB-INF/lib/*.jar \ ? ; do echo$jar ; unzip -v $jar |grep -i mysq

Re: Tomcat JDBC Error

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Leo, On 1/27/14, 12:17 PM, Leo Medina wrote: > Good morning Mark, > > Can you please elaborate more as to what you meant by: > "com.mysql.jdbc.Driver must be present in one of your webapps. I'd > expect it to be in a JAR that has mysql in the name.

[OT] Re: Tomcat JDBC Error

Leo, On 27.1.2014 18:17, Leo Medina wrote: Can you please elaborate more as to what you meant by: "com.mysql.jdbc.Driver must be present in one of your webapps. I'd expect it to be in a JAR that has mysql in the name. If you don't need it remove it." I meant that we don't have a mysql db. in

Re: Tomcat JDBC Error

Good morning Mark, Can you please elaborate more as to what you meant by: "com.mysql.jdbc.Driver must be present in one of your webapps. I'd expect it to be in a JAR that has mysql in the name. If you don't need it remove it." I meant that we don't have a mysql db. in our original integration.

Re: Tomcat JDBC Error

On 24/01/2014 18:24, Leo Medina wrote: > It's been a while since I installed tomcat and having some jdbc errors with > version 6.0.20. Time to upgrade. > We don't have a mysql.jdbc.driver com.mysql.jdbc.Driver must be present in one of your webapps. I'd expect it to be in a JAR that has mysql in

Re: Tomcat JDBC with PostgreSQL

Thanks Dan, I would like to test it more, but I think it works. 2013.05.08. 15:01 keltezéssel, Daniel Mikusa írta: On May 8, 2013, at 8:54 AM, Lutischán Ferenc wrote: Dear Users, Tomcat 7.0.39. I have the following configuration in META-INF/context.xml: The situation: - The database

Re: Tomcat JDBC with PostgreSQL

On May 8, 2013, at 8:54 AM, Lutischán Ferenc wrote: > Dear Users, > > Tomcat 7.0.39. > > I have the following configuration in META-INF/context.xml: > > > driverClassName="org.postgresql.Driver" > factory="org.apache.tomcat.jdbc.pool.DataSourceFactory" initialSize="2" > maxIdle="20" maxA

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: Tomcat JDBC Pooling - Connections

> -Original Message- > From: Madan KN [mailto:madan...@gmail.com] > Sent: Monday, April 08, 2013 9:29 AM > To: Tomcat Users List > Subject: Re: Tomcat JDBC Pooling - Connections > > # 99% percent of the time we do have need for 200 active sessions > across our appl

Re: Tomcat JDBC Pooling - Connections

Hi: But I can see that you aren't using Tomcat JDBC pool, but oracle.jdbc.pool. OracleDataSource , right ? And I don't know how you set up your datasource to more than 200 maxActive connections Indeed, I don't know how you define the size of connection pool Regards 2013/4/8 Madan KN > # 9

Re: Tomcat JDBC Pooling - Connections

On Apr 8, 2013, at 10:28 AM, Madan KN wrote: > # 99% percent of the time we do have need for 200 active sessions across > our application cluster. But due to some high spikes we end up with 2000 > sessions which is ending up in the pool with out getting evicted.* > > * > # I think once the applic

Re: Tomcat JDBC Pooling - Connections

# 99% percent of the time we do have need for 200 active sessions across our application cluster. But due to some high spikes we end up with 2000 sessions which is ending up in the pool with out getting evicted.* * # I think once the application is out of peak the connections are returned in eithe

Re: Tomcat JDBC Pooling - Connections

On Apr 8, 2013, at 3:23 AM, Madan KN wrote: > *Hi All,* > > Currently we are using tomcat jdbc pooling for oracle 11g R12. What version of Tomcat are you using? If you are using the pool directly outside of Tomcat, what version of it are you using? > The problem > we are facing is during the

Re: Tomcat JDBC Connection Pool - Deadlock

On Mar 28, 2013, at 8:27 AM, amit shah wrote: > Hello, > I am using the tomcat jdbc connection pool independently in my web Because you are using this independently you are going to need to tell us the version of the connection pool that you have included with your application. Also, a

RE: Tomcat JDBC Connection Pool - Deadlock

> From: amit shah [mailto:amits...@gmail.com] > Subject: Re: Tomcat JDBC Connection Pool - Deadlock > I copied the dev group too since it involved technical details (thread > dumps, source code etc). Sorry if that sounds incorrect. It was incorrect, as is your top-posting. Don

Re: Tomcat JDBC Connection Pool - Deadlock

I copied the dev group too since it involved technical details (thread dumps, source code etc). Sorry if that sounds incorrect. The traces I added are not incomplete. They are the ones we generated through the jmx api - ManagementFactory.getThreadMXBean().dumpAllThreads(true, true); On Thu, Mar

RE: Tomcat JDBC Connection Pool - Deadlock

> From: amit shah [mailto:amits...@gmail.com] > To: Tomcat Users List; d...@tomcat.apache.org Do not cross-post. This belongs only on the users list. Read (and follow) the mailing list usage rules. > Subject: Tomcat JDBC Connection Pool - Deadlock > The two threads involved in the deadlock h

Re: Tomcat JDBC connection pool + JMX

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Jose, On 3/27/13 8:34 AM, Jose María Zaragoza wrote: > I'm using tomcat-jdbc as a connection pool in a standalone > application. > > I would like monitorize this pool by JMX . > > How I can do that ? What is the name of MBean ? http://wiki.apache

  1   2   3   >