Top Description Constructors Methods
org.hibernate.dialect

public Class Oracle10gDialect

extends Oracle9iDialect
Class Inheritance
Known Direct Subclasses
org.hibernate.dialect.Oracle12cDialect
Imports
java.sql.CallableStatement, .ResultSet, .SQLException, org.hibernate.LockOptions, org.hibernate.sql.ANSIJoinFragment, .JoinFragment
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

Constructor Summary

AccessConstructor and Description
public
Oracle10gDialect()

Constructs an Oracle10gDialect

Method Summary

Modifier and TypeMethod and Description
public JoinFragment
createOuterJoinFragment()

Overrides org.hibernate.dialect.Oracle8iDialect.createOuterJoinFragment.

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

Overrides org.hibernate.dialect.Oracle8iDialect.getCrossJoinSeparator.

Returns the separator to use for defining cross joins when translating HQL queries.
public String
getForUpdateSkipLockedString()

Overrides org.hibernate.dialect.Dialect.getForUpdateSkipLockedString.

Retrieves the FOR UPDATE SKIP LOCKED syntax specific to this dialect.
public String
getForUpdateSkipLockedString(String
The columns to be write locked.
aliases)

Overrides org.hibernate.dialect.Dialect.getForUpdateSkipLockedString.

Get the FOR UPDATE OF column_list SKIP LOCKED fragment appropriate for this dialect given the aliases of the columns to be write locked.
public ResultSet
getResultSet(CallableStatement
The callable statement.
statement, int
The bind position at which to register the output param.
position)

Overrides org.hibernate.dialect.Dialect.getResultSet.

Given a callable statement previously processed by registerResultSetOutParameter, extract the ResultSet.
public ResultSet
getResultSet(CallableStatement
The callable statement.
statement, String
The parameter name (for drivers which support named parameters).
name)

Overrides org.hibernate.dialect.Dialect.getResultSet.

Given a callable statement previously processed by registerResultSetOutParameter, extract the ResultSet from the OUT parameter.
public String
getWriteLockString(int
in milliseconds, -1 for indefinite wait and 0 for no wait.
timeout)

Overrides org.hibernate.dialect.Oracle9iDialect.getWriteLockString.

Get the string to append to SELECT statements to acquire WRITE locks for this dialect.
public String
getWriteLockString(String
The columns to be read locked.
aliases, int
in milliseconds, -1 for indefinite wait and 0 for no wait.
timeout)

Overrides org.hibernate.dialect.Dialect.getWriteLockString.

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.
public int
registerResultSetOutParameter(CallableStatement
The callable statement.
statement, String
The parameter name (for drivers which support named parameters).
name)

Overrides org.hibernate.dialect.Dialect.registerResultSetOutParameter.

Registers a parameter (either OUT, or the new REF_CURSOR param type available in Java 8) capable of returning ResultSet *by name*.
public boolean
supportsSkipLocked()

Overrides org.hibernate.dialect.Dialect.supportsSkipLocked.

Does this dialect/database support SKIP_LOCKED timeout.
Inherited from org.hibernate.dialect.Oracle9iDialect:
createCaseFragmentgetCurrentTimestampSelectStringgetCurrentTimestampSQLFunctionNamegetForUpdateStringgetLimitHandlergetLimitStringgetReadLockStringgetSelectClauseNullStringregisterCharacterTypeMappingsregisterDateTimeTypeMappingssupportsRowValueConstructorSyntaxInInListsupportsTupleDistinctCounts

Constructor Detail

Oracle10gDialectback to summary
public Oracle10gDialect()

Constructs an Oracle10gDialect

Method Detail

createOuterJoinFragmentback to summary
public JoinFragment createOuterJoinFragment()

Overrides org.hibernate.dialect.Oracle8iDialect.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
getCrossJoinSeparatorback to summary
public String getCrossJoinSeparator()

Overrides org.hibernate.dialect.Oracle8iDialect.getCrossJoinSeparator.

Doc from org.hibernate.dialect.Dialect.getCrossJoinSeparator.

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!

Returns:String

The cross join separator

Annotations
@Override
getForUpdateSkipLockedStringback to summary
public String getForUpdateSkipLockedString()

Overrides org.hibernate.dialect.Dialect.getForUpdateSkipLockedString.

Doc from org.hibernate.dialect.Dialect.getForUpdateSkipLockedString.

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

Returns:String

The appropriate FOR UPDATE SKIP LOCKED clause string.

Annotations
@Override
getForUpdateSkipLockedStringback to summary
public String getForUpdateSkipLockedString(String aliases)

Overrides org.hibernate.dialect.Dialect.getForUpdateSkipLockedString.

Doc from org.hibernate.dialect.Dialect.getForUpdateSkipLockedString.

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

Parameters
aliases:String

The columns to be write locked.

Returns:String

The appropriate FOR UPDATE colunm_list SKIP LOCKED clause string.

Annotations
@Override
getResultSetback to summary
public ResultSet getResultSet(CallableStatement statement, int position) throws SQLException

Overrides org.hibernate.dialect.Dialect.getResultSet.

Doc from org.hibernate.dialect.Dialect.getResultSet.

Given a callable statement previously processed by registerResultSetOutParameter, extract the ResultSet.

Parameters
statement:CallableStatement

The callable statement.

position:int

The bind position at which to register the output param.

Returns:ResultSet

The extracted result set.

Annotations
@Override
Exceptions
SQLException:
Indicates problems extracting the result set.
getResultSetback to summary
public ResultSet getResultSet(CallableStatement statement, String name) throws SQLException

Overrides org.hibernate.dialect.Dialect.getResultSet.

Doc from org.hibernate.dialect.Dialect.getResultSet.

Given a callable statement previously processed by registerResultSetOutParameter, extract the ResultSet from the OUT parameter.

Parameters
statement:CallableStatement

The callable statement.

name:String

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

Returns:ResultSet

The extracted result set.

Annotations
@Override
Exceptions
SQLException:
Indicates problems extracting the result set.
getWriteLockStringback to summary
public String getWriteLockString(int timeout)

Overrides org.hibernate.dialect.Oracle9iDialect.getWriteLockString.

Doc from org.hibernate.dialect.Dialect.getWriteLockString.

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

Parameters
timeout:int

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

Returns:String

The appropriate LOCK clause string.

Annotations
@Override
getWriteLockStringback to summary
public String getWriteLockString(String aliases, int timeout)

Overrides org.hibernate.dialect.Dialect.getWriteLockString.

Doc from org.hibernate.dialect.Dialect.getWriteLockString.

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.

Parameters
aliases:String

The columns to be read locked.

timeout:int

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

Returns:String

The appropriate LOCK clause string.

Annotations
@Override
registerResultSetOutParameterback to summary
public int registerResultSetOutParameter(CallableStatement statement, String name) throws SQLException

Overrides org.hibernate.dialect.Dialect.registerResultSetOutParameter.

Doc from org.hibernate.dialect.Dialect.registerResultSetOutParameter.

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.

Parameters
statement:CallableStatement

The callable statement.

name:String

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

Returns:int

The number of (contiguous) bind positions used.

Annotations
@Override
Exceptions
SQLException:
Indicates problems registering the param.
supportsSkipLockedback to summary
public boolean supportsSkipLocked()

Overrides org.hibernate.dialect.Dialect.supportsSkipLocked.

Doc from org.hibernate.dialect.Dialect.supportsSkipLocked.

Does this dialect/database support SKIP_LOCKED timeout.

Returns:boolean

true if SKIP_LOCKED is supported

Annotations
@Override