From [mapguide-users] Forum: Oracle Spatial with Adsk MapGuide FDO

[Francisco Javier Rojas Duran]

Hi Robert:

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.

<SchemaMapping xmlns="http://www.autodesk.com/isd/fdo/OracleProvider"
xmlns:rdb="http://fdordbms.osgeo.org/schemas" provider="Autodesk.Oracle.3.0"
name="Schema_AB">
  <AutoGeneration geomTypeMaxRows="0">
  <TableList>
  <Name>MY_VIEW1</Name> 
  <Name>MY_VIEW2</Name> 
  </TableList>
  </AutoGeneration>
</SchemaMapping>

Regards

Francisco J. Rojas Duran
Autodesk Developer Network Member

-----Mensaje original-----
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
MapGuide FDO

Joel,

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.

<SchemaMapping xmlns="http://www.autodesk.com/isd/fdo/OracleProvider"
xmlns:rdb="http://fdordbms.osgeo.org/schemas"
provider="Autodesk.Oracle.3.0" name="Schema_AB">
  <AutoGeneration geomTypeMaxRows="0">
  <TableList>
  <Name>MY_VIEW1</Name> 
  <Name>MY_VIEW2</Name> 
  </TableList>
  </AutoGeneration>
</SchemaMapping>

Hope it helps a bit.

RF 

-----Original Message-----
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
MapGuide FDO


Robert,

"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
problem http://discussion.autodesk.com/thread.jspa?threadID=486000

Now, if I were to reload this informating using Map, would everything
"just work" ?

Joel


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 
> definitions.
> 
> If you have some use case that doesn't work, we certainly would like 
> to know about it.
> 
> RF
> 
> -----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
> 
> 
> Simon,
> 
> 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 
> documentation?
> 
> Thanks
> Joel
> 
> 
> 
View this message in context:
http://www.nabble.com/Oracle-Spatial-v-s-Oracle-Locator-with-MapGuide-FD
O-tf2194071.html#a6086989
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