Thread: Idle in Transaction ..
Hi, we ran into an issue that looks like http://osdir.com/ml/ db.postgresql.jdbc/2004-04/msg00108.html We also use a connection pool. The thread indicates that there could be some changes in the jdbc drivers to change the behaviour with autocommit disabled. Has this been implemented? If so when? Does that need additional properties to enable it? Is that issue also dependent on the server version? I don't think so from reading the thread. Many thanks Heiko
Hi, > we ran into an issue that looks like http://osdir.com/ml/ > db.postgresql.jdbc/2004-04/msg00108.html > We also use a connection pool. The thread indicates that there > could be some changes in the > jdbc drivers to change the behaviour with autocommit disabled. > I see those implemented in dev302 - did this then automatically make its way into 8.0-308 and so on (especially the 8.0-312 driver)? The icons on the changelog page are unfortunately not clear to me. Thanks Heiko
Yes, according to the change log it was fixed in 302. Why are you using 8.0 anyway ? It's verging on end of life ? Dave Heiko W.Rupp wrote: > Hi, > >> we ran into an issue that looks like >> http://osdir.com/ml/db.postgresql.jdbc/2004-04/msg00108.html >> We also use a connection pool. The thread indicates that there could >> be some changes in the >> jdbc drivers to change the behaviour with autocommit disabled. >> > I see those implemented in dev302 - did this then automatically make > its way into > 8.0-308 and so on (especially the 8.0-312 driver)? > > The icons on the changelog page are unfortunately not clear to me. > > Thanks > Heiko > > > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend >
Hi, On Wed, 2007-09-26 at 07:16 -0400, Dave Cramer wrote: > Why are you using 8.0 anyway ? It's verging on end of life ? Only Windows version is going to be EOLed. I just wanted to avoid any confusion :) Regards, -- Devrim GÜNDÜZ PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, ODBCng - http://www.commandprompt.com/
Attachment
On Tue, 25 Sep 2007, Heiko W.Rupp wrote: >> we ran into an issue that looks like >> http://osdir.com/ml/db.postgresql.jdbc/2004-04/msg00108.html >> We also use a connection pool. The thread indicates that there could be >> some changes in the >> jdbc drivers to change the behaviour with autocommit disabled. >> > I see those implemented in dev302 - did this then automatically make its way > into > 8.0-308 and so on (especially the 8.0-312 driver)? Yes, it did. > The icons on the changelog page are unfortunately not clear to me. > The icons simply describe the type of change: update/add/fix/... Kris Jurka
Am 26.09.2007 um 13:16 schrieb Dave Cramer:
> Yes, according to the change log it was fixed in 302.
>
> Why are you using 8.0 anyway ? It's verging on end of life ?
>
Well, it is deployed on running systems at customers (running 8.2.4
on the backend side).
Unfortunately the customer reported errors and the situation very
much looks like
that old pre 302 situation. That is why I ask if 312 should have the
fix (and thus already
be implemented at the customer) or not.
Thanks
Heiko