From: | Peter Tap <ptrtap(at)yahoo(dot)com> |
---|---|
To: | Maciek Sakrejda <msakrejda(at)truviso(dot)com> |
Cc: | pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Transactional support across multiple machines... |
Date: | 2010-11-17 18:55:21 |
Message-ID: | 958934.2354.qm@web62307.mail.re1.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi Maciek,
Thank you for your help.
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(at)truviso(dot)com>
To: Peter Tap <ptrtap(at)yahoo(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Sent: Wed, November 17, 2010 10:40:57 AM
Subject: Re: [JDBC] Transactional support across multiple machines...
Prepared transactions:
http://www.postgresql.org/docs/9.0/static/sql-prepare-transaction.html
---
Maciek Sakrejda | System Architect | Truviso
1065 E. Hillsdale Blvd., Suite 215
Foster City, CA 94404
(650) 242-3500 Main
www.truviso.com
From | Date | Subject | |
---|---|---|---|
Next Message | Maciek Sakrejda | 2010-11-17 19:15:36 | Re: Transactional support across multiple machines... |
Previous Message | Heikki Linnakangas | 2010-11-17 18:47:13 | Re: Transactional support across multiple machines... |