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...
02:09:31,760 ERROR [jsp:154] java.net.SocketException: Socket closed
at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:99)
at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
at
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
at org.postgresql.core.PGStream.flush(PGStream.java:508)
at
org.postgresql.core.v3.QueryExecutorImpl.sendSync(QueryExecutorImpl.java:1107)
at
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:256)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:479)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdbc2Statement.java:353)
at
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2Statement.java:252)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
org.apache.commons.dbcp.DelegatingStatement.executeQuery(DelegatingStatement.java:208)
at
org.geotools.jdbc.JDBCFeatureReader.<init>(JDBCFeatureReader.java:147)
at
org.geotools.jdbc.JDBCFeatureSource.getReaderInternal(JDBCFeatureSource.java:557)
at
org.geotools.jdbc.JDBCFeatureStore.getReaderInternal(JDBCFeatureStore.java:209)
at
org.geotools.data.store.ContentFeatureSource.getReader(ContentFeatureSource.java:483)
at
org.geotools.data.store.ContentFeatureCollection.features(ContentFeatureCollection.java:209)
at
org.geotools.data.store.ContentFeatureCollection.features(ContentFeatureCollection.java:62)
at au.org.aurin.util.LocationUtil.getLGAs(LocationUtil.java:149)
at
au.org.aurin.portlets.LocationPickerPortlet.doView(LocationPickerPortlet.java:105)
I had a look at my postgresql logs as well and found this whenever the
exception above is thrown..
2011-05-27 12:07:34 EST ERROR: relation "gt_pk_metadata" does not exist
at character 15
2011-05-27 12:07:34 EST STATEMENT: SELECT * FROM GT_PK_METADATA
2011-05-27 12:07:42 EST ERROR: relation "gt_pk_metadata" does not exist
at character 15
2011-05-27 12:07:42 EST STATEMENT: SELECT * FROM GT_PK_METADATA
2011-05-27 12:07:59 EST LOG: unexpected EOF on client connection
2011-05-27 12:07:59 EST LOG: unexpected EOF on client connection
2011-05-27 12:07:59 EST LOG: unexpected EOF on client connection
2011-05-27 12:07:59 EST LOG: unexpected EOF on client connection
2011-05-27 12:07:59 EST LOG: unexpected EOF on client connection
2011-05-27 12:08:39 EST ERROR: relation "gt_pk_metadata" does not exist
at character 15
2011-05-27 12:08:39 EST STATEMENT: SELECT * FROM GT_PK_METADATA
2011-05-27 12:08:41 EST LOG: unexpected EOF on client connection
2011-05-27 12:09:12 EST LOG: unexpected EOF on client connection
2011-05-27 12:09:12 EST LOG: unexpected EOF on client connection
2011-05-27 12:10:01 EST ERROR: relation "gt_pk_metadata" does not exist
at character 15
2011-05-27 12:10:01 EST STATEMENT: SELECT * FROM GT_PK_METADATA
2011-05-27 12:10:03 EST LOG: unexpected EOF on client connection
Any ideas?
I'm not sure if I should send this message to the PostGIS mailing list
or just geotools, but I'll try it here first.
Thanks,
Gerson
------------------------------------------------------------------------------
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
