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-boun...@lists.osgeo.org > [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of GordonL > Sent: Tuesday, May 26, 2009 2:37 PM > To: mapguide-users@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-boun...@lists.osgeo.org >> [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of David Hequet >> Sent: Wednesday, May 20, 2009 7:24 AM >> To: mapguide-users@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-boun...@lists.osgeo.org >>> [mailto:mapguide-users-boun...@lists.osgeo.org] On Behalf Of GordonL >>> Sent: Wednesday, May 20, 2009 3:05 PM >>> To: mapguide-users@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@lists.osgeo.org >>> http://lists.osgeo.org/mailman/listinfo/mapguide-users >>> _______________________________________________ >>> mapguide-users mailing list >>> mapguide-users@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@lists.osgeo.org >> http://lists.osgeo.org/mailman/listinfo/mapguide-users >> _______________________________________________ >> mapguide-users mailing list >> mapguide-users@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@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapguide-users > _______________________________________________ > mapguide-users mailing list > mapguide-users@lists.osgeo.org > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > -- View this message in context: http://n2.nabble.com/Oracle-FDO-and-View-tp1811392p2977153.html Sent from the MapGuide Users mailing list archive at Nabble.com. _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
