Skip site navigation (1) Skip section navigation (2)

Re: Transactional support across multiple machines...

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 (view raw or flat)
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



      

In response to

Responses

pgsql-jdbc by date

Next:From: Maciek SakrejdaDate: 2010-11-17 19:15:36
Subject: Re: Transactional support across multiple machines...
Previous:From: Heikki LinnakangasDate: 2010-11-17 18:47:13
Subject: Re: Transactional support across multiple machines...

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group