this is of course possible with jdbc. Although it might be not sooo easy to do. If your app uses EOF to write changes to one db you either have to query the source db for changed values (you must find a way how to check if a value was updated) or you can use a delegate to reapply the EOAdaptorOperations to another EOF stack which is connected to another database. Check projectwonder (as usual) which already has support to serialize EOAdaptorOperations from finished transactions to disk and which also has support to write these operations to a EOF stack.

I am using such things to synchronize database in cases where normal db replication cannot work because the database are not in the same network, aka offline working and such things. Drop me a line if you need further assistance.


cheers, David

Am 17.10.2005 um 10:23 schrieb Ute Hoffmann:

Hallo,
do you think it si possible to do this:

Have a for-loop which loops through a list of database connections.
Each loop sets the value of a given modelfile to those of a different DB, then makes a connection, updates some values, closes the connection....

Is that possible or will I get myself into trouble with that design.

Background: I have a number of identical DB's and want to update/ hand over some values from a different WOApp into those DB's.

Some advice will be appreciated.

Regards,

Ute

_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/david.teran% 40cluster9.com

This email sent to [EMAIL PROTECTED]



_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list      ([email protected])
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to