[Mapserver-users] Displaying WFS data from a GeoServer/Oracle Spatial server
Kralidis,Tom [Burlington]
Tom.Kralidis at ec.gc.ca
Thu Feb 12 13:54:17 PST 2004
Are you sure you (or MapServer) are passing that exact query to the WFS?
You may want to see what the web log records as a request on their side.
..Tom
> -----Original Message-----
> From: Jeff McKenna [mailto:jmckenna at dmsolutions.ca]
> Sent: Thursday, February 12, 2004 2:58 PM
> To: mapserver-users at lists.gis.umn.edu
> Subject: [Mapserver-users] Displaying WFS data from a
> GeoServer/OracleSpatial server
>
>
> (with a subject line, sorry)
> -----
>
> Hello,
>
> I am trying to view a WFS layer in MapServer from a server
> that is publishing their data using GeoServer (and they are
> storing their data in Oracle). When I try their GetFeature
> request in a browser valid GML is returned
> (http://aadc-maps.aad.gov.au/geoserver/wfs?VERSION=1.0.0&REQUE
ST=GetFeature&TYPENAME=topp:ICEBERG_PY).
> I have verified that the GML is valid with the ogrinfo
> utility, as well as converting the GML to a shapefile using
> the OGR2OGR utility...it looks good. But when I try to
> access the layer with MapServer I get a lovely MapServer
> error: [MapServer Error]: msWFSLayerWhichShapes(): WFS
> request produced unexpected output (junk?) for layer aad_wfs
>
> In my IMAGEPATH directory the GML file that is produced looks
> like this:
>
> <?xml version="1.0" ?>
> <ServiceExceptionReport
> version="1.2.0"
> xmlns="http://www.opengis.net/ogc"
> xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> xsi:schemaLocation="http://www.opengis.net/ogc
> http://localhost:8080/geoserver/data/capabilities/wfs/1.0.0/OG
> C-exception.xsd">
> <ServiceException>
> problem with FeatureResults:
> org.geotools.data.DataSourceException: Could not count
> at
> org.geotools.data.jdbc.JDBCFeatureSource.count(JDBCFeatureSour
> ce.java:402)
> at
> org.geotools.data.jdbc.JDBCFeatureSource$1.getCount(JDBCFeatur
> eSource.java:218)
> at
> org.vfny.geoserver.responses.wfs.FeatureResponse.execute(Featu
> reResponse.java:307)
> at
> org.vfny.geoserver.responses.wfs.FeatureResponse.execute(Featu
> reResponse.java:193)
> at
> org.vfny.geoserver.servlets.AbstractService.doService(Abstract
> Service.java:295)
> at
> org.vfny.geoserver.servlets.AbstractService.doGet(AbstractServ
> ice.java:202)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at
> org.vfny.geoserver.servlets.wfs.WfsDispatcher.doResponse(WfsDi
> spatcher.java:172)
> at
> org.vfny.geoserver.servlets.wfs.WfsDispatcher.doGet(WfsDispatc
> her.java:123)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
> at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
> at jrun.servlet.ServletInvoker.invoke(ServletInvoker.java:91)
> at
> jrun.servlet.JRunInvokerChain.invokeNext(JRunInvokerChain.java:42)
> at
> jrun.servlet.JRunRequestDispatcher.invoke(JRunRequestDispatche
> r.java:252)
> at
> jrun.servlet.ServletEngineService.dispatch(ServletEngineServic
> e.java:527)
> at
> jrun.servlet.http.WebService.invokeRunnable(WebService.java:168)
> at
> jrunx.scheduler.ThreadPool$ThreadThrottle.invokeRunnable(Threa
dPool.java:451)
> at jrunx.scheduler.WorkerThread.run(WorkerThread.java:66)
> Caused by: java.sql.SQLException: ORA-00921: unexpected end
> of SQL command
>
> at
> oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
> at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:289)
> at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:579)
> at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1894)
> at
> oracle.jdbc.ttc7.TTC7Protocol.parseExecuteDescribe(TTC7Protoco
> l.java:831)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatem
> ent.java:2496)
> at
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Oracle
> Statement.java:2840)
> at
> oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatemen
> t.java:623)
> at
> org.geotools.data.jdbc.JDBCFeatureSource.count(JDBCFeatureSour
> ce.java:391)
> ... 18 more
> </ServiceException>
> </ServiceExceptionReport>
>
> The mapfile that I'm using is as follows:
>
>
> NAME AAD_WFS
> STATUS ON
> SIZE 400 300
> SYMBOLSET ./etc/symbols.sym
> EXTENT 60 -90 160 0
> UNITS DD
> #SHAPEPATH "C:/GCRC/data/antarctica/scale0/st17_20"
> IMAGECOLOR 255 255 255
> FONTSET ./etc/fonts.txt
>
> WEB
> IMAGEPATH "c:/tmp/ms_tmp/"
> IMAGEURL "c:/ms_tmp/"
> METADATA
> END
> LOG "c:/GCRC/www/add-demo/htdocs/ms_error.txt"
> END
>
> PROJECTION
> "init=epsg:4326"
> END
>
>
> LAYER
> NAME "aad_wfs"
> TYPE POLYGON
> CONNECTIONTYPE WFS
> CONNECTION
> "http://aadc-maps.aad.gov.au/geoserver/wfs?VERSION=1.0.0&REQUE
ST=GetFeature&TYPENAME=topp:ICEBERG_PY"
> PROJECTION
> "init=epsg:8307"
> END
> METADATA
> "wfs_connectiontimeout" "60"
> "wfs_latlonboundingbox" "60 -90 160 0"
> END
> STATUS ON
> DEBUG TRUE
> CLASS
> NAME "test"
> COLOR 255 0 0
> END
> END
>
> The WFS server in question is actually the Australian
> Antarctic Division (AAD), and we are trying to make their
> data available to other partners around the world. Is it
> something on their side that is causing MapServer to blow up??
> From a GetCapabilities request we can see that the data is in
> 8307 EPSG, which is not included in the standard EPSG
> file....and I think that 8307 is the same as generic
> lat/long....so I added an 8307 code in my EPSG file with the
> same params as 4326 (is this the problem???).
>
> More questions: from comparing the GML returned in the
> browser with other valid GML that MapServer CAN display we've
> noticed that the AAD server GML states <gml:Box
> srsName="http://www.opengis.net/gml/srs/epsg.xml#8307">
> whereas others say <gml:Box srsName="EPSG:9810">...is
> MapServer having a problem with that URL????
>
> Any help is greatly appreciated.
>
> jeff
>
>
>
> ---
> Jeff McKenna
> Research Assistant
> Geomatics and Cartographic Research Centre
> Carleton University
> Ottawa, ON
> Canada
>
>
>
>
>
>
>
> _______________________________________________
> Mapserver-users mailing list
> Mapserver-users at lists.gis.umn.edu
> http://lists.gis.umn.edu/mailman/listinfo/maps> erver-users
>
More information about the MapServer-users
mailing list