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 "ferrocarriles"TYPE
LINESTATUS ONDUMP TRUEDEBUG ONCONNECTIONTYPE oraclespatial
> CONNECTION "user/pass at SDE"DATA "SHAPE FROM RED_FERROCARRIL
USING VERSION
9i"PROJECTION          
       
"init=EPSG:4326"ENDMETADATA   
"wfs_title"       
        "Ferrocarriles"
>     "gml_featureid"   
     "OBJECTID"   
"gml_include_items"    
"all"   
ENDCLASS        NAME
"ferrocarriles"       
STYLE               
COLOR 200 255 0
>         ENDENDEND  # layerWhen i
make a getcapabilities like:
> 
>
http://192.168.53.18:81/cgi-bin/mapserver?SERVICE=WFS&VERSION=1.1.1&REQUEST=Getcapabilities
> 
> it shows me 
> 
> <FeatureType>
> <Name>ferrocarriles</Name>
> <Title>ferrocarriles</Title>
> <SRS>EPSG:4326</SRS>
> <LatLongBoundingBox minx="195210"
miny="4.07581e+006" maxx="533545"
maxy="4.26175e+006"/>
> </FeatureType>But if i make a
getfeature:http://192.168.53.18:81/cgi-bin/mapserver?service=WFS&version=1.0.0&request=getfeature&typename=ferrocarriles
> <wfs:FeatureCollection
xsi:schemaLocation="http://www.opengis.net/wfs
http://schemas.opengis.net/wfs/1.0.0/WFS-basic.xsd
>
                        
http://mapserver.gis.umn.edu/mapserver 
>
http://localhost:81/cgi-bin/mapserver?service=WFS&SERVICE=WFS&VERSION=1.0.0&REQUEST=DescribeFeatureType&TYPENAME=ferrocarriles&OUTPUTFORMAT=XMLSCHEMA">−   
<gml:boundedBy>
> −    <gml:Box
srsName="EPSG:4326">−   
<gml:coordinates>195210.088989,4075810.305023
533545.363841,4261747.980489</gml:coordinates></gml:Box></gml:boundedBy>
> </wfs:FeatureCollection>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
> 
>