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

From John R Pierce
Subject Re: "Idle in Transaction" revisited.
Date
Msg-id 0e3701c49d19$e8a90230$0200a8c0@hogranch.com
Whole thread Raw
In response to "Idle in Transaction" revisited.  ("John R Pierce" <pierce@hogranch.com>)
Responses Re: "Idle in Transaction" revisited.
List pgsql-jdbc
> Yeah, that's from prematurely issuing BEGIN.  I believe there's a
> solution for this in the most recent JDBC driver versions --- but
> I dunno if it's in any official releases yet.

Its my understanding from reading the prior threads on this that somewhere
after jdbc 213 they moved the initial BEGIN to the first SQL Execute rather
than immediately upon Connection.

When an app does a Commit or Rollback, this generates an END;

After this END; does a new BEGIN happen immediately, or is it postponed
until the next Execute ?



pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: "Idle in Transaction" revisited.
Next
From: Oliver Jowett
Date:
Subject: Re: "Idle in Transaction" revisited.