Link to home
Start Free TrialLog in
Avatar of huizhanghopeqi
huizhanghopeqi

asked on

what is "Failed to lock the record, another user holds the lock"? What should I do with it?

I am using JDeveloper to insert data to Oracle database, my browser give me the following message:

Validation ErrorYou must correct the following error(s) before proceeding:
JBO-26030: Failed to lock the record, another user holds the lock.
JBO-26030: Failed to lock the record, another user holds the lock.

Avatar of sathyagiri
sathyagiri
Flag of United States of America image

If the record is selected by another user for update, then you will get this error.

You could issue a select for update clause to wait and acquire a row level lock on the record u're trying to update.
Avatar of huizhanghopeqi
huizhanghopeqi

ASKER

This is when I insert a new record, it is impossible to be selected by another user at this moment.
Please help. Thanks.
Could you post your code here??
ASKER CERTIFIED SOLUTION
Avatar of fmonroy
fmonroy
Flag of Mexico image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial