Hi ,
Jdeveloper version :Studio Edition Version 12.2.1.0.0
I have read ADF pl/sql integration at couple of places. For instance :Oracle ADF Architecture TV - Design - Architecting for PLSQL Integrat…
Simplified usecase :
Page has a Query panel and table. There is a field to enter new salary at bottom of page and a button to click update. Update button issues a PL/SQL call to update all employees passing : newsalary, whereClause .
Now two users try to issue PL/SQL update through update through button. Please note that it is not doDML of entity... it is one AM Method call that invokes PL/SQl procedure.
Questions and concerns for discussion :
Incase of multiUser update through entity, Framework handles it. It is optimistic locking so I get Another User has updated the row with Primary key... Which is correct and expected.
How does multiUser update is handled in case when AM method pl/sql procedure issues update on multiple rows ?
Example :- User A filtered all employees with salary 2000-5000 and UserB filtered all employees with salary 3500-5500. User A tries to set salary for filtered employees to 4000 and UserB tries to set to 4500. So both invoking PL/SQL API in am method to update. What's happening is which ever update is going later is the final value of salary and version number is not updated ...neither I recieve any error like Another user has updated the row with primary key.
I dont think Refresh on Update property will have any impact in refreshing EO/VO.