Sunday, November 28, 2010

JDev/ADF sample - Immediate Row Level Lock Management for ADF 11g Transactional Applications

  • Immediate Row Level Lock Management for ADF 11g Transactional Applications. Oracle ADF 11g framework is primarily designed for enterprise applications. Majority of enterprise applications are processing user transactions, it is important to preserve proper transaction state for every user. Oracle ADF 11g out of the box provides pessimistic and optimistic locking support - Optimistic and Pessimistic Locking in Oracle ADF BC. Generally, optimistic locking is recommended for Web applications, pessimistic locking mechanism will lock current record once user will edit it. However, for specific applications (especially bank and insurance sector), we have quite natural business requirement to lock record directly after this record was opened for editing. Such type of locking is stronger than pessimistic locking - it locks record even before user starts editing it. Its very important to understand how to tune and control ADF 11g runtime parameters, when implementing immediate locking solutions. Today I will describe how immediate locking use case can be implemented with ADF BC and ADF Task Flows. My next posts will provide information about ADF BC parameters tuning for reliable immediate row locking mechanism.
    Download - RowLockingApp.zip

6 comments:

subu said...

excuse sir,

sorry to disturb you.
am struggling no one give solution for this problem.

.oracle.jbo.NoDefException: JBO-25002: Definition setup1.view.pageDefs.untitled3PageDef of type Form Binding Definition is not found.

But untitled3PageDef of type Form Binding Definition is present but unable to read by the wls server. any other solution.you may prescribe.

Andrejus Baranovskis said...

First rule - never use such names as "untitled", follow naming best practices :)

Andrejus

subu said...

k sir,

hereafter i will not repeat the mistake.

Is there any other solution for that bug. Most of the oracle post, solution releated are not provided.
so only am asking.

Andrejus Baranovskis said...

Try to see in DataBindings.cpx file, if page mapping with page definition is correct.

Andrejus

sandy said...

Hi Andrejus,

I have a similar requirement to implement in ADF. I have a Orders results page and there are are two buttons: Update and Send. Lets say User A selects a order and clicks on Update and starts updating the order. Now User B comes and selects the same order: I should stop him saying that Order is already in use. Will this example satisfy the same? Pls confirm.

Or pls let me know how I can handle such situation in ADF 11g.

Thanks much,
Sandy

Andrejus Baranovskis said...

Yes, it sounds like the same requirement. Please refer to following post: http://andrejusb.blogspot.com/2010/12/oracle-adf-bc-11g-tuning-for-immediate.html

Andrejus