Default mode for transaction in postgreSQL and JDBC

From: Dirk Koschuetzki <dkoschuetzki(at)gmx(dot)de>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: Default mode for transaction in postgreSQL and JDBC
Date: 2000-07-04 17:20:41
Message-ID: 39621CE9.22B3DBE8@gmx.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

Hello,

I played around with the transaction management in postgreSQL and I found
that the JDBC-Driver allways indicates that the transaction isolation
level is "serializable". This is hard coded within the source and changing
the transaction isolation level with the provided method gives an
exception. So far so good.
A second look in the postgreSQL source code (V 6.5.3) indicates that the
default isolation level is read commited, the documentation states the
same and a check with psql confirms this.

So, is the transaction isolation level within my (6.5.3) JDBC-Version
really serializable?

Regards
Dirk

Ps.: Please CC me, as I'm currently not subscribed to the list.

--
Dirk Koschützki dkoschuetzki(at)medialift(dot)com
OpenPGP messages welcome
Fingerprint: E0C4 74F1 9E21 8C90 EEA7 A65A 1868 A81D 5622 74C4

Browse pgsql-interfaces by date

  From Date Subject
Next Message Peter Eisentraut 2000-07-04 19:58:19 Re: Upper characters in database names
Previous Message Dave Page 2000-07-04 16:33:29 RE: Exporting access tables using odbc