Problems with WFS and OracleSpatial

[Fernando Simon]

Hi,
    Looking for the log that you past appeared a strange problem.
    You defined you layer data with the USING UNIQUE parameter, but the
OBJECTID don't appear in the Apache log. This is the log for the request
to a layer that uses UNIQUE? The oraclespatial driver don't execute any
query function without the UNIQUE parameter in your data layer.
    Best regards.

Fernando Simon


José Ramón López wrote:
> Im trying to configure a WFS Server with oraclespatial.
> This is the definition of the layer:
>
> LAYER
>     NAME ferrocarriles
>     TYPE line
>     CONNECTIONTYPE oraclespatial
>     CONNECTION "user/pass at SDE "
>     DATA "SHAPE FROM RED_FERROCARRIL USING UNIQUE OBJECTID VERSION 9i"
>     DUMP TRUE
>     DEBUG ON
>     TRANSPARENCY 0
>     PROJECTION          
>         "init=epsg:23030"
>     END                 
>     CLASS
>         NAME 'Red Ferrocarriles'    
>         COLOR 255 0 255   
>     END 
>     METADATA             
>         "wms_title" "Red Ferrocarriles"
>         "wms_abstract" "Red Ferrocarriles"
>         "wms_keywordlist" "WMS Red Ferrocarriles"
>        
>         "wfs_title"         "Red Ferrocarriles"
>         "gml_featureid"        "OBJECTID"
>         "gml_include_item"    "all"
>     END
> END
>
> When i make a getcapabilities like:
>
> http://192.168.53.18:81/cgi-bin/mapserver?SERVICE=WFS&VERSION=1.1.1&REQUEST=Getcapabilities
> <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
> <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://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
> <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_FERROCARRIL\r
> [error] msOracleSpatialLayerOpen. Shared connection not available.
> Creating one.\r
> [error] msConnPoolRegister(ferrocarrile
> s,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_FERROCARRIL\r
> [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 SDE\r
> [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)\r
>
> Does anybody know what is happening?
>
> Thanxs
>
>
> -- 
> José Ramón López
> Tfno: 627 88 88 24