Re: Transaction state on connection Idle/Open/Failed

On 8/16/19 12:57 PM, David Wall wrote:
> In JDBC (latest version), I'm using the
> org.postgresql.jdbc.PgConnection.getTransactionState() that returns an
> enumeration of IDLE, OPEN or FAILED.
>
> I am familiar with IDLE, meaning the connection has a new transaction
> started, but isn't doing anything.  We think of this as the "normal"
> state for our connections.
>
> How does OPEN compare to IDLE?  If we stop using a connection that's in
> the OPEN state, is something wrong?  That is, does it have pending
> updates that require a commit/rollback?
>
> Same for FAILED.  If we no longer need a connection in the FAILED state,
> is something wrong?  Does it have pending updates that require a
> commit/rollback (assuming in this state rollback makes more sense).
>
> I'm really trying to find out what it means for the connection to be in
> OPEN or FAILED states compared to IDLE.

https://jdbc.postgresql.org/development/privateapi/org/postgresql/core/ProtocolConnection.html

>
> Thanks,
> David
>
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com