[Geoserver-devel] [jira] Created: (GEOS-279) JDBC for shp files?

Message:

  A new issue has been created in JIRA.

---------------------------------------------------------------------
View the issue:
  http://jira.codehaus.org/browse/GEOS-279

Here is an overview of the issue:
---------------------------------------------------------------------
        Key: GEOS-279
    Summary: JDBC for shp files?
       Type: Bug

     Status: Open
   Priority: Major

Original Estimate: Unknown
Time Spent: Unknown
  Remaining: Unknown

    Project: GeoServer
   Fix Fors:
             1.2.5
   Versions:
             1.2.5

   Assignee: Chris Holmes
   Reporter: David Zwiers

    Created: Mon, 7 Feb 2005 2:58 PM
    Updated: Mon, 7 Feb 2005 2:58 PM
Environment: Tomcat 5.0.19 www.refractions.net/geoserver

used a sample shp file (Streams)

Description:
      org.geotools.data.DataSourceException: Could not count
  at org.geotools.data.jdbc.JDBCFeatureSource.count(JDBCFeatureSource.java:410)
  at org.geotools.data.jdbc.JDBCFeatureSource$1.getCount(JDBCFeatureSource.java:225)
  at org.vfny.geoserver.responses.wfs.FeatureResponse.execute(FeatureResponse.java:285)
  at org.vfny.geoserver.responses.wfs.FeatureResponse.execute(FeatureResponse.java:142)
  at org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:362)
  at org.vfny.geoserver.servlets.AbstractService.doPost(AbstractService.java:300)
  at org.vfny.geoserver.servlets.wfs.WfsDispatcher.doResponse(WfsDispatcher.java:245)
  at org.vfny.geoserver.servlets.wfs.WfsDispatcher.doPost(WfsDispatcher.java:134)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:284)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:257)
  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199)
  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184)
  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164)
  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
  at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156)
  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)
  at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206)
  at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833)
  at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732)
  at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619)
  at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688)
  at java.lang.Thread.run(Thread.java:534)
Caused by: org.postgresql.util.PSQLException: An I/O error has occured while flushing the output - Exception: java.net.SocketException: Broken pipe
Stack Trace:

java.net.SocketException: Broken pipe
  at java.net.SocketOutputStream.socketWrite0(Native Method)
  at java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:92)
  at java.net.SocketOutputStream.write(SocketOutputStream.java:136)
  at java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:66)
  at java.io.BufferedOutputStream.flush(BufferedOutputStream.java:124)
  at org.postgresql.core.PGStream.flush(PGStream.java:411)
  at org.postgresql.core.QueryExecutor.sendQueryV3(QueryExecutor.java:337)
  at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:121)
  at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
  at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
  at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
  at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)
  at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:233)
  at org.postgresql.jdbc1.Abstra
ctJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:221)
  at sun.reflect.GeneratedMethodAccessor74.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at java.lang.reflect.Method.invoke(Method.java:324)
  at org.postgresql.jdbc2.optional.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:392)
  at $Proxy1.executeQuery(Unknown Source)
  at org.geotools.data.jdbc.JDBCFeatureSource.count(JDBCFeatureSource.java:399)
  at org.geotools.data.jdbc.JDBCFeatureSource$1.getCount(JDBCFeatureSource.java:225)
  at org.vfny.geoserver.responses.wfs.FeatureResponse.execute(FeatureResponse.java:285)
  at org.vfny.geoserver.responses.wfs.FeatureResponse.execute(FeatureResponse.java:142)
  at org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:362)
  at org.vfny.geoserver.servlets.AbstractService.doPost(AbstractService.java:300)
  at org.vfny.geoserver.servlets.wfs.WfsDispatcher.doResponse(WfsDispatcher.java:245)
  at org.vfny.geoserver.servlets.wfs.WfsDispatcher.doPost(WfsDispatcher.java:134)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:763)
  at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
  at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:284)
  at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:204)
  at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:257)
  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at org.apache.catalina.core.StandardContextValve.invokeInternal(StandardContextValve.java:245)
  at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:199)
  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:184)
  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:164)
  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:149)
  at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:156)
  at org.apache.catalina.core.StandardValveContext.invokeNext(StandardValveContext.java:151)
  at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:567)
  at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:972)
  at org.apache.coyote.tomcat5.CoyoteAdapter.service(CoyoteAdapter.java:206)
  at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:833)
  at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processConnection(Http11Protocol.java:732)
  at org.apache.tomcat.util.net.TcpWorkerThread.runIt(PoolTcpEndpoint.java:619)
  at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:688)
  at java.lang.Thread.run(Thread.java:534)
End of Stack Trace

  at org.postgresql.core.PGStream.flush(PGStream.java:415)
  at org.postgresql.core.QueryExecutor.sendQueryV3(QueryExecutor.java:337)
  at org.postgresql.core.QueryExecutor.executeV3(QueryExecutor.java:121)
  at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:100)
  at org.postgresql.core.QueryExecutor.execute(QueryExecutor.java:43)
  at org.postgresql.jdbc1.AbstractJdbc1Statement.execute(AbstractJdbc1Statement.java:517)
  at org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Statement.java:50)
  at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:233)
  at org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statement.java:221)
  at sun.reflect.GeneratedMethodAccessor74.invoke(Unknown Source)
  at sun.reflect.DelegatingMethodAcces
sorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
  at java.lang.reflect.Method.invoke(Method.java:324)
  at org.postgresql.jdbc2.optional.PooledConnectionImpl$StatementHandler.invoke(PooledConnectionImpl.java:392)
  at $Proxy1.executeQuery(Unknown Source)
  at org.geotools.data.jdbc.JDBCFeatureSource.count(JDBCFeatureSource.java:399)
  ... 33 more

---------------------------------------------------------------------
JIRA INFORMATION:
This message is automatically generated by JIRA.

If you think it was sent incorrectly contact one of the administrators:
   http://jira.codehaus.org/secure/Administrators.jspa

If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira