getFeatureInfo against unique character primary key

[Sebastian Schmitz]

Hi,

anybody out there having the need for MapServer being able to serve 
getFeatureInfo against unique character primary key columns?

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
---------------------------------------

-- 
---------------------------------------
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
---------------------------------------