Andreas,
On 2/16/24 02:21, Döscher, Andreas (ESI) wrote:
Moin,
in the docpage https://tomcat.apache.org/tomcat-10.1-doc/jdbc-pool.html it says
The JDBC Connection Pool org.apache.tomcat.jdbc.pool is a replacement or an
alternative to the Apache Commons DBCP connection pool.
So why do we
Moin,
in the docpage https://tomcat.apache.org/tomcat-10.1-doc/jdbc-pool.html it says
>The JDBC Connection Pool org.apache.tomcat.jdbc.pool is a replacement or an
>alternative to the Apache Commons DBCP connection pool.
>
>So why do we need a new connection pool?
>
>Here are a
. The only
thing I could find in a google search for "Unable to find [jdbc]"
says my configuration is wrong and proceeds to explain how to set up a
datasource. My datasources have been set up for several years,
correctly as far as I know. They were all working fine until a couple
o
All of a sudden I started getting a NameNotFoundException when I'm
trying to resolve a dataSource name. But it comes and goes on all of
my dataSource names. The log below was from about a minute. The only
thing I could find in a google search for "Unable to find [jdbc]"
On 13/02/2023 19:12, Ragosta, Vincent wrote:
Is the above GC root, an example of the above condition?
Yes.
If so, can this be mitigated using the JreMemoryLeakPreventionListener, as
illustrated in the Tomcat documentation, here --
nt : 20,
sleepMillis : 1000)
1. oracle.jdbc.driver.OracleTimeoutPollingThread ↘465,922Kb (57.4%), self
136b (< 0.1%), 1 object(s)
I came across the following note:
Oracle JDBC driver, at least in some versions (such as ojdbc6), have a timeout
detection thread, _oracle.jdbc.driver.OracleTimeoutPolli
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
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
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...
Hi,
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.
Mfg
Thomas
--
Diese Nachricht wurde von meinem Android-Gerät mit K-9 Mail gesendet.
Greetings!
I have a problem, possibly (or not) tied to the Tomcat-JDBC Pool. Here
is the rundown:
Application Server: Apache Tomcat 9.0.56
JDBC Connection Pool: org.apache.tomcat.jdbc.pool.DataSource; Tomcat-JDBC
9.0.56
Oracle Version: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0
Hi, folks
[NOT A CONTRIBUTION]
JDBC Pool Version: 9.0.49
Database: Oracle
JDBC Version: 19.3.0.0
OS: Mac, Linux
The problem I'm running into:
We are using Tomcat JDBC Pool. When getting the network failure between server
and database something like 'Connection Reset by Peer' ORM framework
hultz
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 T
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 Tomcat.
Honestly, I would
> 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:
tions 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
> abou
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@tomcat.apache.org
Subject: Re: Tomcat jdbc connections
On 1/21
ess this means you're still not interested in that awesome
potential contribution we could make to Tomcat :D
Rémy
Rémy
>
> -chris
>
> > -Original Message-
> > From: Orendt, John
> > Sent: torstai 20. tammikuuta 2022 18.11
> > To: users@tomcat.
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
> minI
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
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
r minutes! 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
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
-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
?
-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
&
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
an application running on Tomcat with a JDBC connection
configured. Are you using Tomcat's built-in pooling, or is your application
managing its own pooling/connections?
- ANSWER we are using dbcp2
Do you have any background tasks (in the JVM) that will run even when there is
no user activity
is terminated?
Presumably, you have an application running on Tomcat with a JDBC
connection configured. Are you using Tomcat's built-in pooling, or is
your application managing its own pooling/connections?
Do you have any background tasks (in the JVM) that will run even when
there is no user
cure!
-chris
-Original Message-
From: Orendt, John
Sent: torstai 20. tammikuuta 2022 18.11
To: users@tomcat.apache.org
Subject: RE: Tomcat 9 Encrpytion of JDBC
[Et saa yleensä sähköpostia osoitteesta john.p.ore...@medtronic.com.invalid.
Lue lisää siitä, miksi tämä on tärke
: it doesn't). The trust is established by
simple physical connection.
So, let's get back to encrypting your JDBC password in your
conf/server.xml file. If you encrypt that, you have to put the
encryption key elsewhere. Fine, you say, I'll use a "remote key-service"
where I supply an encryp
Message-
From: Orendt, John
Sent: torstai 20. tammikuuta 2022 18.11
To: users@tomcat.apache.org
Subject: RE: Tomcat 9 Encrpytion of JDBC
[Et saa yleensä sähköpostia osoitteesta john.p.ore...@medtronic.com.invalid.
Lue lisää siitä, miksi tämä on tärkeää, osoitteesta
http://aka.ms
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
types.
Internet Banking does exist.
John Orendt
john.p.ore...@medtronic.com
-Original Message-
From: Christopher Schultz
Sent: Tuesday, January 18, 2022 11:32 AM
To: users@tomcat.apache.org
Subject: Re: Tomcat 9 Encrpytion of JDBC
John,
On 1/18/22 08:37, Orendt, John wrote:
> Secr
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?
-
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
t
Subject: RE: Tomcat 9 Encrpytion of JDBC
OK thanks Bill!
-Original Message-
From: Bill Stewart
Sent: 14 January 2022 19:02
To: Tomcat Users List
Subject: Re: Tomcat 9 Encrpytion of JDBC
On Fri, Jan 14, 2022 at 10:25 AM Alan F wrote:
Interested to know your best practices on sec
2:05 PM
To: Tomcat Users List
Subject: RE: Tomcat 9 Encrpytion of JDBC
OK thanks Bill!
-Original Message-
From: Bill Stewart
Sent: 14 January 2022 19:02
To: Tomcat Users List
Subject: Re: Tomcat 9 Encrpytion of JDBC
On Fri, Jan 14, 2022 at 10:25 AM Alan F wrote:
> Interested to k
OK thanks Bill!
-Original Message-
From: Bill Stewart
Sent: 14 January 2022 19:02
To: Tomcat Users List
Subject: Re: Tomcat 9 Encrpytion of JDBC
On Fri, Jan 14, 2022 at 10:25 AM Alan F wrote:
> Interested to know your best practices on securing jdbc plain text
> passwords,
On Fri, Jan 14, 2022 at 10:25 AM Alan F wrote:
> Interested to know your best practices on securing jdbc plain text
> passwords, in my last place they used a mechanism to encrypt all passwords.
> Is this the best method as I read some people don't recommend this. Any
> details or p
All,
Interested to know your best practices on securing jdbc plain text passwords,
in my last place they used a mechanism to encrypt all passwords. Is this the
best method as I read some people don't recommend this. Any details or procs on
best practice appreciated.
Thanks
Ken
gt;
> On 1/5/22 23:31, hantsy bai wrote:
> > I finally resolved this issue. Exclude the pg driver from war, and copy
> it
> > to tomcat/lib, it works.
> >
> > I remember in the past years, I preferred tomcat for Java Web
> applications
> > because I did no
Hantsy,
On 1/5/22 23:31, hantsy bai wrote:
I finally resolved this issue. Exclude the pg driver from war, and copy it
to tomcat/lib, it works.
I remember in the past years, I preferred tomcat for Java Web applications
because I did not need to register a Jdbc driver but it is tedious work
I finally resolved this issue. Exclude the pg driver from war, and copy it
to tomcat/lib, it works.
I remember in the past years, I preferred tomcat for Java Web applications
because I did not need to register a Jdbc driver but it is tedious work in
Java EE application servers
I have tried to update myself Spring 6/Jakarta EE9/Java 17, etc, and
created a simple war application, when deployed to Tomcat 10, failed, due
to the famous *no suitable drivers*.
I have created a detailed post on stackoverflow:
received this message in error, please advise
the sender immediately by reply e-mail and delete this message. Thank you for
your cooperation.
> -Original Message-
> From: Mark Eggers
> Sent: Tuesday, November 2, 2021 5:55 PM
> To: users@tomcat.apache.org
> Subject: Re: Stra
Hmmm...strange. I've gone thru their configuration and modified it to match up
with our strategy of using separate HOME and BASE locations. I've had them get
rid of duplicate jar files from BASE that are in HOME. Only 1-off is the Oracle
JDBC jar. I do need to see if they have "cleared
looks like you are seeing this issue:
https://bz.apache.org/bugzilla/show_bug.cgi?id=54194
Possible explanations:
- the application is packaged with a (very) old version of Tomcat's
jdbc-pool and is using that rather than the version provided by Tomcat
- The Tomcat instances are running a
="false" in each of the
resources.
Any assistance would be grand.
Thanks,
Stack Trace
02-Nov-2021 13:01:45.809 SEVERE [localhost-startStop-1]
org.apache.tomcat.jdbc.pool.DataSource.registerJmx Unable to register JDBC pool
d.
Thanks,
Stack Trace
02-Nov-2021 13:01:45.809 SEVERE [localhost-startStop-1]
org.apache.tomcat.jdbc.pool.DataSource.registerJmx Unable to register JDBC pool
with JMX
java.lang.NullPointe
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
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
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
not a time consuming operation.
If the pool is not properly sized and new connections must be established, that
will cause lags and issues.
Greetings, Thomas
Von: Lasantha Samarakoon
Gesendet: Sonntag, 12. September 2021 20:30
An: Tomcat Users List
Betreff: Re: Calculate time to get a connection
Hi John,
Thanks for your suggestion on the JMX approach. But as per my requirement,
using JMX to get the connection time will not be a viable solution.
My exact requirement is to log down individual connection establishment
time for each JDBC connection which is related to specific message flow
Lasantha,
> -Original Message-
> From: Lasantha Samarakoon
> Sent: Monday, September 06, 2021 10:22 PM
> To: users@tomcat.apache.org
> Subject: Calculate time to get a connection from JDBC Pool
>
> Hi all,
>
> I am working on Tomcat JDBC Pools and I ha
Hi all,
I am working on Tomcat JDBC Pools and I have a requirement that needs to
calculate the total time it takes to get a connection from the JDBC pool.
This is to cover the entire connection borrowing process (includes
connection creation, setting up, validation, etc). The Tomcat version we
s are getting
processed
as normally.
>
So, my question is, with pool exhausted scenarios, doesn't existing
connections execute their queries during that time(maxWait) and try to
resolve the exhausted behaviour by releasing those connections to idle
queue automatically? When checkin
leep state and doesn't execute any queries.
> >> After
> >>> waiting for maxWait period the pool exhausted exception gets thrown and
> >>> seems to reset the connections and then the queries are getting
> processed
> >>> as normally.
> >> >
and try to
resolve the exhausted behaviour by releasing those connections to idle
queue automatically? When checking the JMX matrix during this pool
exhausted time all the connections are in the active queue.
https://blog.christopherschultz.net/2009/03/16/properly-handling-pooled-jdbc-connecti
ing those connections to idle
> > queue automatically? When checking the JMX matrix during this pool
> > exhausted time all the connections are in the active queue.
>
>
> https://blog.christopherschultz.net/2009/03/16/properly-handling-pooled-jdbc-connections/
>
> > If not,
lve the exhausted behaviour by releasing those connections to idle
queue automatically? When checking the JMX matrix during this pool
exhausted time all the connections are in the active queue.
https://blog.christopherschultz.net/2009/03/16/properly-handling-pooled-jdbc-connections/
If not, what i
Hi All,
In my local setup before pool exhaustion exception is thrown, all the
connections seem to be in freezed and when checking processList in mysql,
those connections are in sleep state and doesn't execute any queries. After
waiting for maxWait period the pool exhausted exception gets thrown
> > 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
> > > > >
> > > > > > 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
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
> 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
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
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.
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
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
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.or
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
Units: seconds
Default: 10
Minimum: -1
Maximum: 231-1
Thanks,
Xcorpius
Mensaje original
On 10 feb. 2021 23:13, Christopher Schultz escribió:
> Xcorpius,
>
> On 2/10/21 07:15, xcorpius wrote:
>> Is there a parameter in "Tomcat JDBC Connectio
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
Hi!
Is there a parameter in "Tomcat JDBC Connection Pool" 9 equivalent to the
ConnectionReserveTimeoutSeconds parameter from Weblogic?
Thanks,
Xcorpius
Yeah I didn’t consider that relevant at the time. All examples of creating a
jdbc connection pool for SQL server on tomcat did not have specifying the
factory in them. So I didn’t consider it relevant. My bad.
Shawn Beard• Sr. Systems Engineer
Middleware Engineering
:
Other tomcat servers with exact same jdbc connection pool
config(only difference is servername, databasename, user and pass)
show 50 max connections, which is what maxActive is set to.
So you can see why we were maybe confused about what was happening.
-chris
ubject: Re: jdbc connction pool issues [EXTERNAL]
** CAUTION: External message
Shawn,
On 12/17/20 11:04, Beard, Shawn wrote:
> I was able to fix this. I added this to the config:
>
> factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
>
> I was then seeing maxConnecti
n't sounds right if "all your other servers are working with
the same config and Tomcat version" so something isn't right about that
statement. *Something* is different.
Switching to the Tomcat jdbc-pool again uses "maxActive" instead of
"maxTotal" as the con
sbe...@wrberkley.com<mailto:sbe...@wrberkley.com>
-Original Message-
From: Beard, Shawn
Sent: Wednesday, December 16, 2020 7:43 AM
To: Tomcat Users List
Subject: RE: jdbc connction pool issues [EXTERNAL]
** CAUTION: External message
Yes same version of tomcat 9.0.31,
<mailto:sbe...@wrberkley.com>
-Original Message-
From: Phil Steitz
Sent: Tuesday, December 15, 2020 3:37 PM
To: users@tomcat.apache.org
Subject: Re: jdbc connction pool issues [EXTERNAL]
** CAUTION: External message
On 12/15/20 1:35 PM, Beard, Shawn wrote:
> No int
On 12/15/20 1:35 PM, Beard, Shawn wrote:
No intitialSize is not defined.
Im getting the data to verify from JMX, however we also have an APM called
appdynamics loaded. Both verified the 8 max connections.
Other tomcat servers with exact same jdbc connection pool config(only
difference
Is there a specific factory I should be loading? Or is not specifying and
allowing default good enough? It is a jdbc connection pool, catalina home is
set correctly.
Shawn Beard
Sr. Systems Engineer |
BTS
Middleware Engineering | +1-515-564-2528 |
sbe
are-->wow6432node ---> apache
software foundation.
Else you might want to check if the same is a problem with DBCP pool as well .
As from the details shared looks like you are using jdbc pool.
Regards
Jalaj
-Original Message-
From: Johnson, Jim
Sent: Tuesday, December 15, 202
No intitialSize is not defined.
Im getting the data to verify from JMX, however we also have an APM called
appdynamics loaded. Both verified the 8 max connections.
Other tomcat servers with exact same jdbc connection pool config(only
difference is servername, databasename, user and pass) show
on active connections)
Here is the doc that I've been referring to - sorry for not linking it earlier:
https://tomcat.apache.org/tomcat-9.0-doc/jdbc-pool.html
On those other Tomcat servers is there a initialSize defined?
Jim
-Original Message-
From: Beard, Shawn
Sent: Tuesday, December
Hi Shawn,
I can't speak to that monitoring tool or why it reports that way. I do see what
you're saying though - I would expect the error message to be something like:
>>name="jdbc/DataSource",type=DataSource has reached 80% limit.
>>Current pool size [8, Max pool size [
Beard
Sr. Systems Engineer |
BTS
Middleware Engineering | +1-515-564-2528 |
sbe...@wrberkley.com<mailto:sbe...@wrberkley.com>
-Original Message-
From: Johnson, Jim
Sent: Tuesday, December 15, 2020 1:35 PM
To: Tomcat Users List
Subject: RE
-
From: Johnson, Jim
Sent: Tuesday, December 15, 2020 1:35 PM
To: Tomcat Users List
Subject: RE: jdbc connction pool issues [EXTERNAL]
** CAUTION: External message
Hi Shawn,
I think you’re missing initialSize
initialSize
(int)The initial number of connections that are created when the pool is
s
is 100
It would make sense that 8 connections would be 80% utilized.
I would try replacing maxActive with initialSize and seeing how that works for
you.
Good luck!
- Jim
From: Beard, Shawn
Sent: Tuesday, December 15, 2020 2:12 PM
To: Tomcat Users List
Subject: jdbc connction pool issues
CAUTION
We have this jdbc connection pool set up:
However we are getting this error:
Resource Pool Limit Reached
Time 12/15/20 11:48:00 AM
Summary
JDBC Connection Pool
Catalina:class=javax.sql.DataSource,context=/XX,host=X,name="jdbc/DataSource",type=DataSource
has reached
brary?
There is very little between them in terms of performance, especially if
you configure them for equivalent behaviour.
I'd summarise the differences as:
- DBCP2 follows the JDBC specs a little more closely by default
- jdbc-pool has marginally better performance under high load
- jdbc-pool has
ore you start moving config files around.
>
> You'll want something like:
>
>
>global="jdbc/dspaceWeb"
> type="javax.sql.DataSource"
> />
>
>
> in server.xml
>
> Mark
>
&
On 26/11/2020 22:52, Hrafn Malmquist wrote:
> A
>
> How silly of me. It's right there staring me in the face nested inside the
> host in server.xml, right?
Right.
The changes to GlobalResources look good.
You'll probably want to revert the change you made to appBase.
> So, best practice
ded
>> the
>> >following Resource
>> >
>> >> > factory="org.apache.tomcat.jdbc.pool.DataSourceFactory"
>> > type="javax.sql.DataSource"
>> > auth="Container"
>
maxTotal="50"
> > maxIdle="15"
> > minIdle="5" />
>
> Exactly where in server.xml did you put this? What element was it nested
> under?
>
> >There are a couple of issues that confuse me:
> >
that confuse me:
>a) the official documentation about JNDI datasource examples [0] says
> "*This
>author has not had success here, although others have reported so.
>Clarification would be appreciated here." *in the section about
>Postgres. In other words, we c
On 26/11/2020 21:01, Rob Sargent wrote:
> Looks like you named your resource jdbc/dspaceWeb and dropped the Web in your
> lookup
Nope. You are confusing the global and local name. The config looks
right on first glance.
Mark
>
>> On Nov 26, 2020, at 12:58 PM, Hrafn Malmq
Looks like you named your resource jdbc/dspaceWeb and dropped the Web in your
lookup
> On Nov 26, 2020, at 12:58 PM, Hrafn Malmquist
> wrote:
>
> Good day fellow Apache Tomcat users
>
> I have recently had reason to set a Postgres DataSource via the Tomcat JNDI
> api
s have reported so.
Clarification would be appreciated here." *in the section about
Postgres. In other words, we can't be sure this works?
b) in the official documtation about JDBC connection pool it says that
if you want to define a JDBC connection pool in the Apache Container (w
the
>> connection to close it in the case of abandoned connections.
>>
>> The dbcp2 pools seems to be able to use that method, while I found no
>> reference to it in the jdbc-pool module (which you are using).
>
> We are talking about making that change on commons-dev now
1 - 100 of 1590 matches
Mail list logo
