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.
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.
ASKER
This is when I insert a new record, it is impossible to be selected by another user at this moment.
Please help. Thanks.
Please help. Thanks.
Could you post your code here??
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
You could issue a select for update clause to wait and acquire a row level lock on the record u're trying to update.