Class OracleTemporalTableSupport

java.lang.Object

org.hibernate.dialect.temporal.DefaultTemporalTableSupport

org.hibernate.dialect.temporal.OracleTemporalTableSupport

All Implemented Interfaces:

TemporalTableSupport

public class OracleTemporalTableSupport
extends DefaultTemporalTableSupport

Constructor Summary

Constructors

Constructor	Description
OracleTemporalTableSupport(OracleDialect dialect)

Method Summary

Modifier and Type	Method	Description
void	addTemporalTableAuxiliaryObjects(TemporalTableStrategy strategy, Table table, Database database, boolean partitioned, String currentPartitionName, String historyPartitionName)	Register any auxiliary database objects required for the given temporary table and strategy.
boolean	createTemporalTableCheckConstraint(TemporalTableStrategy strategy)	Return false because we use period for system_time to implement the constraint on Oracle.
String	getAsOfOperator(TemporalTableStrategy strategy)	The operator used to specify a temporal instant for querying historical data.
String	getExtraTemporalTableDeclarations(TemporalTableStrategy strategy, String rowStartColumn, String rowEndColumn, boolean partitioned)	Any extra declarations required as part of the create table statement for a temporal table.
String	getTemporalTableOptions(TemporalTableStrategy strategy, String rowEndColumnName, boolean partitioned, String currentPartition, String historyPartition)	Table options to use for temporal tables, used to specify system versioning or table partitioning.
boolean	supportsNativeTemporalTables()	Does this dialect natively support SQL 2011-style temporal tables?
boolean	supportsTemporalTablePartitioning()	Do we support partitioning temporal tables in this dialect?
boolean	suppressesTemporalTablePrimaryKeys(boolean partitioned)	Do we need to suppress creation of the primary key constraint on a temporal table?
boolean	useAsOfOperator(TemporalTableStrategy strategy)	Should be use the for system_time as of operator when querying temporal tables? We usually only use it for querying native temporal tables at a historical instant, but in Oracle we use it all the time.
boolean	useTemporalRestriction(LoadQueryInfluencers influencers)	Should we use temporal restrictions on the row start and row end columns when querying temporal tables? We usually use them unless we are using native temporal tables, but on Oracle we never use them.

Methods inherited from class DefaultTemporalTableSupport

getDefaultTemporalTableStrategy, getTemporalColumnPrecision, getTemporalColumnType, getTemporalExclusionColumnOption

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Details

OracleTemporalTableSupport

public OracleTemporalTableSupport(OracleDialect dialect)

Method Details

createTemporalTableCheckConstraint

public boolean createTemporalTableCheckConstraint(TemporalTableStrategy strategy)

Return false because we use period for system_time to implement the constraint on Oracle.

Specified by:

createTemporalTableCheckConstraint in interface TemporalTableSupport

Overrides:

createTemporalTableCheckConstraint in class DefaultTemporalTableSupport

getExtraTemporalTableDeclarations

public String getExtraTemporalTableDeclarations(TemporalTableStrategy strategy,
 String rowStartColumn,
 String rowEndColumn,
 boolean partitioned)

Description copied from interface: TemporalTableSupport

Any extra declarations required as part of the create table statement for a temporal table. These declarations, unlike the options come inside the parentheses, along with the column and constraint definitions. Examples include the period for system_time clause, the Db2 transaction start id column, the MySQL partitioning column, and so on.

Specified by:

getExtraTemporalTableDeclarations in interface TemporalTableSupport

Overrides:

getExtraTemporalTableDeclarations in class DefaultTemporalTableSupport

Parameters:

strategy - The temporal table strategy

partitioned - Is partitioning requested

getAsOfOperator

public String getAsOfOperator(TemporalTableStrategy strategy)

Description copied from interface: TemporalTableSupport

The operator used to specify a temporal instant for querying historical data. Usually for system_time as of. This is usually used together with native temporal tables, but in Oracle we use it all the time.

Specified by:

getAsOfOperator in interface TemporalTableSupport

Overrides:

getAsOfOperator in class DefaultTemporalTableSupport

useAsOfOperator

public boolean useAsOfOperator(TemporalTableStrategy strategy)

Description copied from interface: TemporalTableSupport

Should be use the for system_time as of operator when querying temporal tables? We usually only use it for querying native temporal tables at a historical instant, but in Oracle we use it all the time.

Specified by:

useAsOfOperator in interface TemporalTableSupport

Overrides:

useAsOfOperator in class DefaultTemporalTableSupport

Parameters:

strategy - The strategy

useTemporalRestriction

public boolean useTemporalRestriction(LoadQueryInfluencers influencers)

Description copied from interface: TemporalTableSupport

Should we use temporal restrictions on the row start and row end columns when querying temporal tables? We usually use them unless we are using native temporal tables, but on Oracle we never use them.

Specified by:

useTemporalRestriction in interface TemporalTableSupport

Overrides:

useTemporalRestriction in class DefaultTemporalTableSupport

Parameters:

influencers - The LoadQueryInfluencers

supportsTemporalTablePartitioning

public boolean supportsTemporalTablePartitioning()

Description copied from interface: TemporalTableSupport

Do we support partitioning temporal tables in this dialect?

Specified by:

supportsTemporalTablePartitioning in interface TemporalTableSupport

Overrides:

supportsTemporalTablePartitioning in class DefaultTemporalTableSupport

See Also:

• Temporal.HistoryPartitioning

suppressesTemporalTablePrimaryKeys

public boolean suppressesTemporalTablePrimaryKeys(boolean partitioned)

Description copied from interface: TemporalTableSupport

Do we need to suppress creation of the primary key constraint on a temporal table?

Specified by:

suppressesTemporalTablePrimaryKeys in interface TemporalTableSupport

Overrides:

suppressesTemporalTablePrimaryKeys in class DefaultTemporalTableSupport

Parameters:

partitioned - Is partitioning requested

getTemporalTableOptions

public String getTemporalTableOptions(TemporalTableStrategy strategy,
 String rowEndColumnName,
 boolean partitioned,
 String currentPartition,
 String historyPartition)

Description copied from interface: TemporalTableSupport

Table options to use for temporal tables, used to specify system versioning or table partitioning.

Specified by:

getTemporalTableOptions in interface TemporalTableSupport

Overrides:

getTemporalTableOptions in class DefaultTemporalTableSupport

Parameters:

strategy - The temporal table strategy

rowEndColumnName - The name of the row end column specified via Temporal.rowEnd()

partitioned - Is partitioning requested

currentPartition - The current partition name, if specified

historyPartition - The history partition name, if specified

Returns:

The options, or null if there are no options

supportsNativeTemporalTables

public boolean supportsNativeTemporalTables()

Description copied from interface: TemporalTableSupport

Does this dialect natively support SQL 2011-style temporal tables?

Specified by:

supportsNativeTemporalTables in interface TemporalTableSupport

Overrides:

supportsNativeTemporalTables in class DefaultTemporalTableSupport

See Also:

• TemporalTableStrategy.NATIVE

addTemporalTableAuxiliaryObjects

public void addTemporalTableAuxiliaryObjects(TemporalTableStrategy strategy,
 Table table,
 Database database,
 boolean partitioned,
 String currentPartitionName,
 String historyPartitionName)

Description copied from interface: TemporalTableSupport

Register any auxiliary database objects required for the given temporary table and strategy. Used to create history tables or table partitions.

Specified by:

addTemporalTableAuxiliaryObjects in interface TemporalTableSupport

Overrides:

addTemporalTableAuxiliaryObjects in class DefaultTemporalTableSupport

Parameters:

strategy - The temporal table strategy

table - A temporal table

database - The database to register with

partitioned - Is partitioning requested

currentPartitionName - The current partition name, if specified

historyPartitionName - The history partition name, if specified