From [mapguide-users] Forum: Oracle Spatial with Adsk MapGuide FDO
Francisco Javier Rojas Duran
francisco.rojas at dasoft.com.mx
Sat Feb 3 18:41:22 EST 2007
Reading from the old one discussion group and I realize that I need that
MapGuideEnterprise 2007 FDO 3.1 displays the Oracle Views, so the
explanation given below shows a way to do that but with MapGuideEnt 2007
without SP, there is any change since that. Also I don't know precisely
where to write the following lines to see my Oracle Views.
Francisco J. Rojas Duran
Autodesk Developer Network Member
De: Robert Fortin [mailto:robert.fortin at autodesk.com]
Enviado el: Jueves, 31 de Agosto de 2006 03:40 p.m.
Para: users at mapguide.osgeo.org
Asunto: RE: [mapguide-users] RE: Oracle Spatial v/s Oracle Locator with
We are aware of some performance problem in the current version of
MapGuide wt Oracle provider and are currently working on these issue at
2 levels: MapGuide itself and Oracle provider.
So what you seem to suggest is that the issue is related to performance
and not to the fact that data is not retrieved. I read the issue you
discussed and it is related to the fact that MapGuide reconnect to the
FDO provider on every request. We optimized that query and the entire
reverse engineering process which should help quite a bit. This will be
available in MapGuide-SP1 for which I don't have an official date yet.
Orest already provided you with guideline for reverse engineering but he
omitted to mentionned that views are not reversed engineered
automatically. You need to modify the config file used by MapGuide to
establish the connection and add entry to load the view. The config file
would have to add a section of that form at the end.
Hope it helps a bit.
From: Joel Carranza [mailto:jec at gatekeeper.com]
Sent: Thursday, August 31, 2006 3:56 PM
To: users at mapguide.osgeo.org
Subject: [mapguide-users] RE: Oracle Spatial v/s Oracle Locator with
"It has some restriction if they are not present but the data should be
readable in MapGuide through the provider."
What are the restrictions?
Our use case resembles the following: Oracle 10g (Locator) with indexed
spatial data loaded with internal tools, i.e. No F_* metadata tables,
but all data appropriately loaded into SDO_GEOM_METADATA. The exact same
schema we are using to serve out MapGuide 6.5 data.
Results: terrible performance. I suspect it is related to these problems
regarding metadata. See my post here about my attempt to discover
Now, if I were to reload this informating using Map, would everything
"just work" ?
Robert Fortin wrote:
> The Oracle provider doesn't require the F_* tables to work with
> MapGuide. It has some restriction if they are not present but the
> data should be readable in MapGuide through the provider. The F_* are
> used to store the FDO metadata. If these tables are not present, the
> FDO schema will be generated by reverse engineering the Oracle table
> If you have some use case that doesn't work, we certainly would like
> to know about it.
> -----Original Message-----
> From: Joel Carranza [mailto:jec at gatekeeper.com]
> Sent: Thursday, August 31, 2006 3:20 PM
> To: users at mapguide.osgeo.org
> Subject: Re: [mapguide-users] Oracle Spatial v/s Oracle Locator with
> MapGuide FDO
> I wonder if you could follow up a little bit on your statement:
> "Oracle provider ... require(s) the F_* Autodesk catalog tables (which
> the AutoDesk provider shipped with their per pay version...)"
> I was not aware of this. It would explain alot about why we can't get
> anything to work. Is this an explicit fact or simply an impression you
> got after trying to get things to work? Can you point me to some
View this message in context:
Sent from the OSGeo MapGuide forum at Nabble.com.
To unsubscribe, e-mail: users-unsubscribe at mapguide.osgeo.org
For additional commands, e-mail: users-help at mapguide.osgeo.org
More information about the mapguide-users