Hello again!
I’ve just got another problem concerning “wfsGetFeature”-Request in Geoserver 1.3.3.
When I’m trying to request the Feature Infos from an Oracle-FeatureType (PUBLICTRAFFIC) I’m getting the following error message:
org.geotools.data.DataSourceException: Could not count
The LOG-File tells me:
cause: org.geotools.data.DataSourceException: Could not count
22.08.2006 09:44:21 org.vfny.geoserver.ServiceException getXmlResponse
WARNUNG: encountered error: org.geotools.data.DataSourceException: Could not count
StackTrace: org.geotools.data.DataSourceException: Could not count
at org.geotools.data.jdbc.JDBCFeatureSource.count(JDBCFeatureSource.java:336)
at org.geotools.data.jdbc.JDBCFeatureCollection.getCount(JDBCFeatureCollection.java:101)
at org.vfny.geoserver.wfs.responses.FeatureResponse.execute(FeatureResponse.java:327)
at org.vfny.geoserver.wfs.responses.FeatureResponse.execute(FeatureResponse.java:156)
at org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:452)
at org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:279)
at org.vfny.geoserver.wfs.servlets.WfsDispatcher.doResponse(WfsDispatcher.java:284)
at org.vfny.geoserver.wfs.servlets.WfsDispatcher.doGet(WfsDispatcher.java:213)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:358)
at org.mortbay.jetty.servlet.WebApplicationHandler$Chain.doFilter(WebApplicationHandler.java:342)
at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:122)
at org.mortbay.jetty.servlet.WebApplicationHandler$Chain.doFilter(WebApplicationHandler.java:334)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:286)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:567)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1807)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:525)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1757)
at org.mortbay.http.HttpServer.service(HttpServer.java:879)
at org.mortbay.http.HttpConnection.service(HttpConnection.java:790)
at org.mortbay.http.HttpConnection.handleNext(HttpConnection.java:961)
at org.mortbay.http.HttpConnection.handle(HttpConnection.java:807)
at org.mortbay.http.SocketListener.handleConnection(SocketListener.java:197)
at org.mortbay.util.ThreadedServer.handle(ThreadedServer.java:276)
at org.mortbay.util.ThreadPool$PoolThread.run(ThreadPool.java:511)
Caused by: java.sql.SQLException: ORA-00921: unexpected end of SQL command
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:681)
at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:614)
at oracle.jdbc.driver.T2CStatement.execute_for_describe(T2CStatement.java:841)
at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:942)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1037)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1183)
at org.geotools.data.jdbc.JDBCFeatureSource.count(JDBCFeatureSource.java:325)
… 25 more
22.08.2006 09:44:22 org.vfny.geoserver.ServiceException getXmlResponse
FEIN: return wfs exception is <?xml version="1.0" ?>
org.geotools.data.DataSourceException: Could not count
at org.geotools.data.jdbc.JDBCFeatureSource.count(JDBCFeatureSource.java:336)
at org.geotools.data.jdbc.JDBCFeatureCollection.getCount(JDBCFeatureCollection.java:101)
at org.vfny.geoserver.wfs.responses.FeatureResponse.execute(FeatureResponse.java:327)
at org.vfny.geoserver.wfs.responses.FeatureResponse.execute(FeatureResponse.java:156)
at org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:452)
at org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:279)
at org.vfny.geoserver.wfs.servlets.WfsDispatcher.doResponse(WfsDispatcher.java:284)
at org.vfny.geoserver.wfs.servlets.WfsDispatcher.doGet(WfsDispatcher.java:213)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at org.mortbay.jetty.servlet.ServletHolder.handle(ServletHolder.java:358)
at org.mortbay.jetty.servlet.WebApplicationHandler$Chain.doFilter(WebApplicationHandler.java:342)
at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:122)
at org.mortbay.jetty.servlet.WebApplicationHandler$Chain.doFilter(WebApplicationHandler.java:334)
at org.mortbay.jetty.servlet.WebApplicationHandler.dispatch(WebApplicationHandler.java:286)
at org.mortbay.jetty.servlet.ServletHandler.handle(ServletHandler.java:567)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1807)
at org.mortbay.jetty.servlet.WebApplicationContext.handle(WebApplicationContext.java:525)
at org.mortbay.http.HttpContext.handle(HttpContext.java:1757)
at org.mortbay.http.HttpServer.service(HttpServer.jav2.08.2006 09:44:20 org.vfny.geoserver.servlets.AbstractService init
INFO: Looking for configured service strategy PARTIAL-BUFFER
22.08.2006 09:44:20 org.vfny.geoserver.servlets.AbstractService init
INFO: Using service strategy class org.vfny.geoserver.servlets.PartialBufferStrategy
22.08.2006 09:44:20 org.vfny.geoserver.servlets.AbstractService init
INFO: Set buffer size to 50
22.08.2006 09:44:21 org.vfny.geoserver.servlets.AbstractService doService
INFO: handling request:
Request: null
output format:GML2
max features:2147483647
version:
I read something about “too much open cursors” from MapServer to Oracle. Is there anything solved or is the problem still existing? Or is it another problem?
Any help is greatly appreciated.