RE: jdbc connction pool issues [EXTERNAL]

2020-12-18 Thread Beard, Shawn
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

Re: jdbc connction pool issues [EXTERNAL]

2020-12-18 Thread Christopher Schultz
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:

RE: jdbc connction pool issues [EXTERNAL]

2020-12-17 Thread Beard, Shawn
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

Re: jdbc connction pool issues [EXTERNAL]

2020-12-17 Thread Christopher Schultz
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

RE: jdbc connction pool issues [EXTERNAL]

2020-12-17 Thread Beard, Shawn
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,

RE: jdbc connction pool issues [EXTERNAL]

2020-12-16 Thread Beard, Shawn
<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

Re: jdbc connction pool issues [EXTERNAL]

2020-12-15 Thread Phil Steitz
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

RE: jdbc connction pool issues [EXTERNAL]

2020-12-15 Thread Beard, Shawn
...@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

RE: jdbc connction pool issues [EXTERNAL]

2020-12-15 Thread Jalaj Asher
: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

RE: jdbc connction pool issues [EXTERNAL]

2020-12-15 Thread Beard, Shawn
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

RE: jdbc connction pool issues [EXTERNAL]

2020-12-15 Thread Johnson, Jim
: 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

RE: jdbc connction pool issues [EXTERNAL]

2020-12-15 Thread Johnson, Jim
- 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 |

RE: jdbc connction pool issues [EXTERNAL]

2020-12-15 Thread Beard, Shawn
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

RE: jdbc connction pool issues [EXTERNAL]

2020-12-15 Thread Beard, Shawn
- 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

RE: jdbc connction pool issues

2020-12-15 Thread Johnson, Jim
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

jdbc connction pool issues

2020-12-15 Thread Beard, Shawn
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