What versions of dbcp and pool are you running? Looks like 1.x from the package names. The first thing to look at is the changelogs[1] for releases since the pool and dbcp versions that you are running.
Phil [1] for dbcp this is https://commons.apache.org/proper/commons-dbcp/changes-report.html There is a similar page on the pool site. On 1/24/17 3:02 PM, Romero, René wrote: > Hello guys. > > Under what circumstances could we get more than MaxActive sessions in the > database if DBCP is our only means of access to it? > > This is our current configuration and it's surpassing 160 Oracle sessions at > times when it shouldn't go beyond 32 (our current value for MaxActive). > > > DB = Oracle 11g > > Data access via spring famework. > > > Thanks in advance. > > > <bean id="dwDataSource" class="org.apache.commons.dbcp.BasicDataSource" > p:url="${dw.db.url}" p:username="${dw.db.username}" > p:password="${dw.db.password}" > p:driverClassName="${dw.db.driverClassName}" init-method="createDataSource" > destroy-method="close"> > <property name="initialSize" value="${dw.db.initial.connection.size}" /> > <property name="maxActive" value="${dw.db.max.connection.size}" /> > <!-- As part of perf testing, saw a bottleneck in the dw hence commiting > these two params > <property name="testOnBorrow" value="true" /> > <property name="validationQuery" value="${dw.db.validation.query}" /> --> > <property name="minEvictableIdleTimeMillis" value="900000" /> > <property name="minIdle" value="${dw.db.minIdle.connections}" /> > <property name="maxIdle" value="${dw.db.maxIdle.connections}" /> > <property name="timeBetweenEvictionRunsMillis" value="1200000" /> > </bean> > > > dw.db.url=jdbc:oracle:thin:someDB/somePass@someHost:1522:SomeInstance > dw.db.username=someUser > dw.db.password=somePass > dw.db.driverClassName=oracle.jdbc.OracleDriver > dw.db.allowed.operations=select > dw.db.schema=1|COMMON_APP_VIEWS_01, 81|COMMON_APP_VIEWS_81 > dw.db.maxRows=500 > dw.db.type=ORACLE > dw.db.validation.query=select 1 from dual > dw.db.initial.connection.size=4 > dw.db.max.connection.size=32 > dw.db.minIdle.connections=4 > dw.db.maxIdle.connections=4 > > > What other info would you need? > > > Rene Romero Benavides > Administrador de Bases de Datos para Command Center > +52(55) 11020460 Ext. 6432 | Office > > +52 1 5545664012 | Mobile > > www.omnitracs.com/mx<http://www.omnitracs.com/mx> > > Register today! www.omnitracs.com/outlook<http://www.omnitracs.com/outlook> > > <https://outlook.office.com/owa/service.svc/s/GetFileAttachment?id=AAMkAGM2NWIyZGFmLWZhMTYtNDUzNC04YzQ5LWEwOTA1Zjk4MTY3ZgBGAAAAAABp9rw%2F5DvqQ5VNu%2FP5FANvBwCC6JFKXcS6RJy5Q76IhGGqAAAAAAEMAACC6JFKXcS6RJy5Q76IhGGqAACGtmA4AAABEgAQANT3RQAH0VJIrveZGngUUTQ%3D&X-OWA-CANARY=zgTt0gEIPEaHc-Q35K2xD7ADDSE3yNIYLGPJUeTkGumastS1fdcpigPbw4ASyo9SSzPAsJtdi6o> > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
