Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.java.programmer > #14227
| Path | csiph.com!usenet.pasdenom.info!aioe.org!.POSTED!not-for-mail |
|---|---|
| From | "Richard Maher" <maher_rj@hotspamnotmail.com> |
| Newsgroups | comp.lang.java.programmer |
| Subject | Re: JDBC transaction isolation |
| Date | Fri, 4 May 2012 06:23:53 +0800 |
| Organization | HTTP *is* The Box - Let's think outside |
| Lines | 27 |
| Message-ID | <jnv0i7$mta$1@speranza.aioe.org> (permalink) |
| References | <jnu4pj$ncr$1@dont-email.me> <4fa2aa0c$0$294$14726298@news.sunsite.dk> <jnujl6$os4$1@dont-email.me> <4fa2d5c7$0$288$14726298@news.sunsite.dk> |
| NNTP-Posting-Host | jOhPn0KFjrxwuMc9OPMmCw.user.speranza.aioe.org |
| X-Complaints-To | abuse@aioe.org |
| X-MimeOLE | Produced By Microsoft MimeOLE V6.00.2900.6157 |
| X-RFC2646 | Format=Flowed; Response |
| X-Notice | Filtered by postfilter v. 0.8.2 |
| X-Newsreader | Microsoft Outlook Express 6.00.2900.5931 |
| X-Priority | 3 |
| X-MSMail-Priority | Normal |
| Xref | csiph.com comp.lang.java.programmer:14227 |
Show key headers only | View raw
"Arne Vajhøj" <arne@vajhoej.dk> wrote in message news:4fa2d5c7$0$288$14726298@news.sunsite.dk... > > Almost all database have it at the SQL level: > > http://dev.mysql.com/doc/refman/5.5/en/set-transaction.html > http://www.postgresql.org/docs/9.1/static/sql-set-transaction.html and > http://www.postgresql.org/docs/9.1/static/transaction-iso.html > http://msdn.microsoft.com/en-us/library/ms173763.aspx > http://docs.oracle.com/cd/B10500_01/server.920/a96524/c21cnsis.htm > Is anyone else of the opinion that Oracle really does not support the serializable isolation level? (At least not in the way that SQL Server, Rdb, and I'm sure others do) That is, it doesn't prevent inserts to the other txn's result-set,touched-rows by locking but rather fudges some sort of snapshot/consistent-view of old data. (And even then with restrictions) Eg: - select count(*) from employees where dept_code=1; > > Arne > Cheers Richard Maher
Back to comp.lang.java.programmer | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
JDBC transaction isolation markspace <-@.> - 2012-05-03 07:30 -0700
Re: JDBC transaction isolation Arne Vajhøj <arne@vajhoej.dk> - 2012-05-03 11:53 -0400
Re: JDBC transaction isolation markspace <-@.> - 2012-05-03 11:43 -0700
Re: JDBC transaction isolation Arne Vajhøj <arne@vajhoej.dk> - 2012-05-03 15:00 -0400
Re: JDBC transaction isolation Lew <lewbloch@gmail.com> - 2012-05-03 14:00 -0700
Re: JDBC transaction isolation Arne Vajhøj <arne@vajhoej.dk> - 2012-05-03 17:13 -0400
Re: JDBC transaction isolation "Richard Maher" <maher_rj@hotspamnotmail.com> - 2012-05-04 06:23 +0800
Re: JDBC transaction isolation Arne Vajhøj <arne@vajhoej.dk> - 2012-05-03 19:57 -0400
Re: JDBC transaction isolation Richard Maher <maherrj@googlemail.com> - 2012-05-03 19:08 -0700
Re: JDBC transaction isolation Arne Vajhøj <arne@vajhoej.dk> - 2012-05-03 22:34 -0400
Re: JDBC transaction isolation Richard Maher <maherrj@googlemail.com> - 2012-05-03 20:11 -0700
Re: JDBC transaction isolation Richard Maher <maherrj@googlemail.com> - 2012-05-03 22:33 -0700
Re: JDBC transaction isolation Arne Vajhøj <arne@vajhoej.dk> - 2012-05-04 08:27 -0400
Re: JDBC transaction isolation Lew <lewbloch@gmail.com> - 2012-05-04 06:58 -0700
Re: JDBC transaction isolation Lew <lewbloch@gmail.com> - 2012-05-03 17:15 -0700
Re: JDBC transaction isolation Arne Vajhøj <arne@vajhoej.dk> - 2012-05-03 21:22 -0400
Re: JDBC transaction isolation Lew <lewbloch@gmail.com> - 2012-05-03 18:32 -0700
csiph-web