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

[Jackie Ng]

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.