Update Cache on external Database changes
682050Feb 2 2009 — edited Feb 11 2009We have external system that updates the database at irregular interval of times. The external system doesnt have access to cache and it cant update coherence cache.So is there any way to synchronise the data between database and coherence cache. I know we can use DB triggers to update Queue and custom written pgms to read from Queue and update cache. I am using coherence with hibernate on Oracle 11 DB. Is there any other way to acheive this?
Does coherence has any in built mechanisms to achieve this. As far as i know, Cache store implementation doent depend on underlying database. So that is not possible. But still i wanted to make sure whether that is possible?
And are there any other effiicient mechanisms to acheive what i needed?