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
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 |
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 |