OracleSpatial getFeatureInfo problem against unique column containing text

[Sebastian Schmitz]

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 "GDI/****@ORCL_HOGGNO"
>>   #not serving getFeatureInfo
>>   DATA "GEOM FROM V_*** USING UNIQUE SST_NR SRID 8307 FILTER VERSION
>>     
> 10g"
>   
>>   #serving getFeatureInfo
>>   DATA "GEOM FROM V_*** USING UNIQUE substr(SST_NR,3,7) SRID 8307
>>     
> FILTER 
>   
>> VERSION 10g"
>>   FILTER "BEREICHKZ = '3'"
>> ...
>>
>> 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 & 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
---------------------------------------