you can just 'touch' the datasource to force a refresh of the cached schema
just get the XML resourceContent and overwrite the existing featureSource On Wed, Mar 12, 2008 at 3:13 AM, Bruce Dechant <[EMAIL PROTECTED]> wrote: > Jackie, > > If you want to disable FDO caching for a specific provider you can do the > following: > > In the serverconfig.ini file edit the DataConnectionPoolExcludedProviders > parameter. Example below: (disables it for ODBC and MySql) > > DataConnectionPoolExcludedProviders = OSGeo.ODBC,OSGeo.MySQL > > If you want to disable it for all providers you can do the following: > > DataConnectionPoolEnabled = 0 > > Warning: Doing this does impact performance, especially for RDBMS (Oracle, > etc...) > > Note: The SDF and SHP providers are already excluded from the data > connection pooling because of a FDO defect, but even though they are excluded > they are still fast. > > Thanks, > Bruce > > > -----Original Message----- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jackie Ng > Sent: Monday, March 10, 2008 10:40 PM > To: [email protected] > > > Subject: RE: [mapguide-users] Problems with SDF/Database Joins (Oracle) > > > Hi Bruce, > > I too find this "problem" annoying during the development/testing stages, as > our db schemas are in flux. Having to restart mapguide everytime the db > changes is time consuming. > > So how would I go about disabling caching on a per-provider level? > > - Jackie > > > Bruce Dechant wrote: > > > > 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: [email protected] > > 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 > > [email protected] > > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > _______________________________________________ > > mapguide-users mailing list > > [email protected] > > http://lists.osgeo.org/mailman/listinfo/mapguide-users > > > > > > -- > View this message in context: > http://www.nabble.com/Problems-with-SDF-Database-Joins-%28Oracle%29-tp15906732s16610p15974750.html > Sent from the MapGuide Users mailing list archive at Nabble.com. > > _______________________________________________ > mapguide-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users > _______________________________________________ > mapguide-users mailing list > [email protected] > http://lists.osgeo.org/mailman/listinfo/mapguide-users > -- Zac Spitzer - http://zacster.blogspot.com (My Blog) +61 405 847 168 _______________________________________________ mapguide-users mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/mapguide-users
