Re: [Geotools-devel] Upgrading our connection pool library

2014-06-04 Thread Andrea Aime 
On Wed, Jun 4, 2014 at 8:48 AM, Ben Caradoc-Davies <
ben.caradoc-dav...@csiro.au> wrote:

> Connections must be idle for at least 5 minutes (and up to 10) with these
> settings:
>
> minEvictableIdleTimeMillis="30"
> timeBetweenEvictionRunsMillis="30"
>
> If requests are very infrequent, then I agree that they will be much
> slower. For more frequent requests there should be no loss of performance.


That depends. The only way for no loss of performance regardless of the
pool policies
is that we get enough parallel requests over time to keep the pool at full
capacity.

If instead we get constant load of one requests (no parallel ones) the pool
will probably go down to just one connection,
 and it will have to grab new ones when the load goes back up.
That is, unless the connections are extracted in a round robin fashion...
but I'd expect the pool to extract objects using
a LRU policy instead (would make sense for performance considerations, the
data structures of the last used connection are more
likely to be in the CPU cache).

Also, to guarantee the connections are freed before the firewall timeout in
the worst case, the numTestsPerEvictionRun should
be as big as the max connection pool size (e..g, if you have 15
connections, and use numTestsPerEvictionRun=3,
it will take 5 runs of the evictor to free the pool, thus bringing the max
idle time before a connection is surely
evicted to 30 minutes)

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

Re: [Geotools-devel] Upgrading our connection pool library

2014-06-03 Thread Ben Caradoc-Davies 
Connections must be idle for at least 5 minutes (and up to 10) with 
these settings:

minEvictableIdleTimeMillis="30"
timeBetweenEvictionRunsMillis="30"

If requests are very infrequent, then I agree that they will be much 
slower. For more frequent requests there should be no loss of performance.

On 04/06/14 14:40, Andrea Aime wrote:
> Yes, that combination would work, but the cure will imho damage the
> patient in the process, as it will reduce
> the performance of the system, especially against Oracle, where grabbing
> a new connection is expensive.

-- 
Ben Caradoc-Davies 
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

Re: [Geotools-devel] Upgrading our connection pool library

2014-06-03 Thread Andrea Aime 
On Wed, Jun 4, 2014 at 8:37 AM, Ben Caradoc-Davies <
ben.caradoc-dav...@csiro.au> wrote:

> What about minIdle=0? That seemed to fix my problems with firewalls
> between GeoServer and the database.
>

Yes, that combination would work, but the cure will imho damage the patient
in the process, as it will reduce
the performance of the system, especially against Oracle, where grabbing a
new connection is expensive.

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

Re: [Geotools-devel] Upgrading our connection pool library

2014-06-03 Thread Ben Caradoc-Davies 
What about minIdle=0? That seemed to fix my problems with firewalls 
between GeoServer and the database.

(Still supporting upgrade to DBCP 2.0.)

On 04/06/14 14:35, Andrea Aime wrote:
> Those are supported, but they are not useful, as the pool won't evict
> connections
> below the minIdle threshold, just the ones above it.

-- 
Ben Caradoc-Davies 
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

Re: [Geotools-devel] Upgrading our connection pool library

2014-06-03 Thread Andrea Aime 
On Wed, Jun 4, 2014 at 3:19 AM, Ben Caradoc-Davies <
ben.caradoc-dav...@csiro.au> wrote:

> 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


Those are supported, but they are not useful, as the pool won't evict
connections
below the minIdle threshold, just the ones above it.
What we need is maxConnLifetimeMillis, which is not available in the 1.4.x
series:
http://svn.apache.org/viewvc/commons/proper/dbcp/branches/DBCP_1_4_x_BRANCH/src/java/org/apache/commons/dbcp/BasicDataSourceFactory.java?view=markup

It's only available in the 2.x series instead (scroll down a bit more here):
http://svn.apache.org/viewvc/commons/proper/dbcp/trunk/src/main/java/org/apache/commons/dbcp2/BasicDataSourceFactory.java?view=markup


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

Re: [Geotools-devel] Upgrading our connection pool library

2014-06-03 Thread Ben Caradoc-Davies 
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
> 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 
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

Re: [Geotools-devel] Upgrading our connection pool library

2014-06-03 Thread Christian Mueller 
+1 from here


On Tue, Jun 3, 2014 at 1:19 PM, Ian Turton  wrote:

> +1 from me
>
> Ian
>
>
> On 3 June 2014 09:40, Andrea Aime  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

Re: [Geotools-devel] Upgrading our connection pool library

2014-06-03 Thread Ian Turton 
+1 from me

Ian


On 3 June 2014 09:40, Andrea Aime  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

Re: [Geotools-devel] Upgrading our connection pool library

2014-06-03 Thread Andrea Aime 
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

Re: [Geotools-devel] Upgrading our connection pool library

2014-04-28 Thread Justin Deoliveira 
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


On Mon, Apr 28, 2014 at 7:03 AM, Andrea Aime
wrote:

> On Mon, Apr 28, 2014 at 2:53 PM, Nuno Oliveira <
> nuno-miguel-olive...@telecom.pt> wrote:
>
>>  Hi,
>>
>> (I think) Commons DBCP (incluing 2.0 version) is deprecated in favour of
>> tomcat-jdbc (a new connection pool implemented by tomcat guys ...):
>>
>> https://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html
>>
>
> In Tomcat it is, yes. But Apache commons never deprecated DBCP, the
> project is still active and making new releases,
> and the material stating that Tomcat own version is better is not
> referring to DBCP 2.0, in fact in the 8.0 pool guide
> the retracted the first two statements about performance and scalability:
>
> https://tomcat.apache.org/tomcat-8.0-doc/jdbc-pool.html
>
> Point 9 is still interesting, but does not even try to compare to DBCP.
> Point 7 is something I'm not too happy about,
> we don't really need another logging library dependency...
>
> 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
>
> ---
>
>
> --
> "Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
> Instantly run your Selenium tests across 300+ browser/OS combos.  Get
> unparalleled scalability from the best Selenium testing platform available.
> Simple to use. Nothing to install. Get started now for free."
> http://p.sf.net/sfu/SauceLabs
> ___
> GeoTools-Devel mailing list
> GeoTools-Devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geotools-devel
>
>


-- 
*Justin Deoliveira*
Vice President, Engineering | Boundless
jdeol...@boundlessgeo.com
@j_deolive 
--
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.  Get 
unparalleled scalability from the best Selenium testing platform available.
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs___
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel

Re: [Geotools-devel] Upgrading our connection pool library

2014-04-28 Thread Andrea Aime 
On Mon, Apr 28, 2014 at 2:53 PM, Nuno Oliveira <
nuno-miguel-olive...@telecom.pt> wrote:

>  Hi,
>
> (I think) Commons DBCP (incluing 2.0 version) is deprecated in favour of
> tomcat-jdbc (a new connection pool implemented by tomcat guys ...):
>
> https://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html
>

In Tomcat it is, yes. But Apache commons never deprecated DBCP, the project
is still active and making new releases,
and the material stating that Tomcat own version is better is not referring
to DBCP 2.0, in fact in the 8.0 pool guide
the retracted the first two statements about performance and scalability:

https://tomcat.apache.org/tomcat-8.0-doc/jdbc-pool.html

Point 9 is still interesting, but does not even try to compare to DBCP.
Point 7 is something I'm not too happy about,
we don't really need another logging library dependency...

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

---
--
"Accelerate Dev Cycles with Automated Cross-Browser Testing - For FREE
Instantly run your Selenium tests across 300+ browser/OS combos.  Get 
unparalleled scalability from the best Selenium testing platform available.
Simple to use. Nothing to install. Get started now for free."
http://p.sf.net/sfu/SauceLabs___
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel

Re: [Geotools-devel] Upgrading our connection pool library

2014-04-27 Thread Andrea Aime 
On Sun, Apr 27, 2014 at 9:38 AM, Jody Garnett wrote:

> Well if they are equal, and both require coding to upgrade we may be able
> to check what is faster.
>

Yes, except my intention is asking was to see if anybody already knows or
has had experiences
with them.

I have no mandate to work on a comparative benchmark, and since it's not
normally a bottleneck
in public benchmarks, not much interest in working on one in my spare time
either :-p

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

---
--
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform___
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel

Re: [Geotools-devel] Upgrading our connection pool library

2014-04-27 Thread Jody Garnett 
Well if they are equal, and both require coding to upgrade we may be able
to check what is faster.

Jody Garnett


On Sun, Apr 27, 2014 at 5:33 PM, Andrea Aime
wrote:

> Hi,
> I was checking the commons-dbcp web site and noticed DBCP 2.0 is out.
> While they claim DBCP has higher performance, version 2.0 is not binary
> compatible with the 1.x series (and it requires Java 7, no big deal here).
>
> Since an upgrade would take some coding, I'm wondering about switching
> to the Tomcat connection pool instead, which is also available as a jar
> in maven central:
> https://people.apache.org/~fhanik/jdbc-pool/jdbc-pool.html
>
> They also claim to have significantly higher performance than DBCP 1.x...
> the times I've tried it out in GeoServer benchmarks I actually so no
> improvements,
> but that might be because the bottleneck has been traditionally somewhere
> else.
>
> Does anyone have an opinion? (Including just staying with DBCP 1.4.x of
> course :-) )
>
> 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
>
> ---
>
>
> --
> Start Your Social Network Today - Download eXo Platform
> Build your Enterprise Intranet with eXo Platform Software
> Java Based Open Source Intranet - Social, Extensible, Cloud Ready
> Get Started Now And Turn Your Intranet Into A Collaboration Platform
> http://p.sf.net/sfu/ExoPlatform
> ___
> GeoTools-Devel mailing list
> GeoTools-Devel@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/geotools-devel
>
>
--
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform___
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel

[Geotools-devel] Upgrading our connection pool library

2014-04-27 Thread Andrea Aime 
Hi,
I was checking the commons-dbcp web site and noticed DBCP 2.0 is out.
While they claim DBCP has higher performance, version 2.0 is not binary
compatible with the 1.x series (and it requires Java 7, no big deal here).

Since an upgrade would take some coding, I'm wondering about switching
to the Tomcat connection pool instead, which is also available as a jar
in maven central:
https://people.apache.org/~fhanik/jdbc-pool/jdbc-pool.html

They also claim to have significantly higher performance than DBCP 1.x...
the times I've tried it out in GeoServer benchmarks I actually so no
improvements,
but that might be because the bottleneck has been traditionally somewhere
else.

Does anyone have an opinion? (Including just staying with DBCP 1.4.x of
course :-) )

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

---
--
Start Your Social Network Today - Download eXo Platform
Build your Enterprise Intranet with eXo Platform Software
Java Based Open Source Intranet - Social, Extensible, Cloud Ready
Get Started Now And Turn Your Intranet Into A Collaboration Platform
http://p.sf.net/sfu/ExoPlatform___
GeoTools-Devel mailing list
GeoTools-Devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geotools-devel