org.hibernate.dialect

Class OracleDialect

java.lang.Object

org.hibernate.dialect.Dialect

org.hibernate.dialect.Oracle9Dialect

org.hibernate.dialect.OracleDialect

Deprecated.

Use Oracle8iDialect instead.

public class OracleDialect
extends Oracle9Dialect

An SQL dialect for Oracle, compatible with Oracle 8.

Author:

Gavin King

Field Summary

Fields inherited from class org.hibernate.dialect.Dialect

CLOSED_QUOTE, DEFAULT_BATCH_SIZE, NO_BATCH, QUOTE

Constructor Summary

Constructors

Constructor and Description
OracleDialect() Deprecated.

Method Summary

Methods

Modifier and Type	Method and Description
CaseFragment	createCaseFragment() Deprecated. Create a CaseFragment strategy responsible for handling this dialect's variations in how CASE statements are handled.
JoinFragment	createOuterJoinFragment() Deprecated. Create a JoinFragment strategy responsible for handling this dialect's variations in how joins are handled.
java.lang.String	getCurrentTimestampSelectString() Deprecated. Retrieve the command used to retrieve the current timestamp from the database.
java.lang.String	getCurrentTimestampSQLFunctionName() Deprecated. The name of the database-specific SQL function for retrieving the current timestamp.
java.lang.String	getLimitString(java.lang.String sql, boolean hasOffset) Deprecated. Apply s limit clause to the query.
java.lang.String	getSelectClauseNullString(int sqlType) Deprecated. Given a Types type code, determine an appropriate null value to use in a select clause.

Methods inherited from class org.hibernate.dialect.Oracle9Dialect

bindLimitParametersInReverseOrder, dropConstraints, dropTemporaryTableAfterUse, forUpdateOfColumns, generateTemporaryTableName, getAddColumnString, getCascadeConstraintsString, getCreateSequenceString, getCreateTemporaryTablePostfix, getCreateTemporaryTableString, getDropSequenceString, getForUpdateNowaitString, getForUpdateNowaitString, getForUpdateString, getQuerySequencesString, getResultSet, getSelectGUIDString, getSelectSequenceNextValString, getSequenceNextValString, getViolatedConstraintNameExtracter, isCurrentTimestampSelectStringCallable, registerResultSetOutParameter, supportsCommentOn, supportsCurrentTimestampSelection, supportsEmptyInList, supportsExistsInSelect, supportsLimit, supportsPooledSequences, supportsSequences, supportsTemporaryTables, supportsUnionAll, useMaxForLimit

Methods inherited from class org.hibernate.dialect.Dialect

addTypeOverride, appendIdentitySelectToInsert, appendLockHint, applyLocksToSql, areStringComparisonsCaseInsensitive, bindLimitParametersFirst, buildSQLExceptionConverter, closeQuote, convertToFirstRowValue, doesReadCommittedCauseWritersToBlockReaders, doesRepeatableReadCauseReadersToBlockWriters, forceLimitUsage, getAddForeignKeyConstraintString, getAddPrimaryKeyConstraintString, getCastTypeName, getColumnAliasExtractor, getColumnComment, getCreateMultisetTableString, getCreateSequenceString, getCreateSequenceStrings, getCreateSequenceStrings, getCreateTableString, getCrossJoinSeparator, getDefaultProperties, getDialect, getDialect, getDropForeignKeyString, getDropSequenceStrings, getDropTemporaryTableString, getForUpdateString, getForUpdateString, getForUpdateString, getForUpdateString, getFunctions, getHibernateTypeName, getHibernateTypeName, getIdentityColumnString, getIdentityColumnString, getIdentityInsertString, getIdentitySelectString, getIdentitySelectString, getKeywords, getLimitString, getLockingStrategy, getLowercaseFunction, getMaxAliasLength, getNativeIdentifierGeneratorClass, getNoColumnsInsertString, getNullColumnString, getReadLockString, getTableComment, getTableTypeString, getTypeName, getTypeName, getTypeOverrides, getWriteLockString, hasAlterTable, hasDataTypeInIdentityColumn, hasSelfReferentialForeignKeyBug, isLockTimeoutParameterized, openQuote, performTemporaryTableDDLInIsolation, qualifyIndexName, quote, registerColumnType, registerColumnType, registerFunction, registerHibernateType, registerHibernateType, registerKeyword, replaceResultVariableInOrderByClauseWithPosition, requiresCastingOfParametersInSelectClause, supportsBindAsCallableArgument, supportsCascadeDelete, supportsCircularCascadeDeleteConstraints, supportsColumnCheck, supportsExpectedLobUsagePattern, supportsIdentityColumns, supportsIfExistsAfterTableName, supportsIfExistsBeforeTableName, supportsInsertSelectIdentity, supportsLimitOffset, supportsLobValueChangePropogation, supportsLockTimeouts, supportsNotNullUnique, supportsOuterJoinForUpdate, supportsParametersInInsertSelect, supportsResultSetPositionQueryMethodsOnForwardOnlyCursor, supportsRowValueConstructorSyntax, supportsRowValueConstructorSyntaxInInList, supportsSubqueryOnMutatingTable, supportsSubselectAsInPredicateLHS, supportsTableCheck, supportsTupleCounts, supportsTupleDistinctCounts, supportsUnboundedLobLocatorMaterialization, supportsUnique, supportsUniqueConstraintInCreateAlterTable, supportsVariableLimit, toBooleanValueString, toString, transformSelectString, useInputStreamToInsertBlob

Methods inherited from class java.lang.Object

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

Constructor Detail

OracleDialect

public OracleDialect()

Deprecated.

Method Detail

createOuterJoinFragment

public JoinFragment createOuterJoinFragment()

Deprecated.

Description copied from class: Dialect

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

Overrides:

createOuterJoinFragment in class Dialect

Returns:

This dialect's JoinFragment strategy.

createCaseFragment

public CaseFragment createCaseFragment()

Deprecated.

Description copied from class: Dialect

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

Overrides:

createCaseFragment in class Dialect

Returns:

This dialect's CaseFragment strategy.

getLimitString

public java.lang.String getLimitString(java.lang.String sql,
                              boolean hasOffset)

Deprecated.

Description copied from class: Dialect

Apply s 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 offest 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 Dialect.getLimitString(String, int, int).

Overrides:

getLimitString in class Oracle9Dialect

Parameters:

sql - The query to which to apply the limit.

hasOffset - Is the query requesting an offset?

Returns:

the modified SQL

getSelectClauseNullString

public java.lang.String getSelectClauseNullString(int sqlType)

Deprecated.

Description copied from class: Dialect

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.

Overrides:

getSelectClauseNullString in class Dialect

Parameters:

sqlType - The Types type code.

Returns:

The appropriate select clause value fragment.

getCurrentTimestampSelectString

public java.lang.String getCurrentTimestampSelectString()

Deprecated.

Description copied from class: Dialect

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

Overrides:

getCurrentTimestampSelectString in class Oracle9Dialect

Returns:

The command.

getCurrentTimestampSQLFunctionName

public java.lang.String getCurrentTimestampSQLFunctionName()

Deprecated.

Description copied from class: Dialect

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

Overrides:

getCurrentTimestampSQLFunctionName in class Dialect

Returns:

The function name.