[mapguide-users] Oracle FDO and View

[Dave Wilson]

Actually you can use a view if it includes the primary key column from the underlying geometry table. You also have to add user_sdo_geom_metadata records for the view. Basically insert by copying the entry for the underlying table that has the geometry.

It should work without the materialized view.

At least it does with the Autodesk Oracle provider.

Dave

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of David Hequet
Sent: Wednesday, May 20, 2009 7:24 AM
To: mapguide-users at lists.osgeo.org
Subject: RE: [mapguide-users] Oracle FDO and View


With Oracle you can add primary key (don't confuse index and Key) to view
(sorry i don't have the sql here).

Materialized view is a good way to improve performance (espacially if you
use view on multiple database).


Haris Kurtagic wrote:
> 
> 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
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> 
> 

-- 
View this message in context: http://n2.nabble.com/Oracle-FDO-and-View-tp1811392p2946099.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