[mapguide-users] Oracle FDO and View

Tue May 26 18:02:48 EDT 2009

Ok, finnally, I created a new column called GISKEY based on the ROWNUM and
made that the primary key in the Materialize View..and it works great now. 

Thanks!

gordon

GordonL wrote:
> 
> Yep, the materialized view has its own key - but still the individual
> objects cannot be selected within MapGuide. The same data in the
> traditional table work fine.  Very weird.
> 
> gordon
> 
> 
> 
> Dave Wilson wrote:
>> 
>> 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
>> _______________________________________________
>> 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-tp1811392p2977550.html
Sent from the MapGuide Users mailing list archive at Nabble.com.