Re: UPDATE fails- deadlock? -- simultaneous access to DB

Padmashali wrote:

> We are facing the DB dead-lock problem. Multiple Access to tables are
> required. More than one transactions are trying to access the same
> table and DB deadlock is noticed.
>
> Will the order of access the Tables will resolve the problem, if I
> provide controlled access to each table in a particular order.
>
> Request you all to suggest various methodology/approach to prevent
> such scenario.
>
> Its Very Urgent.
>
> Thank You Very Much
>
> Best Regards
> Padmashali

What database are you working in? Is it Oracle? Are you sure? Because Oracle does not have dead-lock problems such as you describe unless a developer has intentionally written code to force this condition.

Be sure to include the version, edition, operating system, front-end tool, and hardware platform in your response.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)