Skip site navigation (1) Skip section navigation (2)

Re: [INTERFACES] JDBC: can't set transaction isolation level

From: Peter Mount <peter(at)retep(dot)org(dot)uk>
To: nelson(at)radix(dot)com(dot)br
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: [INTERFACES] JDBC: can't set transaction isolation level
Date: 2001-03-12 20:10:38
Message-ID: 5.0.2.1.0.20010312200925.00a262a0@mail.retep.org.uk (view raw or flat)
Thread:
Lists: pgsql-interfacespgsql-jdbc
At 14:29 12/03/01 -0300, nelson(at)radix(dot)com(dot)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


In response to

pgsql-interfaces by date

Next:From: Peter MountDate: 2001-03-12 20:12:20
Subject: Re: [INTERFACES] object id
Previous:From: maetDate: 2001-03-12 18:22:26
Subject: Re: object id

pgsql-jdbc by date

Next:From: Peter MountDate: 2001-03-12 20:12:20
Subject: Re: [INTERFACES] object id
Previous:From: maetDate: 2001-03-12 18:22:26
Subject: Re: object id

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group