Re: jdbc xa support

On Sun, 24 Jul 2005, Heikki Linnakangas wrote:

> On Sat, 23 Jul 2005, Michael Allman wrote:
>
>> On a related note, can we get the backend to indicate if a transaction was
>> read-only when the "PREPARE TRANSACTION" statement is called? (Also, I
>> believe preparing a read-only transaction should automatically "commit"
>> it.) We could then return XA_RDONLY from the driver's prepare() method in
>> that case. As it is, it either throws an exception or returns XA_OK.
>
> It should be possible, but we're already past the feature freeze so it'll
> have to wait for version 8.2. The backend already keeps track which
> transactions are read-only, and skips updating the clog for them. That
> information just needs to be exposed.

Cool. It would be a nice optimization to incorporate in the driver when
it becomes available in the backend.

Michael