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.klaver@aklaver.com