Received: from mail.retep.org.uk ([216.126.85.184])
	by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2CKD7x58376
	for <pgsql-jdbc@postgresql.org>; Mon, 12 Mar 2001 15:13:07 -0500 (EST)
	(envelope-from peter@retep.org.uk)
Received: from heather.retep.org.uk ([193.113.118.126]) (authenticated)
	by mail.retep.org.uk (8.11.1/8.11.1) with ESMTP id f2CKCWR58188;
	Mon, 12 Mar 2001 15:12:32 -0500 (EST)
	(envelope-from peter@retep.org.uk)
Message-Id: <5.0.2.1.0.20010312200925.00a262a0@mail.retep.org.uk>
X-Sender: peter@mail.retep.org.uk
X-Mailer: QUALCOMM Windows Eudora Version 5.0.2
Date: Mon, 12 Mar 2001 20:10:38 +0000
To: nelson@radix.com.br
From: Peter Mount <peter@retep.org.uk>
Subject: Re: [INTERFACES] JDBC: can't set transaction isolation level
Cc: pgsql-jdbc@postgresql.org
In-Reply-To: <984418149.3aad0765ac09c@gandalf.radix.com.br>
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"; format=flowed
X-Archive-Number: 200103/58
X-Sequence-Number: 274

At 14:29 12/03/01 -0300, nelson@radix.com.br wrote:
redirecting to jdbc list:
>     Hi,
>
>     I need to set transaction isolation level to SERIALIZABLE in a java 
> program.
>Calling the method setTransationIsolation of class Connection has no 
>effect: the
>isolation level still remains READ_COMMITTED (the default).
>     I tried to create a Statement and set the isolation level as an 
> ordinary SQL
>- stmt.executeUpdate("set transaction isolation level serializable"); - and it
>works fine.
>     And finally, the method Connection.getTransationIsolation() always 
> returns
>2, whatever the isolation level is set to.
>     These problems happen with PostgreSQL 7.0.3. Can you help me?

I did fix some bugs on this about a month ago, so the 7.1 driver should 
have this fixed.

Peter