Hello!
I’ve just got a 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:
javax.xml.transform.TransformerException: Translator error
I’ve got a primary Key-Constraint and a spatial Index defined for the oracle table PUBLICTRAFFIC (feature class).
The LOG-File tells me:
21.08.2006 12:32:28 org.geotools.data.jdbc.JDBC1DataStore executeQuery
SCHWERWIEGEND: Error Performing SQL query: SELECT “PK_PTRAFFIC”, “PUBTRAF_ID”, “COUNTRY_ID”, “CAT_ID”, “NETWORK_ID”, “DIR_ID”, “FLOOR_ID”, “CONST_ID”, “FOREIGN_ID”, “FOREIGNKEY”, “MODDATE_A”, “MODOPER_A”, “MODDATE_G”, “MODOPER_G”, “CREATEDATE”, “CREATEOPER”, “GEOM” FROM “PUBLICTRAFFIC” WHERE
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.JDBC1DataStore.executeQuery(JDBC1DataStore.java:897)
at org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore.java:656)
at org.geotools.data.jdbc.JDBCFeatureCollection.reader(JDBCFeatureCollection.java:78)
at org.geotools.data.DefaultFeatureResults.getBounds(DefaultFeatureResults.java:193)
at org.geotools.gml.producer.FeatureTransformer$FeatureTranslator.encode(FeatureTransformer.java:389)
at org.geotools.xml.transform.TransformerBase$XMLReaderSupport.parse(TransformerBase.java:611)
at org.apache.xalan.transformer.TransformerIdentityImpl.transform(TransformerIdentityImpl.java:463)
at org.geotools.xml.transform.TransformerBase$Task.run(TransformerBase.java:293)
at org.geotools.xml.transform.TransformerBase.transform(TransformerBase.java:126)
at org.geotools.xml.transform.TransformerBase.transform(TransformerBase.java:105)
at org.vfny.geoserver.wfs.responses.GML2FeatureResponseDelegate.encode(GML2FeatureResponseDelegate.java:225)
at org.vfny.geoserver.wfs.responses.FeatureResponse.writeTo(FeatureResponse.java:141)
at org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:527)
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)
I ask myself where is the WHERE-clause?
Did I configure something wrong or missed a definition in the config.xml?
Did I forgot something in defining the FeatureType?
A request like
http://localhost/geoserver/wfs?request=GetFeature&version=1.0.0&propertyname=*&featureversion=1&typename=NT18:PUBLICTRAFFIC&featureid=PUBLICTRAFFIC.1515
works great!
Thanks in advance for any help!
Best regards,
Dirk