Transaction state on connection Idle/Open/Failed

From: David Wall <d(dot)wall(at)computer(dot)org>
To: pgsql-general(at)lists(dot)postgresql(dot)org, pgsql-jdbc(at)lists(dot)postgresql(dot)org
Subject: Transaction state on connection Idle/Open/Failed
Date: 2019-08-16 19:57:50
Message-ID: 07cb7902-20a3-b139-096d-cdfffca7d3cd@computer.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-jdbc

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.

Thanks,
David

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Susan Hurst 2019-08-16 20:00:53 Re: Missing Trigger after pgdump install
Previous Message Ken Tanzer 2019-08-16 19:30:33 Re: A 3 table join question

Browse pgsql-jdbc by date

  From Date Subject
Next Message Adrian Klaver 2019-08-17 17:27:04 Re: Transaction state on connection Idle/Open/Failed
Previous Message Sehrope Sarkuni 2019-08-05 15:35:37 Re: Wish to subsribe the this list