Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.
Difference between revisions of "Configuring Historical Sessions (ELUG)"
m (New page: <div style="float:right;border:1px solid #000000;padding:5px">__TOC__ Related Topics</div> This section describes the vario...) |
m |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| + | [[Image:Elug draft icon.png]] '''For the latest EclipseLink documentation, please see http://www.eclipse.org/eclipselink/documentation/ ''' | ||
| + | |||
| + | ---- | ||
| + | |||
| + | |||
<div style="float:right;border:1px solid #000000;padding:5px">__TOC__ | <div style="float:right;border:1px solid #000000;padding:5px">__TOC__ | ||
[[Special:Whatlinkshere/Configuring Historical Sessions (ELUG)|Related Topics]]</div> | [[Special:Whatlinkshere/Configuring Historical Sessions (ELUG)|Related Topics]]</div> | ||
| − | |||
For information on configuring a historical session using an Oracle Database platform, see [[#How to Configure Historical Sessions Using an Oracle Platform|How to Configure Historical Sessions Using an Oracle Platform]]. | For information on configuring a historical session using an Oracle Database platform, see [[#How to Configure Historical Sessions Using an Oracle Platform|How to Configure Historical Sessions Using an Oracle Platform]]. | ||
| − | For information on configuring a historical session using any supported database platform and a EclipseLink <tt>HistoryPolicy</tt>, see [[#How to Configure Historical Sessions Using a EclipseLink | + | For information on configuring a historical session using any supported database platform and a EclipseLink <tt>HistoryPolicy</tt>, see [[#How to Configure Historical Sessions Using a EclipseLink HistoryPolicy|How to Configure Historical Sessions Using a EclipseLink HistoryPolicy]]. |
For more information about historical sessions, see [[Introduction%20to%20EclipseLink%20Sessions%20(ELUG)#Historical Sessions|Historical Sessions]]. | For more information about historical sessions, see [[Introduction%20to%20EclipseLink%20Sessions%20(ELUG)#Historical Sessions|Historical Sessions]]. | ||
| Line 14: | Line 18: | ||
There are two following ways to configure EclipseLink to access the historical versions of objects maintained by your data source: | There are two following ways to configure EclipseLink to access the historical versions of objects maintained by your data source: | ||
| − | |||
* using an Oracle platform (see [[#How to Configure Historical Sessions Using an Oracle Platform|How to Configure Historical Sessions Using an Oracle Platform]]) | * using an Oracle platform (see [[#How to Configure Historical Sessions Using an Oracle Platform|How to Configure Historical Sessions Using an Oracle Platform]]) | ||
* using EclipseLink <tt>HistoryPolicy</tt> (see [[#How to Configure Historical Sessions Using a EclipseLink HistoryPolicy|How to Configure Historical Sessions Using a EclipseLink HistoryPolicy]]) | * using EclipseLink <tt>HistoryPolicy</tt> (see [[#How to Configure Historical Sessions Using a EclipseLink HistoryPolicy|How to Configure Historical Sessions Using a EclipseLink HistoryPolicy]]) | ||
| Line 21: | Line 24: | ||
===How to Configure Historical Sessions Using an Oracle Platform=== | ===How to Configure Historical Sessions Using an Oracle Platform=== | ||
| − | |||
Oracle9''i'' Database Server (or later) automatically maintains historical versions of objects and extends SQL with an <tt>AS_OF</tt> clause used to query this historical data. Oracle refers to these as flashback queries. | Oracle9''i'' Database Server (or later) automatically maintains historical versions of objects and extends SQL with an <tt>AS_OF</tt> clause used to query this historical data. Oracle refers to these as flashback queries. | ||
| Line 29: | Line 31: | ||
For more information, see the following: | For more information, see the following: | ||
| − | |||
* [[Acquiring%20and%20Using%20Sessions%20at%20Run%20Time%20(ELUG)#Acquiring a Historical Session|Acquiring a Historical Session]] | * [[Acquiring%20and%20Using%20Sessions%20at%20Run%20Time%20(ELUG)#Acquiring a Historical Session|Acquiring a Historical Session]] | ||
* [[Introduction%20to%20EclipseLink%20Queries%20(ELUG)#Historical Queries|Historical Queries]]. | * [[Introduction%20to%20EclipseLink%20Queries%20(ELUG)#Historical Queries|Historical Queries]]. | ||
| + | |||
| + | |||
===How to Configure Historical Sessions Using a EclipseLink HistoryPolicy=== | ===How to Configure Historical Sessions Using a EclipseLink HistoryPolicy=== | ||
| Line 38: | Line 41: | ||
For more information, see the following: | For more information, see the following: | ||
| − | |||
* [[Configuring%20a%20Descriptor%20(ELUG)#Configuring a History Policy|Configuring a History Policy]] | * [[Configuring%20a%20Descriptor%20(ELUG)#Configuring a History Policy|Configuring a History Policy]] | ||
* [[Acquiring%20and%20Using%20Sessions%20at%20Run%20Time%20(ELUG)#Acquiring a Historical Session|Acquiring a Historical Session]] | * [[Acquiring%20and%20Using%20Sessions%20at%20Run%20Time%20(ELUG)#Acquiring a Historical Session|Acquiring a Historical Session]] | ||
* [[Introduction%20to%20EclipseLink%20Queries%20(ELUG)#Historical Queries|Historical Queries]]. | * [[Introduction%20to%20EclipseLink%20Queries%20(ELUG)#Historical Queries|Historical Queries]]. | ||
| + | |||
| + | |||
| Line 49: | Line 53: | ||
[[Category: EclipseLink User's Guide]] | [[Category: EclipseLink User's Guide]] | ||
| − | [[Category: | + | [[Category: Release 1]] |
[[Category: Task]] | [[Category: Task]] | ||
Latest revision as of 15:26, 16 July 2012
For the latest EclipseLink documentation, please see http://www.eclipse.org/eclipselink/documentation/
Contents
For information on configuring a historical session using an Oracle Database platform, see How to Configure Historical Sessions Using an Oracle Platform.
For information on configuring a historical session using any supported database platform and a EclipseLink HistoryPolicy, see How to Configure Historical Sessions Using a EclipseLink HistoryPolicy.
For more information about historical sessions, see Historical Sessions.
Introduction to Historical Session Configuration
There are two following ways to configure EclipseLink to access the historical versions of objects maintained by your data source:
- using an Oracle platform (see How to Configure Historical Sessions Using an Oracle Platform)
- using EclipseLink HistoryPolicy (see How to Configure Historical Sessions Using a EclipseLink HistoryPolicy)
How to Configure Historical Sessions Using an Oracle Platform
Oracle9i Database Server (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 Configuring a Relational Database Platform at the Session Level) for Oracle9i Database Server (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:
How to Configure Historical Sessions Using a EclipseLink HistoryPolicy
If you use a schema that you designed to maintain historical versions of objects and if that schema can be described by EclipseLink HistoryPolicy, you can query the historical versions of objects maintained by your database in accordance with your schema.
For more information, see the following: