From: | Peter Mount <petermount(at)it(dot)maidstone(dot)gov(dot)uk> |
---|---|
To: | "'dkoschuetzki(at)gmx(dot)de'" <dkoschuetzki(at)gmx(dot)de>, pgsql-interfaces(at)postgresql(dot)org |
Subject: | RE: Default mode for transaction in postgreSQL and J DBC |
Date: | 2000-07-05 08:05:15 |
Message-ID: | 1B3D5E532D18D311861A00600865478CF1B005@exchange1.nt.maidstone.gov.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-interfaces |
The driver included in 6.5.3 is actually the 6.5.2 one (due to me not
committing it correctly).
In the 7.0, the transactionIsolation() code was implemented as part of the
javax.sql extensions.
--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council
-----Original Message-----
From: Dirk Koschuetzki [mailto:dkoschuetzki(at)gmx(dot)de]
Sent: Tuesday, July 04, 2000 6:21 PM
To: pgsql-interfaces(at)postgresql(dot)org
Subject: [INTERFACES] Default mode for transaction in postgreSQL and
JDBC
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
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Mount | 2000-07-05 13:37:59 | RE: UNFINISHED code for more scalable JDBC driver av ailable |
Previous Message | Dan Rosner | 2000-07-05 02:27:38 | Inserting null values into a float4 field using Perl DBI |