| 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: | Whole Thread | Raw Message | 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 |