Top Description Fields Constructors Methods
org.hibernate.dialect

public Class OracleDialect

extends Oracle9Dialect
Class Inheritance
Annotations
@SuppressWarnings:deprecation
@Deprecated
Imports
java.sql.Types, java.util.Locale, org.hibernate.internal.CoreMessageLogger, org.hibernate.sql.CaseFragment, .DecodeCaseFragment, .JoinFragment, .OracleJoinFragment, org.jboss.logging.Logger

Deprecated

Use Oracle8iDialect instead.

An SQL dialect for Oracle, compatible with Oracle 8.
Author
Gavin King

Field Summary

Modifier and TypeField and Description
private static final CoreMessageLogger
LOG

Hides org.hibernate.dialect.Oracle9Dialect.LOG.

Constructor Summary

AccessConstructor and Description
public
OracleDialect()

Constructs a (DEPRECATED) Oracle9Dialect

Method Summary

Modifier and TypeMethod and Description
public CaseFragment
createCaseFragment()

Overrides org.hibernate.dialect.Dialect.createCaseFragment.

Create a CaseFragment strategy responsible for handling this dialect's variations in how CASE statements are handled.
public JoinFragment
createOuterJoinFragment()

Overrides org.hibernate.dialect.Dialect.createOuterJoinFragment.

Create a JoinFragment strategy responsible for handling this dialect's variations in how joins are handled.
public String
getCurrentTimestampSelectString()

Overrides org.hibernate.dialect.Oracle9Dialect.getCurrentTimestampSelectString.

Retrieve the command used to retrieve the current timestamp from the database.
public String
getCurrentTimestampSQLFunctionName()

Overrides org.hibernate.dialect.Dialect.getCurrentTimestampSQLFunctionName.

The name of the database-specific SQL function for retrieving the current timestamp.
public String
getLimitString(String
The query to which to apply the limit.
sql, boolean
Is the query requesting an offset?
hasOffset)

Overrides org.hibernate.dialect.Oracle9Dialect.getLimitString.

Apply a limit clause to the query.
public String
getSelectClauseNullString(int
The Types type code.
sqlType)

Overrides org.hibernate.dialect.Dialect.getSelectClauseNullString.

Given a Types type code, determine an appropriate null value to use in a select clause.
Inherited from org.hibernate.dialect.Oracle9Dialect:
bindLimitParametersInReverseOrdercanCreateSchemadropConstraintsforUpdateOfColumnsgetAddColumnStringgetCascadeConstraintsStringgetCreateSequenceStringgetDefaultMultiTableBulkIdStrategygetDropSequenceStringgetForUpdateNowaitStringgetForUpdateNowaitStringgetForUpdateStringgetInExpressionCountLimitgetNotExpressiongetQuerySequencesStringgetResultSetgetSelectGUIDStringgetSelectSequenceNextValStringgetSequenceInformationExtractorgetSequenceNextValStringgetViolatedConstraintNameExtracterisCurrentTimestampSelectStringCallableregisterResultSetOutParametersupportsCommentOnsupportsCurrentTimestampSelectionsupportsEmptyInListsupportsExistsInSelectsupportsLimitsupportsNoWaitsupportsPooledSequencessupportsSequencessupportsUnionAlluseMaxForLimit

Field Detail

LOGback to summary
private static final CoreMessageLogger LOG

Hides org.hibernate.dialect.Oracle9Dialect.LOG.

Constructor Detail

OracleDialectback to summary
public OracleDialect()

Constructs a (DEPRECATED) Oracle9Dialect

Method Detail

createCaseFragmentback to summary
public CaseFragment createCaseFragment()

Overrides org.hibernate.dialect.Dialect.createCaseFragment.

Doc from org.hibernate.dialect.Dialect.createCaseFragment.

Create a CaseFragment strategy responsible for handling this dialect's variations in how CASE statements are handled.

Returns:CaseFragment

This dialect's CaseFragment strategy.

Annotations
@Override
createOuterJoinFragmentback to summary
public JoinFragment createOuterJoinFragment()

Overrides org.hibernate.dialect.Dialect.createOuterJoinFragment.

Doc from org.hibernate.dialect.Dialect.createOuterJoinFragment.

Create a JoinFragment strategy responsible for handling this dialect's variations in how joins are handled.

Returns:JoinFragment

This dialect's JoinFragment strategy.

Annotations
@Override
getCurrentTimestampSelectStringback to summary
public String getCurrentTimestampSelectString()

Overrides org.hibernate.dialect.Oracle9Dialect.getCurrentTimestampSelectString.

Doc from org.hibernate.dialect.Dialect.getCurrentTimestampSelectString.

Retrieve the command used to retrieve the current timestamp from the database.

Returns:String

The command.

Annotations
@Override
getCurrentTimestampSQLFunctionNameback to summary
public String getCurrentTimestampSQLFunctionName()

Overrides org.hibernate.dialect.Dialect.getCurrentTimestampSQLFunctionName.

Doc from org.hibernate.dialect.Dialect.getCurrentTimestampSQLFunctionName.

The name of the database-specific SQL function for retrieving the current timestamp.

Returns:String

The function name.

Annotations
@Override
getLimitStringback to summary
public String getLimitString(String sql, boolean hasOffset)

Overrides org.hibernate.dialect.Oracle9Dialect.getLimitString.

Doc from org.hibernate.dialect.Dialect.getLimitString.

Apply a limit clause to the query.

Typically dialects utilize variable limit clauses when they support limits. Thus, when building the select command we do not actually need to know the limit or the offset since we will just be using placeholders.

Here we do still pass along whether or not an offset was specified so that dialects not supporting offsets can generate proper exceptions. In general, dialects will override one or the other of this method and getLimitString(String, int, int).

Parameters
sql:String

The query to which to apply the limit.

hasOffset:boolean

Is the query requesting an offset?

Returns:String

the modified SQL

Annotations
@Override
getSelectClauseNullStringback to summary
public String getSelectClauseNullString(int sqlType)

Overrides org.hibernate.dialect.Dialect.getSelectClauseNullString.

Doc from org.hibernate.dialect.Dialect.getSelectClauseNullString.

Given a Types type code, determine an appropriate null value to use in a select clause.

One thing to consider here is that certain databases might require proper casting for the nulls here since the select here will be part of a UNION/UNION ALL.

Parameters
sqlType:int

The Types type code.

Returns:String

The appropriate select clause value fragment.

Annotations
@Override