Re: Tomcat dbcp2 connection pool configuration

2024-01-17 Thread Phil Steitz
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 19

Re: Tomcat dbcp2 connection pool configuration

2024-01-16 Thread Christopher Schultz
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 standment objects are not cleared even after the connection says closed. Anybody faced similar issue ? Here

Tomcat dbcp2 connection pool configuration

2024-01-11 Thread அருள்ராஜன் அ லை
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 standment objects are not cleared even after the connection says closed. Anybody faced similar issue ? Here is the values in tomcat context.xml maxWaitMillis

Re: Solved: DataSource Connection pool [non] leak

2023-08-31 Thread Christopher Schultz
you describe above is the job of a connection pool, and Tomcat provides two of them for your selection. There are a host of others available for Java as well. I highly recommend that you use one of those instead of trying to re-invent this particular wheel. As the count wasn't being decremente

Solved: DataSource Connection pool [non] leak

2023-08-31 Thread Scott,Tim
Hi Chris, > > Hi all, > > > > Thanks for your responses. I think I've found the problem. > > > > My wrapping class which detects the invocation of the close() method to > > decrement its count is no longer decrementing its count because > > method.getDeclaringClass() has changed from

Re: [EXTERNAL] RE: DataSource Connection pool leak

2023-08-30 Thread Christopher Schultz
Tim, On 8/29/23 10:33, Scott,Tim wrote: Hi all, Thanks for your responses. I think I've found the problem. My wrapping class which detects the invocation of the close() method to decrement its count is no longer decrementing its count because method.getDeclaringClass() has changed from

RE: [EXTERNAL] RE: DataSource Connection pool leak

2023-08-29 Thread Scott,Tim
Hi all, Thanks for your responses. I think I've found the problem. My wrapping class which detects the invocation of the close() method to decrement its count is no longer decrementing its count because method.getDeclaringClass() has changed from java.sql.Connection to

Re: [EXTERNAL] RE: DataSource Connection pool leak

2023-08-25 Thread Christopher Schultz
Tim, On 8/25/23 10:48, Scott,Tim wrote: Hi John, Why does your app need 20 connections just to start up? That's a bit of a rhetorical question, but needing so many connections to start up seems odd to me. It doesn't. It only needs 1-2 at a time, but it makes 100s of queries in loops, each

RE: [EXTERNAL] RE: DataSource Connection pool leak

2023-08-25 Thread Scott,Tim
t my application manually, as > IntelliJ refused to deploy remotely. > > This lead to it quickly exhausting its connection pool and then hanging* > before the application could complete its startup activity. > * Each request for a connection from the pool timed out. The

RE: DataSource Connection pool leak

2023-08-25 Thread John.E.Gregg
Tim, > -Original Message- > From: Scott,Tim > Sent: Friday, August 25, 2023 3:09 AM > To: users@tomcat.apache.org > Subject: DataSource Connection pool leak > > Hi, > > For various diagnostics, I tried Tomcat 9.0.79 recently on a development > machine.

DataSource Connection pool leak

2023-08-25 Thread Scott,Tim
application manually, as IntelliJ refused to deploy remotely. This lead to it quickly exhausting its connection pool and then hanging* before the application could complete its startup activity. * Each request for a connection from the pool timed out. The log shows that all 20

Re: Tomcat connection pool 9.0.52 uses more then configured maxActive connections

2023-05-22 Thread Mark Thomas
On 22/05/2023 09:45, Stefan López Romero wrote: Hello, I have the problem that the Tomcat connection pool uses more than the maxActive connections. In my Dropwizard application I have configured a maxSize of 30, but I found the following message in the logs. Timeout: Pool empty. Unable

Tomcat connection pool 9.0.52 uses more then configured maxActive connections

2023-05-22 Thread Stefan López Romero
Hello, I have the problem that the Tomcat connection pool uses more than the maxActive connections. In my Dropwizard application I have configured a maxSize of 30, but I found the following message in the logs. Timeout: Pool empty. Unable to fetch a connection in 15 seconds, none available

RE: [EXTERNAL] Re: Connection pool

2022-05-09 Thread Mohamed Eliyas Abdul Kadar
Thank you Mark and Chris -Original Message- From: Christopher Schultz Sent: Monday, May 9, 2022 12:13 PM To: users@tomcat.apache.org Subject: Re: [EXTERNAL] Re: Connection pool CAUTION: This email originated from outside the organization. DO NOT click links or open attachments unless

Re: [EXTERNAL] Re: Connection pool

2022-05-09 Thread Christopher Schultz
- From: Mark Thomas Sent: Monday, May 9, 2022 8:47 AM To: users@tomcat.apache.org Subject: Re: [EXTERNAL] Re: Connection pool CAUTION: This email originated from outside the organization. DO NOT click links or open attachments unless you recognize the sender and know the content is safe. On

RE: [EXTERNAL] Re: Connection pool

2022-05-09 Thread Mohamed Eliyas Abdul Kadar
: Mark Thomas Sent: Monday, May 9, 2022 8:47 AM To: users@tomcat.apache.org Subject: Re: [EXTERNAL] Re: Connection pool CAUTION: This email originated from outside the organization. DO NOT click links or open attachments unless you recognize the sender and know the content is safe. On 09/05/2022

Re: [EXTERNAL] Re: Connection pool

2022-05-09 Thread Mark Thomas
On 09/05/2022 16:42, Mohamed Eliyas Abdul Kadar wrote: Does that mean manager app deployed on the tomcat will also influence creating of connection pools. Manager does not have ang datasource, even then will it induce connection pool. Yes. If you define the resource in CATALINA_BASE/conf

RE: [EXTERNAL] Re: Connection pool

2022-05-09 Thread Mohamed Eliyas Abdul Kadar
Does that mean manager app deployed on the tomcat will also influence creating of connection pools. Manager does not have ang datasource, even then will it induce connection pool. -Original Message- From: Mark Thomas Sent: Thursday, May 5, 2022 10:00 AM To: users@tomcat.apache.org

Re: [EXTERNAL] Re: Connection pool

2022-05-05 Thread Mark Thomas
three instances of your connection pool each with a maximum of 20 connections. That means your database server may see up to 60 connections. If you want one pool of 20 connections shared between all the deployed web applications then you need to define that pool as a global resource

RE: [EXTERNAL] Re: Connection pool

2022-05-05 Thread Mohamed Eliyas Abdul Kadar
C:\apache-tomcat-9.0.45\conf which is CATALINA_BASE\conf -Original Message- From: Mark Thomas Sent: Thursday, May 5, 2022 8:43 AM To: users@tomcat.apache.org Subject: Re: [EXTERNAL] Re: Connection pool CAUTION: This email originated from outside the organization. DO NOT click links

RE: [EXTERNAL] Re: Connection pool

2022-05-05 Thread Mohamed Eliyas Abdul Kadar
Please find below : C:\apache-tomcat-9.0.45\conf -Original Message- From: Mark Thomas Sent: Thursday, May 5, 2022 8:43 AM To: users@tomcat.apache.org Subject: Re: [EXTERNAL] Re: Connection pool CAUTION: This email originated from outside the organization. DO NOT click links or open

Re: [EXTERNAL] Re: Connection pool

2022-05-05 Thread Mark Thomas
\apache-tomcat-9.0.45\bin\tomcat-juli.jar" Using CATALINA_OPTS: "" -Original Message- From: Mark Thomas Sent: Wednesday, May 4, 2022 11:38 PM To: users@tomcat.apache.org Subject: [EXTERNAL] Re: Connection pool CAUTION: This email originated from outside the organizatio

RE: [EXTERNAL] Re: Connection pool

2022-05-05 Thread Mohamed Eliyas Abdul Kadar
ME:"C:\Program Files\Java\jdk1.8.0_281" Using CLASSPATH: "C:\apache-tomcat-9.0.45\bin\bootstrap.jar;C:\apache-tomcat-9.0.45\bin\tomcat-juli.jar" Using CATALINA_OPTS: "" -Original Message- From: Mark Thomas Sent: Wednesday, May 4, 2022 11:38 PM To:

RE: [EXTERNAL] Re: Connection pool

2022-05-05 Thread Mohamed Eliyas Abdul Kadar
Subject: [EXTERNAL] Re: Connection pool CAUTION: This email originated from outside the organization. DO NOT click links or open attachments unless you recognize the sender and know the content is safe. Hello Mohamed, On Thu, May 5, 2022 at 2:59 AM Mohamed Eliyas Abdul Kadar wrote: > >

Re: Connection pool

2022-05-05 Thread Mark Thomas
On 04/05/2022 22:29, Mohamed Eliyas Abdul Kadar wrote: Hi All I am trying to limit the db connections on the oracle side by limiting the size of connection pool in the datasource config as below. I tried setting the max size to 20 by maxTotal/ maxActive either of them didn't work. The db side

Re: Connection pool

2022-05-04 Thread Suvendu Sekhar Mondal
Hello Mohamed, On Thu, May 5, 2022 at 2:59 AM Mohamed Eliyas Abdul Kadar wrote: > > Hi All > I am trying to limit the db connections on the oracle side by limiting the > size of connection pool in the datasource config as below. I tried setting > the max size to 20 by maxT

Connection pool

2022-05-04 Thread Mohamed Eliyas Abdul Kadar
Hi All I am trying to limit the db connections on the oracle side by limiting the size of connection pool in the datasource config as below. I tried setting the max size to 20 by maxTotal/ maxActive either of them didn't work. The db side connection was always more than 30. Please advise

RE: Tomcat 9.0.x JDBC connection pool does not always remove abandoned connections

2021-10-15 Thread Martin, Gerhardt A
Chris, really appreciate you taking some time to respond. See my replies inline below. > -Original Message- > From: Christopher Schultz > Sent: Thursday, October 14, 2021 12:19 PM > To: users@tomcat.apache.org > Subject: Re: Tomcat 9.0.x JDBC connection pool does no

Re: Tomcat 9.0.x JDBC connection pool does not always remove abandoned connections

2021-10-14 Thread Christopher Schultz
Gerhardt, On 10/12/21 13:27, Martin, Gerhardt A wrote: Running Tomcat 9.0.50 on Centos 7.9.x Linux and using Tomcat JDBC connection pool to connect to my application's databases. My app connects to about a dozen read only databases and one read/write database. Here is a typical resource

Tomcat 9.0.x JDBC connection pool does not always remove abandoned connections

2021-10-12 Thread Martin, Gerhardt A
Running Tomcat 9.0.50 on Centos 7.9.x Linux and using Tomcat JDBC connection pool to connect to my application's databases. My app connects to about a dozen read only databases and one read/write database. Here is a typical resource definition with tuning configurations for the pool

DB Connection Pool Error Handling

2021-06-25 Thread Jerry Malcolm
of a statement.execute() call.  So the 25 second delay is happening somewhere downstream from that. The connection has already been retrieved.  So I'm pretty sure it's nothing to do with connection pool wait.  Is there anything else that goes on inside the jdbc stuff that might cause this?  (I realize

Re: Does Tomcat JDBC Connection Pool reset autocommit on closed connections?

2021-03-16 Thread Christopher Schultz
> > Hello, > > > > > > > > > > > > I'm using Tomcat 10.0.0. Suppose I call setAutoCommit(false) on a connection obtained from a Tomcat JDBC Connection Pool. Then I do some stuff with the connection, call commit() or rollback() and final

Re: Does Tomcat JDBC Connection Pool reset autocommit on closed connections?

2021-03-15 Thread My Subs
> > > > > > > > > > > I'm using Tomcat 10.0.0. Suppose I call setAutoCommit(false) > > on a connection obtained from a Tomcat JDBC Connection Pool. Then I do > > some stuff with the connection, call commit() or rollback() and finally

Re: Does Tomcat JDBC Connection Pool reset autocommit on closed connections?

2021-03-15 Thread Christopher Schultz
n 12/03/2021 03:57, My Subs wrote: > > > > Hello, > > > > > > > > I'm using Tomcat 10.0.0. Suppose I call setAutoCommit(false) on a connection obtained from a Tomcat JDBC Connection Pool. Then I do some stuff with the connection, call commi

Re: Does Tomcat JDBC Connection Pool reset autocommit on closed connections?

2021-03-13 Thread My Subs
> On 12/03/2021 03:57, My Subs wrote: > > > > Hello, > > > > > > > > I'm using Tomcat 10.0.0. Suppose I call setAutoCommit(false) on a > > connection obtained from a Tomcat JDBC Connection Pool. Then I do some > > stuff with the connection

Re: Does Tomcat JDBC Connection Pool reset autocommit on closed connections?

2021-03-12 Thread Christopher Schultz
Alex, On 3/12/21 16:32, My Subs wrote: On Fri, 12 Mar 2021 02:35:27 -0500 Mark Thomas wrote > On 12/03/2021 03:57, My Subs wrote: > > Hello, > > > > I'm using Tomcat 10.0.0. Suppose I call setAutoCommit(false) on a connection obtained from a Tomcat

Re: Does Tomcat JDBC Connection Pool reset autocommit on closed connections?

2021-03-12 Thread My Subs
On Fri, 12 Mar 2021 02:35:27 -0500 Mark Thomas wrote > On 12/03/2021 03:57, My Subs wrote: > > Hello, > > > > I'm using Tomcat 10.0.0. Suppose I call setAutoCommit(false) on a > > connection obtained from a Tomcat JDBC Connection Pool.

Re: Does Tomcat JDBC Connection Pool reset autocommit on closed connections?

2021-03-11 Thread Mark Thomas
On 12/03/2021 03:57, My Subs wrote: Hello, I'm using Tomcat 10.0.0. Suppose I call setAutoCommit(false) on a connection obtained from a Tomcat JDBC Connection Pool. Then I do some stuff with the connection, call commit() or rollback() and finally call close() on it without ever calling

Does Tomcat JDBC Connection Pool reset autocommit on closed connections?

2021-03-11 Thread My Subs
Hello, I'm using Tomcat 10.0.0. Suppose I call setAutoCommit(false) on a connection obtained from a Tomcat JDBC Connection Pool. Then I do some stuff with the connection, call commit() or rollback() and finally call close() on it without ever calling setAutocommit(true). What

Re: Tomcat JDBC Connection Pool question

2021-02-11 Thread xcorpius
g/proper/commons-dbcp/configuration.html > > Phil > > On 2/10/21 3:22 PM, xcorpius wrote: >> Hi Chris! >> >> ConnectionReserveTimeoutSeconds: >> >> The number of seconds after which a call to reserve a connection from the >> connection pool will timeout. >>

Re: Tomcat JDBC Connection Pool question

2021-02-10 Thread Phil Steitz
: 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 Units: seconds Default: 10 Minimum: -1 Maximum

Re: Tomcat JDBC Connection Pool question

2021-02-10 Thread xcorpius
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

2021-02-10 Thread Christopher Schultz
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 d

Tomcat JDBC Connection Pool question

2021-02-10 Thread xcorpius
Hi! Is there a parameter in "Tomcat JDBC Connection Pool" 9 equivalent to the ConnectionReserveTimeoutSeconds parameter from Weblogic? Thanks, Xcorpius

Re: tomcat connection pool per database (postgres)

2020-11-25 Thread Rob Sargent
: Perhaps I read too much into the description of "The tomcat JDBC Connection Pool" page? TheJDBC Connection Pool|org.apache.tomcat.jdbc.pool|is a replacement or an alternative to theApache Commons DBCP <https://commons.apache.org/dbcp/>connection pool. I reacted to the "repla

Re: tomcat connection pool per database (postgres)

2020-11-25 Thread Christopher Schultz
Phil and Rob, On 11/24/20 11:26, Phil Steitz wrote: On 11/24/20 8:52 AM, Rob Sargent wrote: Perhaps I read too much into the description of "The tomcat JDBC Connection Pool" page? TheJDBC Connection Pool|org.apache.tomcat.jdbc.pool|is a replacement or an alternative to theApac

Re: tomcat connection pool per database (postgres)

2020-11-24 Thread Mark Thomas
On 24/11/2020 16:26, Phil Steitz wrote: > > > On 11/24/20 8:52 AM, Rob Sargent wrote: >> Perhaps I read too much into the description of "The tomcat JDBC >> Connection Pool" page? >> >> TheJDBC Connection Pool|org.apache.tomcat.jdbc.pool|is a replacemen

Re: tomcat connection pool per database (postgres)

2020-11-24 Thread Phil Steitz
On 11/24/20 8:52 AM, Rob Sargent wrote: Perhaps I read too much into the description of "The tomcat JDBC Connection Pool" page? TheJDBC Connection Pool|org.apache.tomcat.jdbc.pool|is a replacement or an alternative to theApache Commons DBCP <https://commons.apache.org/dbc

Re: tomcat connection pool per database (postgres)

2020-11-24 Thread Rob Sargent
Perhaps I read too much into the description of "The tomcat JDBC Connection Pool" page? TheJDBC Connection Pool|org.apache.tomcat.jdbc.pool|is a replacement or an alternative to theApache Commons DBCP <https://commons.apache.org/dbcp/>connection pool. I reacted to the &

Re: tomcat connection pool per database (postgres)

2020-11-24 Thread Phil Steitz
8, Rob Sargent wrote: Since the connection URL names a specific postgres database is it standard practice to have a pool per target database?  (Switching databases in postgres amounts to closing/opening a connection.) I generally consider a database connection pool to be a connection to a c

Re: tomcat connection pool per database (postgres)

2020-11-24 Thread Rob Sargent
a connection.) I generally consider a database connection pool to be a connection to a certain database/tablespace/schema, not a connection to an IP address. That's the only thing that would make sense in terms of an application, which would expect a connection to a specific data store, right? If you

Re: tomcat connection pool per database (postgres)

2020-11-24 Thread Christopher Schultz
Rob, On 11/19/20 12:38, Rob Sargent wrote: Since the connection URL names a specific postgres database is it standard practice to have a pool per target database?  (Switching databases in postgres amounts to closing/opening a connection.) I generally consider a database connection pool

tomcat connection pool per database (postgres)

2020-11-19 Thread Rob Sargent
Since the connection URL names a specific postgres database is it standard practice to have a pool per target database?  (Switching databases in postgres amounts to closing/opening a connection.)

Re: Tomcat DB Connection pool timeBetweenEvictionRunsMillis

2020-06-04 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Steve, On 6/4/20 16:59, Sanders, Steve wrote: > I'm working with an application team that wishes to set the > timeBetweenEvictionRunsMillis setting of their database connection > pool to a very low setting - 20ms. Hah! Sorry.

Tomcat DB Connection pool timeBetweenEvictionRunsMillis

2020-06-04 Thread Sanders, Steve
Hi all, Tomcat Version - 8.5.55 OS - OL7 I'm working with an application team that wishes to set the timeBetweenEvictionRunsMillis setting of their database connection pool to a very low setting - 20ms. According to the documentation (https://tomcat.apache.org/tomcat-8.5-doc/jdbc-pool.html

Re: Datasource Connection Pool

2019-03-20 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Rajendra On 3/18/19 12:24, Rajendra wrote: > Tomcat(8.5.32) is not establishing connections to database after > database is restarted. Currently, I am restarting Tomcat instance > if DB is restarted. Please let me know any parameters need to be >

Re: Datasource Connection Pool

2019-03-18 Thread Luis Rodríguez Fernández
Hello Rajendra, For instance if you are using MYSQL a validationQuery="l" in your datasource configuration [1] plus the magic autoreconnect parameter in the URL can do the trick for you. However this can have side effects (see the mysql autoreconnect description). In my experience the cheapest

Datasource Connection Pool

2019-03-18 Thread Rajendra
Hi, Tomcat(8.5.32) is not establishing connections to database after database is restarted. Currently, I am restarting Tomcat instance if DB is restarted. Please let me know any parameters need to be added to datasource resource element in Tomcat in order to establish database connections

[OT] Re: Connection pool and parallel deployment problem

2018-11-27 Thread tomcat
ou use JMX for ? Thanks again Regards Gilles -Message d'origine- De : HeeGu Lee [mailto:elfhazardw...@gmail.com] Envoyé : mardi 27 novembre 2018 08:36 À : Tomcat Users List Objet : Re: Connection pool and parallel deployment problem Dear Gilles, I apologize for the delay in reply.

RE: Connection pool and parallel deployment problem

2018-11-27 Thread Gilles SCHLIENGER
You can try HikariCP, it is mentionned in the Spring documentation -Message d'origine- De : HeeGu Lee [mailto:elfhazardw...@gmail.com] Envoyé : mardi 27 novembre 2018 10:28 À : Tomcat Users List Objet : Re: Connection pool and parallel deployment problem I'm glad to solve problem

Re: Connection pool and parallel deployment problem

2018-11-27 Thread HeeGu Lee
especially now that we will > use connection pools configured inside the webapp (no more context xml file) > > Regards > Gilles > > -Message d'origine- > De : HeeGu Lee [mailto:elfhazardw...@gmail.com] > Envoyé : mardi 27 novembre 2018 10:17 > À : Tomcat Users List

RE: Connection pool and parallel deployment problem

2018-11-27 Thread Gilles SCHLIENGER
 : mardi 27 novembre 2018 10:17 À : Tomcat Users List Objet : Re: Connection pool and parallel deployment problem 1. JMX registration is call by BasicDataSource of apache commons-dbcp2 library. It is hidden inside and can not be controlled. The name of the spring bean is referenced as part

Re: Connection pool and parallel deployment problem

2018-11-27 Thread HeeGu Lee
ng JMX beans ? Is it the @ManagedBean > annotation ? > > 2. What do you use JMX for ? > > Thanks again > Regards > Gilles > > > -Message d'origine- > De : HeeGu Lee [mailto:elfhazardw...@gmail.com] > Envoyé : mardi 27 novembre 2018 08:36 > À : Tomcat Us

Re: Connection pool and parallel deployment problem

2018-11-27 Thread Esther Montes
voyé : mardi 27 novembre 2018 08:36 > À : Tomcat Users List > Objet : Re: Connection pool and parallel deployment problem > > Dear Gilles, > > I apologize for the delay in reply. > > I make simple webapp and upload to github. In project, my test result is > included. >

RE: Connection pool and parallel deployment problem

2018-11-27 Thread Gilles SCHLIENGER
27 novembre 2018 08:36 À : Tomcat Users List Objet : Re: Connection pool and parallel deployment problem Dear Gilles, I apologize for the delay in reply. I make simple webapp and upload to github. In project, my test result is included. https://github.com/elfhazardwork/dbcp2-test Tomcat's

RE: Connection pool and parallel deployment problem

2018-11-27 Thread Gilles SCHLIENGER
Just one more thing I forgot to mention : When I see the conections opened on databases using an sql query, I also see the Threads of the connection pool still present using jConsole to connect to tomcat Gilles -Message d'origine- De : Chris Cheshire [mailto:yahoono...@gmail.com

Re: Connection pool and parallel deployment problem

2018-11-26 Thread HeeGu Lee
will duplicate and crush. The connection pool is used where the developer does not explicitly declare JXM. So this is a Tomcat bug. Otherwise, you must set JMX bean name dynamically. I hope this helps. 2018년 11월 27일 (화) 오전 2:03, Chris Cheshire 님이 작성: > On Mon, Nov 26, 2018 at 9:58 AM Gil

Re: Connection pool and parallel deployment problem

2018-11-26 Thread Chris Cheshire
leave it up to the gurus to decide :) > -Message d'origine- > De : Chris Cheshire [mailto:yahoono...@gmail.com] > Envoyé : lundi 26 novembre 2018 15:27 > À : Tomcat Users List > Objet : Re: Connection pool and parallel deployment problem > > I'm interested in what so

RE: Connection pool and parallel deployment problem

2018-11-26 Thread Gilles SCHLIENGER
[mailto:yahoono...@gmail.com] Envoyé : lundi 26 novembre 2018 15:27 À : Tomcat Users List Objet : Re: Connection pool and parallel deployment problem I'm interested in what solution there is for this because I have the exact same problem but without parallel deployment. [snip] On Mon, Nov 26, 2018 at 3:54

Re: Connection pool and parallel deployment problem

2018-11-26 Thread Chris Cheshire
eing closed, maybe the connection pool is closed > but the connections to the database are not. > > Here are the tests I did: > > + TEST 1: > - I deploy my war > - I login to my webapp > - I check on my postgresql and mysql database that connections have been > opened (select...)

RE: Connection pool and parallel deployment problem

2018-11-26 Thread Gilles SCHLIENGER
Hi Christopher, Thanks for your email. About connection pools not being closed, maybe the connection pool is closed but the connections to the database are not. Here are the tests I did: + TEST 1: - I deploy my war - I login to my webapp - I check on my postgresql and mysql database

Re: Connection pool and parallel deployment problem

2018-11-24 Thread Christopher Schultz
e context.xml file Why not? > Once the connexions are opened, they stay opened until Tomcat > shuts down, whatever configuration you try. I would expect that any connection pool created for a context (or instance of a context, when parallel deployments are being done) would be shut-d

RE: Connection pool and parallel deployment problem

2018-11-23 Thread Gilles SCHLIENGER
21 novembre 2018 14:18 À : Tomcat Users List; Gilles SCHLIENGER Objet : Re: Connection pool and parallel deployment problem On 21/11/2018 11:00, Gilles SCHLIENGER wrote: > Hi all, > > We are using Tomcat 9 and parallel deployment. > > I use a connection pool defined in the xml co

RE: Connection pool and parallel deployment problem

2018-11-21 Thread Gilles SCHLIENGER
Are you talking about parallel deployment or connection pools ? Parallel deployment is in Tomcat since Tomcat 7 Gilles -Message d'origine- De : HeeGu Lee [mailto:elfhazardw...@gmail.com] Envoyé : mercredi 21 novembre 2018 13:24 À : Tomcat Users List Objet : Re: Connection pool

Re: Connection pool and parallel deployment problem

2018-11-21 Thread Mark Thomas
On 21/11/2018 11:00, Gilles SCHLIENGER wrote: > Hi all, > > We are using Tomcat 9 and parallel deployment. > > I use a connection pool defined in the xml context (myApp##1.xml, > myApp##2.xml in my exemple) > > I have the following problem : > - I have myApp##1.war

Re: Connection pool and parallel deployment problem

2018-11-21 Thread HeeGu Lee
in such features. Both Tomcat and DB vendors are not going to fix it. It's not a tragedy, it's just a comedy. 2018년 11월 21일 (수) 오후 8:00, Gilles SCHLIENGER 님이 작성: > Hi all, > > We are using Tomcat 9 and parallel deployment. > > I use a connection pool defined in the xml context (myApp##1.

Connection pool and parallel deployment problem

2018-11-21 Thread Gilles SCHLIENGER
Hi all, We are using Tomcat 9 and parallel deployment. I use a connection pool defined in the xml context (myApp##1.xml, myApp##2.xml in my exemple) I have the following problem : - I have myApp##1.war deployed using a connection pool (configured in myApp##1.xml) - I deploy myApp##2.war

Re: tomcat connection pool not closing properly

2018-04-26 Thread Chris Cheshire
evious connection pool instances lingering on webapp reload), or is it mysqld misbehaving? It's not a critical problem as restarting tomcat itself clears all the connections, which isn't an issue on sandboxes and rare on the live site

tomcat connection pool not closing properly

2018-04-26 Thread Chris Cheshire
[ tomcat 8.5.30, mysql server 5.7.22, connector/j 5.1.46, centos 6, debian 8. ] I recently upgraded my sandboxes from 8.5.24 to 8.5.28 and now .30 and I have noticed that when a webapp is reloaded via the host manager, the associated connection pool is not getting closed down properly

Re: Oracle REST Data Services Unavailable -- java.sql.SQLException: Unable to start the Universal Connection Pool

2018-04-24 Thread chandra sekhar
> >>> > >>> We were recently installed and configured Apex on two servers > >>> and did the Load balance.We were facing the issue like "Oracle > >>> REST Data Services Unavailable" and we found the below error > >>> messages in

Re: Oracle REST Data Services Unavailable -- java.sql.SQLException: Unable to start the Universal Connection Pool

2018-04-23 Thread Christopher Schultz
; >>> We were recently installed and configured Apex on two servers >>> and did the Load balance.We were facing the issue like "Oracle >>> REST Data Services Unavailable" and we found the below error >>> messages in the catalina.out >> Can >&g

Re: Oracle REST Data Services Unavailable -- java.sql.SQLException: Unable to start the Universal Connection Pool

2018-04-20 Thread chandra sekhar
, chandra sekhar < > >> chandra.c...@gmail.com> > >> >> wrote: > >> >> > Hi, > >> >> > > >> >> > We were recently installed and configured Apex on two servers and > did > >> the > >> >> >

Re: Oracle REST Data Services Unavailable -- java.sql.SQLException: Unable to start the Universal Connection Pool

2018-04-20 Thread John Dale
handra.c...@gmail.com> >> >> wrote: >> >> > Hi, >> >> > >> >> > We were recently installed and configured Apex on two servers and did >> the >> >> > Load balance.We were facing the issue like "Oracle REST Data Servi

Re: Oracle REST Data Services Unavailable -- java.sql.SQLException: Unable to start the Universal Connection Pool

2018-04-20 Thread chandra sekhar
> chandra.c...@gmail.com> > >> wrote: > >> > Hi, > >> > > >> > We were recently installed and configured Apex on two servers and did > the > >> > Load balance.We were facing the issue like "Oracle REST

Re: Oracle REST Data Services Unavailable -- java.sql.SQLException: Unable to start the Universal Connection Pool

2018-04-20 Thread John Dale
e "Oracle REST Data Services >> > Unavailable" and we found the below error messages in the catalina.out >> Can >> > anybody suggest me. >> > >> > Error Message: >> > == >> > Caused by: java.sql.SQLException: Unable to

Re: Oracle REST Data Services Unavailable -- java.sql.SQLException: Unable to start the Universal Connection Pool

2018-04-20 Thread chandra sekhar
and did the > > Load balance.We were facing the issue like "Oracle REST Data Services > > Unavailable" and we found the below error messages in the catalina.out > Can > > anybody suggest me. > > > > Error Message: > > == > > Caused by: java.s

Re: Oracle REST Data Services Unavailable -- java.sql.SQLException: Unable to start the Universal Connection Pool

2018-04-20 Thread John Dale
ad balance.We were facing the issue like "Oracle REST Data Services > Unavailable" and we found the below error messages in the catalina.out Can > anybody suggest me. > > Error Message: > == > Caused by: java.sql.SQLException: U

Oracle REST Data Services Unavailable -- java.sql.SQLException: Unable to start the Universal Connection Pool

2018-04-20 Thread chandra sekhar
=== Caused by: java.sql.SQLException: Unable to start the Universal Connection Pool: oracle.ucp.UniversalConnectionPoolException: Failed to create initialPoolSize connections while starting a pool: java.lang.IllegalArgumentException: empty service member name at oracle.ucp.util.UCPErrorHandler.newSQ

Re: Connection Pool only evicts closed connections when validator runs?

2018-03-22 Thread Casey Merrill
On 3/22/18, 2:34 PM, "Christopher Schultz" <ch...@christopherschultz.net> wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Casey, On 3/22/18 3:33 PM, Casey Merrill wrote: > I’m currently using Dropwizard + Jooq and Tomcat jdbc for the

Re: Connection Pool only evicts closed connections when validator runs?

2018-03-22 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Casey, On 3/22/18 3:33 PM, Casey Merrill wrote: > I’m currently using Dropwizard + Jooq and Tomcat jdbc for the > connection pool. I’m seeing issues when a connection dies it’s not > evicted from the connection pool until the valid

Connection Pool only evicts closed connections when validator runs?

2018-03-22 Thread Casey Merrill
I’m currently using Dropwizard + Jooq and Tomcat jdbc for the connection pool. I’m seeing issues when a connection dies it’s not evicted from the connection pool until the validator runs. While I can turn the rate up at which the validator runs its seems odd that a closed connection

Re: error creating connection pool

2018-02-22 Thread Felix Schumacher
Am 13. Februar 2018 15:20:00 MEZ schrieb "Bruce L. Riddle" <bruce.l.rid...@dartmouth.edu>: >We are running a CDC Application PHIN MS that uses Tomcat 8.5.11. > >As the application starts, we are getting a message that says > >'error creating connection pool

RE: [E] Re: Cannot get a connection, pool error Timeout waiting for ideal object

2018-02-20 Thread Halder, Arpan [ITSUS Non J]
a Consultancy Services providing services to: Global Data and Analytics Application Support / ITAS Route 22 West▪NJ 08876 ▪ USA Mobile: +1 (908) 392 2947 -Original Message- From: Christopher Schultz [mailto:ch...@christopherschultz.net] Sent: Sunday, February 18, 2018 11:13 AM To: users@to

RE: [E] Re: Cannot get a connection, pool error Timeout waiting for ideal object

2018-02-19 Thread Howlader, Aakash [GTSUS Non-J]
issue? Best Regards, Aakash -Original Message- From: Halder, Arpan [ITSUS Non J] Sent: Monday, February 19, 2018 3:57 AM To: DL-MD-R <DL-HCSUS-MD-R@its.jnj.com> Subject: Fw: [EXTERNAL] Re: [E] Re: Cannot get a connection, pool error Timeout waiting for ideal object _____

Re: [E] Re: Cannot get a connection, pool error Timeout waiting for ideal object

2018-02-18 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Arpan, On 2/16/18 6:58 PM, Halder, Arpan [ITSUS Non J] wrote: > We could able to locate context.xml under " > /apps/apache-tomcat-7.0.67/conf" path - see below: That is the wrong file. The file conf/context.xml contains the defaults for every

RE: [E] Re: Cannot get a connection, pool error Timeout waiting for ideal object

2018-02-16 Thread Halder, Arpan [ITSUS Non J]
Hi Chris, Thanks a lot for your help!!Much appreciated!! We could able to locate context.xml under " /apps/apache-tomcat-7.0.67/conf" path - see below: WEB-INF/web.xml Could you please check which are the parameters to add/modify/delete. Also we could

Re: [E] Re: Cannot get a connection, pool error Timeout waiting for ideal object

2018-02-16 Thread Christopher Schultz
mcat.apache.org Subject: [EXTERNAL] Re: > [E] Re: Cannot get a connection, pool error Timeout waiting for > ideal object > > Arpan, > > On 2/15/18 8:54 AM, Halder, Arpan [ITSUS Non J] wrote: >> We have already setup below parameters in jdbc-pool.html (see >> b

RE: [E] Re: Cannot get a connection, pool error Timeout waiting for ideal object

2018-02-16 Thread Halder, Arpan [ITSUS Non J]
riday, February 16, 2018 2:24 PM To: users@tomcat.apache.org Subject: [EXTERNAL] Re: [E] Re: Cannot get a connection, pool error Timeout waiting for ideal object -BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Arpan, On 2/15/18 8:54 AM, Halder, Arpan [ITSUS Non J] wrote: > We have a

Re: [E] Re: Cannot get a connection, pool error Timeout waiting for ideal object

2018-02-16 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Arpan, On 2/15/18 8:54 AM, Halder, Arpan [ITSUS Non J] wrote: > We have already setup below parameters in jdbc-pool.html (see > below) – could you please advise if we need to modify/add anything > else here: > > And here is an example on how to

RE: Cannot get a connection, pool error Timeout waiting for ideal object

2018-02-15 Thread Halder, Arpan [ITSUS Non J]
an Halder Tata Consultancy Services providing services to: Global Data and Analytics Application Support / ITAS Route 22 West▪NJ 08876 ▪ USA Mobile: +1 (908) 392 2947 -Original Message- From: Mark Thomas [mailto:ma...@apache.org] Sent: Thursday, February 15, 2018 6:03 AM To: Tomcat Us

  1   2   3   4   5   6   7   8   >