93 Configuring Historical Sessions

This chapter describes the various components that you must configure in order to be able to use historical sessions.

This chapter includes the following section:

For information on configuring a historical session using Oracle Database platform, see Section 93.1.1, "How to Configure Historical Sessions Using an Oracle Platform".

For information on configuring a historical session using any supported database platform and a TopLink HistoryPolicy, see Section 93.1.2, "How to Configure Historical Sessions Using a TopLink HistoryPolicy".

For more information about historical sessions, see Section 87.6, "Historical Sessions".

93.1 Introduction to Historical Session Configuration

There are two following ways to configure TopLink to access the historical versions of objects maintained by your data source:

93.1.1 How to Configure Historical Sessions Using an Oracle Platform

Oracle9i Database (or later) automatically maintains historical versions of objects and extends SQL with an AS_OF clause used to query this historical data. Oracle refers to these as flashback queries.

If you configure your Session with an OraclePlatform (see Section 98.2, "Configuring a Relational Database Platform at the Session Level") for Oracle9i Database (or later), you can query the historical versions of objects automatically maintained by Oracle Database.

No further session configuration is required.

For more information, see the following:

93.1.2 How to Configure Historical Sessions Using a TopLink HistoryPolicy

If you use a schema that you designed to maintain historical versions of objects and if that schema can be described by TopLink HistoryPolicy, you can query the historical versions of objects maintained by your database in accordance with your schema.

For more information, see the following: