CRUD Operations in Oracle ADF 11g Table Without Auto PPR

It seems, quite popular to implement CRUD operations for table component, using separate Popup window, as described in my previous blog post - CRUD Operations in Oracle ADF 11g Table Using PopUp Component. All my latest customers prefer to follow this approach. Its why today I will post improved sample for the same use case. There is an issue, when we want to reflect changes done in editable Popup window back to main read-only table. In order to keep main table in synch, we can set Iterator ChangeEventPolicy to ppr:

This means, each time when data change will happen in Popup window, main read-only table will be refreshed automatically. It works well, but there is one side effect with this approach, unfortunately. Table refresh will happen each time, when user simply selects another record. For simple tables thats Ok, but if we have complex screen with Master-Detail data - screen performance will be down immediately. It will refresh not only Master table, but all dependent Detail tables as well. So, we need to disable ppr for iterator binding:

The question now - how we trigger table refresh. Actually, it is quite straightforward - we need to set PartialTriggers dependency for Panel Collection from Popup and Popup Dialog components. We need to set it from both, because:

• Popup Dialog component triggers partial refresh on OK event (when we save data)
• Popup component triggers partial refresh on Popup Cancel event and on Popup fetch event (we can see newly inserted row)

Same logic works in case of custom reusable toolbar component, consuming page can reference Popup and Popup Dialog directly from custom tag library.

Let's set PartialTriggers property for Panel Collection:

PartialTriggers property must be based on two components:

Popup component and Popup Dialog:

Let's see how it works now. There is one record selected in the table:

We select another one, and no table refresh happens - thats what we want:

We can edit data:

Table is refreshed after we close dialog and shows latest changes:

When new row is being inserted, table is pre-populated with new empty row:

Download sample application - TableDialogEdit4.zip.