Wednesday, August 21, 2013

JDev/ADF sample - ADF BC Locking Lifetime and Application Module Pooling

  • ADF BC Locking Lifetime and Application Module Pooling. ADF BC API provides method to lock current row, but lock lifetime can be short. Lock method issues SQL lock and locks the record for current user. If your use case is to keep lock for longer period of time, in other words to reserve record by the user until commit or rollback - this is not the method you should use. Lock issued from ADF BC can be released automatically, before user will be committing his changes. This happens when DB pooling is enabled or when there are more concurrent users than AM pool can handle. If you want to make sure that record will be reserved by the user for certain period of time, you must implement custom flag column in the DB and update it separately.
    Download - LockApp.zip

No comments: