[mapguide-users] MapGuide OSGeo.ODBC FDO not releasing schema cache

[Zac Spitzer]

that would be need to be done in code....

just use maestro

2009/12/23 neilyoung <neil.young at ch2m.com>:
>
> Thanks for the quick reply.
>
> Please Forgive my ignorance, but how exactly would I do that?
>
> I went to the mapagent index, and selected GetResourceContent, but all i got
> was a few lines of text. What would I do with that to perform the
> SetResouceContent?
>
>
> zspitzer wrote:
>>
>> just save the feature source definition, that will flush the cache
>>
>> either via studio/maestro or via the api
>>
>> geResourceContent then  setResourceContent
>>
>>
>>
>> 2009/12/23 neilyoung <neil.young at ch2m.com>:
>>>
>>> I have numerous layers pointing ot the same ODBC connection using a DSN
>>> pointing to a SQL Server database.
>>>
>>> We have changed the schema, however when looking at the tables, we do not
>>> see the updates to the schema.
>>>
>>> I have disabled caching for the OSGEO.ODBC FDO
>>> (DataConnectionPoolExcludedProviders = OSGeo.ODBC), and restarted the
>>> service and the new schema still isn't showing up. Even if I create a new
>>> DSN on the server if the database name referred to in the DSN is the
>>> same,
>>> then the old schema still shows up.
>>>
>>> Any ideas on how the cache can be removed? It seems as though it may not
>>> be
>>> caching, but the the cache still remains.
>>>
>>> All assistance is appreciated.
>>> --
>>> View this message in context:
>>> http://n2.nabble.com/MapGuide-OSGeo-ODBC-FDO-not-releasing-schema-cache-tp4206600p4206600.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
>>>
>>
>>
>>
>> --
>> Zac Spitzer
>> Solution Architect / Director
>> Ennoble Consultancy Australia
>> http://www.ennoble.com.au
>> http://zacster.blogspot.com
>> +61 405 847 168
>> _______________________________________________
>> mapguide-users mailing list
>> mapguide-users at lists.osgeo.org
>> http://lists.osgeo.org/mailman/listinfo/mapguide-users
>>
>>
>
> --
> View this message in context: http://n2.nabble.com/MapGuide-OSGeo-ODBC-FDO-not-releasing-schema-cache-tp4206600p4206675.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
>



-- 
Zac Spitzer
Solution Architect / Director
Ennoble Consultancy Australia
http://www.ennoble.com.au
http://zacster.blogspot.com
+61 405 847 168