Re: Changing isolation level?

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1070486233.549645_at_yasure...
| D Alpern wrote:
|
| > SELECT... FOR UPDATE {WAIT | NOWAIT} springs to mind...
| >
| > David
|
| Why would that spring to mind?
|
| It doesn't block a read which is the point of the OP's request.
|
| --
| Daniel Morgan
| http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
| http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
| damorgan_at_x.washington.edu
| (replace 'x' with a 'u' to reply)
|

actually, it does... it voluntarily blocks the read that it itself (grammar?) is attempting to do

so, on a case by case basis (instead of a session or instance isolation level setting), the reader gets blocked by the writer

unfortunately, the reader that uses this syntax now blocks writers, but if serialization is what's required to meet the business requirement, this would seem to do it

-- 
Mark C. Stock
mcstock -> enquery(dot)com
www.enquery.com training & consulting