Missing FeatureMember with Oracle Spati al

[Fernando Simon]

Hi Holger,
    Sure, big numbers can make the request (query) not work correctly in 
Mapserver and Oracle Spatial.It's the second time that this kind of 
problem occur.
    This occurs because Oracle can store numbers that are bigger of 
Mapserver can store in shapeobj index. Maybe this issue needs a bug report.
    Best regards

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


porath at web.de wrote:
> Hi Fernando,
>
> i have made some further investigations today. First, Bart was right that the UNIQUE parameter was missing in my DATA statement. Second, the primary key column of all records in my oracle spatial database table contained more than 10 digits (exactly 17). After cutting the values to 10 digits the wfs returned correctly all featuremembers.
>
> Regards,
>
> Holger
>
>
>
> -----Ursprüngliche Nachricht-----
> Von: Fernando Simon <fsimon at univali.br>
> Gesendet: 16.05.06 18:42:46
> An: porath at WEB.DE
> CC: MAPSERVER-USERS at LISTS.UMN.EDU, b.vdeijnden at AGI.RWS.MINVENW.NL
> Betreff: Re: [UMN_MAPSERVER-USERS] Missing FeatureMember with  Oracle Spati al
>
>
> Hi Holger,
>    The UNIQUE parameter just accept an unique column because in 
> Mapserver core the shapeobj index it's a number.
>    Can you provide more details about the error that Mapserver reported? 
> I'm working in another Oracle Spatial bug request, but I need more 
> report about it. I will try to fix it for the next release.
>    Bart, can you post a little example of a layer that you are using 
> with WFS and Oracle Spatial?
>    Best regards.
>
> ------------------------------------------------------------------------
> Fernando Simon
> Mapserver and Oracle Spatial developer
> G10 - Laboratorio de Computacao Aplicada - Brazil
> http://www.univali.br/g10 - UNIVALI/CTTMAR
> ------------------------------------------------------------------------
>
> H. Porath wrote:
>   
>> Hi Bart,
>>
>> yes, i added a new primary key to my table because the original primary key spans over four columns and i didn't know how to use the UNIQUE statement with more than one primary key column. Anyway, it didn't help so i removed it. 
>>
>> Thanks for thinking about my problem.
>>
>> Regards,
>>
>>
>> Holger
>>
>> -----Ursprüngliche Nachricht-----
>> Von: "Eijnden, B. van den (Bart)" <b.vdeijnden at AGI.RWS.MINVENW.NL>
>> Gesendet: 15.05.06 19:54:03
>> An: MAPSERVER-USERS at LISTS.UMN.EDU
>> Betreff: Re: [UMN_MAPSERVER-USERS] Missing FeatureMember with Oracle Spati al
>>
>>
>>
>> Have you tried using USING UNIQUE [primary_key] in your DATA statement?
>>
>>
>> See the Oracle Spatial HOWTO for details.
>>
>>
>> Best regards,
>>
>> Bart
>>
>> _______________________________________________________________
>> SMS schreiben mit WEB.DE FreeMail - einfach, schnell und
>> kostenguenstig. Jetzt gleich testen! http://f.web.de/?mc=021192
>>
>>   
>>     
>
>
>
> _______________________________________________________________
> SMS schreiben mit WEB.DE FreeMail - einfach, schnell und
> kostenguenstig. Jetzt gleich testen! http://f.web.de/?mc=021192
>
>
>