[mapguide-users] Oracle FDO and View

[Haris Kurtagic]

Yes, you need to create materialized view for index or you can use
KingFdoClass metadata table to tell provider which column will be used
as primary key.

Haris

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org
[mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of GordonL
Sent: Wednesday, May 20, 2009 3:05 PM
To: mapguide-users at lists.osgeo.org
Subject: Re: [mapguide-users] Oracle FDO and View


Thanks David, 
Index on a view?  The core tables are already indexed - including the
GEOMETRY column.  Do you mean convert it to a MATERIALIZED VIEW and
index it
then?

thanks
gordon



David Hequet wrote:
> 
> Hi,
> 
> Features can be selectable if you add primary key to your view
(MapGuide
> need Primary key on all feature to be selectable).
> 
> David
> 
> 
> GordonL wrote:
>> 
>> Hi David, did you ever solve this problem?
>> 
>> I am having trouble that features drawn from VIEWS in Oracle are not
>> selectable (FDO 4.3).  This is true for both the Autodesk Oracle
Provider
>> AND the KING one..
>> 
>> thanks
>> gordon
>> 
>> 
>> David Hequet wrote:
>>> 
>>> Hello,
>>> 
>>> About this case i'm using Autodesk Mapguide Enterprise 2008 with
>>> Autodesk Spatial Oracle FDO.
>>> One of the new feature is "using Oracle View"
>>> I tried to use a view with geometry, it work, but features can't be
>>> selectable! I make them selectable in Studio but they are not,
either in
>>> dwf or ajax viewer.
>>> 
>>> Is it the same with the Oracle King provider? Or anyone has an idea
on
>>> how make them selectable (really :p )
>>> 
>> 
>> 
> 
> 

-- 
View this message in context:
http://n2.nabble.com/Oracle-FDO-and-View-tp1811392p2946000.html
Sent from the MapGuide Users mailing list archive at Nabble.com.

_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users