How Does Record Locking Work?

Record locking is a mechanism that the database provides to prevent simultaneous update access to the same resource by multiple users. Locking strategies and granularity differs from database vendor to database vendor, but with the Oracle database, locks are taken out on a row-level basis.

Just like Oracle Forms, ADF BC automatically handles the day-to-day process of issuing locks to protect updates in progress. You do not have to write code to issue locks. However, you can configure the way that these locks are managed.

Within ADF Business Components, the Transaction object, which we encountered earlier as a home for COMMIT and ROLLBACK operations, also provides a way to configure the locking mode of the application. ...

Get Oracle JDeveloper 10g for Forms & PL/SQL Developers: A Guide to Web Development with Oracle ADF now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.