| Lists: | pgsql-general |
|---|
| From: | Christian Ferrari <camauz(at)yahoo(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | PostgreSQL and XA Distributed Transaction Protocol |
| Date: | 2009-06-06 20:51:38 |
| Message-ID: | 2190.60705.qm@web24407.mail.ird.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Hi all,
I'm developing a new, free, XA compliant transaction manager.
One of the first resource manager I would be glad to support is PostgreSQL; after some googling I have found no information related to PostgreSQL and XA protocol support.
Can anyone give me more information related to this matter?
Thanks in advance.
Regards
Ch.
| From: | Martin Gainty <mgainty(at)hotmail(dot)com> |
|---|---|
| To: | <camauz(at)yahoo(dot)com>, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL and XA Distributed Transaction Protocol |
| Date: | 2009-06-06 22:03:39 |
| Message-ID: | BLU142-W1930885AF4ADA313264BAAE490@phx.gbl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
from what i can see here autocommit is not supported
http://archives.postgresql.org/pgsql-jdbc/2009-01/msg00027.php
Not sure if autocommit is part of the JTA spec?
Martin Gainty
______________________________________________
Verzicht und Vertraulichkeitanmerkung/Note de déni et de confidentialité
Diese Nachricht ist vertraulich. Sollten Sie nicht der vorgesehene Empfaenger sein, so bitten wir hoeflich um eine Mitteilung. Jede unbefugte Weiterleitung oder Fertigung einer Kopie ist unzulaessig. Diese Nachricht dient lediglich dem Austausch von Informationen und entfaltet keine rechtliche Bindungswirkung. Aufgrund der leichten Manipulierbarkeit von E-Mails koennen wir keine Haftung fuer den Inhalt uebernehmen.
Ce message est confidentiel et peut être privilégié. Si vous n'êtes pas le destinataire prévu, nous te demandons avec bonté que pour satisfaire informez l'expéditeur. N'importe quelle diffusion non autorisée ou la copie de ceci est interdite. Ce message sert à l'information seulement et n'aura pas n'importe quel effet légalement obligatoire. Étant donné que les email peuvent facilement être sujets à la manipulation, nous ne pouvons accepter aucune responsabilité pour le contenu fourni.
Date: Sat, 6 Jun 2009 20:51:38 +0000
From: camauz(at)yahoo(dot)com
Subject: [GENERAL] PostgreSQL and XA Distributed Transaction Protocol
To: pgsql-general(at)postgresql(dot)org
Hi all,
I'm developing a new, free, XA compliant transaction manager.
One of the first resource manager I would be glad to support is PostgreSQL; after some googling I have found no information related to PostgreSQL and XA protocol support.
Can anyone give me more information related to this matter?
Thanks in advance.
Regards
Ch.
_________________________________________________________________
Insert movie times and more without leaving Hotmail®.
http://windowslive.com/Tutorial/Hotmail/QuickAdd?ocid=TXT_TAGLM_WL_HM_Tutorial_QuickAdd_062009
| From: | "Albe Laurenz" <laurenz(dot)albe(at)wien(dot)gv(dot)at> |
|---|---|
| To: | "Christian Ferrari *EXTERN*" <camauz(at)yahoo(dot)com>, <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: PostgreSQL and XA Distributed Transaction Protocol |
| Date: | 2009-06-08 09:42:59 |
| Message-ID: | D960CB61B694CF459DCFB4B0128514C202FF6633@exadv11.host.magwien.gv.at |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-general |
Christian Ferrari wrote:
> I'm developing a new, free, XA compliant transaction manager.
> One of the first resource manager I would be glad to support
> is PostgreSQL; after some googling I have found no
> information related to PostgreSQL and XA protocol support.
> Can anyone give me more information related to this matter?
To the best of my knowledge, the only XA interface in PostgreSQL
is SQL.
A session participating in a distributed transaction would
issue "PREPARE TRANSACTION <name>", and the transaction manager
can "COMMIT PREPARED <name>" or "ROLLBACK PREPARED <name>".
The currently active prepared transactions cann be seen in
the pg_prepared_xacts system catalog.
That should be good enough to implement a transaction manager,
right?
Yours,
Laurenz Albe