org.hibernate.dialect

Class Oracle10gDialect

java.lang.Object

org.hibernate.dialect.Dialect

org.hibernate.dialect.Oracle8iDialect

org.hibernate.dialect.Oracle9iDialect

org.hibernate.dialect.Oracle10gDialect

All Implemented Interfaces:

ConversionContext

Direct Known Subclasses:

Oracle12cDialect

public class Oracle10gDialect
extends Oracle9iDialect

A dialect specifically for use with Oracle 10g.

The main difference between this dialect and Oracle9iDialect is the use of "ANSI join syntax".

Author:

Steve Ebersole

Field Summary

Fields inherited from class org.hibernate.dialect.Dialect

CLOSED_QUOTE, DEFAULT_BATCH_SIZE, LEGACY_LOB_MERGE_STRATEGY, NEW_LOCATOR_LOB_MERGE_STRATEGY, NO_BATCH, QUOTE, STANDARD_DEFAULT_BATCH_LOAD_SIZING_STRATEGY, STREAM_XFER_LOB_MERGE_STRATEGY

Constructor Summary

Constructors

Constructor and Description
Oracle10gDialect() Constructs a Oracle10gDialect

Method Summary

Modifier and Type	Method and Description
JoinFragment	createOuterJoinFragment() Create a JoinFragment strategy responsible for handling this dialect's variations in how joins are handled.
String	getCrossJoinSeparator() Returns the separator to use for defining cross joins when translating HQL queries.
String	getForUpdateSkipLockedString() Retrieves the FOR UPDATE SKIP LOCKED syntax specific to this dialect.
String	getForUpdateSkipLockedString(String aliases) Get the FOR UPDATE OF column_list SKIP LOCKED fragment appropriate for this dialect given the aliases of the columns to be write locked.
ResultSet	getResultSet(CallableStatement statement, int position) Given a callable statement previously processed by Dialect.registerResultSetOutParameter(java.sql.CallableStatement, int), extract the ResultSet.
ResultSet	getResultSet(CallableStatement statement, String name) Given a callable statement previously processed by Dialect.registerResultSetOutParameter(java.sql.CallableStatement, int), extract the ResultSet from the OUT parameter.
String	getWriteLockString(int timeout) Get the string to append to SELECT statements to acquire WRITE locks for this dialect.
String	getWriteLockString(String aliases, int timeout) Get the string to append to SELECT statements to acquire WRITE locks for this dialect given the aliases of the columns to be write locked.
int	registerResultSetOutParameter(CallableStatement statement, String name) Registers a parameter (either OUT, or the new REF_CURSOR param type available in Java 8) capable of returning ResultSet *by name*.
boolean	supportsSkipLocked() Does this dialect/database support SKIP_LOCKED timeout.

Methods inherited from class org.hibernate.dialect.Oracle9iDialect

createCaseFragment, getCurrentTimestampSelectString, getCurrentTimestampSQLFunctionName, getForUpdateString, getLimitHandler, getLimitString, getReadLockString, getSelectClauseNullString, registerCharacterTypeMappings, registerDateTimeTypeMappings, supportsRowValueConstructorSyntaxInInList, supportsTupleDistinctCounts

Methods inherited from class org.hibernate.dialect.Oracle8iDialect

bindLimitParametersInReverseOrder, buildSQLExceptionConversionDelegate, canCreateSchema, dropConstraints, forceLobAsLastValue, forUpdateOfColumns, getAddColumnString, getBasicSelectClauseNullString, getCallableStatementSupport, getCascadeConstraintsString, getCreateSequenceString, getCreateSequenceString, getCurrentSchemaCommand, getDefaultMultiTableBulkIdStrategy, getDropSequenceString, getForUpdateNowaitString, getForUpdateNowaitString, getForUpdateString, getInExpressionCountLimit, getMaxAliasLength, getNotExpression, getQueryHintString, getQuerySequencesString, getResultSet, getSelectGUIDString, getSelectSequenceNextValString, getSequenceNextValString, getSqlTypeDescriptorOverride, getViolatedConstraintNameExtracter, isCurrentTimestampSelectStringCallable, registerDefaultProperties, registerFunctions, registerLargeObjectTypeMappings, registerNumericTypeMappings, registerResultSetOutParameter, registerReverseHibernateTypeMappings, statementType, supportsCommentOn, supportsCurrentTimestampSelection, supportsEmptyInList, supportsExistsInSelect, supportsLimit, supportsNoWait, supportsPartitionBy, supportsPooledSequences, supportsSequences, supportsUnionAll, useFollowOnLocking, useMaxForLimit

Methods inherited from class org.hibernate.dialect.Dialect

addSqlHintOrComment, appendLockHint, appendLockHint, applyLocksToSql, areStringComparisonsCaseInsensitive, augmentRecognizedTableTypes, bindLimitParametersFirst, buildIdentifierHelper, buildSQLExceptionConverter, canCreateCatalog, cast, cast, cast, closeQuote, contributeTypes, convertToFirstRowValue, defaultScrollMode, doesReadCommittedCauseWritersToBlockReaders, doesRepeatableReadCauseReadersToBlockWriters, escapeLiteral, forceLimitUsage, getAddColumnSuffixString, getAddForeignKeyConstraintString, getAddForeignKeyConstraintString, getAddPrimaryKeyConstraintString, getAddUniqueConstraintString, getAlterTableString, getAuxiliaryDatabaseObjectExporter, getCaseInsensitiveLike, getCastTypeName, getColumnAliasExtractor, getColumnComment, getCreateCatalogCommand, getCreateMultisetTableString, getCreateSchemaCommand, getCreateSequenceStrings, getCreateSequenceStrings, getCreateTableString, getDefaultBatchLoadSizingStrategy, getDefaultProperties, getDialect, getDialect, getDropCatalogCommand, getDropForeignKeyString, getDropSchemaCommand, getDropSequenceStrings, getDropTableString, getForeignKeyExporter, getForUpdateString, getForUpdateString, getForUpdateString, getFunctions, getHibernateTypeName, getHibernateTypeName, getIdentityColumnSupport, getIndexExporter, getKeywords, getLimitString, getLobMergeStrategy, getLockingStrategy, getLowercaseFunction, getNameQualifierSupport, getNativeIdentifierGeneratorClass, getNativeIdentifierGeneratorStrategy, getNoColumnsInsertString, getNullColumnString, getQueryHintString, getReadLockString, getSchemaNameResolver, getSequenceExporter, getSequenceInformationExtractor, getTableComment, getTableExporter, getTableTypeString, getTypeName, getTypeName, getUniqueDelegate, getUniqueKeyExporter, hasAlterTable, hasSelfReferentialForeignKeyBug, inlineLiteral, isJdbcLogWarningsEnabledByDefault, isLegacyLimitHandlerBehaviorEnabled, isLockTimeoutParameterized, isTypeNameRegistered, openQuote, prependComment, qualifyIndexName, quote, registerColumnType, registerColumnType, registerFunction, registerHibernateType, registerHibernateType, registerKeyword, remapSqlTypeDescriptor, renderOrderByElement, replaceResultVariableInOrderByClauseWithPosition, requiresCastingOfParametersInSelectClause, requiresParensForTupleDistinctCounts, supportsBindAsCallableArgument, supportsCascadeDelete, supportsCaseInsensitiveLike, supportsCircularCascadeDeleteConstraints, supportsColumnCheck, supportsExpectedLobUsagePattern, supportsIfExistsAfterAlterTable, supportsIfExistsAfterConstraintName, supportsIfExistsAfterTableName, supportsIfExistsBeforeConstraintName, supportsIfExistsBeforeTableName, supportsLimitOffset, supportsLobValueChangePropogation, supportsLockTimeouts, supportsNamedParameters, supportsNationalizedTypes, supportsNonQueryWithCTE, supportsNotNullUnique, supportsOuterJoinForUpdate, supportsParametersInInsertSelect, supportsResultSetPositionQueryMethodsOnForwardOnlyCursor, supportsRowValueConstructorSyntax, supportsSubqueryOnMutatingTable, supportsSubselectAsInPredicateLHS, supportsTableCheck, supportsTupleCounts, supportsTuplesInSubqueries, supportsUnboundedLobLocatorMaterialization, supportsUnique, supportsUniqueConstraintInCreateAlterTable, supportsValuesList, supportsVariableLimit, toBooleanValueString, toString, transformSelectString, useFollowOnLocking, useInputStreamToInsertBlob

Methods inherited from class java.lang.Object

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

Constructor Detail

Oracle10gDialect

public Oracle10gDialect()

Constructs a Oracle10gDialect

Method Detail

createOuterJoinFragment

public JoinFragment createOuterJoinFragment()

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 Oracle8iDialect

Returns:

This dialect's JoinFragment strategy.

getCrossJoinSeparator

public String getCrossJoinSeparator()

Description copied from class: Dialect

Returns the separator to use for defining cross joins when translating HQL queries.

Typically this will be either [ cross join ] or [, ]

Note that the spaces are important!

Overrides:

getCrossJoinSeparator in class Oracle8iDialect

Returns:

The cross join separator

getWriteLockString

public String getWriteLockString(int timeout)

Description copied from class: Dialect

Get the string to append to SELECT statements to acquire WRITE locks for this dialect. Location of the of the returned string is treated the same as getForUpdateString.

Overrides:

getWriteLockString in class Oracle9iDialect

Parameters:

timeout - in milliseconds, -1 for indefinite wait and 0 for no wait.

Returns:

The appropriate LOCK clause string.

getWriteLockString

public String getWriteLockString(String aliases,
                                 int timeout)

Description copied from class: Dialect

Get the string to append to SELECT statements to acquire WRITE locks for this dialect given the aliases of the columns to be write locked. Location of the of the returned string is treated the same as getForUpdateString.

Overrides:

getWriteLockString in class Dialect

Parameters:

aliases - The columns to be read locked.

timeout - in milliseconds, -1 for indefinite wait and 0 for no wait.

Returns:

The appropriate LOCK clause string.

getForUpdateSkipLockedString

public String getForUpdateSkipLockedString()

Description copied from class: Dialect

Retrieves the FOR UPDATE SKIP LOCKED syntax specific to this dialect.

Overrides:

getForUpdateSkipLockedString in class Dialect

Returns:

The appropriate FOR UPDATE SKIP LOCKED clause string.

getForUpdateSkipLockedString

public String getForUpdateSkipLockedString(String aliases)

Description copied from class: Dialect

Get the FOR UPDATE OF column_list SKIP LOCKED fragment appropriate for this dialect given the aliases of the columns to be write locked.

Overrides:

getForUpdateSkipLockedString in class Dialect

Parameters:

aliases - The columns to be write locked.

Returns:

The appropriate FOR UPDATE colunm_list SKIP LOCKED clause string.

getResultSet

public ResultSet getResultSet(CallableStatement statement,
                              int position)
                       throws SQLException

Description copied from class: Dialect

Given a callable statement previously processed by Dialect.registerResultSetOutParameter(java.sql.CallableStatement, int), extract the ResultSet.

Overrides:

getResultSet in class Dialect

Parameters:

statement - The callable statement.

position - The bind position at which to register the output param.

Returns:

The extracted result set.

Throws:

SQLException - Indicates problems extracting the result set.

registerResultSetOutParameter

public int registerResultSetOutParameter(CallableStatement statement,
                                         String name)
                                  throws SQLException

Description copied from class: Dialect

Registers a parameter (either OUT, or the new REF_CURSOR param type available in Java 8) capable of returning ResultSet *by name*. Pre-Java 8, registering such ResultSet-returning parameters varied greatly across database and drivers; hence its inclusion as part of the Dialect contract.

Overrides:

registerResultSetOutParameter in class Dialect

Parameters:

statement - The callable statement.

name - The parameter name (for drivers which support named parameters).

Returns:

The number of (contiguous) bind positions used.

Throws:

SQLException - Indicates problems registering the param.

getResultSet

public ResultSet getResultSet(CallableStatement statement,
                              String name)
                       throws SQLException

Description copied from class: Dialect

Given a callable statement previously processed by Dialect.registerResultSetOutParameter(java.sql.CallableStatement, int), extract the ResultSet from the OUT parameter.

Overrides:

getResultSet in class Dialect

Parameters:

statement - The callable statement.

name - The parameter name (for drivers which support named parameters).

Returns:

The extracted result set.

Throws:

SQLException - Indicates problems extracting the result set.

supportsSkipLocked

public boolean supportsSkipLocked()

Description copied from class: Dialect

Does this dialect/database support SKIP_LOCKED timeout.

Overrides:

supportsSkipLocked in class Dialect

Returns:

true if SKIP_LOCKED is supported