WFS and Oracle
Bart van den Eijnden
BEN at SYNCERA-ITSOLUTIONS.NL
Thu Aug 25 07:19:52 EDT 2005
you need to compile mapserv with VC6, SP3 or SP4 minimal (one of the two, I can't remember exactly). Otherwise you get crashes on GetFeatureInfo or GetFeature with maporaclespatial. VC7 also does the trick.
Bart van den Eijnden
Syncera IT Solutions
2600 AG DELFT
email: BEN at Syncera-ITSolutions.nl
>>> Huub Fleuren <hfl at HOME.NL> 08/25/05 1:13 pm >>>
All compiling goes with vc6, no sp ((i think: i use a copy of the vc98
directory :-), what happens there if i should run a service pack?)
Are you guessing it would be nessacary to run the sevice pack before
gdal succeeds in converting the retrieved dataset to GML?
Running an SP is something i can do of course. Results on monday.
There are different stages in this:
Oracle must be accessed by mapserver, this goes oke, because it
needs to do that for WMS too,
this goes OK, because the same dataset shows up in the map.
It takes some time for mapserver to crash. I guess the dataset is
retrieved. How can i be sure?
If the dataset really was retrieved by mapserver GDAL 1.3 might not
be able GMLizes it?
On the other hand: the SHP was GMLized correctly (by GDAL?).
Maybe someone who really knows which components do what for which
connectiontype could make a better guess.
A DescribeFeatureType works, GetFeatureInfo will be tried next monday.
Bart van den Eijnden wrote:
> which Visual Studio version did you compile with? If 6, which SP?
> Does a WMS GetFeatureInfo request work?
> Best regards,
> On Wed, 24 Aug 2005 14:05:11 +0200, Huub Fleuren <hfl at HOME.NL> wrote:
>> WFS experiments continue today on a Oracle 9 database.
>> I'm using a compile against Oracle 92 OCI in mapserver as well as
>> A wfs request on a test layer (SHP) give me all the data.
>> A WMS request still runs fine on this Oracle layer, but
>> on Oracle mapserver crashes, even if i FILTER for only one record.
>> WFS requests on Oracle Layers should work i think.
>> So what am i missing.
>> Regards, Huub
>> wfs_type "gebouw"
>> wfs_title "gebouw"
>> gml_include_items "all"
>> FILTERITEM ID
>> FILTER "id=623898"
>> DEBUG ON
>> DUMP TRUE
>> STATUS OFF
>> CONNECTIONTYPE oraclespatial
>> CONNECTION "gv/gv at gv"
>> PROCESSING "CLOSE_CONNECTION=DEFER"
>> DATA "GEOMETRIE FROM KBK.KBK_gebouw USING UNIQUE ID SRID 90112"
>> NAME "gebouw"
>> TYPE POLYGON
>> SYMBOL "circle"
>> SIZE 1
>> COLOR 255 0 0
>> OUTLINECOLOR 255 0 0
More information about the mapserver-users