history.as-of

Configures the query to query the state of the object as-of a point in time.

Values

Table 4-10 describes this query hint's values.

Table 4-10 Valid Values for history.as-of

Value	Description
Timestamp	Timestamp, in the form: `YYYY/MM/DD HH:MM:SS.n`

Usage

Both the query execution and result will conform to the database as it existed in the past.

Note:

This query hint requires a class with historical support or when using Oracle Flashback.

Examples

Example 4-21 Using history.as-of in a JPA Query

import org.eclipse.persistence.config.HintValues;
 import org.eclipse.persistence.config.QueryHints;
 query.setHint("eclipselink.AS_OF", "2012/10/15 11:21:18.2");

Example 4-22 Using history.as-of in @QueryHint Annotation

import org.eclipse.persistence.config.HintValues;
 import org.eclipse.persistence.config.QueryHints;
 @QueryHint(name=QueryHints.AS_OF, value="2012/10/15 11:21:18.2");

See Also

For more information, see:

"history.as-of.scn"
"Using Oracle Flashback Technology" in Oracle Database Advanced Application Developer's Guide