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