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: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bob Cassarly Sent: Sunday, March 09, 2008 3:06 PM To: mapguide-users@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@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users _______________________________________________ mapguide-users mailing list mapguide-users@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/mapguide-users
