So DBCP 1.4 does not support minEvictableIdleTimeMillis/timeBetweenEvictionRunsMillis or equivalent? http://docs.geoserver.org/latest/en/user/data/app-schema/data-stores.html#jndi
+1 for upgrade to DBCP 2.0 based on our positive experience with 1.4. Kind regards, Ben. On 03/06/14 16:40, Andrea Aime wrote: > On Mon, Apr 28, 2014 at 4:31 PM, Justin Deoliveira > <jdeol...@boundlessgeo.com <mailto:jdeol...@boundlessgeo.com>> wrote: > > I'll take the conservative approach of "if it ain't broke don't fix > it". With the java7 upgrade still ongoing we already have enough > moving parts so perhaps we should put this one off for now since it > doesn't actually fix a known issue. But no strong opinion, just my $0.02 > > > Hi all, > in the last few days I stumbled into not one, but two separate cases in > which "it is broken". > > In both cases there is a overzealous network apparatus between the > connection pool and the database that, > for security reasons, automatically closes the TCP connections that have > been idle for too long time. > However, it does that in a very nasty way, when the JDBC driver tries to > use the connection the query > gets sent over, goes nowhere, the driver does not notice though, and it > eventually times out after > around 10 minutes wait. > > This is... really really nasty, if you stumble into one such connections > the response won't come > back in ages, and during that time, the connection will keep on using a > slot in the pool, reducing > its capacity. > > Turns out there is nothing we can do at the DCBP 1.4 level, but both > DBCP 2.0 and Tomcat pool > have a configuration to just drop connections that have been idle for > too long. > > I'm leaning towards an upgrade to DBCP 2.0, mostly because I'm nervous > about Tomcat deploys > where having tomcat-pool both in the webapp and in the tomcat shared > libs, possibly with different > versions of the library, may result nasty issues (ever tried having a > jdbc driver both > in the app and in the shared libs? it does not work). > > Cheers > Andrea > > -- > == > Meet us at GEO Business 2014! in London! Visit http://goo.gl/fES3aK > for more information. > == > > Ing. Andrea Aime > @geowolf > Technical Lead > > GeoSolutions S.A.S. > Via Poggio alle Viti 1187 > 55054 Massarosa (LU) > Italy > phone: +39 0584 962313 > fax: +39 0584 1660272 > mob: +39 339 8844549 > > http://www.geo-solutions.it > http://twitter.com/geosolutions_it > > ------------------------------------------------------- > > > ------------------------------------------------------------------------------ > Learn Graph Databases - Download FREE O'Reilly Book > "Graph Databases" is the definitive new guide to graph databases and their > applications. Written by three acclaimed leaders in the field, > this first edition is now available. Download your free book today! > http://p.sf.net/sfu/NeoTech > > > > _______________________________________________ > GeoTools-Devel mailing list > GeoTools-Devel@lists.sourceforge.net > https://lists.sourceforge.net/lists/listinfo/geotools-devel > -- Ben Caradoc-Davies <ben.caradoc-dav...@csiro.au> Software Engineer CSIRO Earth Science and Resource Engineering Australian Resources Research Centre ------------------------------------------------------------------------------ Learn Graph Databases - Download FREE O'Reilly Book "Graph Databases" is the definitive new guide to graph databases and their applications. Written by three acclaimed leaders in the field, this first edition is now available. Download your free book today! http://p.sf.net/sfu/NeoTech _______________________________________________ GeoTools-Devel mailing list GeoTools-Devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/geotools-devel
