Displaying all columns in ADF table (TopLink entity)

If you are using ADF Faces table, that is based on TopLink entity bean and is generated from Data Control, by default you can not show columns involved into primary-foreign key relationship. It is because, Data Control generated based on Session Facade does not allow to display columns of ValueHolderInterface type, only data types (String, Integer, etc.) are allowed. For example, if we have Regions(regionId, regionName) and Countries(countryId, countryName, regionId) tables, by default it will not be possible to generate such ADF Faces table - Table(countryId, countryName, regionName).

How to show all columns? I have solved this, by adding one getter method to Countries TopLink entity bean:

public String getRegionName() {
return this.getRegions().getRegionName();
}

You can download sample application I have developed to solve this issue - AllColumns.zip (JDeveloper 10.1.3.1). Application description:

1. As a datasource, standard HR schema is used
2. Two entity objects are generated - Regions and Countries
3. Getter for regionName is added into Countries TopLink entity bean
4. Session Facade and Data Control are created
5. To countries.jspx page, Countries Method Return is dragged and dropped from Data Control Pallete.

Generated Data Control, regionName involved into primary-foreign key relationship is available:


Data displayed on countries.jspx page: