Oracle Wfs getfeature CRASH

[Jan Espenlaub]

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-bin/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-bin/oracle/oracle/xtra-maps_LOE_ALK_hausnummern.map&*"
/>
</HTTP>
</DCPType>
- <#> <DCPType>
- <#>
<HTTP>
<Post
onlineResource="*http://myserver/cgi-bin/oracle/oracle/mapserv.exe?map=cgi-bin/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-bin/oracle/oracle/xtra-maps_LOE_ALK_hausnummern.map&*"
/>
</HTTP>
</DCPType>
- <#> <DCPType>
- <#>
<HTTP>
<Post
onlineResource="*http://myserver/cgi-bin/oracle/oracle/mapserv.exe?map=cgi-bin/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-bin/oracle/oracle/xtra-maps_LOE_ALK_hausnummern.map&*"
/>
</HTTP>
</DCPType>
- <#> <DCPType>
- <#>
<HTTP>
<Post
onlineResource="*http://myserer/cgi-bin/oracle/oracle/mapserv.exe?map=cgi-bin/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