Menu
▾
▴
Re: [Geotools-gt2-users] SocketException being thrown after a number of consecutive PostGIS queries
|
From: Andrea A. <and...@ge...> - 2011-05-27 06:53:07
|
On Fri, May 27, 2011 at 4:48 AM, Gerson Galang <ger...@gm...> wrote: > Hi again, > > I've written a portlet that needs to perform a number of PostGIS queries > per http request. There are times when the query just wouldn't work. > Whenever the query fails, I get this on the log file... My guess is that your postgis is setup to drop the connections to the client after a certain timeout. The best thing would be to enable the connection validation in the params, the connection pool with then first send a fast query (normally getting the current date) to check if the connection is still valid before giving it back to the code in the data store 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 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 ------------------------------------------------------- |
