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
======================================================
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] |