delete stament locking users - any help appreciated!!!

Hello Gang,

I have a third party application. My users have started using it full fledged recently and since then I have this great job of killing sessions because they seem to get locked!

The statement in question is a delete statement which says

delete table x where
y='....'

or something of that sort, as in there is a where clause which specifies what rows to delete. My problem is that no two users will be accessing the same set of rows and still they get locked. What could be the problem and what is the solution?

Any help in this regard is appreciated.

Thanks,
have a nice day,
-Shyami

1) Is 'COMMIT' or 'ROLLBACK' missing in application after DELETE statement..

Otherwise there should not be any problem even though two users are deleting same set of rows...

If first user issues a delete statement

f.ex

DELETE FROM test WHERE id =1;

and if he doesn't COMMIT/ROLLBACK after deleting rows..

second user will hang if he tries to delete same set of rows.. here is exm..

DELETE FROM test WHERE id =1;

2) Or Is there any messgage dialog box which gets confirmation of DELETE operation??.. and then COMMITS/ROLLBACK based on user response..

In this case.. there is a possibility of missing COMMIT/ROLLACBK statements.... Sometimes application programmers do miss these things which creates such problems..


HTH

Sameer

[Edited by Sameer on 09-17-2002 at 06:45 AM]

Thanks Sameer, being a third party application I do not know if there is a commit or rollback after the delete statement. I can always ask the provider though.

Thanks again,
-Shyami