[mapguide-users] King Oracle FDO Provider Single select hights allfeatures

[Haris Kurtagic]

Hi,

 

I have looked into this and I got same behavior.

 

What is happing is that MG layer created from class doesn't have
identity properties set.

 

If you select one feature it will be selected (just one in properties
window) but all will be rendered as selected (blue).

This means that provider is correctly running spatial filter to select
just one feature.

 

What I found in MapGuide is that if provider is returning just one FDO
Schema (KingOra ) instead of two FDO Schemas (KingOra and KingFdoClass )
it is working properly.

 

I have checked with Fdo2Fdo and both FDO classes, from base table and
view, look's exactly same except FDO schema name and still layer created
in MapGuide for one class has identity property set and not for another
class.

 

I am not 100% sure but because of this findings in this moment it looks
like issue with MapGuide (or Studio) not the provider.

Unfortunately I am traveling again and right now I don't' have time to
investigate it further.

 

My reply is coming little late because I was travelling and not able to
look at this before.

 

Haris

 

From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Joseph
Doherty
Sent: 17. april 2007 22:23
To: mapguide-users at lists.osgeo.org
Subject: [mapguide-users] King Oracle FDO Provider Single select hights
allfeatures

 

I am using Mapguide Enterprise 2007 SP1, Mapguide Studio, Oracle
Enterprise Ed. 10.2.0.1.0 and the King Oracle FDO (0.6.4).

 

Oracle and Mapguide are on the same machine and using the regular Oracle
Client, not the Instant client.

 

In Mapguide Studio, I have a layer defined using a KingFDOClass based on
a view. When I view this layer in a Mapdefinition and select a single
line, all the lines are selected.

 

This behavior happens after applying SP1 to Mapguide. This behavior does
not happen when I use the base table.

 

The view has a primary key defined, below is additional info:

 

Below is the table  "CMGENCLD" , the King FDO Class definition table
(showing only the columns with values)

FDO_UNIQUE_ID

FDO_ORA_OWNER

FDO_ORA_NAME

FDO_ORA_GEOMCOLUMN

FDO_SPATIALTABLE_OWNER

FDO_SPATIALTABLE_NAME

FDO_SPATIALTABLE_GEOMCOLUMN

FDO_CLASS_NAME

FDO_IDENTITY

1061

GUTAPP

V_UTWATPIP_BASE

GEOMETRY

GUTAPP

UTWATPIP

GEOMETRY

V_UTWATPIP_BASE_CLS

DATALINK

 

These are entries in the MDSYS.SDO_GEOM_METADATA_TABLE for the GUTAPP
user/schema

SDO_OWNER

SDO_TABLE_NAME

SDO_COLUMN_NAME

SDO_SRID

GUTAPP

UTWATPIP

GEOMETRY

41051

GUTAPP

V_UTWATPIP_BASE

GEOMETRY

41051

 

 

Any thoughts or insights would be appreciated.

 

Mahalo,

 

Joseph Doherty 
Software Engineer

Oracle Certified Professional

Microdesk, Inc. 
P: 781-419-8105 
C: 781-820-1389 
F: 781-890-5275 
www.microdesk.com  <http://www.microdesk.com>  

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/mapguide-users/attachments/20070421/64215b18/attachment-0001.html