RE: [EXTERNAL] Re: Connection pool

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

al Message- 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

RE: [EXTERNAL] Re: Connection pool

: 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

/context.xml you get one instance of the resource for every web application deployed. Mark -Original Message- From: Mark Thomas Sent: Thursday, May 5, 2022 10:00 AM To: users@tomcat.apache.org Subject: Re: [EXTERNAL] Re: Connection pool CAUTION: This email originated from outside the

RE: [EXTERNAL] Re: Connection pool

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 05/05/2022 17:51, Mohamed Eliyas Abdul Kadar wrote: > > C:\apache-tomcat-9.0.45\conf

Re: [EXTERNAL] Re: Connection pool

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 05/05/2022 16:39, Mohamed Eliyas Abdul Kadar wrote: This fi

RE: [EXTERNAL] Re: Connection pool

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

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

\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 organization. D

RE: [EXTERNAL] Re: Connection pool

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

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

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

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 maxTotal/ maxActive either

[OT] Re: Connection pool and parallel deployment problem

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 Users List Objet : Re: Connection pool and parallel deployment problem Dear Gilles, I apologize for the delay i

RE: Connection pool and parallel deployment problem

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 pr

Re: Connection pool and parallel deployment problem

ne so far, 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 > À

RE: Connection pool and parallel deployment problem

m] Envoyé : 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 p

Re: Connection pool and parallel deployment problem

eans ? 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 > À : Tomc

Re: Connection pool and parallel deployment problem

t; 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. > > I make simple webapp and upload to github. In project, my test result is > included.

RE: Connection pool and parallel deployment problem

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. https://github.com/elfhazardwork/dbcp2-test Tom

RE: Connection pool and parallel deployment problem

l.com] Envoyé : lundi 26 novembre 2018 18:04 À : Tomcat Users List Objet : Re: Connection pool and parallel deployment problem On Mon, Nov 26, 2018 at 9:58 AM Gilles SCHLIENGER wrote: > > Hi, > I understand your needs, but what is your problem, since you don't use > parallel deploymen

Re: Connection pool and parallel deployment problem

he database doesn't." > > I could well be wrong, I'll 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

Re: Connection pool and parallel deployment problem

be wrong, I'll 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 > >

RE: Connection pool and parallel deployment problem

s 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 solution there is for this because I have the exact same problem but without parallel deployment. [snip] On Mon, Nov 2

Re: Connection pool and parallel deployment problem

s needed for the user realm datasource). > -Message d'origine- > De : Christopher Schultz [mailto:ch...@christopherschultz.net] > Envoyé : samedi 24 novembre 2018 17:19 > À : users@tomcat.apache.org > Objet : Re: Connection pool and parallel deployment problem > >

RE: Connection pool and parallel deployment problem

ailto:ch...@christopherschultz.net] Envoyé : samedi 24 novembre 2018 17:19 À : users@tomcat.apache.org Objet : Re: Connection pool and parallel deployment problem -BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Gilles, On 11/23/18 05:07, Gilles SCHLIENGER wrote: > Thanks Mark for your answer > > Her

Re: Connection pool and parallel deployment problem

imeout, but it always starts whether or not you use queries with timeouts. It's frustrating. - -chris > -Message d'origine- De : Mark Thomas > [mailto:ma...@apache.org] Envoyé : mercredi 21 novembre 2018 14:18 > À : Tomcat Users List; Gilles SCHLIENGER Objet : Re: Connection &

RE: Connection pool and parallel deployment problem

credi 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 x

RE: Connection pool and parallel deployment problem

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 poo

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 context (myApp##1.xml, > myApp##2.xml in my exemple) > > I have the following problem : > - I have myApp##1.war deployed using a connection p

Re: Connection pool and parallel deployment problem

I think it is good for your mental health not to use this feature. You just have to think of it as an experimental function like google chrome's about://flags. JMX has subscribe model. However, Tomcat is no ability to receive notifications. And most JDBC implementations are not interested in such

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

Here's my configuration for dropwizard driverClass: com.mysql.jdbc.Driver charSet: UTF-8 characterEncoding: UTF-8 maxWaitForConnection: 1s validationQuery: "select case when @@read_only + @@innodb_read_only = 0 then 1 else (select table_name from information_schema.tables) end as `1`"

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

-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 validator runs. While

Re: Connection pool issue was in with 7.0.52 version? And it is fixed in 7.0.78 version?

Hi, Please let anyone confirm me that,Is there is any issue regarding the connection pool in Tomcat V7.0.52 or older versions. And,In which version Connection pool Issue was resloved. Thank you On Mon, Jun 19, 2017 at 2:58 PM, Sai Kumar wrote: > Hi , > Need one help.I just seen this. > *Bug 53

Re: Connection pool issue was in with 7.0.52 version? And it is fixed in 7.0.78 version?

Hi , Need one help.I just seen this. *Bug 53367* - Database failure may cause pool to hang - in bugzilla., My problem is something related to this case.And the fix included two files.. 1.FairBlockingQueue.java 2.Bug53367.java Can you please tel

Re: Connection pool issue was in with 7.0.52 version? And it is fixed in 7.0.78 version?

Am 16.06.2017 um 14:00 schrieb Sai Kumar: > There is no problem with code,We are closing the connections properely. > This issue is occured in production side.We are highly suspecting that > there is an issue with the Tomcat server( V7.0.52). First of all,Please let > us know if there is any bug r

Re: Connection pool issue was in with 7.0.52 version? And it is fixed in 7.0.78 version?

There is no problem with code,We are closing the connections properely. This issue is occured in production side.We are highly suspecting that there is an issue with the Tomcat server( V7.0.52). First of all,Please let us know if there is any bug regarding the Connection pool in tomcat V7.0.52 .If

Re: Connection pool issue was in with 7.0.52 version? And it is fixed in 7.0.78 version?

If you don't have 4000 concurrent connections coming in to your application server, this sounds suspiciously like your code gets a connection from the pool and never returns it. Naturally, once the connection has been used, it will turn idle (as no more statements are executed), but if the connecti

Re: Connection pool issue was in with 7.0.52 version? And it is fixed in 7.0.78 version?

We are using 4000 connections for the particular DB in connection pool.Somehow,those 4000 connections are utilised in our production environment.If any new request is coming ,it is unable to fetch a connection because all the connections are utilised.But ,The actual problem is after processing the

Re: Connection pool issue was in with 7.0.52 version? And it is fixed in 7.0.78 version?

Sai Kumar, Am 16.06.2017 um 12:06 schrieb Sai Kumar: > Hi , > > We are using following tomcat version > Apache Tomcat/7.0.52 > Server number: 7.0.52.0 > and currently we are facing a problem with this one. While you give some description of things that happen in your environmen

Re: Connection pool in a clustered environment

Hi Chris, thanks for the explanations. I just completed a first dirty test and it is actually working fine. I believe I did something wrong on my first trial. I did put the distributable="true" attribute in the Context element of my context file in $CATALINA_BASE/conf/[[enginename]/[hostname]/mywe

Re: Connection pool in a clustered environment

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Daniel, On 3/8/16 2:27 PM, Daniel Savard wrote: > I wonder how you handle a pool of connections (not necessarily to > a database, think about something generic) in a clustered > environement. Generally, there is nothing to be done, here. Each node is

Re: Connection pool statistics

t Users List Subject: Re: Connection pool >> statistics >> >> -BEGIN PGP SIGNED MESSAGE- Hash: SHA256 >> >> Jeffrey, >> >> On 10/22/13 9:47 AM, Jeffrey Janner wrote: >>>> -Original Message- From: Anu Prab >> [mailto:anupr..

RE: Connection pool statistics

Chris -- > -Original Message- > From: Christopher Schultz [mailto:ch...@christopherschultz.net] > Sent: Tuesday, October 22, 2013 10:38 AM > To: Tomcat Users List > Subject: Re: Connection pool statistics > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 >

Re: Connection pool statistics

-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Jeffrey, On 10/22/13 9:47 AM, Jeffrey Janner wrote: >> -Original Message- From: Anu Prab >> [mailto:anupr...@gmail.com] Sent: Tuesday, October 22, 2013 4:36 >> AM To: Tomcat Users List Subject: Reg: Connection pool >> statistics >> >> Hi, >

RE: Connection pool statistics

> -Original Message- > From: Anu Prab [mailto:anupr...@gmail.com] > Sent: Tuesday, October 22, 2013 4:36 AM > To: Tomcat Users List > Subject: Reg: Connection pool statistics > > Hi, > > Is it possible to get the statistics of a connection pool > programmatically, say when was it created?

RE: Connection pool race condition

> From: cjder...@gmail.com [mailto:cjder...@gmail.com] On Behalf Of chris derham > Subject: Re: Connection pool race condition > Fixed this by setting the service to startup delayed > sc config start= delayed-auto Sounds like a FAQ/Wiki entry might be in order here, but I'

Re: Connection pool race condition

Fixed this by setting the service to startup delayed sc config start= delayed-auto Thanks Chris

Re: Connection pool race condition

There is another solution that should work, and that is to define initialSize="0" so that no attempt is made to contact the DB when it is created. Then set testOnBorrow="true" The jdbc-pool project should work like this http://people.apache.org/~fhanik/jdbc-pool/ Filip On 4/28/2011 1:58 PM, Fi

Re: Connection pool race condition

this is the way to go, just setup a service dependency On 4/28/2011 7:36 AM, Peter Crowther wrote: You could use Windows' service dependency management ( http://support.microsoft.com/kb/193888) to start Tomcat only after Oracle reports that it's running. This might still cause problems if Ora

Re: Connection pool race condition

On 4/28/2011 8:36 AM, Peter Crowther wrote: You could use Windows' service dependency management ( http://support.microsoft.com/kb/193888) to start Tomcat only after Oracle reports that it's running. This might still cause problems if Oracle does the same as SQL Server and continues recovering a

Re: Connection pool race condition

You could use Windows' service dependency management ( http://support.microsoft.com/kb/193888) to start Tomcat only after Oracle reports that it's running. This might still cause problems if Oracle does the same as SQL Server and continues recovering after its "official" startup has finished. In

Re: connection pool

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Tomaz, On 10/11/2010 4:08 AM, TomazM wrote: > Why if I reload application which use connection pool doesn't release > connection's to MySQL DB? > > Only if I restart Tomcat connection's are released, is this a bug. Yes, it is: https://issues.apache

Re: connection pool

On 11/10/2010 09:08, TomazM wrote: > Why if I reload application which use connection pool doesn't release > connection's to MySQL DB? Which connection pool and how is it defined? Where is the JDBC driver placed, and which one (exact version) are you using? Can you upgrade to the latest version

Re: connection pool issues with mod_proxy_ajp when tomcat is remote

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Russell, On 4/13/2010 3:53 PM, Russell Uman wrote: > tomcat server.xml: > enableLookups="false" redirectPort="8443" protocol="AJP/1.3" > minSpareThreads="5" maxThreads="300" > connectionTimeout="12" URIEncoding="UTF-8" />

Re: connection pool issues with mod_proxy_ajp when tomcat is remote

On 13/04/2010 23:25, Russell Uman wrote: we're trying to move from apache 2.0.52 with mod_jk 1.2.19 to apache 2.2.3 with mod_proxy_ajp in front of tomcat 5.5.28 mod_proxy_ajp was fairly new in 2.2.3, there are significant improvements in it since then. Upgrading is essential if you want to use

Re: connection pool issues with mod_proxy_ajp when tomcat is remote

we're trying to move from apache 2.0.52 with mod_jk 1.2.19 to apache 2.2.3 with mod_proxy_ajp in front of tomcat 5.5.28 mod_proxy_ajp was fairly new in 2.2.3, there are significant improvements in it since then. Upgrading is essential if you want to use it in production. Otherwise, go back

Re: connection pool issues with mod_proxy_ajp when tomcat is remote

On 13/04/2010 20:53, Russell Uman wrote: howdy! we're trying to move from apache 2.0.52 with mod_jk 1.2.19 to apache 2.2.3 with mod_proxy_ajp in front of tomcat 5.5.28 mod_proxy_ajp was fairly new in 2.2.3, there are significant improvements in it since then. Upgrading is essential if you w

Re: Connection pool stats

Hi Mark, That won't work because Tomcat creates an instance of org.apache.tomcat.dbcp.dbcp.BasicDataSource which cannot be cast to org.apache.commons.dbcp.BasicDataSource. I need to keep the code generic (to run in other containers), so I can't use org.apache.tomcat.dbcp.dbcp.BasicDataSource in t

RE: Connection pool stats

> From: Dhiren Bhatia [mailto:dhiren.for...@gmail.com] > Subject: Connection pool stats > > How do I get stats on the connection pool? I would like to check how > many connections are active/idle at any point in time. This may help: http://lambdaprobe.org/d/index.htm An example of its display fo

Re: Connection pool stats

You can cast your datasource object to be a BasicDataSource then the javadoc gives you all kinds of things you can get. like getNumActive(), getNumIdle() etc (for dbcp 1.3) http://commons.apache.org/dbcp/api-1.3/index.html Dhiren Bhatia wrote: > I've configured my DB connection pool as follows:

RE: Connection Pool Exhausted

lement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni. > Date: Fri, 21 Aug 2009 09:10:51 -0700 > Subject: Re: Connection Pool

Re: Connection Pool Exhausted

I just wanted to report back on the connection pool exhausted issue. I got some help from the JASIG uPortal list and it turns out that some of my settings in the uPortal config files were screwing with the way database connection pooling was working. Now that those settings have been tweaked, it

Re: Connection Pool Exhausted

--- On Mon, 8/17/09 at 11:38 AM, Kristen Walker wrote: > We had some help debugging the connection pool exhausted issue over the > weekend and for now it seems that changing jdbcUsePool=true to > jdbcUsePool=false stops the site from crashing due to connection pool > issues.  We are going to inve

Re: Connection Pool Exhausted

like expected. -Kristen On 8/15/09 7:46 AM, "Caldarale, Charles R" wrote: >> From: David Smith [mailto:d...@cornell.edu] >> Subject: Re: Connection Pool Exhausted >> >> some other app on the same tomcat instance >> is leaking the connections. > >

Re: Connection Pool Exhausted

On Sat, Aug 15, 2009 at 7:08 AM, wrote: > Okay, so let's say I set my db connection pool size to one, where do I look > to see what connection doesn't get closed like it should? Chuck already gave you the sophisticated (thread dump) approach. Alternatively, from the Department of Quick Hackery :

RE: Connection Pool Exhausted

> From: David Smith [mailto:d...@cornell.edu] > Subject: Re: Connection Pool Exhausted > > some other app on the same tomcat instance > is leaking the connections. Can't be another app - the connections are declared local to this webapp. As David states, finding out wha

Re: Connection Pool Exhausted

I know I'm coming late to the party and starting with the original post to boot. I see a third party app (not developed by Kristen) that ran perfectly before a restart caused some problems. Given this, I'm of the feeling there's a config problem OR some other app on the same tomcat instance is le

RE: Connection Pool Exhausted

> From: kwal...@sbceo.org [mailto:kwal...@sbceo.org] > Subject: RE: Connection Pool Exhausted > > where do I look to see what connection doesn't get closed > like it should? Now you've reached the hard part. You'll need to take thread dumps to find out what thre

RE: Connection Pool Exhausted

these are really obvious, I'm new to this. Thanks! Kristen Quoting "Caldarale, Charles R" : From: Martin Gainty [mailto:mgai...@hotmail.com] Subject: RE: Connection Pool Exhausted from my experience setting numActive to 1 is NOT a l/t solution No one ever suggested it was

RE: Connection Pool Exhausted

> From: Martin Gainty [mailto:mgai...@hotmail.com] > Subject: RE: Connection Pool Exhausted > > from my experience setting numActive to 1 is NOT a l/t solution No one ever suggested it was; it's simply a debugging technique to make it easier to find the connection leak.

RE: Connection Pool Exhausted

100 > From: ma...@apache.org > To: users@tomcat.apache.org > Subject: Re: Connection Pool Exhausted > > Martin Gainty wrote: > > set numActive=1 is not a long term solution mark > > It isn't meant to be. For the umpteenth time, read the

Re: Connection Pool Exhausted

Martin Gainty wrote: > set numActive=1 is not a long term solution mark It isn't meant to be. For the umpteenth time, read the thread and understand the context before you comment. Mark - To unsubscribe, e-mail: users-unsubscr

RE: Connection Pool Exhausted

; From: ma...@apache.org > To: users@tomcat.apache.org > Subject: Re: Connection Pool Exhausted > > Martin Gainty wrote: > > that is only one solution > > No it isn't. You didn't answer the question asked which was "How do I > set the connection pool size to 1&quo

Re: Connection Pool Exhausted

Martin Gainty wrote: > that is only one solution No it isn't. You didn't answer the question asked which was "How do I set the connection pool size to 1". > what is your non-jocl solution? Read the thread. Hassan has already answered the question. Mark ---

RE: Connection Pool Exhausted

100 > From: ma...@apache.org > To: users@tomcat.apache.org > Subject: Re: Connection Pool Exhausted > > Martin Gainty wrote: > > dbcp parameters are located in a *.jocl file located on your classpath > > Kristen - you can safely ignore this. It doesn't apply in your case

Re: Connection Pool Exhausted

Martin Gainty wrote: > dbcp parameters are located in a *.jocl file located on your classpath Kristen - you can safely ignore this. It doesn't apply in your case. Martin - Please read the entire thread before you post. It was made quite clear how the pool was configured and it wasn't with a jocl

RE: Connection Pool Exhausted

> From: kwal...@sbceo.org > To: users@tomcat.apache.org > Subject: Re: Connection Pool Exhausted > > Sorry if this is a stupid question, I am pretty new to this, but how do I set > the db connection pool size to 1? > > Thanks, > Kristen > > Quoting Hassan Schroed

Re: Connection Pool Exhausted

On Fri, Aug 14, 2009 at 6:04 PM, wrote: > how do I set the db connection pool size to 1? -- Hassan Schroeder hassan.schroe...@gmail.com twitter: @hassan - To unsubscribe, e-mail: users-unsubscr...@t

Re: Connection Pool Exhausted

Sorry if this is a stupid question, I am pretty new to this, but how do I set the db connection pool size to 1? Thanks, Kristen Quoting Hassan Schroeder : On your test/staging server, set your db connection pool size to 1 and exercise the site; if there's a connection leak, you'll find it pret

Re: Connection Pool Exhausted

On Fri, Aug 14, 2009 at 5:21 PM, wrote: > > Caused by: org.springframework.dao.DataAccessResourceFailureException: > RDBMServices sql error trying to get connection to uportal; nested exception > is org.apache.commons.dbcp.SQLNestedException: Cannot get a connection, pool > exhausted > Does anyon

Re: Connection pool exhausted

Kristen Walker wrote: > Hi everyone, Please don't hijack threads. Mark - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org

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

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

RE: Connection Pool and Connections

If I recall correctly close from a datasource (not a SQLConnection) will return the connection to the pool for reuse. In the later this will close the connection to the database. To answer your question I'm pretty sure any statement executed within the connection from the datasource will go to

Re: Connection Pool and Connections

Hi LightBulb... No its not going to work like I think you want it to... Statement stmt= con.createStatement(); ResultSet resultSet = stmt.executeQuery(sSql); //For Select and say Statement stmt = con.createStatement(); recs

Re: connection pool

gt; To: "Tomcat Users List" Sent: Monday, April 02, 2007 12:36 PM Subject: Re: connection pool sorry if someone has already mentioned this, but you will probably have to add the testOnborrow Parameter. So that also means you have to use the ValidationQuery, etc... but it(the pool) shoul

Re: connection pool

2007 12:36 PM Subject: Re: connection pool sorry if someone has already mentioned this, but you will probably have to add the testOnborrow Parameter. So that also means you have to use the ValidationQuery, etc... but it(the pool) should try to restablish a connection at that point. testOnBorrow will cau

Re: connection pool

sorry if someone has already mentioned this, but you will probably have to add the testOnborrow Parameter. So that also means you have to use the ValidationQuery, etc... but it(the pool) should try to restablish a connection at that point. testOnBorrow will cause some more overhead, but it might

Re: connection pool

--- "Gioia, Michael" <[EMAIL PROTECTED]> wrote: > Almost every weekend the database gets bumped and > the java app that were > running needs to have tomcat restarted to reconnect > to the database thru > the connection pool. When we come in on Monday > tomcat and the database > are up and runnin

RE: connection pool

lto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 12:24 PM To: Tomcat Users List Subject: Re: connection pool I dont use Tomcats built in db pooling, use a different one, but I think the problem is not that it drops the connection, because any pool should simply reallocate a new one when needed

Re: connection pool

I dont use Tomcats built in db pooling, use a different one, but I think the problem is not that it drops the connection, because any pool should simply reallocate a new one when needed. I have a feeling you are exhausting all the available connections, and the pool cant give you a new one. A

RE: connection pool

exactly. -Original Message- From: Nelson, Tracy M. [mailto:[EMAIL PROTECTED] Sent: Thursday, March 22, 2007 9:05 AM To: Tomcat Users List Subject: RE: connection pool | From: Gioia, Michael [mailto:[EMAIL PROTECTED] | Sent: Thursday, 22 March, 2007 08:36 | | Barry, how did you have a

Re: connection pool

Hmmm... that's odd. Can you offer any more details of the problem? OS? tomcat version? database and driver? Any reliance on mapped network drive resources? --David Gioia, Michael wrote: Hi, I'm still having a problem with tomcat with keeping up the connection to the database thru the con

RE: connection pool

| From: Gioia, Michael [mailto:[EMAIL PROTECTED] | Sent: Thursday, 22 March, 2007 08:36 | | Barry, how did you have a service stop and start on it's own, with out | rebooting the machine? You can probably use the NET START/STOP commands in a script, and then run that script as a scheduled job (o

RE: connection pool

Barry, how did you have a service stop and start on it's own, with out rebooting the machine? -Original Message- From: Propes, Barry L [GCG-NAOT] [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 12:15 PM To: Tomcat Users List Subject: RE: connection pool I wonder if you have

RE: connection pool

gotcha. -Original Message- From: Tim Lucia [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 11:54 AM To: 'Tomcat Users List' Subject: RE: connection pool See http://jakarta.apache.org/commons/dbcp/configuration.html (testOnBorrow=true is the default, so you would have

RE: connection pool

, 2007 9:44 AM To: Tomcat Users List Subject: RE: connection pool is testOnBorrow an attribute in the xml config? I haven't seen that in my version, coincidentally. -Original Message- From: Tim Lucia [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 11:15 AM To: 'Tomcat

RE: connection pool

007 12:44 PM > To: Tomcat Users List > Subject: RE: connection pool > > is testOnBorrow an attribute in the xml config? I haven't seen that in my > version, coincidentally. > > -Original Message- > From: Tim Lucia [mailto:[EMAIL PROTECTED] > Sent: Monday, Ma

RE: connection pool

is testOnBorrow an attribute in the xml config? I haven't seen that in my version, coincidentally. -Original Message- From: Tim Lucia [mailto:[EMAIL PROTECTED] Sent: Monday, March 19, 2007 11:15 AM To: 'Tomcat Users List' Subject: RE: connection pool Do you have a valida

RE: connection pool

t: Monday, March 19, 2007 12:04 PM > To: Tomcat Users List > Subject: RE: connection pool > > I have the same problem. Ideally, there shouldn't be any broken > connections in the pool. When needed > connection should be created if database is up and running. This doesn't >

  1   2   >