WFS and Oracle

[Fernando Simon]

Hi Huub,
    I saw a little problem with your layer definition, using the layer 
definition that you sent in previously e-mail (08/24/2005) you defined 
the FILTER and FILTERITEM parameter.
    The Mapfile reference tells that the FILTERITEM parameter is only 
for shapefiles/OGR. The FILTER parameter can be defined for Oracle 
Spatial, I already saw a problem with FILTER parameter and WFS requests 
(Oracle Spatial), but I didn't find the core of the problem yet.
    Using you layer definition that you sent before you can solve this 
problem when you need to redefine your DATA parameter, as:
        "GEOMETRIE FROM (SELECT GEOMETRIE, ID FROM KBK.KBK_gebouw WHERE 
ID = 623898) USING UNIQUE ID SRID 90112" or
        "GEOMETRIE FROM (SELECT GEOMETRIE, ID FROM KBK.KBK_gebouw WHERE 
ID = 623898) USING UNIQUE ID SRID 90112 NONE"
     Just to test and confirm the problem, can you sent the WFS request 
that generate the error?
     Thanks.


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

Huub Fleuren wrote:

>Hi
>
>I've been building mapserver with a properly installed vc6sp6 since a week or two
>
>-oracle92
>-libcurl 7.10.7 7.13.2 7.14.0
>-gdal 1.2.5 1.2.6 1.3.0 (with / without oraclesupport)
>-mapserver 4.4.1 4.6 and CVS (wfs server/client support)
>
>
>In different combinations
>
>There was not a mapserver that did not crash on a WFS request for Oracle.
>
>Would Howard Butler want to run his oracle92 build again with the newest releases and see if it works for me?
>
>Regards, Huub
>
>  
>