Forum Stats

  • 3,769,695 Users
  • 2,253,008 Discussions
  • 7,875,155 Comments

Discussions

Deadlock after second postChange

Perevertkin M A
Perevertkin M A Member Posts: 37 Blue Ribbon
edited Oct 27, 2021 9:20AM in JDeveloper and ADF

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 : )

Answers