Part 1: How to solve the transactional issues of isolation levels

Question

Post reply

Part 1: How to solve the transactional issues of isolation levels

at.yazdani

SSC Rookie

Points: 25
More actions
April 30, 2013 at 10:32 pm

#394698

Comments posted to this topic are about the item Part 1: How to solve the transactional issues of isolation levels

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

parveen.verma Grasshopper Points: 12 More actions · Answer 1

Good Article where Concurrency problems and Isolations levels are described in simple form.

Good work 🙂 Thanks!!

fajprieto Grasshopper Points: 19 More actions · Answer 2

First of all I introduce myself my name is Javier Prieto (Capilla del Monte, Cordoba - Argentina) and attend a facility with SQLSERVER 2008 R2 STD.

On this issue I tell ...

All client pc run Visual Fox Pro9 ADODB Connection and work against the engine.

To make a reservation, according to the theory, with use the statement

SET TRANSACTION ISOLATION LEVEL SERIALIZABLE UNCOMMITTED

there should be no way that two pc try to lock a record at the same time, however happens.

I understand that if the sentence is utilizace from a stored procedure, maybe meet what I should do. But the sentence the way through ADODB and thus does not have the desired effects. In fact I did not find the way it really is serializable.

What I also came to the concept of having to add that statement is as follows:

select @Pudo=COUNT(*) from Bloqueos with (UpdLock)

With "with (UpdLock)" could greatly reduce the number of users, but I could not remove.

Maybe you know some effective technique that can be used with ADODB.:crying:

jerryschiffelbein 85806 SSC Journeyman Points: 86 More actions · Answer 3

It would be very helpful if more attention was given to proof reading articles before posting them. This one has numerous grammar and punctuation errors which make it very cumbersome to read.

SQLGuy64 Ten Centuries Points: 1081 More actions · Answer 4

just a note to say that isolation level is set at the connection level and that the default is read committed and that if another isolation level is desired it needs to be set in the connection

fajprieto Grasshopper Points: 19 More actions · Answer 5

I'm sorry but my home language is Spanish and I use the Google translator to write the post.

Maybe then you can tell me a good site to post in Spanish.:-D

jerryschiffelbein 85806 SSC Journeyman Points: 86 More actions · Answer 6

D'oh! Language barrier. That would explain it then. In that case, if a reviewer is unavailable, then it may be helpful to include a disclaimer in future articles.

temp 95500 Grasshopper Points: 12 More actions · Answer 7

> or it may show (-20$) (which is quite impossible as of banking constraints)

Not in the USA... the bank would gladly let the account go negative and charge another $50 fee 🙁

at.yazdani SSC Rookie Points: 25 More actions · Answer 8

Thanks for your note.

I recommend you to be wait for the second part. I hope the clarification can help.