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.

huizhanghopeqiAsked:
Who is Participating?
 
fmonroyCommented:
it's most likely because other user has a pending transaction on the table that you are inserting into.

as sathyagiri says, post the inserting code and any transaction code on the same table.
0
 
sathyagiriCommented:
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.
0
 
huizhanghopeqiAuthor Commented:
This is when I insert a new record, it is impossible to be selected by another user at this moment.
Please help. Thanks.
0
 
sathyagiriCommented:
Could you post your code here??
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.