ership Unleashing Business Potential
-Original Message-
From: Christopher Schultz
Sent: Friday, December 18, 2020 7:22 AM
To: Tomcat Users List
Subject: Re: jdbc connction pool issues [EXTERNAL]
** CAUTION: External message
Shawn,
On 12/17/20 14:21, Beard, Shawn wrote:
> Well
Shawn,
On 12/17/20 14:21, Beard, Shawn wrote:
Well the other tomcat servers had a custom factory specified. That
was the only difference. (devs wrote their own library for it)
So they were different. It's always misleading when getting a report
like this:
On 12/15/20 15:35, Beard, Shawn wrote:
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
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 maxConnections of 50 in jmx and not 8.
So Phil was right: you needed to s/maxActive/maxTotal/.
That doesn't sounds righ
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 intitialSi
com>
-Original Message-
From: Johnson, Jim
Sent: Tuesday, December 15, 2020 2:22 PM
To: Tomcat Users List
Subject: RE: jdbc connction pool issues [EXTERNAL]
** CAUTION: External message
Hi Shawn,
No, I don't think that maxActive means that it's defining the m
...@wrberkley.com<mailto:sbe...@wrberkley.com>
-Original Message-
From: Jalaj Asher
Sent: Tuesday, December 15, 2020 2:39 PM
To: Tomcat Users List
Subject: RE: jdbc connction pool issues [EXTERNAL]
** CAUTION: External message
Hi Shawn,
Check the Catalina home and see i
:22 PM
To: Tomcat Users List
Subject: RE: jdbc connction pool issues [EXTERNAL]
Attention: This email was sent from someone outside of eClinicalWorks. Always
use caution when opening attachments or clicking links from unknown senders or
when receiving unexpected emails.
Hi Shawn,
No, I don
Sent: Tuesday, December 15, 2020 2:22 PM
To: Tomcat Users List
Subject: RE: jdbc connction pool issues [EXTERNAL]
** CAUTION: External message
Hi Shawn,
No, I don't think that maxActive means that it's defining the maximum number of
connections for the pool, I think it's stri
: Tuesday, December 15, 2020 2:49 PM
To: Tomcat Users List
Subject: RE: jdbc connction pool issues [EXTERNAL]
But wouldn’t maxActive mean the connection pool has a max of 50 conenctions? On
other tomcat servers I have, maxActive is set to 50 and I verified im jmx that
there are 50 max connections
- Jim
-Original Message-
From: Beard, Shawn
Sent: Tuesday, December 15, 2020 2:42 PM
To: Tomcat Users List
Subject: RE: jdbc connction pool issues [EXTERNAL]
If default is 10, they why would we be getting an error about 8 being max?
Shawn Beard
Sr. Systems Engineer |
PM
To: Tomcat Users List
Subject: jdbc connction pool issues
CAUTION EXTERNAL EMAIL: This email originated from outside of the organization.
Do not click links or open attachments unless you recognize the sender and know
the content is safe.
We have this jdbc connection pool set up:
However
-
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
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 80% limit. Curre
16 matches
Mail list logo