Re: SET AUTOCOMMIT TO OFF no longer supported - Mailing list pgsql-jdbc

From Carlos Correia
Subject Re: SET AUTOCOMMIT TO OFF no longer supported
Date
Msg-id 43E50300.2080505@m16e.com
Whole thread Raw
In response to Re: SET AUTOCOMMIT TO OFF no longer supported  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: SET AUTOCOMMIT TO OFF no longer supported  (Kris Jurka <books@ejurka.com>)
List pgsql-jdbc
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Tom Lane escreveu:
| Carlos Correia <carlos@m16e.com> writes:
|
|>Tom Lane escreveu:
|>| I think you need a newer JDBC driver.  (If the app itself, rather than
|>| the driver, is trying to issue this command then the app is so broken
|>| it doesn't deserve to live.)
|
|
|>newer then this:
|>http://jdbc.postgresql.org/download/postgresql-8.1-404.jdbc3.jar?
|
|
| No, that driver is plenty new enough to know not to do this.  It's the
| app that's broken, then --- it has no business messing with SET
| AUTOCOMMIT rather than using the JDBC-spec methods to control
| transaction boundaries.
|
|

I'm using Connection's setAutocommit() method and not execQuery( "set
autocommit off" )... note that this only happens in Windows2000, not in
Linux.

regards,

Carlos
- --
MEMÓRIA PERSISTENTE, Lda.
Tel.: 219 291 591 - GSM:  967 511 762
e-mail: geral@m16e.com - URL: http://www.m16e.com
AIM: m16e - ICQ: 257488263 - Jabber: m16e@amessage.de
Skype.com username (VoIP): m16e.com
GnuPG: wwwkeys.eu.pgp.net
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org

iD8DBQFD5QMA90uzwjA1SJURApVWAJ9g79029OfZju1u56uxCLvPAQC5LgCfZWch
+caTxqN/Z5L/8bUGONlLR0w=
=Lokx
-----END PGP SIGNATURE-----

pgsql-jdbc by date:

Previous
From: Tom Lane
Date:
Subject: Re: SET AUTOCOMMIT TO OFF no longer supported
Next
From: Kris Jurka
Date:
Subject: Re: SET AUTOCOMMIT TO OFF no longer supported