I looked at the link you provided me. However, I am still confused. I have three different connections to three different databases. If I call PREPARE_TRANSACTION and COMMIT_PREPARED on each machine, it may still not be atomic.
I would think one would need some kind of distributed transaction coordinator such as Java Transactional API (JTA).
I appreciate your help.
Regards, Peter
From: Maciek Sakrejda <msakrejda@truviso.com> To: Peter Tap <ptrtap@yahoo.com> Cc: pgsql-jdbc@postgresql.org Sent: Wed, November 17, 2010 10:40:57 AM Subject: Re: [JDBC] Transactional support across multiple machines...