Re: Postgres XA support - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: Postgres XA support
Date
Msg-id 43012F6F.3020709@opencloud.com
Whole thread Raw
In response to Re: Postgres XA support  (Michael Allman <msa@allman.ms>)
Responses Re: Postgres XA support  (Michael Allman <msa@allman.ms>)
List pgsql-jdbc
Michael Allman wrote:

> Key to the protocol is the ability to start and end the association of
> transactions to threads of control.  In particular, what's bothering me
> is that there appears to be no way to end the transaction association of
> the current postgres connection, either permanently or for suspension.
> Please correct me if I'm wrong.
>
> Thus work performed using the underlying physical connection of a
> PGXAResource unassociated with any transaction will still be performed
> on the connection's transaction.

You'll need another layer to support all of XA's behaviour -- this was
the discussion about mapping XA connections to physical connections that
happened on the list a while back, wasn't it?

It's probably unnecessary for the first cut, though. What exactly is the
behaviour that you can't support without that extra layer, and is it
needed for common use of XA? Seems to me that you could get away with
just disallowing work on a Connection that has an unprepared XA
transaction pending.

-O

pgsql-jdbc by date:

Previous
From: Michael Allman
Date:
Subject: Re: Postgres XA support
Next
From: Michael Allman
Date:
Subject: Re: Postgres XA support