-----BEGIN PGP SIGNED MESSAGE-----
Oliver Jowett wrote:
| Gaetano Mendola wrote:
|> John R Pierce wrote:
|>> I'm curious what common practice is for threads that do nothing but
|>> SELECTS... do folks just enable auto_commit, thereby preventing
|>> pgJDBC from doing BEGIN; ? Do they lace their code with COMMIT() calls?
|> We were bitten by this problem too, and my solution was to suggest our
|> developer to do and explicit: "ABORT" after the connection, and do
|> explicit "BEGIN" "END" instead of rely on the jdbc interface.
| This is a pretty bad idea as it can confuse the driver's idea of the
| current transaction state. For example, cursor-based resultsets won't
| ever be used if you do your own transaction demarcation in this way.
Fortunatelly I do not use cursors otherwise I could find it out long time ago,
this was the only solution since the 6.x version, and is working well at
least in my applications.
BTW also the python drivers were ( are ? ) affected by this "idle in transaction"
phenomenon and the jdbc 7.4 series too.
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.4 (MingW32)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org
-----END PGP SIGNATURE-----
In response to
pgsql-jdbc by date
|Next:||From: Francisco Figueiredo Jr.||Date: 2004-09-18 14:30:45|
|Subject: Issues regarding code license of ported code.|
|Previous:||From: Oliver Jowett||Date: 2004-09-18 10:53:26|
|Subject: Re: "Idle in Transaction" revisited.|