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

Posted on 2007-08-01
Last Modified: 2013-11-17
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.

Question by:huizhanghopeqi
    LVL 14

    Expert Comment

    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.

    Author Comment

    This is when I insert a new record, it is impossible to be selected by another user at this moment.
    Please help. Thanks.
    LVL 14

    Expert Comment

    Could you post your code here??
    LVL 5

    Accepted Solution

    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.

    Featured Post

    Course: HTML5 Specialist

    HTML5 development skills are critical to all developers. HTML5 is the foundation to almost any development process. That's why business, design studios, development shops and other organizations need HTML5 developers. Get your foot in the door as a HTML5 specialist.

    Join & Write a Comment

    Suggested Solutions

    Title # Comments Views Activity
    percentage remaining 6 30
    MS Access 2003 Query 2 26
    update set column values in oracle 3 32
    Problem to Popup 37 61
    APEX (Application Express) is used to develop a web application from Oracle. SQL Workshop is one of the tools that comes with Oracle APEX to query or modify the database objects or to make any changes to the structure.
    Read about achieving the basic levels of HRIS security in the workplace.
    The purpose of this video is to demonstrate how to update a WordPress Site’s version. WordPress releases new versions of its software frequently and it is important to update frequently in order to keep your site secure, and to get new WordPress…
    The purpose of this video is to demonstrate how to integrate Mailchimp with WordPress, by placing a Mailchimp signup form on a WordPress Page or Post. This will be demonstrated using a Windows 8 PC. Mailchimp will be used. Log into your Mailchi…

    730 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    15 Experts available now in Live!

    Get 1:1 Help Now