Re: SET AUTOCOMMIT TO OFF no longer supported

From: Carlos Correia <carlos(at)m16e(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: SET AUTOCOMMIT TO OFF no longer supported
Date: 2006-02-04 23:42:17
Message-ID: 43E53BD9.5030407@m16e.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

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

Kris Jurka escreveu:
|
|
| On Sat, 4 Feb 2006, Carlos Correia wrote:
|
|> I'm using Connection's setAutocommit() method and not execQuery( "set
|> autocommit off" )... note that this only happens in Windows2000, not in
|> Linux.
|>
|
| Check your classpath. I'd bet you've got two versions of the driver in
| there. Try adding this line somewhere in your app.
|
| org.postgresql.util.PSQLDriverVersion.main(null);
|
| It will print where it finds the driver on stdout.
|

YOU'RE RIGHT :-D

Some years ago I had the same problem: there was an old pg jar file in
JAVA_HOME/lib/ext dir... you have pointed it out then, as you did now :-D

THANK YOU VERY MUCH!!! and my appologies for asking the same question
twice -- thought with different versions.

I LOVE POSTGRES :-D

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

iD8DBQFD5TvY90uzwjA1SJURAgv9AJ9ZUE1Z4SkYHd6FCTJR5pTYcmuKgQCaAn+C
bTTh6XIexAx8UdwOJd3tHGg=
=uaJb
-----END PGP SIGNATURE-----

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Carlos Correia 2006-02-05 19:19:52 Statement has been closed (only in Windows)
Previous Message Kris Jurka 2006-02-04 19:58:39 Re: SET AUTOCOMMIT TO OFF no longer supported