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.
Shawn Beard
Sr. Systems Engineer |
BTS
Middleware Engineering | +1-515-564-2528<tel:+1-515-564-2528> |
sbe...@wrberkley.com<mailto:sbe...@wrberkley.com>
-----Original Message-----
From: Beard, Shawn <sbe...@wrberkley.com.INVALID>
Sent: Wednesday, December 16, 2020 7:43 AM
To: Tomcat Users List <users@tomcat.apache.org>
Subject: RE: jdbc connction pool issues [EXTERNAL]
** CAUTION: External message
Yes same version of tomcat 9.0.31, however the one having issues is running
java 8 where the one that shows things correctly is running java 11.
Shawn Beard
Sr. Systems Engineer |
BTS
Middleware Engineering | +1-515-564-2528<tel:+1-515-564-2528> |
sbe...@wrberkley.com<mailto:sbe...@wrberkley.com>
-----Original Message-----
From: Phil Steitz <p...@steitz.com>
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 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://urldefense.com/v3/__https://tomcat.apache.org/migration-8.html*Database_Connection_Pooling__;Iw!!Li8W9_Um1Taa!orxL7Ci-tTj7jM-90ooXXY8VTcDfIzFLc9YZw4Oh-ybxGw-BbIQv4_O0_vGUlXfF$
>
>
>
> Shawn Beard
>
> Sr. Systems Engineer |
> BTS
>
> Middleware Engineering | +1-515-564-2528<tel:+1-515-564-2528> |
> sbe...@wrberkley.com<mailto:sbe...@wrberkley.com>
>
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: Johnson, Jim <j1john...@unum.com>
> Sent: Tuesday, December 15, 2020 2:22 PM
> To: Tomcat Users List <users@tomcat.apache.org>
> 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/j
> dbc-pool.html__;!!Li8W9_Um1Taa!vJGrxr7yc86joO5r6QoNstpipfempGFqrYRe3_N
> yAIGNs-LenmBWhtjn1fRiAOex$
>
> On those other Tomcat servers is there a initialSize defined?
>
> Jim
>
> -----Original Message-----
> From: Beard, Shawn <sbe...@wrberkley.com.INVALID>
> Sent: Tuesday, December 15, 2020 2:49 PM
> To: Tomcat Users List <users@tomcat.apache.org>
> 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> |
> sbe...@wrberkley.com<mailto:sbe...@wrberkley.com>
>
>
>
>
>
>
>
>
>
> -----Original Message-----
> From: Johnson, Jim <j1john...@unum.com>
> Sent: Tuesday, December 15, 2020 1:35 PM
> To: Tomcat Users List <users@tomcat.apache.org>
> 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 <sbe...@wrberkley.com.INVALID>
> Sent: Tuesday, December 15, 2020 2:12 PM
> To: Tomcat Users List <users@tomcat.apache.org>
> 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="j
> dbc/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<mailto:sbe...@wrberkley.com>
> Website:
> berkleytechnologyservices.com<https://urldefense.com/v3/__https://nam0
> 5.safelinks.protection.outlook.com/?url=https*3A*2F*2Furldefense.com*2
> Fv3*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*7Cd5952c785d
> 4e41caaff07174c1f75393*7C0*7C0*7C637436563975240326*7CUnknown*7CTWFpbG
> Zsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0*
> 3D*7C3000*26sdata*3D3nTT6swXEeC2zC*2BUb7Q7nvgxM214SGf7HJaI*2F4*2BYupA*
> 3D*26reserved*3D0__*3BJSUlJSUlJSUlJSUlJSUlJSUlJSU!!Li8W9_Um1Taa!qrMl5L
> --I8QMohhvL9LXmHKdJz0jf2lM2XTvoH8FwyisGVhxNJdYs74vjiQ2KJgp*24&data
> =04*7C01*7CJ1Johnson*40unum.com*7C016565a918474642884608d8a1328579*7Cd
> 5952c785d4e41caaff07174c1f75393*7C0*7C0*7C637436585655273329*7CUnknown
> *7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJ
> XVCI6Mn0*3D*7C2000&sdata=tBYkHrqnGHyaJPmtqrHIB5LPJLsZfdU4YdsK2JFVw
> Ao*3D&reserved=0__;JSUlJSUlJSUlJSUqKioqJSUqKioqKioqKioqKiolJSoqKio
> lJSUlJSUlJSUlJSUlJSUlJQ!!Li8W9_Um1Taa!vJGrxr7yc86joO5r6QoNstpipfempGFq
> rYRe3_NyAIGNs-LenmBWhtjn1ZVqcYXS$ >
>
> Technology Leadership Unleashing Business Potential
>
>
> Shawn
>
> Beard
> Sr. Systems Engineer
> |
> BTS
> Middleware Engineering
> |
> +1-515-564-2528<tel:+1-515-564-2528>
> |
> sbe...@wrberkley.com<mailto: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.
> 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.
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
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.
