OracleSpatial getFeatureInfo problem against unique column containing text

[Bart van den Eijnden (OSGIS)]

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