[mapguide-users] Oracle FDO and View

[Dave Wilson]

A materialized view might need its own primary key defined as it's basically a table.

Dave

-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of GordonL
Sent: Tuesday, May 26, 2009 2:37 PM
To: mapguide-users at lists.osgeo.org
Subject: RE: [mapguide-users] Oracle FDO and View


Yes, it does work, but it does not allow me to select features in the map.  

For example, I have a materialize view called MVIEW_PARCELS, it has a
spatial index on the GEOMETRY column and index on the GIS_ID column.  It has
a row in the MDSYS.SDO_GEOM_METADATA_TABLE.  

I can see everything on the map in MapGuide, but I cannot select individual
parcels.


gordon



Dave Wilson wrote:
> 
> 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
> _______________________________________________
> 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-tp1811392p2977086.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