Java Development Tools

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Deadlock after second postChange

Perevertkin M AOct 27 2021 — edited Oct 27 2021

I have 1 master table and 4 details tables. When i insert one row to master table and post changes all work correctly. But when i update inserted row, and post changes master table and 4 details tables locked.
And when in other session i try work with this tables, i get deadlock.
Application have optimistic locking mode in adf-config.xml(Error reproduced if i change to <config:Database jbo.locking.mode="none"/> )

Log related with locking:
<oracle.adf.model> <PropertyManager> <loadProperty> <[48] BC4J Property Override: jbo.locking.mode='none' -->(MetaObjectManager) from Client Environment>
<oracle.adf.model> <OracleSQLBuilderImpl> <doEntityDML> <[673] OracleSQLBuilder Executing, Lock 0 DML on: ALC_ALLOC (Insert)> (before insert row)
<oracle.adf.model> <OracleSQLBuilderImpl> <doEntityDML> <[721] OracleSQLBuilder Executing, Lock 0 DML on: ALC_ALLOC (Update)> (before update row)
Software:

Build JDEVADF_12.2.1.4.0_GENERIC_200613.1114.S
WebLogic Server Version: 12.2.1.4.0
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
Recognized As: Oracle12c Database Release 1 (12.1.0.2)

Please, help : )

Added on Oct 27 2021

#application-development-in-java, #database, #jdeveloper, #jdeveloper-and-adf, #session, #transaction

5 comments

261 views