IC5Notice: We have upgraded developerWorks Community to the latest version of IBM Connections. For more information, read our upgrade FAQ.
Topic
  • 2 replies
  • Latest Post - ‏2007-03-27T19:02:49Z by SystemAdmin
SystemAdmin
SystemAdmin
1525 Posts

Pinned topic Oracle Database Synchronization

‏2007-03-27T14:20:26Z |
Hello,

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.

  • Derek
Updated on 2007-03-27T19:02:49Z at 2007-03-27T19:02:49Z by SystemAdmin
  • Jean_Anderson
    Jean_Anderson
    179 Posts

    Re: Oracle Database Synchronization

    ‏2007-03-27T14:34:59Z  
    Custom procedures are certainly an option that users have used with many databases, but they tend to not be reliable when errors occur, systems go down, etc.

    The Derby wiki lists some replication products that might help:
    http://wiki.apache.org/db-derby/UsesOfDerby#ProductsByType

    Regarding funambol, it used to be called sync4j and there's a developerWorks article showing how to use Derby with it:
    http://www.ibm.com/developerworks/java/library/j-sync4j/

    Also, Sequoia might do it (and probably more than you need):
    http://sequoia.continuent.org/HomePage

    regards,

    -jean
  • SystemAdmin
    SystemAdmin
    1525 Posts

    Re: Oracle Database Synchronization

    ‏2007-03-27T19:02:49Z  
    Custom procedures are certainly an option that users have used with many databases, but they tend to not be reliable when errors occur, systems go down, etc.

    The Derby wiki lists some replication products that might help:
    http://wiki.apache.org/db-derby/UsesOfDerby#ProductsByType

    Regarding funambol, it used to be called sync4j and there's a developerWorks article showing how to use Derby with it:
    http://www.ibm.com/developerworks/java/library/j-sync4j/

    Also, Sequoia might do it (and probably more than you need):
    http://sequoia.continuent.org/HomePage

    regards,

    -jean
    Jean,

    Thanks for the info on these open source projects. I will look into them as potential options.

    • Derek