JDBC: can't set transaction isolation level

From: nelson(at)radix(dot)com(dot)br
To: pgsql-interfaces(at)postgresql(dot)org
Subject: JDBC: can't set transaction isolation level
Date: 2001-03-12 17:29:09
Message-ID: 984418149.3aad0765ac09c@gandalf.radix.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces pgsql-jdbc

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?

Thanks.

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message J. T. Vermeulen 2001-03-12 17:30:46 Re: libpq++: combined patches based on 7.1b5
Previous Message Oliver Elphick 2001-03-12 17:25:48 Compiling JDBC - problem

Browse pgsql-jdbc by date

  From Date Subject
Next Message maet 2001-03-12 18:22:26 Re: object id
Previous Message Peter Eisentraut 2001-03-12 16:47:48 Re: JDBC build patches