Wednesday, February 5, 2014

JDev/ADF sample - Different Approach for DB Constraint Error Handling in ADF

  • Different Approach for DB Constraint Error Handling in ADF. Let's be honest - no matter how developer friendly and stable validation rules support would be in ADF BC, there will be always use cases when validation logic will be executed directly in DB, by check constraints for example. There is one problem in ADF, when validation logic is executed by DB check constraints. As there will be error received in doDML, while posting row and violating check constraint - transaction will stop and no other edited rows will be verified, until currently failed row data will be fixed. I will explain in this post, how to bypass such behaviour and have to report failed rows to ADF UI.
    Download - DoDMLExceptionProcessingApp.zip

No comments: