Re: SET AUTOCOMMIT TO OFF no longer supported

From: Carlos Correia <carlos(at)m16e(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: SET AUTOCOMMIT TO OFF no longer supported
Date: 2006-02-04 19:39:44
Message-ID: 43E50300.2080505@m16e.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Tom Lane escreveu:
| Carlos Correia <carlos(at)m16e(dot)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(at)m16e(dot)com - URL: http://www.m16e.com
AIM: m16e - ICQ: 257488263 - Jabber: m16e(at)amessage(dot)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-----

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Kris Jurka 2006-02-04 19:58:39 Re: SET AUTOCOMMIT TO OFF no longer supported
Previous Message Tom Lane 2006-02-04 19:29:23 Re: SET AUTOCOMMIT TO OFF no longer supported