OracleSpatial getFeatureInfo problem against unique column containing text

[Sebastian Schmitz]

Not very easily. Well, one could find a workaround of some kind, but it 
would be nicer to have MapServer support character primary key columns, 
which are unique as well.

In the relevant project, SAP is involved and within SAP all IDs are 
defined as Text always. Now, we cannot change SAP. However, we could 
change IDs to something else, e.g. map character values to numbers, but 
that seems a little odd.

Anybody else having the need for MapServer being able to serve 
getFeatureInfo against unique character primary key columns? Let us try 
find a solution!

Cheers

Sebastian Schmitz


Bart van den Eijnden (OSGIS) schrieb:
> It's a restriction from Mapserver side.
>
> You can't change your view SQL so that it has an integer primary key column?
>
> Best regards,
> Bart
>
> --
> Bart van den Eijnden
> OSGIS, Open Source GIS
> http://www.osgis.nl
>
>
> --------- Oorspronkelijk bericht --------
> Van: Sebastian Schmitz <sebastian.schmitz at WHEREGROUP.COM>
> Naar: MAPSERVER-USERS at LISTS.UMN.EDU <MAPSERVER-USERS at LISTS.UMN.EDU>
> Onderwerp: Re: [UMN_MAPSERVER-USERS] OracleSpatial getFeatureInfo problem
> against unique column containing text
> Datum: 23/02/07 09:32
>
>   
>> Now what do I do?
>>
>> Is this a restriction from Oracle-side or from MapServer?
>> MapServer I guess?
>>
>> Cheers
>>
>> Sebastian
>>
>> Bart van den Eijnden (OSGIS) schrieb:
>> > No this is not possible.
>> >
>> > You need to use an integer for the unique column. It's a requirement.
>> >
>> > Best regards,
>> > Bart
>> >
>> > --
>> > Bart van den Eijnden
>> > OSGIS, Open Source GIS
>> > http://www.osgis.nl
>> >
>> >
>> > --------- Oorspronkelijk bericht --------
>> > Van: Sebastian Schmitz <sebastian.schmitz at WHEREGROUP.COM>
>> > Naar: MAPSERVER-USERS at LISTS.UMN.EDU
>>     
> <MAPSERVER-USERS at LISTS.UMN.EDU>
>   
>> > Onderwerp: [UMN_MAPSERVER-USERS] OracleSpatial getFeatureInfo problem
>> > against unique column containing text
>> > Datum: 23/02/07 08:33
>> >
>> >   
>> >> Hi,
>> >>
>> >> I have a view in Oracle Spatial 10gR2 with a unique Id, which is
>>     
> text.
>   
>> >> MapServer draws the map OK using oraclespatial CONNECTIONTYPE.
>> >> However, MapServer is unable to serve a getFeatureInfo request
>>     
> against 
>   
>> >> that view. If I change the DATA statement to substr(ID, 3,7),
>>     
> removing 
>   
>> >> letters from the ID - getFeatureInfo runs fine for the time
>>     
> being, but 
>   
>> >> without the letters my ID will soon lose its uniqueness.
>> >>
>> >> Is MapServer able to server a getFeatureInfo request against DATA
>>     
> that 
>   
>> >> uses a unique text-column containing letters?
>> >>
>> >> Find more detail below:
>> >> mapfile:
>> >> ...
>> >> CONNECTIONTYPE oraclespatial
>> >>   CONNECTION &quot;GDI/****@ORCL_HOGGNO&quot;
>> >>   #not serving getFeatureInfo
>> >>   DATA &quot;GEOM FROM V_*** USING UNIQUE SST_NR SRID 8307
>>     
> FILTER VERSION
>   
>> >>     
>> > 10g&quot;
>> >   
>> >>   #serving getFeatureInfo
>> >>   DATA &quot;GEOM FROM V_*** USING UNIQUE substr(SST_NR,3,7)
>>     
> SRID 8307
>   
>> >>     
>> > FILTER 
>> >   
>> >> VERSION 10g&quot;
>> >>   FILTER &quot;BEREICHKZ = '3'&quot;
>> >> ...
>> >>
>> >> log:
>> >> Fri Feb 23 10:54:40 2007 - msOracleSpatialLayerGetShape():
>>     
> OracleSpatial 
>   
>> >> error. Error: ORA-01722: invalid number
>> >>  . Query statement: SELECT ***,***, GEOM FROM V_*** WHERE SST_NR
>>     
> = 0 AND 
>   
>> >> BEREICHKZ = '2' .Check your data statement.
>> >>
>> >> SST_NR in this case should not be null, but sth. like 'SS0023093
>>     
> '.
>   
>> >>
>> >> Cheers
>> >>
>> >> Sebastian
>> >>
>> >> -- 
>> >> ---------------------------------------
>> >> WhereGroup GmbH &amp; Co. KG
>> >> Siemensstraße 8
>> >> 53121 Bonn
>> >> -------------------------------
>> >> Fon: +49 (0)228 / 90 90 38 - 24
>> >> Fax: +49 (0)228 / 90 90 38 - 11
>> >> -------------------------------
>> >> mailto:sebastian.schmitz at wheregroup.com
>> >> http://www.wheregroup.com
>> >> -------------------------------
>> >> Komplementärin:
>> >> WhereGroup Verwaltungs GmbH
>> >> vertreten durch:
>> >> Arnulf Christl, Olaf Knopp, Peter Stamm
>> >> Amtsgericht Bonn, HRB 9885
>> >> ---------------------------------------
>> >>
>> >>
>> >>     
>>
>> -- 
>> ---------------------------------------
>> WhereGroup GmbH & Co. KG
>> Siemensstraße 8
>> 53121 Bonn
>> -------------------------------
>> Fon: +49 (0)228 / 90 90 38 - 24
>> Fax: +49 (0)228 / 90 90 38 - 11
>> -------------------------------
>> mailto:sebastian.schmitz at wheregroup.com
>> http://www.wheregroup.com
>> -------------------------------
>> Komplementärin:
>> WhereGroup Verwaltungs GmbH
>> vertreten durch:
>> Arnulf Christl, Olaf Knopp, Peter Stamm
>> Amtsgericht Bonn, HRB 9885
>> ---------------------------------------
>>
>>
>>     

-- 
---------------------------------------
WhereGroup GmbH & Co. KG
Siemensstraße 8
53121 Bonn
-------------------------------
Fon: +49 (0)228 / 90 90 38 - 24
Fax: +49 (0)228 / 90 90 38 - 11
-------------------------------
mailto:sebastian.schmitz at wheregroup.com
http://www.wheregroup.com
-------------------------------
Komplementärin:
WhereGroup Verwaltungs GmbH
vertreten durch:
Arnulf Christl, Olaf Knopp, Peter Stamm
Amtsgericht Bonn, HRB 9885
---------------------------------------