| From: | John R Pierce <pierce(at)hogranch(dot)com> |
|---|---|
| To: | Scot Kreienkamp <SKreien(at)la-z-boy(dot)com> |
| Cc: | Donald Day <dday01(at)la-z-boy(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Idle in transaction help |
| Date: | 2009-07-10 21:17:51 |
| Message-ID: | 4A57AFFF.2040106@hogranch.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Scot Kreienkamp wrote:
> It is Java. I asked our programmers to check on the JDBC version as I
> had seen that on the list previously. It is using postgresql-8.2-504.
> Is that one of the problem versions? I had thought it was new enough
> that it would not be subject to that problem.
>
well, the current JDBC for 8.2 is build 510. see
http://jdbc.postgresql.org/download.html
It does appear the idle-in-transaction bug I'm remembering is pretty
old... it was fixed in Version 8.0-dev302 (2004-06-15), heh. your
version is from 2006-12-01. I would still consider upgrading, there
have been a lot of fixes and enhancements between 504 and 510... See
http://jdbc.postgresql.org/changes.html for a revision history.
Remember, if you have autocommit OFF, then even read-only (select-only)
connections need commits, or they stay in transaction.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stuart McGraw | 2009-07-10 22:06:52 | Re: psql language |
| Previous Message | Scott Marlowe | 2009-07-10 21:02:32 | Re: is autovacuum recommended? |