From derby-user-return-6498-apmail-db-derby-user-archive=db.apache.org@db.apache.org Mon Mar 26 22:32:04 2007 Return-Path: Delivered-To: apmail-db-derby-user-archive@www.apache.org Received: (qmail 88972 invoked from network); 26 Mar 2007 22:32:03 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 26 Mar 2007 22:32:03 -0000 Received: (qmail 44107 invoked by uid 500); 26 Mar 2007 22:32:10 -0000 Delivered-To: apmail-db-derby-user-archive@db.apache.org Received: (qmail 43760 invoked by uid 500); 26 Mar 2007 22:32:08 -0000 Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Discussion" Delivered-To: mailing list derby-user@db.apache.org Received: (qmail 43749 invoked by uid 99); 26 Mar 2007 22:32:08 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 26 Mar 2007 15:32:08 -0700 X-ASF-Spam-Status: No, hits=-0.0 required=10.0 tests=SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: domain of fabian2007@merkisoft.ch designates 82.195.224.25 as permitted sender) Received: from [82.195.224.25] (HELO mail.genotec.ch) (82.195.224.25) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 26 Mar 2007 15:31:59 -0700 Received: from fabi (84-73-64-116.dclient.hispeed.ch [84.73.64.116]) by mail.genotec.ch (Postfix) with ESMTP id 13A2E16C6BA0 for ; Tue, 27 Mar 2007 00:31:35 +0200 (CEST) Message-ID: <008101c76ff7$bddbc390$6402a8c0@fabi> From: "Fabian Merki" To: "Derby Discussion" References: <007901c76ad7$45acbd90$6402a8c0@fabi> <46016415.6050609@amberpoint.com> Subject: Re: Oracle Database Synchronization Date: Tue, 27 Mar 2007 00:40:23 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1807 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1896 X-Virus-Checked: Checked by ClamAV on apache.org look at daffodil i did some test with it and wrote an assignement about master-master replication http://merkisoft.ch/projects/replication/ have fun! fabian ----- Original Message ----- From: "Sedillo, Derek (Mission Systems)" To: "Derby Discussion" Sent: Tuesday, March 27, 2007 12:04 AM Subject: Oracle Database Synchronization Hello, Currently we are looking at using Derby as a cache for a larger Oracle database to 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 Derby 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 Derby 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