org.hibernate.dialect

Class Oracle9Dialect

Known Direct Subclasses:
DataDirectOracle9Dialect, OracleDialect

public class Oracle9Dialect
extends Dialect

An SQL dialect for Oracle 9 (uses ANSI-style syntax where possible).
Author:
Gavin King, David Channon

Field Summary

Fields inherited from class org.hibernate.dialect.Dialect

CLOSED_QUOTE, DEFAULT_BATCH_SIZE, NO_BATCH, QUOTE

Constructor Summary

Oracle9Dialect()

Method Summary

boolean
bindLimitParametersInReverseOrder()
boolean
dropConstraints()
boolean
dropTemporaryTableAfterUse()
boolean
forUpdateOfColumns()
String
generateTemporaryTableName(String baseTableName)
String
getAddColumnString()
String
getCascadeConstraintsString()
String
getCreateSequenceString(String sequenceName)
String
getCreateTemporaryTablePostfix()
String
getCreateTemporaryTableString()
String
getCurrentTimestampSelectString()
String
getDropSequenceString(String sequenceName)
String
getForUpdateNowaitString()
String
getForUpdateNowaitString(String aliases)
String
getForUpdateString(String aliases)
String
getLimitString(String sql, boolean hasOffset)
String
getQuerySequencesString()
ResultSet
getResultSet(CallableStatement ps)
String
getSelectGUIDString()
String
getSelectSequenceNextValString(String sequenceName)
String
getSequenceNextValString(String sequenceName)
ViolatedConstraintNameExtracter
getViolatedConstraintNameExtracter()
boolean
isCurrentTimestampSelectStringCallable()
int
registerResultSetOutParameter(CallableStatement statement, int col)
boolean
supportsCommentOn()
boolean
supportsCurrentTimestampSelection()
boolean
supportsEmptyInList()
boolean
supportsExistsInSelect()
boolean
supportsLimit()
boolean
supportsPooledSequences()
boolean
supportsSequences()
boolean
supportsTemporaryTables()
boolean
supportsUnionAll()
boolean
useMaxForLimit()

Methods inherited from class org.hibernate.dialect.Dialect

appendIdentitySelectToInsert, appendLockHint, applyLocksToSql, areStringComparisonsCaseInsensitive, bindLimitParametersFirst, bindLimitParametersInReverseOrder, buildSQLExceptionConverter, closeQuote, createCaseFragment, createOuterJoinFragment, doesReadCommittedCauseWritersToBlockReaders, doesRepeatableReadCauseReadersToBlockWriters, dropConstraints, dropTemporaryTableAfterUse, forUpdateOfColumns, generateTemporaryTableName, getAddColumnString, getAddForeignKeyConstraintString, getAddPrimaryKeyConstraintString, getCascadeConstraintsString, getCastTypeName, getColumnComment, getCreateMultisetTableString, getCreateSequenceString, getCreateSequenceString, getCreateSequenceStrings, getCreateSequenceStrings, getCreateTableString, getCreateTemporaryTablePostfix, getCreateTemporaryTableString, getCurrentTimestampSQLFunctionName, getCurrentTimestampSelectString, getDefaultProperties, getDialect, getDialect, getDropForeignKeyString, getDropSequenceString, getDropSequenceStrings, getForUpdateNowaitString, getForUpdateNowaitString, getForUpdateString, getForUpdateString, getForUpdateString, getFunctions, getHibernateTypeName, getHibernateTypeName, getIdentityColumnString, getIdentityColumnString, getIdentityInsertString, getIdentitySelectString, getIdentitySelectString, getKeywords, getLimitString, getLimitString, getLockingStrategy, getLowercaseFunction, getMaxAliasLength, getNativeIdentifierGeneratorClass, getNoColumnsInsertString, getNullColumnString, getQuerySequencesString, getResultSet, getSelectClauseNullString, getSelectGUIDString, getSelectSequenceNextValString, getSequenceNextValString, getTableComment, getTableTypeString, getTypeName, getTypeName, getViolatedConstraintNameExtracter, hasAlterTable, hasDataTypeInIdentityColumn, hasSelfReferentialForeignKeyBug, isCurrentTimestampSelectStringCallable, openQuote, performTemporaryTableDDLInIsolation, qualifyIndexName, quote, registerColumnType, registerColumnType, registerFunction, registerHibernateType, registerHibernateType, registerKeyword, registerResultSetOutParameter, supportsBindAsCallableArgument, supportsCascadeDelete, supportsCircularCascadeDeleteConstraints, supportsColumnCheck, supportsCommentOn, supportsCurrentTimestampSelection, supportsEmptyInList, supportsExistsInSelect, supportsExpectedLobUsagePattern, supportsIdentityColumns, supportsIfExistsAfterTableName, supportsIfExistsBeforeTableName, supportsInsertSelectIdentity, supportsLimit, supportsLimitOffset, supportsLobValueChangePropogation, supportsNotNullUnique, supportsOuterJoinForUpdate, supportsParametersInInsertSelect, supportsPooledSequences, supportsResultSetPositionQueryMethodsOnForwardOnlyCursor, supportsRowValueConstructorSyntax, supportsRowValueConstructorSyntaxInInList, supportsSequences, supportsSubqueryOnMutatingTable, supportsSubselectAsInPredicateLHS, supportsTableCheck, supportsTemporaryTables, supportsUnboundedLobLocatorMaterialization, supportsUnionAll, supportsUnique, supportsUniqueConstraintInCreateAlterTable, supportsVariableLimit, toBooleanValueString, toString, transformSelectString, useInputStreamToInsertBlob, useMaxForLimit

Constructor Details

Oracle9Dialect

public Oracle9Dialect()

Method Details

bindLimitParametersInReverseOrder

public boolean bindLimitParametersInReverseOrder()
Overrides:
bindLimitParametersInReverseOrder in interface Dialect

dropConstraints

public boolean dropConstraints()
Overrides:
dropConstraints in interface Dialect

dropTemporaryTableAfterUse

public boolean dropTemporaryTableAfterUse()
Overrides:
dropTemporaryTableAfterUse in interface Dialect

forUpdateOfColumns

public boolean forUpdateOfColumns()
Overrides:
forUpdateOfColumns in interface Dialect

generateTemporaryTableName

public String generateTemporaryTableName(String baseTableName)
Overrides:
generateTemporaryTableName in interface Dialect

getAddColumnString

public String getAddColumnString()
Overrides:
getAddColumnString in interface Dialect

getCascadeConstraintsString

public String getCascadeConstraintsString()
Overrides:
getCascadeConstraintsString in interface Dialect

getCreateSequenceString

public String getCreateSequenceString(String sequenceName)
Overrides:
getCreateSequenceString in interface Dialect

getCreateTemporaryTablePostfix

public String getCreateTemporaryTablePostfix()
Overrides:
getCreateTemporaryTablePostfix in interface Dialect

getCreateTemporaryTableString

public String getCreateTemporaryTableString()
Overrides:
getCreateTemporaryTableString in interface Dialect

getCurrentTimestampSelectString

public String getCurrentTimestampSelectString()
Overrides:
getCurrentTimestampSelectString in interface Dialect

getDropSequenceString

public String getDropSequenceString(String sequenceName)
Overrides:
getDropSequenceString in interface Dialect

getForUpdateNowaitString

public String getForUpdateNowaitString()
Overrides:
getForUpdateNowaitString in interface Dialect

getForUpdateNowaitString

public String getForUpdateNowaitString(String aliases)
Overrides:
getForUpdateNowaitString in interface Dialect

getForUpdateString

public String getForUpdateString(String aliases)
Overrides:
getForUpdateString in interface Dialect

getLimitString

public String getLimitString(String sql,
                             boolean hasOffset)
Overrides:
getLimitString in interface Dialect

getQuerySequencesString

public String getQuerySequencesString()
Overrides:
getQuerySequencesString in interface Dialect

getResultSet

public ResultSet getResultSet(CallableStatement ps)
            throws SQLException
Overrides:
getResultSet in interface Dialect

getSelectGUIDString

public String getSelectGUIDString()
Overrides:
getSelectGUIDString in interface Dialect

getSelectSequenceNextValString

public String getSelectSequenceNextValString(String sequenceName)
Overrides:
getSelectSequenceNextValString in interface Dialect

getSequenceNextValString

public String getSequenceNextValString(String sequenceName)
Overrides:
getSequenceNextValString in interface Dialect

getViolatedConstraintNameExtracter

public ViolatedConstraintNameExtracter getViolatedConstraintNameExtracter()
Overrides:
getViolatedConstraintNameExtracter in interface Dialect

isCurrentTimestampSelectStringCallable

public boolean isCurrentTimestampSelectStringCallable()
Overrides:
isCurrentTimestampSelectStringCallable in interface Dialect

registerResultSetOutParameter

public int registerResultSetOutParameter(CallableStatement statement,
                                         int col)
            throws SQLException
Overrides:
registerResultSetOutParameter in interface Dialect

supportsCommentOn

public boolean supportsCommentOn()
Overrides:
supportsCommentOn in interface Dialect

supportsCurrentTimestampSelection

public boolean supportsCurrentTimestampSelection()
Overrides:
supportsCurrentTimestampSelection in interface Dialect

supportsEmptyInList

public boolean supportsEmptyInList()
Overrides:
supportsEmptyInList in interface Dialect

supportsExistsInSelect

public boolean supportsExistsInSelect()
Overrides:
supportsExistsInSelect in interface Dialect

supportsLimit

public boolean supportsLimit()
Overrides:
supportsLimit in interface Dialect

supportsPooledSequences

public boolean supportsPooledSequences()
Overrides:
supportsPooledSequences in interface Dialect

supportsSequences

public boolean supportsSequences()
Overrides:
supportsSequences in interface Dialect

supportsTemporaryTables

public boolean supportsTemporaryTables()
Overrides:
supportsTemporaryTables in interface Dialect

supportsUnionAll

public boolean supportsUnionAll()
Overrides:
supportsUnionAll in interface Dialect

useMaxForLimit

public boolean useMaxForLimit()
Overrides:
useMaxForLimit in interface Dialect