Re: "Idle in Transaction" revisited.
От | Gaetano Mendola |
---|---|
Тема | Re: "Idle in Transaction" revisited. |
Дата | |
Msg-id | 41502A95.6010204@bigfoot.com обсуждение исходный текст |
Ответ на | Re: "Idle in Transaction" revisited. ("John R Pierce" <pierce@hogranch.com>) |
Список | pgsql-jdbc |
John R Pierce wrote: >>> Trouble is, with JDBC as its currently implemented, the instant you >>> Commit() or Rollback(), JDBC starts a new transaction automatically, >>> since JDBC has no explicit Begin(). If that thread then goes >>> quiescent for an arbitrary period of time (perhaps waiting for more >>> messaging traffic, our apps are message driven factory floor >>> middleware things), this transaction remains open. Our >>> applications are characterized by bursts of frenetic activity >>> followed by long idle periods, quite unpredictably. >> >> >> I was under the impression that this was easily addressed by >> delaying the onset of the next transaction after commit/rollback until >> some actual statement activity began. (like a SELECT...) > > > yes, apparently that fix is in the 8 beta client, but not in the 7.4.5 > client. However it seems the 8.0 client will work with the 7.4.x server Regards Gaetano Mendola
В списке pgsql-jdbc по дате отправления: