WFS and Oracle

[Huub Fleuren]

Hi Fernando,
just  now tested the following compile libcurl 7.13.2 oracle 10g /  gdal 
1.3 (with oracle 10g/xerces 2.4) (on a different server)
http://host/cgi-bin/testbin/mapserv.exe?map=s5.map&request=getfeature&service=wfs&typename=bommen&version=1.0.0

(the layer bommen contains 10 points)
same problem, mapserver crashes on wfs/oracle (not on wfs / shape), 
getcapabilities works (very slow), describefeaturetype works


LAYER
  STATUS ON
  DEBUG OFF
  CONNECTIONTYPE oraclespatial
  CONNECTION "usr/pwd at db"
  PROCESSING "CLOSE_CONNECTION=DEFER"
  NAME "bommen"
  DATA "geom ( select geom, id from bommen ) using unique id srid 90112"
  TYPE POINT
  DUMP TRUE

  METADATA
    "Wms_Srs"   "Epsg:28992"
    "Wms_Name"  "bommen"
    "Wms_Title" "bommen"
  END

  CLASS
    NAME "Bommen"
    STYLE
    SYMBOL 'bommen'
    SIZE 20
    COLOR 120 120 120
    END
  END
END


Fernando Simon wrote:

> 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
>>
>>  
>>
>
>
>