[mapguide-users] MapGuide 2.2 ODBC schema walk on Oracle 10g

[Zac Spitzer]

Nasty indeed....

there isn't any oracle specific logic in the ODBC provider is there?

just a generic, enumerate everything visible and the describe?

z

On 30 June 2010 12:09, Trevor Wekel <trevor_wekel at otxsystems.com> wrote:
> Hello,
>
> I am posting this to -users since it may be of public interest.  I have an Oracle 10g XE database with a single user and three attribute tables.  There are no spatial tables in the database.  When I create an ODBC database connection using Maestro or Autodesk MapGuide Studio 2011, the UI freezes for about five minutes.
>
> Turning on trace logging reveals that the MapGuide Server is executing DescribeSchemaAsXML for the three tables owned by the user and all of the public synonyms visible to the user.  This includes tables like ALL_CATALOG, CTX_OBJECTS, and WWV_FLOW_HOURS_12 just to name a few.
>
> Does anyone have any suggestions on how to limit the schema walk to only return the tables owned by the Oracle user?
>
> Thanks,
> Trevor
>
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
>



-- 
Zac Spitzer
Solution Architect / Director
Ennoble Consultancy Australia
http://www.ennoble.com.au
http://zacster.blogspot.com
+61 405 847 168