Problems with WFS and OracleSpatial

[José Ramón López]

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

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_FERROCARRIL\r
[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_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
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapserver-users/attachments/20061204/a7965068/attachment.html