My Oracle Support Banner

Passivation Warning "Another user has changed the row..." Not Shown For Later Users Committing Changes (Doc ID 2448564.1)

Last updated on SEPTEMBER 18, 2018

Applies to:

Oracle JDeveloper - Version 12.1.2.0.0 and later
Information in this document applies to any platform.

Symptoms

When passivation occurs the warning "Another user has changed the row..." is not shown for later users committing changes to the same table.

Scenario: Two users are working on the same table row in an ADF application with AM locking mode optimistic.

User 1 and 2 have same page already open (no changes made yet). User 1 changes value for an input and commits, then User 2 changes that same input and commits but the warning "Another user has changed the row..." is not showing for User 2.

If number of users is equal or less than the setting Referenced Pool Size (jbo.recyclethreshold) (say 10) to keep AM instance affinity (not passivating) then warning is correctly shown.

If AM pooling is disabled the warning is shown as expected.

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
 Proper tune of AM pool size
 Use oracle.adf.model.__isClientConsistencyEnabled__
References


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