Re: Transactional support across multiple machines...

Поиск
Список
Период
Сортировка
От Peter Tap
Тема Re: Transactional support across multiple machines...
Дата
Msg-id 958934.2354.qm@web62307.mail.re1.yahoo.com
обсуждение исходный текст
Ответ на Re: Transactional support across multiple machines...  (Maciek Sakrejda <msakrejda@truviso.com>)
Список 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@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...

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

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Maciek Sakrejda
Дата:
Сообщение: Re: Transactional support across multiple machines...
Следующее
От: Michael Fork
Дата:
Сообщение: Re: PSQLException: The column name was not found in this ResultSet.