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

[Bruce Dechant]

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