Yes, this is possible; it's a mere matter of programming :)
It would seem to me you could do this in a number of ways. You could
have a timestamp column in all of your Derby tables, and then query each
table to see what rows were modified since the last time you updated Oracle.
Alternately, you could write a trigger on insert/update/delete of each
table, which then logs the change to a "to-be-done" table. Then you
simply select all the changes from the "to-be-done" table, apply them,
and then clean out the table. This solution uses less time and is less
intrusive but requires more space.
David
Yekesa Kosuru wrote:
Hi All,
I'd like to use Apache Derby in front of Oracle DB.
We have bunch of clients that would be writing data to
Derby db. And, periodically (every minute or so), we
want to write all updates back to Oracle db.
Is this possible ?, we would be running Derby as a
Network Server.
Thanks for any insights,
Vissu
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
