468,107 Members | 1,439 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,107 developers. It's quick & easy.

Deadlock even with SELECT..FOR UPDATE

1
Hi,
I have query something like this:
select * from emp where sal > ( select avg(sal) from emp ) for update

When ran multithreaded environment, i used to get this error
"Abnormal end unit of work condition occured" which is i think is due to deadlock condition.

I just wanted to know that What database lock ( share/update/exclusive) will be aquired for the above statement ? Is it that all txn will try to hold only U lock (since for update clause is present) ?? Or 1 txn holds U lock and other txn holds S lock ( for inner query)??


Thanks,
Jaideep.
Mar 29 '07 #1
1 2012
hiiiiiiiiiii all
1 tel me can any query possible for retrieving particular fieldname?
2.
please tel me anyone can we eliminate unique records and retrieve duplicates only in a table having 1000 records and we dnt know wats ename
Mar 30 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

11 posts views Thread by hendershot | last post: by
15 posts views Thread by Zeng | last post: by
2 posts views Thread by Hugo Flores | last post: by
4 posts views Thread by fmatamoros | last post: by
3 posts views Thread by shark | last post: by
1 post views Thread by Solo | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.