+1 from here
On Tue, Jun 3, 2014 at 1:19 PM, Ian Turton <ijtur...@gmail.com> wrote:
> +1 from me
>
> Ian
>
>
> On 3 June 2014 09:40, Andrea Aime <andrea.a...@geo-solutions.it> wrote:
>
>> On Mon, Apr 28, 2014 at 4:31 PM, Justin Deoliveira <
>> 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
>>
>>
>
>
> --
> Ian Turton
>
>
> ------------------------------------------------------------------------------
> 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
>
>
--
DI Christian Mueller MSc (GIS), MSc (IT-Security)
OSS Open Source Solutions GmbH
------------------------------------------------------------------------------
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
