WFS and Oracle
Fernando Simon
fsimon at UNIVALI.BR
Tue Sep 13 10:16:30 PDT 2005
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
>
>
>
More information about the MapServer-users
mailing list