Wednesday, January 9, 2013

JDev/ADF sample - LOV for Editable Primary Key in ADF Table Problem

  • LOV for Editable Primary Key in ADF Table Problem. Probably every ADF developer at least ones was facing this problem - creating LOV for editable primary key attribute rendered in ADF table. Very often database design is based on business key and there is requirement to create LOV for that key. Unfortunately ADF doesn't handle this case well - LOV defined for editable key in the table is unstable. There are different workarounds, but all of them with the side effects. The best workaround is to fix database design and introduce surrogate key for the table - but in practice is hardly possible, no one wants to change DB design, especially if it works well in Oracle Forms.
    Download - EditableTableKeyApp.zip

No comments: