Hibernate ORM - hibernate-core 5.6.15.Final · org.hibernate.dialect.Oracle8iDialect

Modifier and Type	Field and Description
private static final Pattern	DISTINCT_KEYWORD_PATTERN
private static final ViolatedConstraintNameExtracter	EXTRACTER Hides org.hibernate.dialect.Dialect.EXTRACTER.
private static final Pattern	GROUP_BY_KEYWORD_PATTERN
private static final AbstractLimitHandler	LIMIT_HANDLER
private static final Pattern	ORDER_BY_KEYWORD_PATTERN
private static final int	PARAM_LIST_SIZE_LIMIT
private static final Pattern	SQL_STATEMENT_TYPE_PATTERN
private static final Pattern	UNION_KEYWORD_PATTERN

Access	Constructor and Description
public	Oracle8iDialect() Constructs an Oracle8iDialect

Method Summary

Modifier and Type	Method and Description
public boolean	bindLimitParametersInReverseOrder() Overrides org.hibernate.dialect.Dialect.bindLimitParametersInReverseOrder. ANSI SQL defines the LIMIT clause to be in the form LIMIT offset, limit.
public SQLExceptionConversionDelegate	buildSQLExceptionConversionDelegate() Overrides org.hibernate.dialect.Dialect.buildSQLExceptionConversionDelegate. Build an instance of a `SQLExceptionConversionDelegate` for interpreting dialect-specific error or SQLState codes.
public boolean	canCreateSchema() Overrides org.hibernate.dialect.Dialect.canCreateSchema. Does this dialect support schema creation?
public CaseFragment	createCaseFragment() Overrides org.hibernate.dialect.Dialect.createCaseFragment. Map case support to the Oracle DECODE function.
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 boolean	dropConstraints() Overrides org.hibernate.dialect.Dialect.dropConstraints. Do we need to drop constraints before dropping tables in this dialect?
public boolean	forceLobAsLastValue() Overrides org.hibernate.dialect.Dialect.forceLobAsLastValue. HHH-4635 Oracle expects all Lob values to be last in inserts and updates.
public boolean	forUpdateOfColumns() Overrides org.hibernate.dialect.Dialect.forUpdateOfColumns. Is `FOR UPDATE OF` syntax supported?
public String	getAddColumnString() Overrides org.hibernate.dialect.Dialect.getAddColumnString. The syntax used to add a column to a table (optional).
public String	Returns: The appropriate select clause fragment getBasicSelectClauseNullString(int The `java.sql.Types` mapping type code sqlType) Allows access to the basic `Dialect#getSelectClauseNullString` implementation...
public CallableStatementSupport	getCallableStatementSupport() Overrides org.hibernate.dialect.Dialect.getCallableStatementSupport.
public String	getCascadeConstraintsString() Overrides org.hibernate.dialect.Dialect.getCascadeConstraintsString. Completely optional cascading drop clause
public String	getCreateSequenceString(String The name of the sequence sequenceName) Overrides org.hibernate.dialect.Dialect.getCreateSequenceString. Typically dialects which support sequences can create a sequence with a single command.
protected String	getCreateSequenceString(String The name of the sequence sequenceName, int The initial value to apply to 'create sequence' statement initialValue, int The increment value to apply to 'create sequence' statement incrementSize) Overrides org.hibernate.dialect.Dialect.getCreateSequenceString. Overloaded form of `getCreateSequenceString(String)`, additionally taking the initial value and increment size to be applied to the sequence definition.
public String	getCrossJoinSeparator() Overrides org.hibernate.dialect.Dialect.getCrossJoinSeparator. Returns the separator to use for defining cross joins when translating HQL queries.
public String	getCurrentSchemaCommand() Overrides org.hibernate.dialect.Dialect.getCurrentSchemaCommand. Get the SQL command used to retrieve the current schema name.
public String	getCurrentTimestampSelectString() Overrides org.hibernate.dialect.Dialect.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 MultiTableBulkIdStrategy	getDefaultMultiTableBulkIdStrategy() Overrides org.hibernate.dialect.Dialect.getDefaultMultiTableBulkIdStrategy.
public String	getDropSequenceString(String The name of the sequence sequenceName) Overrides org.hibernate.dialect.Dialect.getDropSequenceString. Typically dialects which support sequences can drop a sequence with a single command.
public String	getForUpdateNowaitString() Overrides org.hibernate.dialect.Dialect.getForUpdateNowaitString. Retrieves the `FOR UPDATE NOWAIT` syntax specific to this dialect.
public String	getForUpdateNowaitString(String The columns to be write locked. aliases) Overrides org.hibernate.dialect.Dialect.getForUpdateNowaitString. Get the `FOR UPDATE OF column_list NOWAIT` fragment appropriate for this dialect given the aliases of the columns to be write locked.
public String	getForUpdateString(String The columns to be write locked. aliases) Overrides org.hibernate.dialect.Dialect.getForUpdateString. Get the `FOR UPDATE OF column_list` fragment appropriate for this dialect given the aliases of the columns to be write locked.
public int	getInExpressionCountLimit() Overrides org.hibernate.dialect.Dialect.getInExpressionCountLimit. Return the limit that the underlying database places on the number of elements in an `IN` predicate.
public LimitHandler	getLimitHandler() Overrides org.hibernate.dialect.Dialect.getLimitHandler. Returns the delegate managing LIMIT clause.
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.Dialect.getLimitString. Apply a limit clause to the query.
public int	getMaxAliasLength() Overrides org.hibernate.dialect.Dialect.getMaxAliasLength. What is the maximum length Hibernate can use for generated aliases?
public String	getNotExpression(String The expression to negate expression) Overrides org.hibernate.dialect.Dialect.getNotExpression. Negate an expression
public String	getQueryHintString(String The query to which to apply the hint. sql, String The hints to apply hints) Overrides org.hibernate.dialect.Dialect.getQueryHintString. Apply a hint to the query.
public String	getQuerySequencesString() Overrides org.hibernate.dialect.Dialect.getQuerySequencesString. Get the select command used retrieve the names of all sequences.
public ResultSet	getResultSet(CallableStatement The callable statement. ps) Overrides org.hibernate.dialect.Dialect.getResultSet. Given a callable statement previously processed by `registerResultSetOutParameter`, extract the `ResultSet` from the OUT parameter.
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.
public String	getSelectGUIDString() Overrides org.hibernate.dialect.Dialect.getSelectGUIDString. Get the command used to select a GUID from the underlying database.
public String	getSelectSequenceNextValString(String the name of the sequence sequenceName) Overrides org.hibernate.dialect.Dialect.getSelectSequenceNextValString. Generate the select expression fragment that will retrieve the next value of a sequence as part of another (typically DML) statement.
public SequenceInformationExtractor	getSequenceInformationExtractor() Overrides org.hibernate.dialect.Dialect.getSequenceInformationExtractor.
public String	getSequenceNextValString(String the name of the sequence sequenceName) Overrides org.hibernate.dialect.Dialect.getSequenceNextValString. Generate the appropriate select statement to to retrieve the next value of a sequence.
protected SqlTypeDescriptor	getSqlTypeDescriptorOverride(int A `Types` constant indicating the SQL column type sqlCode) Overrides org.hibernate.dialect.Dialect.getSqlTypeDescriptorOverride. Returns the `SqlTypeDescriptor` that should be used to handle the given JDBC type code.
public ViolatedConstraintNameExtracter	getViolatedConstraintNameExtracter() Overrides org.hibernate.dialect.Dialect.getViolatedConstraintNameExtracter. Implements org.hibernate.exception.spi.ConversionContext.getViolatedConstraintNameExtracter.
public boolean	isCurrentTimestampSelectStringCallable() Overrides org.hibernate.dialect.Dialect.isCurrentTimestampSelectStringCallable. Should the value returned by `getCurrentTimestampSelectString` be treated as callable.
protected void	registerCharacterTypeMappings()
protected void	registerDateTimeTypeMappings()
protected void	registerDefaultProperties()
protected void	registerFunctions()
protected void	registerLargeObjectTypeMappings()
protected void	registerNumericTypeMappings()
public int	registerResultSetOutParameter(CallableStatement The callable statement. statement, int The bind position at which to register the output param. col) 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 position.
protected void	registerReverseHibernateTypeMappings()
protected String	statementType(String sql)
public boolean	supportsCommentOn() Overrides org.hibernate.dialect.Dialect.supportsCommentOn. Does this dialect/database support commenting on tables, columns, etc?
public boolean	supportsCurrentTimestampSelection() Overrides org.hibernate.dialect.Dialect.supportsCurrentTimestampSelection. Does this dialect support a way to retrieve the database's current timestamp value?
public boolean	supportsEmptyInList() Overrides org.hibernate.dialect.Dialect.supportsEmptyInList. Does this dialect support empty IN lists?
public boolean	supportsExistsInSelect() Overrides org.hibernate.dialect.Dialect.supportsExistsInSelect. Does the dialect support an exists statement in the select clause?
public boolean	supportsLimit() Overrides org.hibernate.dialect.Dialect.supportsLimit. Does this dialect support some form of limiting query results via a SQL clause?
public boolean	supportsNoWait() Overrides org.hibernate.dialect.Dialect.supportsNoWait. Does this dialect/database support NO_WAIT timeout.
public boolean	supportsPartitionBy() Overrides org.hibernate.dialect.Dialect.supportsPartitionBy. Does the underlying database support partition by
public boolean	supportsPooledSequences() Overrides org.hibernate.dialect.Dialect.supportsPooledSequences. Does this dialect support "pooled" sequences.
public boolean	supportsSequences() Overrides org.hibernate.dialect.Dialect.supportsSequences. Does this dialect support sequences?
public boolean	supportsUnionAll() Overrides org.hibernate.dialect.Dialect.supportsUnionAll. Does this dialect support UNION ALL, which is generally a faster variant of UNION?
public boolean	Returns: `true` indicates that the dialect requests that locking be applied by subsequent select; `false` (the default) indicates that locking should be applied to the main SQL statement.. useFollowOnLocking(QueryParameters parameters) Overrides org.hibernate.dialect.Dialect.useFollowOnLocking. For Oracle, the FOR UPDATE clause cannot be applied when using ORDER BY, DISTINCT or views.
public boolean	useMaxForLimit() Overrides org.hibernate.dialect.Dialect.useMaxForLimit. Does the `LIMIT` clause take a "maximum" row number instead of a total number of returned rows?

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

public Class Oracle8iDialect

Field Summary

Constructor Summary

Method Summary