Integration

Hi
We have a query where records are fecthed and updated viz DB Adapter.
The first query which is a select returns multiple records and then we take and update each record one by one based on certain conditions.
There are multiple instances of BPEL running and the same table is being acted on. Now we are getting a deadlock exception on the table.

We are updating certain rows on table and are selecting the same row while the update is on because of some logic check.
But there are no instances in which same row can be updated at same time. Then how is the table lock happening ? Will the table itself be locked when an update happens ? i thought only row level locks happen and hence we can do multiple updates and select on the same table.

Is there any way by which we can capture the details of what records are being updated then and also the total log details ?


Thanks