Friday, October 05, 2007

Mapguide refresh the King.Oracle schema cache trick

I hit an issue today with mapguide, i was creating a table and then creating a layer to view it.

GetClassDefinition kept crashing with "The specified class was not found." Turns out for performance reasons King Oracle caches the SDO_GEOM_METADATA for the class list and there is no simple API way to fix this.

I swapped a few emails with Harris and then as a last attempt I updated the FeatureSource XML with a simple save, which turns out to cause Mapguide to refresh King Oracle and read in the new SDO_GEOM_METADATA.

I didn't hit this so often when i was doing dev, because there is a 10 minute timeout for FDO providers.

No comments: