DBCP issuing more sessions than maxActive sessions in Oracle

2017-01-24 Thread Romero , René
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 =

Re: DBCP issuing more sessions than maxActive sessions in Oracle

2017-01-24 Thread Phil Steitz
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

Re: [EXTERNAL]Re: DBCP issuing more sessions than maxActive sessions in Oracle

2017-01-24 Thread Shawn Heisey
On 1/24/2017 5:36 PM, Romero, René wrote: > Guys, do you think dbcp-1.4.1 is going to come out soon? I'm more familiar with the Lucene/Solr project than Commons, but if I had to guess, I would say that you're unlikely to see a new 1.x version of dbcp or pool. The 1.4 version of dbcp was released

Re: [EXTERNAL]Re: DBCP issuing more sessions than maxActive sessions in Oracle

2017-01-24 Thread Romero , René
We're running commons-dbcp-1.4 and commons-pool-1.6. To me, it sounds like we're being impacted by this bug: https://issues.apache.org/jira/browse/DBCP-379 [DBCP-379] number of connections created has crossed more ... issues.apache.org I found

Re: [EXTERNAL]Re: DBCP issuing more sessions than maxActive sessions in Oracle

2017-01-24 Thread Shawn Heisey
On 1/24/2017 3:55 PM, Romero, René wrote: > We're running commons-dbcp-1.4 and commons-pool-1.6. To me, it sounds like > we're being impacted by this bug: > > https://issues.apache.org/jira/browse/DBCP-379 > > [DBCP-379] number of connections created has crossed more >

Re: [EXTERNAL]Re: DBCP issuing more sessions than maxActive sessions in Oracle

2017-01-24 Thread Romero , René
Thank you very much Shawn for sharing your experience and code on this, we'll certainly use it. Guys, do you think dbcp-1.4.1 is going to come out soon? Rene Romero Benavides Administrador de Bases de Datos para Command Center +52(55) 11020460 Ext. 6432 | Office +52 1 5545664012 | Mobile

Re: [EXTERNAL]Re: DBCP issuing more sessions than maxActive sessions in Oracle

2017-01-24 Thread Gary Gregory
ATM & FWIW, the only push I see is to release new versions of [pool2] and [dbcp2] out of the current branches. Gary On Tue, Jan 24, 2017 at 5:37 PM, Shawn Heisey wrote: > On 1/24/2017 5:36 PM, Romero, René wrote: > > Guys, do you think dbcp-1.4.1 is going to come out soon?

Re: [EXTERNAL]Re: DBCP issuing more sessions than maxActive sessions in Oracle

2017-01-24 Thread Romero , René
Got it. Thanks a lot for the info. Won't put my hopes on the 1.x series. Greetings from Mexico. Rene Romero Benavides Administrador de Bases de Datos para Command Center