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>
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


"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