Re: "Idle in Transaction" revisited.

Поиск
Список
Период
Сортировка
От Oliver Jowett
Тема Re: "Idle in Transaction" revisited.
Дата
Msg-id 414CB3D0.8020800@opencloud.com
обсуждение исходный текст
Ответ на Re: "Idle in Transaction" revisited.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-jdbc
Tom Lane wrote:
> Jeffrey Tenny <jeffrey.tenny@comcast.net> writes:
>
>>Are you saying that I will see stale database state at the logical
>>"start" of my transaction from a pooled connection?
>
>
>>That's a showstopper for sure. If I'm confused please enlighten me.
>
>
> Apparently you are confused, because the JDBC behavior has always
> been like that; it's only the current devel driver that fixes it.

That's not entirely true; 7.3-era drivers (which I think is what is
being used here) used "set autocommit" rather than explicit BEGIN. It
went back to using BEGIN again when 7.4 removed that option.

-O

В списке pgsql-jdbc по дате отправления:

Предыдущее
От: "John R Pierce"
Дата:
Сообщение: Re: Issues regarding code license of ported code.
Следующее
От: Oliver Jowett
Дата:
Сообщение: Re: "Idle in Transaction" revisited.