Connection Pooling

[Lionel Samuel]

Hello:

I am trying to understand why DB connections exceed the value set at
maxTotal (when viewed under 'netstat -a') --- so not a Shibboleth question
directly (many here would be able to help more clearly).

We are on v3.3.3, tomcat 8, java 8 (oracle) -- we have to use DB connector
for certain events for looking up attributes (~50 DataConnectors).

Tomcat set at: JAVA_OPTS="-server -Xmx3072m
-Djava.security.egd=file:/dev/./urandom"

For maxTotal --- this is the concurrent active sessions? Our DBA is
complaining she sees far more connections that the values set at maxTotal
on each of the 5 load  balanced server......trying to pin this down.


 <bean id="OracleDataSource"
class="org.apache.commons.dbcp2.BasicDataSource" destroy-method="close"
    p:driverClassName="oracle.jdbc.driver.OracleDriver"
    p:url="jdbc:oracle:thin:@foo" p:username="da" p:password="nyet"
    p:initialSize="5" p:maxTotal="100" p:maxIdle="25"
p:maxWaitMillis="2000" p:testOnBorrow="true"
    p:testWhileIdle="true" p:testOnReturn="true"
p:timeBetweenEvictionRunsMillis="120000"
    p:minEvictableIdleTimeMillis="60000" p:validationQuery="select 1 from
dual" p:validationQueryTimeout="4" />
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://shibboleth.net/pipermail/users/attachments/20180905/a35a0740/attachment.html>