Re: Connection Idle in transaction - Mailing list pgsql-jdbc

From David Wall
Subject Re: Connection Idle in transaction
Date
Msg-id 024e01c41dd2$046852e0$3201a8c0@rasta
Whole thread Raw
In response to Connection Idle in transaction  (Gaetano Mendola <mendola@bigfoot.com>)
Responses Re: Connection Idle in transaction
Re: Connection Idle in transaction
List pgsql-jdbc
> Not block sorry, but the vacuum is not able to free all the row updated
> by other connections.

But each connection shouldn't have any updated rows that haven't been
committed or rolled back.  Now, if you are running some statements against a
connection and then never calling commit/rollback, that's another thing
since you are actually tying up resources then.  But since the driver just
does a 'begin' after any given commit/rollback, there shouldn't be anything
locked by that connection.

David


pgsql-jdbc by date:

Previous
From: Gaetano Mendola
Date:
Subject: Re: Connection Idle in transaction
Next
From: Oliver Jowett
Date:
Subject: Re: Connection Idle in transaction