WFS and Oracle

[Fernando Simon]

Hi folks,
    The Oracle support for Mapserver need the Oracle Call Interfaces 
(OCI) libraries. Mapserver access Oracle Spatial directly by OCI, don't 
use ODBC.
    Using this way is more quickly to receive the results and the 
performance of the (maporaclespatial.c) is better.
    I recomment to compile Mapserver with Oracle Spatial using the VC6 
with SP4, here I compiled using SP6 and didn't see problems.
    Thanks.

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



Bart van den Eijnden wrote:

>Huub,
>
>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.
>
>Best regards,
>Bart
>
>Bart van den Eijnden
>Syncera IT Solutions
>Postbus 270
>2600 AG  DELFT
>
>tel.nr.: 015-7512436
>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.
>
>My guessing.
>    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.
>
>Regards,
>Huub
>
>Bart van den Eijnden wrote:
>
>  
>
>>Huub,
>>
>>which Visual Studio version did you compile with? If 6, which SP?
>>
>>Does a WMS GetFeatureInfo request work?
>>
>>Best regards,
>>Bart
>>
>>On Wed, 24 Aug 2005 14:05:11 +0200, Huub Fleuren <hfl at HOME.NL> wrote:
>>
>>    
>>
>>>Hi
>>>
>>>WFS experiments continue today on a Oracle 9 database.
>>>I'm using a compile against Oracle 92 OCI in mapserver as well as 
>>>gdal1.3
>>>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
>>>
>>>LAYER
>>>  METADATA
>>>    wfs_type "gebouw"
>>>    wfs_title "gebouw"
>>>    gml_include_items "all"
>>>  END
>>>
>>>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
>>>  CLASS
>>>    STYLE
>>>      SYMBOL "circle"
>>>      SIZE 1
>>>      COLOR 255 0 0
>>>      OUTLINECOLOR 255 0 0
>>>    END
>>>  END
>>>END
>>>
>>>      
>>>
>>
>>    
>>
>
>  
>