Re: jdbc connction pool issues [EXTERNAL]

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 se

RE: jdbc connction pool issues [EXTERNAL]

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

RE: jdbc connction pool issues [EXTERNAL]

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

RE: jdbc connction pool issues [EXTERNAL]

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 5

RE: jdbc connction pool issues [EXTERNAL]

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 conn

RE: jdbc connction pool issues [EXTERNAL]

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 b

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​

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: Johnso

RE: jdbc connction pool issues

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

jdbc connction pool issues

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