Oracle DATA problem as WFS

[Fernando Simon]

Hi,
   I believe that the problem is with Mapserver version, I don't know
if the 4.2 and older work, only 4.4 and newer.
   If you are using the 4.4 version you need to define the "unique
column" in your data string. Like: DATA "GEOM FROM (SELECT GEO_COORD_
AS GEOM, GMNR AS ITEM_GEMARKUNG, FLNR AS ITEM_FLUR, FSNR AS
ITEM_FLSTCK, FUNR AS ITEM_NENNER, QUELLE AS QUELLE FROM
FLO.FLO_AL125_AGGREGA_VW) USING UNIQUE "<YOUR PKEY>" SRID 82027".
Where the "<YOUR PKEY>" is your a numeric column that store the
unique identifier for the rows in your table (usually the primary
key).
    Thanks.

----------------------------------------------------
Fernando Simon
Mapserver and Oracle Spatial developer
G10 - Laboratorio de Computacao Aplicada - Brazil
http://g10.cttmar.univali.br - UNIVALI/CTTMAR
----------------------------------------------------

Citando "Uli Rothstein (CCGIS)" <uli.rothstein at CCGIS.DE>:

> Hi,
> we have a problem using MapServer as WFS. The WMS connection works
> fine we
> get a map. The WFS on the same connection returns a nice
> capabilities doc
> but DescribeFeature will not give us a list of features.
>
> <?xml version='1.0' encoding="ISO-8859-1" ?>
> <schema
>     targetNamespace="http://www.ttt.org/myns"
>     xmlns:myns="http://www.ttt.org/myns"
>     xmlns:ogc="http://www.opengis.net/ogc"
>     xmlns:xsd="http://www.w3.org/2001/XMLSchema"
>     xmlns="http://www.w3.org/2001/XMLSchema"
>     xmlns:gml="http://www.opengis.net/gml"
>     elementFormDefault="qualified" version="0.1" >
>
>    <import namespace="http://www.opengis.net/gml"
>            schemaLocation="../gml/2.1.1/feature.xsd" />
>
>    <element name="ALK_WFS"
>             type="myns:ALK_WFS_Type"
>             substitutionGroup="gml:_Feature" />
>
>    <complexType name="ALK_WFS_Type">
>      <complexContent>
>        <extension base="gml:AbstractFeatureType">
>          <sequence>
>
>            <element ref="gml:polygonProperty" minOccurs="0" />
>          </sequence>
>        </extension>
>      </complexContent>
>    </complexType>
>
> </schema>
>
> ---
> This is our MAP file snippet:
>
> LAYER
>     NAME "ALK_WFS"
>     STATUS ON
>     METADATA
>        "WFS_SRS"      "epsg:31467"
>        "WFS_TITLE"    "spatial"
>        "WFS_FEATURE_INFO_MIME_TYPE"     "text/html"
>        "WFS_EXTENT"   "3300000 5400000 3500000 5650000"
>     END
>     CONNECTIONTYPE oraclespatial
>     CONNECTION "*****"
>     DATA "GEO_COORD_ AS GEOM, GMNR AS ITEM_GEMARKUNG, FLNR AS
> ITEM_FLUR,
> FSNR AS ITEM_FLSTCK, FUNR AS ITEM_NENNER, QUELLE AS QUELLE FROM
> FLO.FLO_AL125_AGGREGA_VW USING SRID 82027"
>     TYPE POLYGON
>     DUMP TRUE
>     PROJECTION
>        "init=epsg:31467"
>     END
> END
> ---
>
> We tried several DATA strings, this is one of them:
>
> DATA "GEO_COORD_ FROM (SELECT GMNR AS ITEM_GEMARKUNG, FLNR AS
> ITEM_FLUR,
> FSNR AS ITEM_FLSTCK, FUNR AS ITEM_NENNER, QUELLE AS QUELLE FROM
> FLO.FLO_AL125_AGGREGA_VW) USING SRID 82027"
>
> To no avail. Any ideas?
>
> Best regards,
> Arnulf
>




-------------------------------------------------
  Univali - Webmail - http://webmail.univali.br