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
: 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 started. Default value is 10 maxActive (int) The maximum number of active connections that

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
Hi Shawn, I think you’re missing initialSize initialSize (int)The initial number of connections that are created when the pool is started. Default value is 10 maxActive (int) The maximum number of active connections that can be allocated from this pool at the same time. The default value is 10