[Mapserver-users] Displaying WFS data from a GeoServer/Oracle Spatial server

Thu Feb 12 16:54:17 EST 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
> 