[mapguide-users] Selection problem with King.Oracle provider

[Andreas Morf]

The datatype according fdo2fdo Schema Manager is Int32 and the values for
the OID (->NUMBER(20) in Oracle) column for two selected Objects are
3252048000000157 and 3252048000000158.
It seems that these values are too big for Int32 and the conversion results
in the same value for the selection-ID...
So the question is why King.Oracle applies the mapping from NUMBER(20) to
Int32? 
Is this a bug or do I miss something?

Andreas

> -----Original Message-----
> From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-
> bounces at lists.osgeo.org] On Behalf Of Simon Pelicon
> Sent: Wednesday, May 13, 2009 8:47 AM
> To: MapGuide Users Mail List
> Subject: Re: [mapguide-users] Selection problem with King.Oracle
> provider
> 
> Hi!
> It looks like that there is some problem with primary key field you
> defined.
> What data type is OID column?
> Check if data are ok in OID column.
> 
> Simon
> 
> Andreas Morf wrote:
> > Within a project I switched from SDF provider to king.oracle (0.8.9)
> and
> > now, selection in fusion doesn't work anymore for same data (no
> error, but
> > no highlighting nor attributes)
> > After investigating a little bit I found the following Selection-XML
> in
> > Query.php:
> >
> > King.Oracle:
> > <?xml version="1.0" encoding="UTF-8"?><FeatureSet
> > xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
> > xsi:noNamespaceSchemaLocation="FeatureSet-1.0.0.xsd"> <Layer
> > id="b3eefd0c-ffff-ffff-8000-00187186e6ed">  <Class
> > id="KingOra:GEORI_AV~AV_BB_GEBAEUDE~GEOMETRY">   <ID>AAAAAA==</ID>
> > <ID>AAAAAA==</ID>   <ID>AAAAAA==</ID>   <ID>AAAAAA==</ID>
> > <ID>AAAAAA==</ID>   <ID>AAAAAA==</ID>  </Class> </Layer></FeatureSet>
> >
> > This, of course doesn't make lot of sense...
> >
> > A primary key was set with fdo2fdo for a column named 'OID'
> >
> > Any explanation for this problem?
> >
> > Thanks, Andreas
> >
> > _______________________________________________
> > mapguide-users mailing list
> > mapguide-users at lists.osgeo.org
> > http://lists.osgeo.org/mailman/listinfo/mapguide-users
> >
> >
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users