pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Default mode for transaction in postgreSQL and JDBC 2+ messages / 2 participants [nested] [flat]
* Default mode for transaction in postgreSQL and JDBC @ 2000-07-04 17:20 Dirk Koschuetzki <dkoschuetzki@gmx.de> 0 siblings, 0 replies; 2+ messages in thread From: Dirk Koschuetzki @ 2000-07-04 17:20 UTC (permalink / raw) To: 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@medialift.com OpenPGP messages welcome Fingerprint: E0C4 74F1 9E21 8C90 EEA7 A65A 1868 A81D 5622 74C4 ^ permalink raw reply [nested|flat] 2+ messages in thread
* RE: Default mode for transaction in postgreSQL and J DBC @ 2000-07-05 08:05 Peter Mount <petermount@it.maidstone.gov.uk> 0 siblings, 0 replies; 2+ messages in thread From: Peter Mount @ 2000-07-05 08:05 UTC (permalink / raw) To: 'dkoschuetzki@gmx.de' <dkoschuetzki@gmx.de>; 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@gmx.de] Sent: Tuesday, July 04, 2000 6:21 PM To: pgsql-interfaces@postgresql.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@medialift.com OpenPGP messages welcome Fingerprint: E0C4 74F1 9E21 8C90 EEA7 A65A 1868 A81D 5622 74C4 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-07-05 08:05 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2000-07-04 17:20 Default mode for transaction in postgreSQL and JDBC Dirk Koschuetzki <dkoschuetzki@gmx.de> 2000-07-05 08:05 RE: Default mode for transaction in postgreSQL and J DBC Peter Mount <petermount@it.maidstone.gov.uk>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox