Re: jdbc connction pool issues [EXTERNAL]

[Phil Steitz]

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 servername, databasename, user and pass) show 50 max connections, 
which is what maxActive is set to.


Are the other tomcat servers running the same tomcat version? Since TC8, 
the default connection pool is DBCP2 which uses maxTotal in place of 
maxActive.  See [1]. If you are running 8+, s/maxActive/maxTotal in the 
config should work.


Phil

[1] https://tomcat.apache.org/migration-8.html#Database_Connection_Pooling





Shawn​  Beard

Sr. Systems Engineer |
 BTS

Middleware Engineering   |  +1-515-564-2528 |  
sbe...@wrberkley.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 maximum number of 
connections for the pool, I think it's strictly referring to the "[ .. ] maximum 
number of *active connections* that can be allocated from this pool at the same time. [ 
.. ]" (emphasis mine on active connections)

Here is the doc that I've been referring to - sorry for not linking it earlier:
https://urldefense.com/v3/__https://tomcat.apache.org/tomcat-9.0-doc/jdbc-pool.html__;!!Li8W9_Um1Taa!vJGrxr7yc86joO5r6QoNstpipfempGFqrYRe3_NyAIGNs-LenmBWhtjn1fRiAOex$

On those other Tomcat servers is there a initialSize defined?

Jim

-Original Message-
From: Beard, Shawn 
Sent: 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 on the connection pool.

Here though I checked jmx, sure enough, its max connections is 8.



Shawn​ Beard

Sr. Systems Engineer |
BTS

Middleware Engineering | +1-515-564-2528 | 
sbe...@wrberkley.com









-Original Message-
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 
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 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 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 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. Current pool size [8, Max pool size [8]

Shouldn’t the max connections of the connection pool be 50 since maxActive is 
50?



Shawn Beard • Sr. Systems Engineer
Middleware Engineering

[cid:image003.png@01D6D2E3.D5F1EFA0]

3840 109th Street Urbandale, IA 50322
Phone: +1-515-564-2528
Email: sbe...@wrberkley.com
Website: 

RE: jdbc connction pool issues [EXTERNAL]

[Beard, Shawn]

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...@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 if your tomcat set up Is pointed to the correct 
path.
You can check that from the registry as well to make sure the service is not 
pointed to another tomcat which might have these parameters setup.

The registry path is HKEY_LOCAL_MACHINE --> software-->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, 2020 3: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't think that maxActive means that it's defining the maximum number of 
connections for the pool, I think it's strictly referring to the "[ .. ] 
maximum number of *active connections* that can be allocated from this pool at 
the same time. [ .. ]" (emphasis mine on active connections)

Here is the doc that I've been referring to - sorry for not linking it earlier:
https://urldefense.com/v3/__https://nam05.safelinks.protection.outlook.com/?url=https*3A*2F*2Ftomcat.apache.org*2Ftomcat-9.0-doc*2Fjdbc-pool.htmldata=04*7C01*7Cjalaj.asher*40eclinicalworks.com*7C3f5dd36a4b0d458695d908d8a1371f11*7C7ce747e48f6d4e0697efa9b76a063808*7C1*7C0*7C637436605411941490*7CUnknown*7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0*3D*7C3000sdata=bPYOMGVa0dYi0ASx*2BuQ5pTdlzpuOKird7pAVi*2FjHQVs*3Dreserved=0__;JSUlJSUlJSUlJSUlJSUlJSUlJSU!!Li8W9_Um1Taa!q2MG45FC18cm0UD-N10yCZgPVqpaQaZGKILOaYz6c1kiDPaCBBP5Q1UZoCWfvJtl$

On those other Tomcat servers is there a initialSize defined?

Jim

-Original Message-
From: Beard, Shawn 
Sent: 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 on the connection pool.

Here though I checked jmx, sure enough, its max connections is 8.



Shawn​ Beard

Sr. Systems Engineer |
BTS

Middleware Engineering | +1-515-564-2528 | 
sbe...@wrberkley.com









-Original Message-
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 
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 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 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 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. Current pool size [8, Max pool size [8]

Shouldn’t the max connections of the connection pool be 50 since maxActive is 
50?



Shawn Beard • Sr. Systems Engineer
Middleware Engineering

[cid:image003.png@01D6D2E3.D5F1EFA0]

3840 109th Street Urbandale, IA 50322
Phone: +1-515-564-2528
Email: sbe...@wrberkley.com
Website: 

RE: jdbc connction pool issues [EXTERNAL]

[Jalaj Asher]

Hi Shawn,
Check the Catalina home and see if your tomcat set up Is pointed to the correct 
path.
You can check that from the registry as well to make sure the service is not 
pointed to another tomcat which might have these parameters setup.

The registry path is HKEY_LOCAL_MACHINE --> software-->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, 2020 3: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't think that maxActive means that it's defining the maximum number of 
connections for the pool, I think it's strictly referring to the "[ .. ] 
maximum number of *active connections* that can be allocated from this pool at 
the same time. [ .. ]"  (emphasis mine on active connections)

Here is the doc that I've been referring to - sorry for not linking it earlier:
https://nam05.safelinks.protection.outlook.com/?url=https%3A%2F%2Ftomcat.apache.org%2Ftomcat-9.0-doc%2Fjdbc-pool.htmldata=04%7C01%7Cjalaj.asher%40eclinicalworks.com%7C3f5dd36a4b0d458695d908d8a1371f11%7C7ce747e48f6d4e0697efa9b76a063808%7C1%7C0%7C637436605411941490%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000sdata=bPYOMGVa0dYi0ASx%2BuQ5pTdlzpuOKird7pAVi%2FjHQVs%3Dreserved=0

On those other Tomcat servers is there a initialSize defined?

 Jim

-Original Message-
From: Beard, Shawn 
Sent: 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 on the connection pool.

Here though I checked jmx, sure enough, its max connections is 8.



Shawn​  Beard

Sr. Systems Engineer |
BTS

Middleware Engineering   |  +1-515-564-2528 |  
sbe...@wrberkley.com









-Original Message-
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 
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 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 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 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. Current pool size [8, Max pool size [8]

Shouldn’t the max connections of the connection pool be 50 since maxActive is 
50?



Shawn Beard • Sr. Systems Engineer
Middleware Engineering

[cid:image003.png@01D6D2E3.D5F1EFA0]

3840 109th Street Urbandale, IA 50322
Phone: +1-515-564-2528
Email: sbe...@wrberkley.com
Website: 
berkleytechnologyservices.com

Technology Leadership 

RE: jdbc connction pool issues [EXTERNAL]

[Beard, Shawn]

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 50 max connections, 
which is what maxActive is set to.



Shawn​  Beard

Sr. Systems Engineer |
BTS

Middleware Engineering   |  +1-515-564-2528 |  
sbe...@wrberkley.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 maximum number of 
connections for the pool, I think it's strictly referring to the "[ .. ] 
maximum number of *active connections* that can be allocated from this pool at 
the same time. [ .. ]" (emphasis mine on active connections)

Here is the doc that I've been referring to - sorry for not linking it earlier:
https://urldefense.com/v3/__https://tomcat.apache.org/tomcat-9.0-doc/jdbc-pool.html__;!!Li8W9_Um1Taa!vJGrxr7yc86joO5r6QoNstpipfempGFqrYRe3_NyAIGNs-LenmBWhtjn1fRiAOex$

On those other Tomcat servers is there a initialSize defined?

Jim

-Original Message-
From: Beard, Shawn 
Sent: 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 on the connection pool.

Here though I checked jmx, sure enough, its max connections is 8.



Shawn​ Beard

Sr. Systems Engineer |
BTS

Middleware Engineering | +1-515-564-2528 | 
sbe...@wrberkley.com









-Original Message-
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 
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 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 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 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. Current pool size [8, Max pool size [8]

Shouldn’t the max connections of the connection pool be 50 since maxActive is 
50?



Shawn Beard • Sr. Systems Engineer
Middleware Engineering

[cid:image003.png@01D6D2E3.D5F1EFA0]

3840 109th Street Urbandale, IA 50322
Phone: +1-515-564-2528
Email: sbe...@wrberkley.com
Website: 
berkleytechnologyservices.com

Technology Leadership Unleashing Business Potential


Shawn​

Beard
Sr. Systems Engineer
|
BTS
Middleware Engineering
|
+1-515-564-2528
|
sbe...@wrberkley.com

CONFIDENTIALITY NOTICE: This e-mail and the transmitted documents contain 
private, privileged and 

RE: jdbc connction pool issues [EXTERNAL]

[Johnson, Jim]

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 strictly referring to the "[ .. ] 
maximum number of *active connections* that can be allocated from this pool at 
the same time. [ .. ]"  (emphasis mine 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 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 on the connection pool.

Here though I checked jmx, sure enough, its max connections is 8.



Shawn​  Beard

Sr. Systems Engineer |
BTS

Middleware Engineering   |  +1-515-564-2528 |  
sbe...@wrberkley.com









-Original Message-
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 
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 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 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 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. Current pool size [8, Max pool size [8]

Shouldn’t the max connections of the connection pool be 50 since maxActive is 
50?



Shawn Beard • Sr. Systems Engineer
Middleware Engineering

[cid:image003.png@01D6D2E3.D5F1EFA0]

3840 109th Street Urbandale, IA 50322
Phone: +1-515-564-2528
Email: sbe...@wrberkley.com
Website: 
berkleytechnologyservices.com

Technology Leadership Unleashing Business Potential


Shawn​

Beard
Sr. Systems Engineer
|
BTS
Middleware Engineering
|
+1-515-564-2528
|
sbe...@wrberkley.com

CONFIDENTIALITY NOTICE: This e-mail and the transmitted documents contain 
private, privileged and confidential information belonging to the sender. The 
information therein is solely for the use of the addressee. If your receipt of 
this transmission has occurred as the result of an error, please immediately 
notify us so we can arrange for the return of the documents. In such 
circumstances, you are advised that you may not disclose, copy, distribute or 
take any other action in reliance on the information transmitted.
CONFIDENTIALITY NOTICE: This e-mail and the transmitted documents contain 
private, privileged and confidential information belonging to the sender. The 
information therein is solely for the use of the addressee. If your receipt of 
this transmission has occurred as the result of an error, please immediately 
notify us so we can arrange for the return of the documents. In such 
circumstances, you are advised that you may not disclose, copy, distribute or 
take any other action in reliance on the information transmitted.

RE: jdbc connction pool issues [EXTERNAL]

[Johnson, Jim]

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 [10]

However, it could be that the number of maxActive connections at the time was 8 
and they simply labeled it incorrectly.

From my perspective it seemed that if you're getting an alert at 80% pool size 
and the current pool size is 8 then you're probably looking for a default 
setting of 10 somewhere that isn't being set and initialSize seemed like a good 
candidate for that setting.

Perhaps you might check your monitoring tool thresholds - I would have to think 
that 80% is setting off bells and whistles so you have time to act before your 
JVM blows up.

Cheers!

- 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 |
BTS

Middleware Engineering   |  +1-515-564-2528 |  
sbe...@wrberkley.com









-Original Message-
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 
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 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 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 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. Current pool size [8, Max pool size [8]

Shouldn’t the max connections of the connection pool be 50 since maxActive is 
50?



Shawn Beard • Sr. Systems Engineer
Middleware Engineering

[cid:image003.png@01D6D2E3.D5F1EFA0]

3840 109th Street Urbandale, IA 50322
Phone: +1-515-564-2528
Email: sbe...@wrberkley.com
Website: 
berkleytechnologyservices.com

Technology Leadership Unleashing Business Potential


Shawn​

Beard
Sr. Systems Engineer
|
BTS
Middleware Engineering
|
+1-515-564-2528
|
sbe...@wrberkley.com

CONFIDENTIALITY NOTICE: This e-mail and the transmitted documents contain 
private, privileged and confidential information belonging to the sender. The 
information therein is solely for the use of the addressee. If your receipt of 
this transmission has occurred as the result of an error, please immediately 
notify us so we can arrange for the return of the documents. In such 
circumstances, you are advised that you may not disclose, copy, distribute or 
take any other action in reliance on the information transmitted.
CONFIDENTIALITY NOTICE: This e-mail and the transmitted documents contain 
private, privileged and confidential information belonging to the sender. The 
information therein is solely for the use of the addressee. If your receipt of 
this transmission has occurred as the result of an error, please immediately 
notify us so we can arrange for the return of the documents. In such 
circumstances, you are advised that you 

RE: jdbc connction pool issues [EXTERNAL]

[Beard, Shawn]

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 on the connection pool.

Here though I checked jmx, sure enough, its max connections is 8.



Shawn​  Beard

Sr. Systems Engineer |
BTS

Middleware Engineering   |  +1-515-564-2528 |  
sbe...@wrberkley.com









-Original Message-
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 
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 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 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 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. Current pool size [8, Max pool size [8]

Shouldn’t the max connections of the connection pool be 50 since maxActive is 
50?



Shawn Beard • Sr. Systems Engineer
Middleware Engineering

[cid:image003.png@01D6D2E3.D5F1EFA0]

3840 109th Street Urbandale, IA 50322
Phone: +1-515-564-2528
Email: sbe...@wrberkley.com
Website: 
berkleytechnologyservices.com

Technology Leadership Unleashing Business Potential


Shawn​

Beard
Sr. Systems Engineer
|
BTS
Middleware Engineering
|
+1-515-564-2528
|
sbe...@wrberkley.com

CONFIDENTIALITY NOTICE: This e-mail and the transmitted documents contain 
private, privileged and confidential information belonging to the sender. The 
information therein is solely for the use of the addressee. If your receipt of 
this transmission has occurred as the result of an error, please immediately 
notify us so we can arrange for the return of the documents. In such 
circumstances, you are advised that you may not disclose, copy, distribute or 
take any other action in reliance on the information transmitted.
CONFIDENTIALITY NOTICE: This e-mail and the transmitted documents contain 
private, privileged and confidential information belonging to the sender. The 
information therein is solely for the use of the addressee. If your receipt of 
this transmission has occurred as the result of an error, please immediately 
notify us so we can arrange for the return of the documents. In such 
circumstances, you are advised that you may not disclose, copy, distribute or 
take any other action in reliance on the information transmitted.

RE: jdbc connction pool issues [EXTERNAL]

[Beard, Shawn]

If default is 10, they why would we be getting an error about 8 being max?



Shawn​  Beard

Sr. Systems Engineer |
BTS

Middleware Engineering   |  +1-515-564-2528 |  
sbe...@wrberkley.com









-Original Message-
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 
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 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 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 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. Current pool size [8, Max pool size [8]

Shouldn’t the max connections of the connection pool be 50 since maxActive is 
50?



Shawn Beard • Sr. Systems Engineer
Middleware Engineering

[cid:image003.png@01D6D2E3.D5F1EFA0]

3840 109th Street Urbandale, IA 50322
Phone: +1-515-564-2528
Email: sbe...@wrberkley.com
Website: 
berkleytechnologyservices.com

Technology Leadership Unleashing Business Potential


Shawn​

Beard
Sr. Systems Engineer
|
BTS
Middleware Engineering
|
+1-515-564-2528
|
sbe...@wrberkley.com

CONFIDENTIALITY NOTICE: This e-mail and the transmitted documents contain 
private, privileged and confidential information belonging to the sender. The 
information therein is solely for the use of the addressee. If your receipt of 
this transmission has occurred as the result of an error, please immediately 
notify us so we can arrange for the return of the documents. In such 
circumstances, you are advised that you may not disclose, copy, distribute or 
take any other action in reliance on the information transmitted.
CONFIDENTIALITY NOTICE: This e-mail and the transmitted documents contain 
private, privileged and confidential information belonging to the sender. The 
information therein is solely for the use of the addressee. If your receipt of 
this transmission has occurred as the result of an error, please immediately 
notify us so we can arrange for the return of the documents. In such 
circumstances, you are advised that you may not disclose, copy, distribute or 
take any other action in reliance on the information transmitted.

RE: jdbc connction pool issues

[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 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 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 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. Current pool size [8, Max pool size [8]

Shouldn’t the max connections of the connection pool be 50 since maxActive is 
50?



Shawn Beard • Sr. Systems Engineer
Middleware Engineering

[cid:image003.png@01D6D2E3.D5F1EFA0]

 3840 109th Street Urbandale, IA 50322
 Phone: +1-515-564-2528
 Email: sbe...@wrberkley.com
 Website: 
berkleytechnologyservices.com

Technology Leadership Unleashing Business Potential


Shawn​

Beard
Sr. Systems Engineer
 |
BTS
Middleware Engineering
 |
+1-515-564-2528
 |
sbe...@wrberkley.com

CONFIDENTIALITY NOTICE: This e-mail and the transmitted documents contain 
private, privileged and confidential information belonging to the sender. The 
information therein is solely for the use of the addressee. If your receipt of 
this transmission has occurred as the result of an error, please immediately 
notify us so we can arrange for the return of the documents. In such 
circumstances, you are advised that you may not disclose, copy, distribute or 
take any other action in reliance on the information transmitted.

jdbc connction pool issues

[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. Current pool size [8, Max pool size [8]

Shouldn’t the max connections of the connection pool be 50 since maxActive is 
50?



Shawn Beard • Sr. Systems Engineer
Middleware Engineering


[cid:image085436.PNG@fbcb1466.43bb3916]


 3840 109th Street Urbandale, IA 50322
 Phone: +1-515-564-2528
 Email: sbe...@wrberkley.com
 Website: 
berkleytechnologyservices.com


Technology Leadership Unleashing Business Potential





Shawn​  Beard

Sr. Systems Engineer |
BTS

Middleware Engineering   |  +1-515-564-2528 |  
sbe...@wrberkley.com







CONFIDENTIALITY NOTICE: This e-mail and the transmitted documents contain 
private, privileged and confidential information belonging to the sender. The 
information therein is solely for the use of the addressee. If your receipt of 
this transmission has occurred as the result of an error, please immediately 
notify us so we can arrange for the return of the documents. In such 
circumstances, you are advised that you may not disclose, copy, distribute or 
take any other action in reliance on the information transmitted.