On Fri, May 27, 2011 at 4:48 AM, Gerson Galang <[email protected]> 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 ------------------------------------------------------- ------------------------------------------------------------------------------ vRanger cuts backup time in half-while increasing security. With the market-leading solution for virtual backup and recovery, you get blazing-fast, flexible, and affordable data protection. Download your free trial now. http://p.sf.net/sfu/quest-d2dcopy1 _______________________________________________ Geotools-gt2-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/geotools-gt2-users
