Oracle Wfs getfeature CRASH

Wed Dec 21 04:21:20 EST 2005

I think Huub Fleuren ran into this also before you 1 or 2 months ago. You
could check the archives.

IIRC, you need to use the following:

DATA "GEOM FROM (SELECT * FROM AL_L_GEBAEUDENUMMER) USING UNIQUE FID"

Best regards,
Bart

-----Oorspronkelijk bericht-----
Van: UMN MapServer Users List
[mailto:MAPSERVER-USERS at LISTS.UMN.EDU]Namens Jan Espenlaub
Verzonden: woensdag 21 december 2005 8:17
Aan: MAPSERVER-USERS at LISTS.UMN.EDU
Onderwerp: [UMN_MAPSERVER-USERS] Oracle Wfs getfeature CRASH

Hello list!

After a few days of meddling I am desperate enough to bother you with my
problems.

I 'm trying to set up Mapserver (version 4.6.0 WindowsServer 2003) as a
WMS/ and WFS server
with data coming from an Oracle Database

- The mapfile is working (nice map if I call it from the url with
mode=map&layer=hausnummer)
- WMS works fine (both: getmap and getcapabilities)
- WFS getcapabilities returns an XML which looks OK (that is: my defined
layer shows up):

<?xml version="1.0" encoding="ISO-8859-1" ?>
- <#> <WFS_Capabilities version="*1.0.0*" updateSequence="*0*"
xmlns="*http://www.opengis.net/wfs*"
xmlns:ogc="*http://www.opengis.net/ogc*"
xmlns:xsi="*http://www.w3.org/2001/XMLSchema-instance*"
xsi:schemaLocation="*http://www.opengis.net/wfs
http://schemas.opengeospatial.net/wfs/1.0.0/WFS-capabilities.xsd*">;
- <!--

MapServer version 4.6.0 OUTPUT=GIF OUTPUT=PNG OUTPUT=JPEG OUTPUT=PDF
OUTPUT=SWF OUTPUT=SVG SUPPORTS=PROJ SUPPORTS=FREETYPE SUPPORTS=WMS_SERVER
SUPPORTS=WMS_CLIENT SUPPORTS=WFS_SERVER SUPPORTS=WFS_CLIENT
SUPPORTS=WCS_SERVER SUPPORTS=THREADS INPUT=POSTGIS INPUT=ORACLESPATIAL
INPUT=OGR INPUT=GDAL INPUT=SHAPEFILE DEBUG=MSDEBUG

-->
- <#> <Service>
<Name>MapServer
WFS</Name>
<Title>Loe_ALK_WFS_Hausnummern</Title>

<OnlineResource>http://myserver/cgi-bin/oracle/oracle/mapserv.exe?map=cgi-bi
n/oracle/oracle/xtra-maps_LOE_ALK_hausnummern.map&</OnlineResource>

</Service>
- <#> <Capability>
- <#> <Request>
- <#> <GetCapabilities>
- <#> <DCPType>
- <#>
<HTTP>
<Get
onlineResource="*http://myserver/cgi-bin/oracle/oracle/mapserv.exe?map=cgi-b
in/oracle/oracle/xtra-maps_LOE_ALK_hausnummern.map&*"
/>
</HTTP>
</DCPType>
- <#> <DCPType>
- <#>
<HTTP>
<Post
onlineResource="*http://myserver/cgi-bin/oracle/oracle/mapserv.exe?map=cgi-b
in/oracle/oracle/xtra-maps_LOE_ALK_hausnummern.map&*"
/>
</HTTP>
</DCPType>
</GetCapabilities>
- <#> <DescribeFeatureType>
- <#> <SchemaDescriptionLanguage>
<XMLSCHEMA />
<SFE_XMLSCHEMA />
</SchemaDescriptionLanguage>
- <#> <DCPType>
- <#>
<HTTP>
<Get
onlineResource="*http://myserver/cgi-bin/oracle/oracle/mapserv.exe?map=cgi-b
in/oracle/oracle/xtra-maps_LOE_ALK_hausnummern.map&*"
/>
</HTTP>
</DCPType>
- <#> <DCPType>
- <#>
<HTTP>
<Post
onlineResource="*http://myserver/cgi-bin/oracle/oracle/mapserv.exe?map=cgi-b
in/oracle/oracle/xtra-maps_LOE_ALK_hausnummern.map&*"
/>
</HTTP>
</DCPType>
</DescribeFeatureType>
- <#> <GetFeature>
- <#> <ResultFormat>
<GML2 />
<GML3 />
</ResultFormat>
- <#> <DCPType>
- <#>
<HTTP>
<Get
onlineResource="*http://myserver/cgi-bin/oracle/oracle/mapserv.exe?map=cgi-b
in/oracle/oracle/xtra-maps_LOE_ALK_hausnummern.map&*"
/>
</HTTP>
</DCPType>
- <#> <DCPType>
- <#>
<HTTP>
<Post
onlineResource="*http://myserer/cgi-bin/oracle/oracle/mapserv.exe?map=cgi-bi
n/oracle/oracle/xtra-maps_LOE_ALK_hausnummern.map&*"
/>
</HTTP>
</DCPType>
</GetFeature>
</Request>
</Capability>
- <#> <FeatureTypeList>
- <#> <Operations>
<Query />
</Operations>
- <#> <FeatureType>
<Name>Hausnummer</Name>
<Title>Hausnummern_wfs</Title>
<SRS>EPSG:31467</SRS>
<LatLongBoundingBox minx="*7.66897*" miny="*47.6335*" maxx="*7.6825*"
maxy="*47.6427*" />
</FeatureType>
</FeatureTypeList>
- <#> <ogc:Filter_Capabilities>
- <#> <ogc:Spatial_Capabilities>
- <#> <ogc:Spatial_Operators>
<ogc:Intersect />
<ogc:DWithin />
<ogc:BBOX />
</ogc:Spatial_Operators>
</ogc:Spatial_Capabilities>
- <#> <ogc:Scalar_Capabilities>
<ogc:Logical_Operators />
- <#> <ogc:Comparison_Operators>
<ogc:Simple_Comparisons />
<ogc:Like />
<ogc:Between />
</ogc:Comparison_Operators>
</ogc:Scalar_Capabilities>
</ogc:Filter_Capabilities>
</WFS_Capabilities>

Now the nasty bit:

WFS getfeature kills MSinstantly  with a Message-Window on the Server,
stating
that mapserver is terminating( No MS-logfile entry)

Here comes the mapfile (WMS-Part removed...)

MAP
OUTPUTFORMAT
NAME png
DRIVER "GD/PNG"
MIMETYPE "image/png"
IMAGEMODE RGB
EXTENSION "png"
END

EXTENT 3400000 5278000 3401000 5279000 #test ausschnitt
UNITS METERS
SIZE 500 500
SHAPEPATH
"C:\Inetpub\wwwroot\inetpub\wwwroot\jan_gemarkung_dev\data\shp"
SYMBOLSET
"C:\Inetpub\wwwroot\jan_gemarkung_dev\chameleon\samples\etc\symbols.sym"
FONTSET
"C:\Inetpub\wwwroot\jan_gemarkung_dev\chameleon\samples\etc\fonts.txt"
IMAGECOLOR 255 255 255
DEBUG on
WEB
IMAGEPATH 'c:\inetpub\wwwroot\tmp\'
IMAGEURL '/tmp/'
LOG 'c:\inetpub\wwwroot\tmp\ms_log.txt'
METADATA
"wfs_title" "Hausnummern" ##
REQUIRED
"wfs_onlineresource"
"http://myserver/cgi-bin/oracle/oracle/mapserv.exe?map=cgi-bin/oracle/oracle
/hausnummern.map&"
"wfs_srs" "EPSG:31467" ## Recommended
END
END
PROJECTION
"init=epsg:31467"
END
LAYER
NAME "Hausnummer"
CONNECTIONTYPE oraclespatial
CONNECTION "user/pass at db"
DATA "GEOM FROM AL_L_GEBAEUDENUMMER USING UNIQUE FID"
#
METADATA
"wfs_extent" "3400000 5278000 3401000 5279000"
"wfs_title" "Hausnummern_wfs"
"gml_include_items" "all"
END

PROJECTION
"init=epsg:31467"
END

DUMP TRUE
MAXFEATURES 10
SIZEUNITS PIXELS
STATUS ON
TOLERANCE 0
TOLERANCEUNITS PIXELS
TYPE POINT
UNITS METERS
labelitem HAUSNUMMER
LABELCACHE ON
END # LAYER
END # MAP

YES the mapserver I am using IS capable of delivering WFS (tried it
with another Oraclebase Dataset which works fine)
NO I can't switch to PostGRES   ;-)

Any Ideas?

SORRY for the long Post !

Thank you all for your advice (which I already got from this list)

Regards

Jan

-- 
Lust, ein paar Euro nebenbei zu verdienen? Ohne Kosten, ohne Risiko!
Satte Provisionen für GMX Partner: http://www.gmx.net/de/go/partner

Disclaimer
************************************************************************
Aan dit bericht kunnen geen rechten worden ontleend. Dit bericht is
uitsluitend bestemd voor de geadresseerde. Als u dit bericht per abuis
hebt ontvangen, wordt u verzocht het te vernietigen en de afzender te 
informeren. Wij adviseren u om bij twijfel over de juistheid of de 
volledigheid van de mail contact met afzender op te nemen.

This message shall not constitute any rights or obligations.
This message is intended solely for the addressee.
If you have received this message in error, please delete it and
notify the sender immediately. When in doubt whether this message
is correct or complete, please contact the sender.
************************************************************************