Re: "Idle in Transaction" and hung connections - Mailing list pgsql-general

From Kris Jurka
Subject Re: "Idle in Transaction" and hung connections
Date
Msg-id Pine.BSO.4.56.0404301047420.23452@leary.csoft.net
Whole thread Raw
In response to Re: "Idle in Transaction" and hung connections  ("Gregory S. Williamson" <gsw@globexplorer.com>)
Responses Load Balancing and Backup
List pgsql-general

On Fri, 30 Apr 2004, Gregory S. Williamson wrote:

>
> Sounds like an excellent suggestion ... we'll get a copy of this release.
>
> Do you know of any incompatabilities with postgres 7.4 ?
>
>  We can upgrade a server to 7.5 and the JDBC, put running some servers
> on 7.4/7.4 JDBC might be, uhm, difficult for me to sell operations (and
> we have only seen this problem in runtime). We might also be able to
> look at certain portions of the CVS code and see what changed and make
> backward patches ? (forwarding a suggestion from our engineering people)
>

You don't need to upgrade a server to use the latest JDBC driver, it has
support going back to at least 7.1.  I've produced a patch and set of
binary drivers for the 7.4 series available here:

http://www.ejurka.com/pgsql/jars/transaction_state/

This code has not gotten a whole lot of testing so I'd be careful just
dropping it into a production situation.

Kris Jurka


pgsql-general by date:

Previous
From: Michael Meskes
Date:
Subject: Re: synchronizing MS access and postgresql tables
Next
From: Ian Ribas
Date:
Subject: Re: Optimizer choosing smaller index instead of right one