Thursday, March 29, 2012

default isolation level

Hi all,
the default isolation level in sql 2k is read committed..
say incase i am connecting to the DB through a jdbc driver and the
application has a default isolation level of repeatable read...
when a transaction is opened from the application end...wat would be the
isolation level...
ll the db override or the application takes up priority..
any help on the context is appreciated..
thnks
anuApplication should override the default level.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
Solid Quality Learning
More than just Training
www.SolidQualityLearning.com
"Anuradha" <Anuradha@.discussions.microsoft.com> wrote in message
news:C46A6429-6D51-40BF-A4EE-9584224F3625@.microsoft.com...
> Hi all,
> the default isolation level in sql 2k is read committed..
> say incase i am connecting to the DB through a jdbc driver and the
> application has a default isolation level of repeatable read...
> when a transaction is opened from the application end...wat would be the
> isolation level...
> ll the db override or the application takes up priority..
> any help on the context is appreciated..
> thnks
> anu

No comments:

Post a Comment