[fdo-users] Impossible to select an object on map mapguide

[Orest Halustchak]

Hi,

To use Oracle views, you need to do a couple of things.

Make sure that you have an entry in user_sdo_geom_metadata for the geometry column.

Add a pkey:
alter view <viewname> add constraint <constraintname> primary key (<columnlist>) disable novalidate;

Thanks,
Orest.

From: fdo-users-bounces at lists.osgeo.org [mailto:fdo-users-bounces at lists.osgeo.org] On Behalf Of Haris Kurtagic
Sent: Tuesday, January 12, 2010 9:22 AM
To: FDO Users Mail List
Subject: Re: [fdo-users] Impossible to select an object on map mapguide

Yes it is FDO_IDENTITY, you can  use comma to separate fields if needed

Caching and using of FD schema in applications is something we could talk a lot about in MG, Map and FDO :).
I have changed 3 times in provider in diff. versions if it cache FDO schema or not.

Haris
On Tue, Jan 12, 2010 at 2:52 PM, Dejan Gregor <dejan.gregor at gmail.com<mailto:dejan.gregor at gmail.com>> wrote:

Haris,

thanks for the information. I have deployed the SL King FDO metadata table
along with the SL Kinf FDO provider for Oracle on MGE 2010 (it works fine).
Which column of the SL Kinf FDO metadata table is actually defining in an
Oracle View the primary key? I would like to set my 'FID' as a primary key
in the FDO class.

Is it maybe the FDO_IDENTITY?!

With the Autodesk Oracle provider upon Oracle Views I have many issues that
concern probably the PK identifier (highlight colour does not show, new
added layers do not show up in MGE Studio, if not restarting the WWW and MG
service, ...). I think there is a lot of caching behing MGE or the Autodesk
FDO.

Dejan

-----

Dejan Gregor, MSc
GISc Researcher and Consultant

http://www.linkedin.com/in/dgregor
--
View this message in context: http://n2.nabble.com/Impossible-to-select-an-object-on-map-mapguide-tp3806579p4291646.html
Sent from the FDO Users mailing list archive at Nabble.com.
_______________________________________________
fdo-users mailing list
fdo-users at lists.osgeo.org<mailto:fdo-users at lists.osgeo.org>
http://lists.osgeo.org/mailman/listinfo/fdo-users

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/fdo-users/attachments/20100112/571a7d1e/attachment-0001.html