XA 2 phase

From: Jeff MacDonald <jeff(at)hub(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: XA 2 phase
Date: 1999-08-16 19:14:51
Message-ID: Pine.LNX.4.10.9908161613580.4721-100000@penguin.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I was sent this mail, and not sure how to reply to it...

> In transaction processing, a two-phase commit guarantees that synchronous
> transactions across multiple datasources will meet the ACID properties:
> atomic, consistent, isolated, durable. The protocol was standardized by the
> XA group. Most transaction processing books have a good description
> of this. I can't find any mention of support for this in the PostgreSQL
> doc, but maybe it's in there?
>
> On the Java JDBC front, the JDBC 2.0 spec has explicit support for
> the XA two-phase commit for transactions in:
>
> javax.sql.XAConnection
>
> So the questions would be:
>
> 1) Does PostgreSQL support XA 2-phase transactions?
> 2) Does the PostgreSQL JDBC adaptor support this as well?
>
> (Virtually all commercial RDBMs support XA 2-phase transactions,
> however, their Java JDBC driver support for this feature sometimes
> lags behind...)
>

Thanks In advance..
Jeff

======================================================
Jeff MacDonald
jeff(at)hub(dot)org webpage: http://hub.org/~jeff
jeff(at)pgsql(dot)com irc: bignose on EFnet
======================================================

Browse pgsql-general by date

  From Date Subject
Next Message Vadim Mikheev 1999-08-17 01:33:54 Re: [GENERAL] v6.5 foreign key trigger reposted with details
Previous Message Peter Mount 1999-08-16 18:37:06 Re: [GENERAL] [Fwd: Maximum filesize of one file]