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<tel:+1-515-564-2528> |
[email protected]<mailto:[email protected]>
-----Original Message-----
From: Jalaj Asher <[email protected]>
Sent: Tuesday, December 15, 2020 2:39 PM
To: Tomcat Users List <[email protected]>
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 <[email protected]>
Sent: Tuesday, December 15, 2020 3:22 PM
To: Tomcat Users List <[email protected]>
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.html&data=04*7C01*7Cjalaj.asher*40eclinicalworks.com*7C3f5dd36a4b0d458695d908d8a1371f11*7C7ce747e48f6d4e0697efa9b76a063808*7C1*7C0*7C637436605411941490*7CUnknown*7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0*3D*7C3000&sdata=bPYOMGVa0dYi0ASx*2BuQ5pTdlzpuOKird7pAVi*2FjHQVs*3D&reserved=0__;JSUlJSUlJSUlJSUlJSUlJSUlJSU!!Li8W9_Um1Taa!q2MG45FC18cm0UD-N10yCZgPVqpaQaZGKILOaYz6c1kiDPaCBBP5Q1UZoCWfvJtl$
On those other Tomcat servers is there a initialSize defined?
Jim
-----Original Message-----
From: Beard, Shawn <[email protected]>
Sent: Tuesday, December 15, 2020 2:49 PM
To: Tomcat Users List <[email protected]>
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<tel:+1-515-564-2528> |
[email protected]<mailto:[email protected]>
-----Original Message-----
From: Johnson, Jim <[email protected]>
Sent: Tuesday, December 15, 2020 1:35 PM
To: Tomcat Users List <[email protected]>
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 <[email protected]>
Sent: Tuesday, December 15, 2020 2:12 PM
To: Tomcat Users List <[email protected]>
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:
<Resource name="jdbc/DataSource" auth="Container" type="javax.sql.DataSource"
driverClassName="com.microsoft.sqlserver.jdbc.SQLServerDriver"
url="jdbc:sqlserver://hostname:1433;selectMethod=direct;databaseName=databasename;sendStringParametersAsUnicode=false"
username="XXX" password="XXXXXX" maxIdle="20" minIdle="10" maxActive="50"
maxWait="30000" testWhileIdle="true" testOnBorrow="true"
validationQuery="SELECT 1"/>
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=XXXXXXXXX,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:[email protected]]
3840 109th Street Urbandale, IA 50322
Phone: +1-515-564-2528
Email: [email protected]<mailto:[email protected]>
Website:
berkleytechnologyservices.com<https://urldefense.com/v3/__https://nam05.safelinks.protection.outlook.com/?url=https*3A*2F*2Furldefense.com*2Fv3*2F__https*3A*2F*2Fnam05.safelinks.protection.outlook.com*2F*3Furl*3Dhttps*3A*2F*2Fwww.berkleytechnologyservices.com*2F*26data*3D04*7C01*7CJ1Johnson*40unum.com*7C64e6e4965acb42aebfe708d8a12d798c*7Cd5952c785d4e41caaff07174c1f75393*7C0*7C0*7C637436563975240326*7CUnknown*7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0*3D*7C3000*26sdata*3D3nTT6swXEeC2zC*2BUb7Q7nvgxM214SGf7HJaI*2F4*2BYupA*3D*26reserved*3D0__*3BJSUlJSUlJSUlJSUlJSUlJSUlJSU!!Li8W9_Um1Taa!qrMl5L--I8QMohhvL9LXmHKdJz0jf2lM2XTvoH8FwyisGVhxNJdYs74vjiQ2KJgp*24&data=04*7C01*7Cjalaj.asher*40eclinicalworks.com*7C3f5dd36a4b0d458695d908d8a1371f11*7C7ce747e48f6d4e0697efa9b76a063808*7C1*7C0*7C637436605411941490*7CUnknown*7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0*3D*7C3000&sdata=j4JvD*2BB6TzoymQAJookdvrCXXLBvGncjNBlYQ*2BpAU1o*3D&reserved=0__;JSUlJSUlJSUlJSUqKioqJSUqKioqKioqKioqKiolJSoqKiolJSUlJSUlJSUlJSUlJSUlJSUl!!Li8W9_Um1Taa!q2MG45FC18cm0UD-N10yCZgPVqpaQaZGKILOaYz6c1kiDPaCBBP5Q1UZoNFJI5zh$
>
Technology Leadership Unleashing Business Potential
Shawn
Beard
Sr. Systems Engineer
|
BTS
Middleware Engineering
|
+1-515-564-2528<tel:+1-515-564-2528>
|
[email protected]<mailto:[email protected]>
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.
B�KKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKKCB�� [��X��ܚX�KK[XZ[
� \�\��][��X��ܚX�P �X�] �\X�K�ܙ�B��܈Y][ۘ[��[X[� �K[XZ[
� \�\��Z[ �X�] �\X�K�ܙ�B�
CONFIDENTIALITY NOTICE TO RECIPIENT: This transmission contains confidential
information belonging to the sender that is legally privileged and proprietary
and may be subject to protection under the law, including the Health Insurance
Portability and Accountability Act (HIPAA). If you are not the intended
recipient of this e-mail, you are prohibited from sharing, copying, or
otherwise using or disclosing its contents. If you have received this e-mail in
error, please notify the sender immediately by reply e-mail and permanently
delete this e-mail and any attachments without reading, forwarding or saving
them. Thank you.
CONFIDENTIALITY NOTICE TO RECIPIENT: This transmission contains confidential
information belonging to the sender that is legally privileged and proprietary
and may be subject to protection under the law, including the Health Insurance
Portability and Accountability Act (HIPAA). If you are not the intended
recipient of this e-mail, you are prohibited from sharing, copying, or
otherwise using or disclosing its contents. If you have received this e-mail in
error, please notify the sender immediately by reply e-mail and permanently
delete this e-mail and any attachments without reading, forwarding or saving
them. Thank you.
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.
