Re: SET AUTOCOMMIT TO OFF no longer supported

Поиск
Список
Период
Сортировка
От Carlos Correia
Тема Re: SET AUTOCOMMIT TO OFF no longer supported
Дата
Msg-id 43E50300.2080505@m16e.com
обсуждение исходный текст
Ответ на Re: SET AUTOCOMMIT TO OFF no longer supported  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: SET AUTOCOMMIT TO OFF no longer supported
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: SET AUTOCOMMIT TO OFF no longer supported
Следующее
От: Kris Jurka
Дата:
Сообщение: Re: SET AUTOCOMMIT TO OFF no longer supported