Re: "Idle in Transaction" revisited. - Mailing list pgsql-jdbc

From Oliver Jowett
Subject Re: "Idle in Transaction" revisited.
Date
Msg-id 414CB3D0.8020800@opencloud.com
Whole thread Raw
In response to Re: "Idle in Transaction" revisited.  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-jdbc
Tom Lane wrote:
> Jeffrey Tenny <jeffrey.tenny@comcast.net> writes:
>
>>Are you saying that I will see stale database state at the logical
>>"start" of my transaction from a pooled connection?
>
>
>>That's a showstopper for sure. If I'm confused please enlighten me.
>
>
> Apparently you are confused, because the JDBC behavior has always
> been like that; it's only the current devel driver that fixes it.

That's not entirely true; 7.3-era drivers (which I think is what is
being used here) used "set autocommit" rather than explicit BEGIN. It
went back to using BEGIN again when 7.4 removed that option.

-O

pgsql-jdbc by date:

Previous
From: "John R Pierce"
Date:
Subject: Re: Issues regarding code license of ported code.
Next
From: Oliver Jowett
Date:
Subject: Re: "Idle in Transaction" revisited.