My Oracle Support Banner

Uncommitted DML And Database Lock On Recursive Validation Error (Doc ID 1613723.1)

Last updated on FEBRUARY 07, 2019

Applies to:

Oracle JDeveloper - Version 11.1.1.7.0 to 11.1.1.7.0 [Release Oracle11g]
Information in this document applies to any platform.

Symptoms

An ADF 11.1.1.7.0 application using ADF BC and doing changes to other entities in the prepareForDml or doDML methods hold on to a database lock in case entity-level validation fails. Upon failing only the failing entity object is being rolled back and not the update of the other entity object thus causing a session with a pending change to hold a lock on the record on the database.

Suppose you have following code on your DepartmentImpl class:



Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.