Hi at all,
If I send a WMS GetFeatuerInfo request to the GeoServer.
http://navi2601:8082/geoserver/wms?bbox=-130,24,-66,50&styles=City&format=jpeg&info_format=text/plain&request=GetFeatureInfo
&layers=XX&query_layers=XX&width=550&height=250&x=170&y=160
I always get the same error message.
<?xml version="1.0" encoding="UTF-8" standalone="no" ?><!DOCTYPE ServiceExceptionReport SYSTEM "http://navi2601:8082/geoserver/schemas//wms/1.1.1/WMS_exception_1_1_1.dtd"> <ServiceExceptionReport version="1.1.1"> <ServiceException code="">Error Performing SQL query: SELECT "LINITEMID", "OBJECT", "ATTTYPE", "ATTVALUE", "NAME" FROM "XX" WHERE </ServiceException> </ServiceExceptionReport>
Perhaps someone can tell me where the error is?
Thank you for your efforts
Nils
Catalina log:
Jul 7, 2006 4:47:55 PM org.vfny.geoserver.util.requests.readers.KvpRequestReader parseKvpSet
FINE: clean request is bbox=-130,24,-66,50&styles=City&format=jpeg&info_format=text/plain&request=GetFeatureInfo&layers=XX&query_layers=XX&width=550&height=250&x=170&y=160
Jul 7, 2006 4:47:55 PM org.vfny.geoserver.util.requests.readers.KvpRequestReader parseKvpSet
FINE: returning parsed {QUERY_LAYERS=XX, LAYERS=XX, BBOX=-130,24,-66,50, HEIGHT=250, Y=160, REQUEST=GetFeatureInfo, STYLES=City, WIDTH=550, INFO_FORMAT=text/plain, FORMAT=jpeg, X=170}
Jul 7, 2006 4:47:55 PM org.vfny.geoserver.servlets.AbstractService init
INFO: Looking for configured service responses' strategy
Jul 7, 2006 4:47:55 PM org.vfny.geoserver.servlets.AbstractService init
INFO: Looking for configured service strategy PARTIAL-BUFFER
Jul 7, 2006 4:47:55 PM org.vfny.geoserver.servlets.AbstractService init
FINE: verifying configured strategy
Jul 7, 2006 4:47:55 PM org.vfny.geoserver.servlets.AbstractService init
INFO: Using service strategy class org.vfny.geoserver.servlets.PartialBufferStrategy
Jul 7, 2006 4:47:55 PM org.vfny.geoserver.servlets.AbstractService init
INFO: Set buffer size to 50
Jul 7, 2006 4:47:55 PM org.vfny.geoserver.servlets.AbstractService doGet
FINE: reading request: bbox=-130,24,-66,50&styles=City&format=jpeg&info_format=text/plain&request=GetFeatureInfo&layers=XX&query_layers=XX&width=550&height=250&x=170&y=160
Jul 7, 2006 4:47:55 PM org.vfny.geoserver.global.Data getFeatureTypeInfo
FINE: getting type XX
Jul 7, 2006 4:47:55 PM org.vfny.geoserver.global.Data getFeatureTypeInfo
FINE: getting type XX
Jul 7, 2006 4:47:55 PM org.vfny.geoserver.servlets.AbstractService doService
INFO: handling request: org.vfny.geoserver.wms.requests.GetFeatureInfoRequest@anonymised.com
Jul 7, 2006 4:47:55 PM org.vfny.geoserver.servlets.AbstractService doService
FINE: strategy is: org.vfny.geoserver.servlets.PartialBufferStrategy@anonymised.com
Jul 7, 2006 4:47:55 PM org.vfny.geoserver.servlets.AbstractService doService
FINE: mime type is: text/plain
Jul 7, 2006 4:47:55 PM org.geotools.filter.SQLEncoderOracle <init>
FINE: SQLEncoderOracle: Geometric Column is: OBJECT
Jul 7, 2006 4:47:55 PM org.geotools.filter.SQLEncoderOracle <init>
FINE: SQLEncoderOracle: Geometric Column is: OBJECT
Jul 7, 2006 4:47:55 PM org.geotools.data.jdbc.JDBC1DataStore constructQuery
FINE: calling sql builder with filter [ POLYGON ((-110.4509090909091 33.568000000000005, -109.98545454545454 33.568000000000005, -109.98545454545454 33.152, -110.4509090909091 33.152, -110.4509090909091 33.568000000000005)) intersects null ]
Jul 7, 2006 4:47:55 PM org.geotools.filter.SQLEncoderOracle doSdoRelate
WARNING: Invalid filter. Cannot have a Geometry filter with only one expression.
Jul 7, 2006 4:47:55 PM org.geotools.data.jdbc.JDBC1DataStore constructQuery
FINE: sql is SELECT "LINITEMID", "OBJECT", "ATTTYPE", "ATTVALUE", "NAME" FROM "XX" WHERE
Jul 7, 2006 4:47:55 PM org.geotools.data.jdbc.JDBC1DataStore executeQuery
FINE: About to execute query: SELECT "LINITEMID", "OBJECT", "ATTTYPE", "ATTVALUE", "NAME" FROM "XX" WHERE
Jul 7, 2006 4:47:55 PM org.geotools.data.jdbc.ConnectionPool getConnection
FINE: Getting available connection.
Jul 7, 2006 4:47:55 PM org.geotools.data.jdbc.JDBC1DataStore executeQuery
SEVERE: Error Performing SQL query: SELECT "LINITEMID", "OBJECT", "ATTTYPE", "ATTVALUE", "NAME" FROM "XX" WHERE
java.sql.SQLException: ORA-00936: missing expression
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:305)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:272)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:626)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:113)
at oracle.jdbc.driver.T4CStatement.execute_for_describe(T4CStatement.java:431)
at oracle.jdbc.driver.OracleStatement.execute_maybe_describe(OracleStatement.java:942)
at oracle.jdbc.driver.T4CStatement.execute_maybe_describe(T4CStatement.java:463)
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:925)
at org.geotools.data.jdbc.JDBC1DataStore.getFeatureReader(JDBC1DataStore.java:684)
at org.geotools.data.jdbc.JDBCFeatureSource$1.reader(JDBCFeatureSource.java:206)
at org.vfny.geoserver.wms.responses.featureInfo.TextFeatureInfoResponse.writeTo(TextFeatureInfoResponse.java:68)
at org.vfny.geoserver.wms.responses.GetFeatureInfoResponse.writeTo(GetFeatureInfoResponse.java:162)
at org.vfny.geoserver.servlets.AbstractService.doService(AbstractService.java:510)
at org.vfny.geoserver.servlets.AbstractService.doGet(AbstractService.java:276)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.vfny.geoserver.wms.servlets.WmsDispatcher.doResponse(WmsDispatcher.java:156)
at org.vfny.geoserver.wms.servlets.WmsDispatcher.doGet(WmsDispatcher.java:115)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.vfny.geoserver.filters.SetCharacterEncodingFilter.doFilter(SetCharacterEncodingFilter.java:122)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:868)
at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:663)
at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
at java.lang.Thread.run(Thread.java:595)
Jul 7, 2006 4:47:55 PM org.geotools.data.jdbc.ConnectionPool$ConnectionListManager connectionClosed
FINE: Connection closed - adding to available connections.
Jul 7, 2006 4:47:55 PM org.vfny.geoserver.wms.responses.GetFeatureInfoResponse abort
FINE: asking delegate for aborting the process
Jul 7, 2006 4:47:55 PM org.vfny.geoserver.servlets.PartialBufferStrategy abort
INFO: OutputStream was successfully aborted.
Jul 7, 2006 4:47:55 PM org.vfny.geoserver.servlets.AbstractService sendError
INFO: Had an undefined error: Error Performing SQL query: SELECT "LINITEMID", "OBJECT", "ATTTYPE", "ATTVALUE", "NAME" FROM "XX" WHERE
--
"Feel free" – 10 GB Mailbox, 100 FreeSMS/Monat ...
Jetzt GMX TopMail testen: http://www.gmx.net/de/go/topmail