WFS Problems

[Bart van den Eijnden (OSGIS)]

Your DATA statement is missing the USING UNIQUE clause.

See the Mapserver Oracle Spatial Howto on the website for details.

Best regards,
Bart

--
Bart van den Eijnden
OSGIS, Open Source GIS
http://www.osgis.nl


--------- Oorspronkelijk bericht --------
Van: José Ramón López <joseramonlopez at GMAIL.COM>
Naar: MAPSERVER-USERS at LISTS.UMN.EDU <MAPSERVER-USERS at LISTS.UMN.EDU>
Onderwerp: [UMN_MAPSERVER-USERS] WFS Problems
Datum: 29/11/06 07:32

> Hello again.Im trying to configure a WFS Server with oraclespatial.This is
the definition of the layer:LAYERNAME &quot;ferrocarriles&quot;TYPE
LINESTATUS ONDUMP TRUEDEBUG ONCONNECTIONTYPE oraclespatial
> CONNECTION &quot;user/pass at SDE&quot;DATA &quot;SHAPE FROM RED_FERROCARRIL
USING VERSION
9i&quot;PROJECTION&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&quot;init=EPSG:4326&quot;ENDMETADATA&nbsp;&nbsp;&nbsp;
&quot;wfs_title&quot;&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp; &nbsp;&nbsp;&nbsp; &quot;Ferrocarriles&quot;
> &nbsp;&nbsp;&nbsp; &quot;gml_featureid&quot;&nbsp;&nbsp;&nbsp;
&nbsp;&nbsp;&nbsp;&nbsp; &quot;OBJECTID&quot;&nbsp;&nbsp;&nbsp;
&quot;gml_include_items&quot; &nbsp;&nbsp;&nbsp;
&quot;all&quot;&nbsp;&nbsp;&nbsp;
ENDCLASS&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; NAME
&quot;ferrocarriles&quot;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
STYLE&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
COLOR 200 255 0
> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; ENDENDEND&nbsp; # layerWhen i
make a getcapabilities like:
> 
>
http://192.168.53.18:81/cgi-bin/mapserver?SERVICE=WFS&amp;VERSION=1.1.1&amp;REQUEST=Getcapabilities
> 
> it shows me 
> 
> &lt;FeatureType&gt;
> &lt;Name&gt;ferrocarriles&lt;/Name&gt;
> &lt;Title&gt;ferrocarriles&lt;/Title&gt;
> &lt;SRS&gt;EPSG:4326&lt;/SRS&gt;
> &lt;LatLongBoundingBox minx=&quot;195210&quot;
miny=&quot;4.07581e+006&quot; maxx=&quot;533545&quot;
maxy=&quot;4.26175e+006&quot;/&gt;
> &lt;/FeatureType&gt;But if i make a
getfeature:http://192.168.53.18:81/cgi-bin/mapserver?service=WFS&amp;version=1.0.0&amp;request=getfeature&amp;typename=ferrocarriles
> &lt;wfs:FeatureCollection
xsi:schemaLocation=&quot;http://www.opengis.net/wfs
http://schemas.opengis.net/wfs/1.0.0/WFS-basic.xsd
>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
http://mapserver.gis.umn.edu/mapserver 
>
http://localhost:81/cgi-bin/mapserver?service=WFS&amp;SERVICE=WFS&amp;VERSION=1.0.0&amp;REQUEST=DescribeFeatureType&amp;TYPENAME=ferrocarriles&amp;OUTPUTFORMAT=XMLSCHEMA&quot;&gt;&minus;&nbsp;&nbsp;&nbsp;
&lt;gml:boundedBy&gt;
> &minus;&nbsp;&nbsp;&nbsp; &lt;gml:Box
srsName=&quot;EPSG:4326&quot;&gt;&minus;&nbsp;&nbsp;&nbsp;
&lt;gml:coordinates&gt;195210.088989,4075810.305023
533545.363841,4261747.980489&lt;/gml:coordinates&gt;&lt;/gml:Box&gt;&lt;/gml:boundedBy&gt;
> &lt;/wfs:FeatureCollection&gt;With some clients, like udig or gvsig i can
connect to wfs, but i cant get info.In apache´s error.log[error]
msOracleSpatialLayerOpen called with: SHAPE FROM RED_FERROCARRILr
> [error] msOracleSpatialLayerOpen. Shared connection not available.
Creating one.r[error]
msConnPoolRegister(ferrocarriles,user/pass at SDE,0173D7E0)r[error]
msOracleSpatialLayerFreeItemInfo was called.r[error]
msOracleSpatialLayerWhichShapes was called.r
> [error] msOracleSpatialLayerWhichShapes. Using this Sql to retrieve the
data: SELECT rownum, SHAPE FROM RED_FERROCARRIL WHERE SDO_FILTER( SHAPE,
MDSYS.SDO_GEOMETRY(2003, NULL, NULL,MDSYS.SDO_ELEM_INFO_ARRAY(1,1003,3),
> MDSYS.SDO_ORDINATE_ARRAY(195210,4075810,533545,4261747)
),'querytype=window') = 'TRUE'r[error] msOracleSpatialLayerFreeItemInfo was
called.r[error] msOracleSpatialLayerClose was called. Layer connection:
user/pass at SDE
> r[error] msOracleSpatialLayerClose. Cleaning layerinfo handlers.r[error]
msOracleSpatialLayerClose. Cleaning Oracle handlers.r[error]
msConnPoolRelease(ferrocarriles,user/pass at SDE,0173D7E0)r[error]
msConnPoolClose(
> user/pass at SDE,0173D7E0)r[error] msOracleSpatialLayerOpen called with:
SHAPE FROM RED_FERROCARRILr[error] msOracleSpatialLayerOpen. Shared
connection not available. Creating one.r[error]
msConnPoolRegister(ferrocarriles,
> user/pass at SDE,0179A3F0)r[error] msOracleSpatialLayerFreeItemInfo was
called.r[error] msOracleSpatialLayerGetItems was called.r[error]
msOracleSpatialLayerInitItemInfo was called.r[error]
msOracleSpatialLayerGetShape was called. Using the record = 1.r
> [error] msOracleSpatialLayerClose was called. Layer connection:
user/pass at SDEr[error] msOracleSpatialLayerClose. Cleaning layerinfo
handlers.r[error] msOracleSpatialLayerClose. Cleaning Oracle handlers.r
> [error] msConnPoolRelease(ferrocarriles,user/pass at SDE,0179A3F0)r[error]
msConnPoolClose(user/pass at SDE,0179A3F0)rDoes anybody know what is
happening?Thanxs-- José Ramón López
> Tfno: 627 88 88 24
> 
>