What is required so that a connection using isolation level 0 is blocking on another connection, which is also using isolation-level 0? The connection which is blocking is executing a simple select on the table.

asked 13 Feb '12, 12:47

Martin's gravatar image

Martin
9.0k130169257
accept rate: 14%

1

Writers do always block writers, regardless of isolation levels...but that do not seem to be your case, right?

(13 Feb '12, 12:52) Volker Barth
Replies hidden
1

You are so quick ;-) You mean a writer which have not already issued its commit will block other writers?

(13 Feb '12, 12:57) Martin

Well, the "quickness" may be due to the fact that on this forum, "writers do not block writers" - though they (at least me) sometimes skip the "thoroughly reading" (or "fully understanding") part:)

(14 Feb '12, 03:29) Volker Barth

As Volker states (correctly), at isolation level 0 connections will still block on other connections due to write or intent lock conflicts. At isolation level 0, SQL Anywhere connections do not acquire read locks on rows. Other types of row locks (INTENT, WRITE) are, however, still acquired and may cause blocking. Schema locks and table-level locks also still apply to isolation level zero connections.

permanent link

answered 13 Feb '12, 13:37

Glenn%20Paulley's gravatar image

Glenn Paulley
10.8k576106
accept rate: 43%

1

... but would that block a connection that is "executing a simple select on the table"?

(13 Feb '12, 18:10) John Smirnios

if you don't want to lock rows, do a commit after the select. we have a PowerBuilder app with 50+ windows and 200+ datawindows. to avoid the locking problem, after each dw retrieve, that we won't update, we do a commit.

permanent link

answered 14 Feb '12, 06:50

Tom%20Mangano's gravatar image

Tom Mangano
672242738
accept rate: 8%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×13

question asked: 13 Feb '12, 12:47

question was seen: 2,179 times

last updated: 14 Feb '12, 06:50