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.