Menu
▾
▴
Re: [Geotools-devel] JDBC stores: switching connettion validation on by default?
|
From: <chr...@nv...> - 2012-02-16 08:51:44
|
+1, full ack to the arguments of Andrea and Justin Zitat von Justin Deoliveira <jde...@op...>: > +1, I agree that typically the performance overhead is negligible. Having > it on by default and leaving the option for advanced users to turn off > seems safer than having it off by default and forcing all classes of users > to deal with the consequences. > > On Wed, Feb 15, 2012 at 12:51 PM, Andrea Aime > <and...@ge...>wrote: > >> Hi, >> most JDBC stores have the ability to validate a connection before using it, >> in order to check if the dbms or some network condition closed the >> connection >> in face of the pool. >> >> Right now the validation if off by default, and that results is several >> reports >> from people that are not familiar with the usage of a long lived >> connection pool. >> >> I would like to turn connection validation on by default in all dabases to >> avoid the above >> reports: the performance penalty is normally small, we avoid the useless >> reports >> and people that are familiar with a connection pool usage can decide >> whether >> they want to disable it or not (e.g., say for example the database is >> sitting on the >> same machine as the client software and no connection timeouts). >> >> Opinions? >> >> Cheers >> Andrea >> >> -- >> ------------------------------------------------------- >> Ing. Andrea Aime >> GeoSolutions S.A.S. >> Tech lead >> >> Via Poggio alle Viti 1187 >> 55054 Massarosa (LU) >> Italy >> >> phone: +39 0584 962313 >> fax: +39 0584 962313 >> mob: +39 339 8844549 >> >> http://www.geo-solutions.it >> http://geo-solutions.blogspot.com/ >> http://www.youtube.com/user/GeoSolutionsIT >> http://www.linkedin.com/in/andreaaime >> http://twitter.com/geowolf >> >> ------------------------------------------------------- >> >> >> ------------------------------------------------------------------------------ >> Virtualization & Cloud Management Using Capacity Planning >> Cloud computing makes use of virtualization - but cloud computing >> also focuses on allowing computing to be delivered as a service. >> http://www.accelacomm.com/jaw/sfnl/114/51521223/ >> _______________________________________________ >> GeoTools-Devel mailing list >> Geo...@li... >> https://lists.sourceforge.net/lists/listinfo/geotools-devel >> >> > > > -- > Justin Deoliveira > OpenGeo - http://opengeo.org > Enterprise support for open source geospatial. > ---------------------------------------------------------------- This message was sent using IMP, the Internet Messaging Program. |