[mapguide-users] Problems with SDF/Database Joins (Oracle)
Zac Spitzer
zac.spitzer at gmail.com
Tue Mar 11 18:59:09 EDT 2008
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
<bruce.dechant at autodesk.com> 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: mapguide-users-bounces at lists.osgeo.org [mailto:mapguide-users-bounces at lists.osgeo.org] On Behalf Of Jackie Ng
> Sent: Monday, March 10, 2008 10:40 PM
> To: mapguide-users at lists.osgeo.org
>
>
> 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: 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
> > _______________________________________________
> > mapguide-users mailing list
> > mapguide-users at lists.osgeo.org
> > 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
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
> _______________________________________________
> mapguide-users mailing list
> mapguide-users at lists.osgeo.org
> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>
--
Zac Spitzer -
http://zacster.blogspot.com (My Blog)
+61 405 847 168
More information about the mapguide-users
mailing list