By Frank Nimphius on Jan 09, 2012
The save point (save for later) feature of the ADF Controller is enabled from Application Resources | Descriptors | ADF META-INF in the Application Navigator. To enable controller save points, double click onto the adf-config.xml file and assign a data source name to the Savepoints | Data Source property using the magnifying glass.
In JDeveloper 11g R1, make
sure the account accessing the schema into which save points should be stored
has the create table permission granted. Background for this requirement is
that the save point table is automatically created the first time a save point
is written by the controller. After this the create table permission can be removed
from the account. As you guessed it, this approach is not a DBA's darling,
which is why an external script is provided in 11g R2.
In JDeveloper 11g R2, an external script - adfc_create_save_point_table.sql - is provided for you t create the save point table in advance. The script is located in the oracle_common\common\sql directory of the JDeveloper 11g installation home.