Currently we are planning to use Cloudscape as a cache for a larger Oracle
database that we work with. We can connect to this larger database via
JDBC, but cannot control its code (e.g. triggers, procedures, etc...).
I need to find a way to synchronize some of our Cloudscape tables with it. I
was wondering if someone may have some ideas on synchronization that
doesn't involve changes to the parent database?
I was thinking of writing a update procedure that could be run
periodically from a cron job or? The procedure could connect to the
Oracle DB and Clouscape and retrieve a resultSet from both. I could then
look for a delta between the tables and perform an update with that
delta. But I am not quite sure how I would compare the result sets,
especially in an efficient manner.
Thanks for any ideas you may have on the matter.