[mapguide-users] Problems with SDF/Database Joins (Oracle)

[Bruce Dechant]

Max,

This is related to the caching done by the MapGuide server, but is not a defect.
The problem is that the MapGuide server has no idea that the underlying feature source schema changed. There is no callback from Oracle (or any other provider) to FDO and then finally to the MapGuide server to inform about any schema changes.

If you are going to be making schema changes while you are developing your site then you could temporarily disable the caching of the specific FDO provider you are using. This will also disable the caching of the underlying schemas and classes. Then turn it back on once your schema changes are done.

Alternatively, you can disable the caching of all schemas and classes by setting the "CacheSize" parameter in the serverconfig.ini file to 0. Be warned that by doing this the MapGuide server will be MUCH slower because it will have to get this information from the underlying FDO providers for everything it does.

I can see adding an API to MapGuide that you can call to clear the FDO schema/classes cache being useful in this case. The WebAdmin could be updated to call this to clear the cache without stopping the MapGuide server whenever you made changes to your schemas.

Thanks,
Bruce


-----Original Message-----
From: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Bob Cassarly
Sent: Sunday, March 09, 2008 3:06 PM
To: mapguide-users at lists.osgeo.org
Subject: Re: [mapguide-users] Problems with SDF/Database Joins (Oracle)


Max,

That is the driver I was using from my DSN.
My problem appears to be a problem is with the way MapGuide OS is caching
the database table/columns

If you first create a new Data Connection that uses a DSN (that uses the
Oracle Instant Client 10.2.0.3) it does indeed work and the tables
enumerate.  The problem I noticed with this is that if you change a table or
view definition to add a table/view column the new column does not appear in
the label/theme list.  This seems like a bug to me (especially considering
there does not seem to be a mechanism to update the cache).

If create a Data Source that uses the FDO ODBC Microsoft for Oracle driver
it connect sucessfully to the database but the tables do not enumerate.  If
I save that Data Connection as then later change Data Connection to use a
DSN the tables do not enumerate.  This also seems like a bug to me.

So the question is where are the database tables/columns cached too and is
it possible to refresh the cache.  Personally I would prefer that the
table/column NOT be cached at all but maybe I am asking too much.

Bob



Hi,
        I think you try to connect Oracle Database  with Oracle Instant
Client 10.2.0.3 and  oracle odbc driver-win32 10.2.0.3 .

Try ODBC FDO "Connect via a Data Source Name (DSN) set up on this server"
and use the above DSN which you created using the oracle odbc driver-win32
10.2.0.3 .


Max !!


--
View this message in context: http://www.nabble.com/Problems-with-SDF-Database-Joins-%28Oracle%29-tp15906732s16610p15946485.html
Sent from the MapGuide Users mailing list archive at Nabble.com.

_______________________________________________
mapguide-users mailing list
mapguide-users at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-users