Im trying to configure a WFS Server with oraclespatial.<br>This is the definition of the layer:<br><br>LAYER<br>    NAME ferrocarriles<br>    TYPE line<br>    CONNECTIONTYPE oraclespatial<br>    CONNECTION "user/pass@SDE
"<br>    DATA "SHAPE FROM RED_FERROCARRIL USING UNIQUE OBJECTID VERSION 9i"<br>    DUMP TRUE<br>    DEBUG ON<br>    TRANSPARENCY 0<br>    PROJECTION           <br>        "init=epsg:23030"<br>    END                  
<br>    CLASS <br>        NAME 'Red Ferrocarriles'     <br>        COLOR 255 0 255    <br>    END  <br>    METADATA              <br>        "wms_title" "Red Ferrocarriles"<br>        "wms_abstract" "Red Ferrocarriles"
<br>        "wms_keywordlist" "WMS Red Ferrocarriles"<br>        <br>        "wfs_title"         "Red Ferrocarriles"<br>        "gml_featureid"        "OBJECTID"
<br>        "gml_include_item"    "all"<br>    END<br>END<br><br>When i make a getcapabilities like:<br>
<br>
<a href="http://192.168.53.18:81/cgi-bin/mapserver?SERVICE=WFS&VERSION=1.1.1&REQUEST=Getcapabilities" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://192.168.53.18:81/cgi-bin/mapserver?SERVICE=WFS&VERSION=1.1.1&REQUEST=Getcapabilities
</a><br>
<br>
it shows me <br>
<br>
<FeatureType><br>
<Name>ferrocarriles</Name><br>
<Title>ferrocarriles</Title><br>
<SRS>EPSG:4326</SRS><br>
<LatLongBoundingBox minx="195210" miny="4.07581e+006" maxx="533545" maxy="4.26175e+006"/><br>
</FeatureType><br><br>But if i make a getfeature:<br><a href="http://192.168.53.18:81/cgi-bin/mapserver?service=WFS&version=1.0.0&request=getfeature&typename=ferrocarriles" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://192.168.53.18:81/cgi-bin/mapserver?service=WFS&version=1.0.0&request=getfeature&typename=ferrocarriles
</a><br><br><wfs:FeatureCollection xsi:schemaLocation="<a href="http://www.opengis.net/wfs" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://www.opengis.net/wfs</a> <a href="http://schemas.opengis.net/wfs/1.0.0/WFS-basic.xsd" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">
http://schemas.opengis.net/wfs/1.0.0/WFS-basic.xsd
</a>                         <a href="http://mapserver.gis.umn.edu/mapserver" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">http://mapserver.gis.umn.edu/mapserver</a> <a href="http://localhost:81/cgi-bin/mapserver?service=WFS&SERVICE=WFS&VERSION=1.0.0&REQUEST=DescribeFeatureType&TYPENAME=ferrocarriles&OUTPUTFORMAT=XMLSCHEMA" target="_blank" onclick="return top.js.OpenExtLink(window,event,this)">

http://localhost:81/cgi-bin/mapserver?service=WFS&SERVICE=WFS&VERSION=1.0.0&REQUEST=DescribeFeatureType&TYPENAME=ferrocarriles&OUTPUTFORMAT=XMLSCHEMA</a>"><br>−<br>    <gml:boundedBy><br>

−<br>    <gml:Box srsName="EPSG:4326"><br>−<br>    <gml:coordinates><br>195210.088989,4075810.305023 533545.363841,4261747.980489<br></gml:coordinates><br></gml:Box><br></gml:boundedBy>
<br></wfs:FeatureCollection><br><br>With some clients, like udig or gvsig i can connect to wfs, but i cant get info.<br><br>In apache´s error.log<br><br>[error] msOracleSpatialLayerOpen called with: SHAPE FROM RED_FERROCARRIL\r
<br>[error] msOracleSpatialLayerOpen. Shared connection not available. Creating one.\r<br>[error] msConnPoolRegister(ferrocarrile<div id="mb_0">s,user/pass@SDE,0173D7E0)\r<br>[error] msOracleSpatialLayerFreeItemInfo was called.\r
<br>[error] msOracleSpatialLayerWhichShapes was called.\r
<br>[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<br>[error] msOracleSpatialLayerFreeItemInfo was called.\r<br>[error] msOracleSpatialLayerClose was called. Layer connection: user/pass@SDE
\r<br>[error] msOracleSpatialLayerClose. Cleaning layerinfo handlers.\r<br>[error] msOracleSpatialLayerClose. Cleaning Oracle handlers.\r<br>[error] msConnPoolRelease(ferrocarriles,user/pass@SDE,0173D7E0)\r<br>[error] msConnPoolClose(
user/pass@SDE,0173D7E0)\r<br>[error] msOracleSpatialLayerOpen called with: SHAPE FROM RED_FERROCARRIL\r<br>[error] msOracleSpatialLayerOpen. Shared connection not available. Creating one.\r<br>[error] msConnPoolRegister(ferrocarriles,
user/pass@SDE,0179A3F0)\r<br>[error] msOracleSpatialLayerFreeItemInfo was called.\r<br>[error] msOracleSpatialLayerGetItems was called.\r<br>[error] msOracleSpatialLayerInitItemInfo was called.\r<br>[error] msOracleSpatialLayerGetShape was called. Using the record = 1.\r
<br>[error] msOracleSpatialLayerClose was called. Layer connection: user/pass@SDE\r<br>[error] msOracleSpatialLayerClose. Cleaning layerinfo handlers.\r<br>[error] msOracleSpatialLayerClose. Cleaning Oracle handlers.\r<br>

[error] msConnPoolRelease(ferrocarriles,user/pass@SDE,0179A3F0)\r<br>[error] msConnPoolClose(user/pass@SDE,0179A3F0)\r<br><br>Does anybody know what is happening?<br><br>Thanxs<br clear="all"><span class="sg"><br></span>
</div><br>-- <br>José Ramón López<br>Tfno: 627 88 88 24