Re: XA support (distributed transactions)

From: "Heikki Linnakangas" <heikki(at)enterprisedb(dot)com>
To: <josh(at)agliodbs(dot)com>
Cc: <pgsql-hackers(at)postgresql(dot)org>, "Florian G(dot) Pflug" <fgp(at)phlo(dot)org>, "Danny Milosavljevic" <danny(dot)milosavljevic(at)fabalabs(dot)org>
Subject: Re: XA support (distributed transactions)
Date: 2006-11-21 10:09:40
Message-ID: 4562D064.9040008@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Josh Berkus wrote:
> Florian,
>
>> I believe there are open-source implementations of such transaction
>> managers, but I don't have any links at hand.
>
> In Java, the Sequoia Project.

I haven't used Sequoia, but I don't think you can use it as a general
purpose transaction manager. It does take care of replicating updates to
all the databases it controls, but AFAIK you can't use it to perform ad
hoc distributed transactions across resource managers.

There is a lot of open source JTA (Java Transaction API) transaction
manager implementations, though. JOTM and SimpleJTA to name a few. And
all the J2EE application server implementations include a transaction
manager as well.

I'm not aware of any open source non-Java transaction managers.

--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-11-21 10:13:57 Re: [PATCHES] WIP 2 interpreters for plperl
Previous Message Russell Smith 2006-11-21 09:39:04 Re: Statistics visibility in SERIALIZABLE transactions