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.
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 |
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 |