Class AbstractHANADialect
- java.lang.Object
-
- org.hibernate.dialect.Dialect
-
- org.hibernate.dialect.AbstractHANADialect
-
- All Implemented Interfaces:
FunctionContributor
,TypeContributor
,ConversionContext
- Direct Known Subclasses:
HANAColumnStoreDialect
,HANADialect
,HANARowStoreDialect
@Deprecated(forRemoval=true) public abstract class AbstractHANADialect extends Dialect
Deprecated, for removal: This API element is subject to removal in a future version.Will be replaced withHANADialect
in the future.An abstract base class for SAP HANA dialects.For more information on interacting with the SAP HANA database, refer to the SAP HANA SQL and System Views Reference and the SAP HANA Client Interface Programming Reference.
Note: This dialect is configured to create foreign keys with
on update cascade
.
-
-
Nested Class Summary
Nested Classes Modifier and Type Class Description static class
AbstractHANADialect.HANABlobType
Deprecated, for removal: This API element is subject to removal in a future version.-
Nested classes/interfaces inherited from class org.hibernate.dialect.Dialect
Dialect.SizeStrategy, Dialect.SizeStrategyImpl
-
-
Field Summary
Fields Modifier and Type Field Description static String
USE_DEFAULT_TABLE_TYPE_COLUMN
Deprecated, for removal: This API element is subject to removal in a future version.-
Fields inherited from class org.hibernate.dialect.Dialect
CLOSED_QUOTE, FALSE_STRING_VALUES, LEGACY_LOB_MERGE_STRATEGY, LOG_BASE2OF10, NEW_LOCATOR_LOB_MERGE_STRATEGY, QUOTE, STANDARD_MULTI_KEY_LOAD_SIZING_STRATEGY, STREAM_XFER_LOB_MERGE_STRATEGY, TRUE_STRING_VALUES
-
-
Constructor Summary
Constructors Constructor Description AbstractHANADialect(DatabaseVersion version)
Deprecated, for removal: This API element is subject to removal in a future version.AbstractHANADialect(HANAServerConfiguration configuration, boolean defaultTableTypeColumn)
Deprecated, for removal: This API element is subject to removal in a future version.
-
Method Summary
All Methods Static Methods Instance Methods Concrete Methods Deprecated Methods Modifier and Type Method Description void
appendBooleanValueString(SqlAppender appender, boolean bool)
Deprecated, for removal: This API element is subject to removal in a future version.Append the SQL literal expression representing the given boolean value to the givenSqlAppender
.void
appendDatetimeFormat(SqlAppender appender, String format)
Deprecated, for removal: This API element is subject to removal in a future version.Translate the given datetime format string from the pattern language defined by Java'sDateTimeFormatter
to whatever pattern language is understood by the native datetime formatting function for this database (often theto_char()
function).void
appendDateTimeLiteral(SqlAppender appender, TemporalAccessor temporalAccessor, TemporalType precision, TimeZone jdbcTimeZone)
Deprecated, for removal: This API element is subject to removal in a future version.Append a datetime literal representing the givenjava.time
value to the givenSqlAppender
.void
appendDateTimeLiteral(SqlAppender appender, Date date, TemporalType precision, TimeZone jdbcTimeZone)
Deprecated, for removal: This API element is subject to removal in a future version.Append a datetime literal representing the givenDate
value to the givenSqlAppender
.IdentifierHelper
buildIdentifierHelper(IdentifierHelperBuilder builder, DatabaseMetaData dbMetaData)
Deprecated, for removal: This API element is subject to removal in a future version.TheIdentifierHelper
indicated by this dialect for handling identifier conversions.SQLExceptionConversionDelegate
buildSQLExceptionConversionDelegate()
Deprecated, for removal: This API element is subject to removal in a future version.An instance ofSQLExceptionConversionDelegate
for interpreting dialect-specific error or SQLState codes.String
castPattern(CastType from, CastType to)
Deprecated, for removal: This API element is subject to removal in a future version.Obtain a pattern for the SQL equivalent to acast()
function call.protected String
columnType(int sqlTypeCode)
Deprecated, for removal: This API element is subject to removal in a future version.void
contribute(TypeContributions typeContributions, ServiceRegistry serviceRegistry)
Deprecated, for removal: This API element is subject to removal in a future version.Contribute typesvoid
contributeTypes(TypeContributions typeContributions, ServiceRegistry serviceRegistry)
Deprecated, for removal: This API element is subject to removal in a future version.A callback which allows theDialect
to contribute types.protected static DatabaseVersion
createVersion(DialectResolutionInfo info)
Deprecated, for removal: This API element is subject to removal in a future version.ScrollMode
defaultScrollMode()
Deprecated, for removal: This API element is subject to removal in a future version.A defaultScrollMode
to be used byQuery.scroll()
.boolean
doesRoundTemporalOnOverflow()
Deprecated, for removal: This API element is subject to removal in a future version.Does this dialect round a temporal when converting from a precision higher to a lower one?boolean
dropConstraints()
Deprecated, for removal: This API element is subject to removal in a future version.Do we need to drop constraints before dropping tables in this dialect?String
extractPattern(TemporalUnit unit)
Deprecated, for removal: This API element is subject to removal in a future version.HANA has no extract() function, but we can emulate it using the appropriate named functions instead of extract().String
generatedAs(String generatedAs)
Deprecated, for removal: This API element is subject to removal in a future version.Thegenerated as
clause, or similar, for generated column declarations in DDL statements.String
getAddColumnString()
Deprecated, for removal: This API element is subject to removal in a future version.The subcommand of thealter table
command used to add a column to a table, usuallyadd column
oradd
.String
getAddColumnSuffixString()
Deprecated, for removal: This API element is subject to removal in a future version.The syntax for the suffix used to add a column to a table.CallableStatementSupport
getCallableStatementSupport()
Deprecated, for removal: This API element is subject to removal in a future version.TheCallableStatementSupport
for this database.String
getCascadeConstraintsString()
Deprecated, for removal: This API element is subject to removal in a future version.The keyword that specifies that adrop table
operation should be cascaded to its constraints, typically" cascade"
where the leading space is required, or the empty string if there is no such keyword in this dialect.String
getColumnComment(String comment)
Deprecated, for removal: This API element is subject to removal in a future version.Get the comment into a form supported for column definition.String
getCreateTableString()
Deprecated, for removal: This API element is subject to removal in a future version.The command used to create a table, usuallycreate table
.String
getCurrentSchemaCommand()
Deprecated, for removal: This API element is subject to removal in a future version.Get the SQL command used to retrieve the current schema name.String
getCurrentTimestampSelectString()
Deprecated, for removal: This API element is subject to removal in a future version.The command used to retrieve the current timestamp from the database.int
getDefaultDecimalPrecision()
Deprecated, for removal: This API element is subject to removal in a future version.This is the default precision for a generated column of exact numeric typeDECIMAL
orNUMERIC
mapped to aBigInteger
orBigDecimal
.boolean
getDefaultNonContextualLobCreation()
Deprecated, for removal: This API element is subject to removal in a future version.The default value to use for the configuration property "hibernate.jdbc.lob.non_contextual_creation".int
getDefaultTimestampPrecision()
Deprecated, for removal: This API element is subject to removal in a future version.This is the default precision for a generated column of typeTIMESTAMP
mapped to aTimestamp
orLocalDateTime
.boolean
getDefaultUseGetGeneratedKeys()
Deprecated, for removal: This API element is subject to removal in a future version.The default value to use for the configuration property "hibernate.jdbc.use_get_generated_keys".DmlTargetColumnQualifierSupport
getDmlTargetColumnQualifierSupport()
Deprecated, for removal: This API element is subject to removal in a future version.Get the minimumDmlTargetColumnQualifierSupport
required by this dialect.String
getDual()
Deprecated, for removal: This API element is subject to removal in a future version.Returns a table expression that has one row.SqmMultiTableInsertStrategy
getFallbackSqmInsertStrategy(EntityMappingType entityDescriptor, RuntimeModelCreationContext runtimeModelCreationContext)
Deprecated, for removal: This API element is subject to removal in a future version.TheSqmMultiTableInsertStrategy
to use when not specified byQueryEngineOptions.getCustomSqmMultiTableInsertStrategy()
.SqmMultiTableMutationStrategy
getFallbackSqmMutationStrategy(EntityMappingType entityDescriptor, RuntimeModelCreationContext runtimeModelCreationContext)
Deprecated, for removal: This API element is subject to removal in a future version.TheSqmMultiTableMutationStrategy
to use when not specified byQueryEngineOptions.getCustomSqmMultiTableMutationStrategy()
.String
getForUpdateNowaitString()
Deprecated, for removal: This API element is subject to removal in a future version.Retrieves theFOR UPDATE NOWAIT
syntax specific to this dialect.String
getForUpdateNowaitString(String aliases)
Deprecated, for removal: This API element is subject to removal in a future version.Get theFOR UPDATE OF column_list NOWAIT
fragment appropriate for this dialect, given the aliases of the columns to be write locked.String
getForUpdateSkipLockedString()
Deprecated, for removal: This API element is subject to removal in a future version.Retrieves theFOR UPDATE SKIP LOCKED
syntax specific to this dialect.String
getForUpdateSkipLockedString(String aliases)
Deprecated, for removal: This API element is subject to removal in a future version.Get theFOR UPDATE OF column_list SKIP LOCKED
fragment appropriate for this dialect, given the aliases of the columns to be write locked.String
getForUpdateString(String aliases)
Deprecated, for removal: This API element is subject to removal in a future version.Get theFOR UPDATE OF column_list
fragment appropriate for this dialect, given the aliases of the columns to be write locked.String
getForUpdateString(String aliases, LockOptions lockOptions)
Deprecated, for removal: This API element is subject to removal in a future version.Get theFOR UPDATE OF
orFOR SHARE OF
fragment appropriate for this dialect, given the aliases of the columns to be locked.String
getForUpdateString(LockMode lockMode)
Deprecated, for removal: This API element is subject to removal in a future version.Given aLockMode
, determine the appropriatefor update
fragment to use to obtain the lock.long
getFractionalSecondPrecisionInNanos()
Deprecated, for removal: This API element is subject to removal in a future version.The "native" precision for arithmetic with datetimes and day-to-second durations.String
getFromDualForSelectOnly()
Deprecated, for removal: This API element is subject to removal in a future version.IdentityColumnSupport
getIdentityColumnSupport()
Deprecated, for removal: This API element is subject to removal in a future version.Get the appropriateIdentityColumnSupport
for this dialect.LimitHandler
getLimitHandler()
Deprecated, for removal: This API element is subject to removal in a future version.Obtain aLimitHandler
that implements pagination support forQuery.setMaxResults(int)
andQuery.setFirstResult(int)
.int
getMaxAliasLength()
Deprecated, for removal: This API element is subject to removal in a future version.What is the maximum length Hibernate can use for generated aliases?int
getMaxIdentifierLength()
Deprecated, for removal: This API element is subject to removal in a future version.What is the maximum identifier length supported by this dialect?int
getMaxNVarcharLength()
Deprecated, for removal: This API element is subject to removal in a future version.The biggest size value that can be supplied as argument to aTypes.NVARCHAR
-like type.int
getMaxVarbinaryLength()
Deprecated, for removal: This API element is subject to removal in a future version.The biggest size value that can be supplied as argument to aTypes.VARBINARY
-like type.int
getMaxVarcharLength()
Deprecated, for removal: This API element is subject to removal in a future version.The biggest size value that can be supplied as argument to aTypes.VARCHAR
-like type.NameQualifierSupport
getNameQualifierSupport()
Deprecated, for removal: This API element is subject to removal in a future version.NullOrdering
getNullOrdering()
Deprecated, for removal: This API element is subject to removal in a future version.Returns the default ordering of null.String
getQueryHintString(String query, List<String> hints)
Deprecated, for removal: This API element is subject to removal in a future version.Apply a hint to the given SQL query.String
getQuerySequencesString()
Deprecated, for removal: This API element is subject to removal in a future version.Get theselect
command used retrieve the names of all sequences.String
getReadLockString(int timeout)
Deprecated, for removal: This API element is subject to removal in a future version.Get the string to append toSELECT
statements to acquire READ locks for this dialect.String
getReadLockString(String aliases, int timeout)
Deprecated, for removal: This API element is subject to removal in a future version.Get the string to append toSELECT
statements to acquire READ locks for this dialect, given the aliases of the columns to be read locked.String
getSelectGUIDString()
Deprecated, for removal: This API element is subject to removal in a future version.Get the command used to select a GUID from the database.SequenceInformationExtractor
getSequenceInformationExtractor()
Deprecated, for removal: This API element is subject to removal in a future version.ASequenceInformationExtractor
which is able to extractSequenceInformation
from the JDBC result set returned whenDialect.getQuerySequencesString()
is executed.SequenceSupport
getSequenceSupport()
Deprecated, for removal: This API element is subject to removal in a future version.Get the appropriateSequenceSupport
for this dialect.SqlAstTranslatorFactory
getSqlAstTranslatorFactory()
Deprecated, for removal: This API element is subject to removal in a future version.TemporaryTableKind
getSupportedTemporaryTableKind()
Deprecated, for removal: This API element is subject to removal in a future version.The kind of temporary tables that are supported on this database.String
getTableComment(String comment)
Deprecated, for removal: This API element is subject to removal in a future version.Get the comment into a form supported for table definition.Exporter<Table>
getTableExporter()
Deprecated, for removal: This API element is subject to removal in a future version.String
getTemporaryTableCreateCommand()
Deprecated, for removal: This API element is subject to removal in a future version.The command to create a temporary table.String
getTemporaryTableCreateOptions()
Deprecated, for removal: This API element is subject to removal in a future version.An arbitrary SQL fragment appended to the end of the statement to create a temporary table, specifying dialect-specific options, ornull
if there are no options to specify.String
getTemporaryTableTruncateCommand()
Deprecated, for removal: This API element is subject to removal in a future version.The command to truncate a temporary table.String
getWriteLockString(int timeout)
Deprecated, for removal: This API element is subject to removal in a future version.Get the string to append toSELECT
statements to acquire pessimistic WRITE locks for this dialect.String
getWriteLockString(String aliases, int timeout)
Deprecated, for removal: This API element is subject to removal in a future version.Get the string to append toSELECT
statements to acquire WRITE locks for this dialect, given the aliases of the columns to be write locked.RowLockStrategy
getWriteRowLockStrategy()
Deprecated, for removal: This API element is subject to removal in a future version.The row lock strategy to use for write locks.void
initializeFunctionRegistry(FunctionContributions functionContributions)
Deprecated, for removal: This API element is subject to removal in a future version.Initialize the given registry with any dialect-specific functions.protected boolean
isCloud()
Deprecated, for removal: This API element is subject to removal in a future version.boolean
isCurrentTimestampSelectStringCallable()
Deprecated, for removal: This API element is subject to removal in a future version.Is the command returned byDialect.getCurrentTimestampSelectString()
treated as callable?protected boolean
isDefaultTableTypeColumn()
Deprecated, for removal: This API element is subject to removal in a future version.boolean
isUseUnicodeStringTypes()
Deprecated, for removal: This API element is subject to removal in a future version.protected void
registerColumnTypes(TypeContributions typeContributions, ServiceRegistry serviceRegistry)
Deprecated, for removal: This API element is subject to removal in a future version.Register ANSI-standard column types using the length limits defined byDialect.getMaxVarcharLength()
,Dialect.getMaxNVarcharLength()
, andDialect.getMaxVarbinaryLength()
.protected void
registerDefaultKeywords()
Deprecated, for removal: This API element is subject to removal in a future version.Register the reserved words of ANSI-standard SQL as keywords.int
registerResultSetOutParameter(CallableStatement statement, int position)
Deprecated, for removal: This API element is subject to removal in a future version.Registers a parameter capable of returning aResultSet
by position, either anOUT
parameter, or aREF_CURSOR
parameter as defined in Java 8.int
registerResultSetOutParameter(CallableStatement statement, String name)
Deprecated, for removal: This API element is subject to removal in a future version.Registers a parameter capable of returning aResultSet
by name, either anOUT
parameter, or aREF_CURSOR
parameter as defined in Java 8.protected boolean
supportsAsciiStringTypes()
Deprecated, for removal: This API element is subject to removal in a future version.boolean
supportsColumnCheck()
Deprecated, for removal: This API element is subject to removal in a future version.HANA currently does not support check constraints.boolean
supportsCommentOn()
Deprecated, for removal: This API element is subject to removal in a future version.Does this dialect support commenting on tables and columns?boolean
supportsCurrentTimestampSelection()
Deprecated, for removal: This API element is subject to removal in a future version.Does this dialect support some way to retrieve the current timestamp value from the database?boolean
supportsExistsInSelect()
Deprecated, for removal: This API element is subject to removal in a future version.Does the dialect support an exists statement in the select clause?boolean
supportsExpectedLobUsagePattern()
Deprecated, for removal: This API element is subject to removal in a future version."Expected" LOB usage pattern is such that I can perform an insert via prepared statement with a parameter binding for a LOB value without crazy casting to JDBC driver implementation-specific classes.boolean
supportsFractionalTimestampArithmetic()
Deprecated, for removal: This API element is subject to removal in a future version.Whether the database supports adding a fractional interval to a timestamp, for exampletimestamp + 0.5 second
.boolean
supportsJdbcConnectionLobCreation(DatabaseMetaData databaseMetaData)
Deprecated, for removal: This API element is subject to removal in a future version.Check whether the JDBCConnection
supports creating LOBs viaConnection.createBlob()
,Connection.createNClob()
, orConnection.createClob()
.boolean
supportsLateral()
Deprecated, for removal: This API element is subject to removal in a future version.Does this dialect support the SQLlateral
keyword or a proprietary alternative?boolean
supportsNoColumnsInsert()
Deprecated, for removal: This API element is subject to removal in a future version.Is theINSERT
statement is allowed to contain no columns?boolean
supportsNoWait()
Deprecated, for removal: This API element is subject to removal in a future version.Does this dialect supportNO_WAIT
timeout.boolean
supportsOffsetInSubquery()
Deprecated, for removal: This API element is subject to removal in a future version.Does this dialect supportoffset
in subqueries?boolean
supportsOrderByInSubquery()
Deprecated, for removal: This API element is subject to removal in a future version.Does this dialect support theorder by
clause in subqueries?boolean
supportsPartitionBy()
Deprecated, for removal: This API element is subject to removal in a future version.Does is dialect supportpartition by
?boolean
supportsSkipLocked()
Deprecated, for removal: This API element is subject to removal in a future version.Does this dialect supportSKIP_LOCKED
timeout.boolean
supportsTableCheck()
Deprecated, for removal: This API element is subject to removal in a future version.Does this dialect support table-level check constraints?boolean
supportsTupleDistinctCounts()
Deprecated, for removal: This API element is subject to removal in a future version.Does this dialect supportcount(distinct a,b)
?boolean
supportsUnboundedLobLocatorMaterialization()
Deprecated, for removal: This API element is subject to removal in a future version.Is it supported to materialize a LOB locator outside the transaction in which it was created?boolean
supportsWindowFunctions()
Deprecated, for removal: This API element is subject to removal in a future version.Does this dialect support window functions likerow_number() over (..)
?String
timestampaddPattern(TemporalUnit unit, TemporalType temporalType, IntervalType intervalType)
Deprecated, for removal: This API element is subject to removal in a future version.Obtain a pattern for the SQL equivalent to atimestampadd()
function call.String
timestampdiffPattern(TemporalUnit unit, TemporalType fromTemporalType, TemporalType toTemporalType)
Deprecated, for removal: This API element is subject to removal in a future version.Obtain a pattern for the SQL equivalent to atimestampdiff()
function call.protected Boolean
useUnicodeStringTypesDefault()
Deprecated, for removal: This API element is subject to removal in a future version.-
Methods inherited from class org.hibernate.dialect.Dialect
addSqlHintOrComment, appendArrayLiteral, appendBinaryLiteral, appendDateTimeLiteral, appendIntervalLiteral, appendLiteral, appendLockHint, appendUUIDLiteral, applyLocksToSql, augmentPhysicalTableTypes, augmentRecognizedTableTypes, buildStringToBooleanCast, buildStringToBooleanCastDecode, buildStringToBooleanDecode, canBatchTruncate, canCreateCatalog, canCreateSchema, canDisableConstraints, castType, checkVersion, closeQuote, contributeFunctions, createOptionalTableUpdateOperation, currentDate, currentLocalTime, currentLocalTimestamp, currentTime, currentTimestamp, currentTimestampWithTimeZone, doesReadCommittedCauseWritersToBlockReaders, doesRepeatableReadCauseReadersToBlockWriters, equivalentTypes, escapeComment, forceLobAsLastValue, getAddForeignKeyConstraintString, getAddForeignKeyConstraintString, getAddPrimaryKeyConstraintString, getAggregateSupport, getAlterColumnTypeString, getAlterTableString, getArrayTypeName, getAuxiliaryDatabaseObjectExporter, getBatchLoadSizingStrategy, getBeforeDropStatement, getCaseInsensitiveLike, getCheckCondition, getCheckCondition, getCheckCondition, getCheckCondition, getCheckCondition, getColumnAliasExtractor, getCreateCatalogCommand, getCreateEnumTypeCommand, getCreateEnumTypeCommand, getCreateIndexString, getCreateIndexTail, getCreateMultisetTableString, getCreateSchemaCommand, getCreateTemporaryTableColumnAnnotation, getCreateUserDefinedTypeExtensionsString, getCreateUserDefinedTypeKindString, getCrossReferenceParentTableFilter, getDefaultIntervalSecondScale, getDefaultLobLength, getDefaultProperties, getDefaultStatementBatchSize, getDisableConstraintsStatement, getDisableConstraintStatement, getDoublePrecision, getDropCatalogCommand, getDropEnumTypeCommand, getDropEnumTypeCommand, getDropForeignKeyString, getDropSchemaCommand, getDropTableString, getDropUniqueKeyString, getEnableConstraintsStatement, getEnableConstraintStatement, getEnumTypeDeclaration, getEnumTypeDeclaration, getFallbackSchemaManagementTool, getFloatPrecision, getForeignKeyExporter, getForUpdateString, getForUpdateString, getFunctionalDependencyAnalysisSupport, getGroupBySelectItemReferenceStrategy, getHqlTranslator, getIndexExporter, getInExpressionCountLimit, getKeywords, getLobMergeStrategy, getLockingStrategy, getLockRowIdentifier, getLowercaseFunction, getMaxNVarcharCapacity, getMaxVarbinaryCapacity, getMaxVarcharCapacity, getMinimumSupportedVersion, getMultiKeyLoadSizingStrategy, getNationalizationSupport, getNativeIdentifierGeneratorStrategy, getNativeParameterMarkerStrategy, getNoColumnsInsertString, getNullColumnString, getNullColumnString, getParameterCountLimit, getPreferredSqlTypeCodeForArray, getPreferredSqlTypeCodeForBoolean, getQueryHintString, getReadRowLockStrategy, getResultSet, getResultSet, getResultSet, getRowIdColumnString, getSchemaNameResolver, getSelectClauseNullString, getSequenceExporter, getSizeStrategy, getSqmTranslatorFactory, getTableCleaner, getTableMigrator, getTableTypeString, getTemporaryTableAfterUseAction, getTemporaryTableBeforeUseAction, getTemporaryTableDdlTransactionHandling, getTemporaryTableDropCommand, getTemporaryTableExporter, getTimeoutInSeconds, getTimeZoneSupport, getTruncateTableStatement, getTruncateTableStatements, getUniqueDelegate, getUniqueKeyExporter, getUserDefinedTypeComment, getUserDefinedTypeExporter, getVersion, getViolatedConstraintNameExtractor, hasAlterTable, hasDataTypeBeforeGeneratedAs, hasSelfReferentialForeignKeyBug, initDefaultProperties, inlineLiteral, isAnsiNullOn, isEmptyStringTreatedAsNull, isJdbcLogWarningsEnabledByDefault, isLob, isLockTimeoutParameterized, openQuote, ordinal, prependComment, qualifyIndexName, quote, quoteCollation, registerKeyword, registerKeywords, requiresCastForConcatenatingNonStrings, requiresFloatCastingOfIntegerDivision, requiresParensForTupleCounts, requiresParensForTupleDistinctCounts, resolveSqlTypeCode, resolveSqlTypeCode, resolveSqlTypeDescriptor, resolveSqlTypeLength, rowId, rowIdSqlType, supportsAlterColumnType, supportsBatchUpdates, supportsBindAsCallableArgument, supportsBitType, supportsCascadeDelete, supportsCaseInsensitiveLike, supportsCircularCascadeDeleteConstraints, supportsConflictClauseForInsertCTE, supportsDistinctFromPredicate, supportsFetchClause, supportsFromClauseInUpdate, supportsIfExistsAfterAlterTable, supportsIfExistsAfterConstraintName, supportsIfExistsAfterTableName, supportsIfExistsAfterTypeName, supportsIfExistsBeforeConstraintName, supportsIfExistsBeforeTableName, supportsIfExistsBeforeTypeName, supportsInsertReturning, supportsInsertReturningGeneratedKeys, supportsInsertReturningRowId, supportsIsTrue, supportsLobValueChangePropagation, supportsLockTimeouts, supportsMaterializedLobAccess, supportsNamedParameters, supportsNationalizedMethods, supportsNonQueryWithCTE, supportsNullPrecedence, supportsOrdinalSelectItemReference, supportsOuterJoinForUpdate, supportsParametersInInsertSelect, supportsPredicateAsExpression, supportsRecursiveCTE, supportsRefCursors, supportsResultSetPositionQueryMethodsOnForwardOnlyCursor, supportsStandardArrays, supportsStandardCurrentTimestampFunction, supportsSubqueryInSelect, supportsSubqueryOnMutatingTable, supportsSubselectAsInPredicateLHS, supportsTemporalLiteralOffset, supportsTemporaryTablePrimaryKey, supportsTemporaryTables, supportsTruncateWithCast, supportsTupleCounts, supportsUnionAll, supportsUnionInSubquery, supportsUpdateReturning, supportsValuesList, supportsValuesListForInsert, supportsWait, toBooleanValueString, toQuotedIdentifier, toString, transformSelectString, translateDurationField, translateExtractField, trimPattern, trimPattern, unquoteGetGeneratedKeys, useArrayForMultiValuedParameters, useConnectionToCreateLob, useCrossReferenceForeignKeys, useFollowOnLocking, useInputStreamToInsertBlob, useMaterializedLobWhenCapacityExceeded
-
-
-
-
Field Detail
-
USE_DEFAULT_TABLE_TYPE_COLUMN
public static final String USE_DEFAULT_TABLE_TYPE_COLUMN
Deprecated, for removal: This API element is subject to removal in a future version.- See Also:
- Constant Field Values
-
-
Constructor Detail
-
AbstractHANADialect
public AbstractHANADialect(DatabaseVersion version)
Deprecated, for removal: This API element is subject to removal in a future version.
-
AbstractHANADialect
public AbstractHANADialect(HANAServerConfiguration configuration, boolean defaultTableTypeColumn)
Deprecated, for removal: This API element is subject to removal in a future version.
-
-
Method Detail
-
contribute
public void contribute(TypeContributions typeContributions, ServiceRegistry serviceRegistry)
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from interface:TypeContributor
Contribute types- Specified by:
contribute
in interfaceTypeContributor
- Overrides:
contribute
in classDialect
- Parameters:
typeContributions
- The callback for adding contributed typesserviceRegistry
- The service registry
-
isDefaultTableTypeColumn
protected boolean isDefaultTableTypeColumn()
Deprecated, for removal: This API element is subject to removal in a future version.
-
isCloud
protected boolean isCloud()
Deprecated, for removal: This API element is subject to removal in a future version.
-
columnType
protected String columnType(int sqlTypeCode)
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
The database column type name for a given JDBC type code defined inTypes
orSqlTypes
. This default implementation returns the ANSI-standard type name.This method may be overridden by concrete
Dialect
s as an alternative toDialect.registerColumnTypes(TypeContributions, ServiceRegistry)
for simple registrations.Note that:
- Implementations of this method are expected to define a
sensible mapping for
Types.NCLOB
Types.NCHAR
, andTypes.NVARCHAR
. On some database, these types are simply remapped toCLOB
,CHAR
, andVARCHAR
. - Mappings for
Types.TIMESTAMP
andTypes.TIMESTAMP_WITH_TIMEZONE
should support explicit specification of precision if possible. - As specified by
DdlTypeRegistry.getDescriptor(int)
, this method never receivesTypes.LONGVARCHAR
,Types.LONGNVARCHAR
, norTypes.LONGVARBINARY
, which are considered synonyms for their non-LONG
counterparts. - On the other hand, the types
SqlTypes.LONG32VARCHAR
,SqlTypes.LONG32NVARCHAR
, andSqlTypes.LONG32VARBINARY
are not synonyms, and implementations of this method must define sensible mappings, for example to database-nativeTEXT
orCLOB
types.
- Overrides:
columnType
in classDialect
- Parameters:
sqlTypeCode
- a SQLtype code
- Returns:
- a column type name, with
$l
,$p
,$s
placeholders for length, precision, scale - See Also:
SqlTypes
- Implementations of this method are expected to define a
sensible mapping for
-
registerColumnTypes
protected void registerColumnTypes(TypeContributions typeContributions, ServiceRegistry serviceRegistry)
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Register ANSI-standard column types using the length limits defined byDialect.getMaxVarcharLength()
,Dialect.getMaxNVarcharLength()
, andDialect.getMaxVarbinaryLength()
.This method is always called when a
Dialect
is instantiated.- Overrides:
registerColumnTypes
in classDialect
-
getDefaultNonContextualLobCreation
public boolean getDefaultNonContextualLobCreation()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
The default value to use for the configuration property "hibernate.jdbc.lob.non_contextual_creation".- Overrides:
getDefaultNonContextualLobCreation
in classDialect
-
getDefaultUseGetGeneratedKeys
public boolean getDefaultUseGetGeneratedKeys()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
The default value to use for the configuration property "hibernate.jdbc.use_get_generated_keys".- Overrides:
getDefaultUseGetGeneratedKeys
in classDialect
-
createVersion
@Deprecated(forRemoval=true) protected static DatabaseVersion createVersion(DialectResolutionInfo info)
Deprecated, for removal: This API element is subject to removal in a future version.
-
castPattern
public String castPattern(CastType from, CastType to)
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Obtain a pattern for the SQL equivalent to acast()
function call. The resulting pattern must contain ?1 and ?2 placeholders for the arguments.- Overrides:
castPattern
in classDialect
- Parameters:
from
- aCastType
indicating the type of the value argumentto
- aCastType
indicating the type the value argument is cast to
-
getDefaultTimestampPrecision
public int getDefaultTimestampPrecision()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
This is the default precision for a generated column of typeTIMESTAMP
mapped to aTimestamp
orLocalDateTime
.Usually 6 (microseconds) or 3 (milliseconds).
- Overrides:
getDefaultTimestampPrecision
in classDialect
- Returns:
- the default precision, in decimal digits, of the fractional seconds field
- See Also:
JdbcTimestampJavaType
,LocalDateTimeJavaType
,OffsetDateTimeJavaType
,ZonedDateTimeJavaType
,InstantJavaType
-
getDefaultDecimalPrecision
public int getDefaultDecimalPrecision()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
This is the default precision for a generated column of exact numeric typeDECIMAL
orNUMERIC
mapped to aBigInteger
orBigDecimal
.Usually returns the maximum precision of the database, except when there is no such maximum precision, or the maximum precision is very high.
- Overrides:
getDefaultDecimalPrecision
in classDialect
- Returns:
- the default precision, in decimal digits
- See Also:
BigDecimalJavaType
,BigIntegerJavaType
-
getMaxVarcharLength
public int getMaxVarcharLength()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
The biggest size value that can be supplied as argument to aTypes.VARCHAR
-like type.For longer column lengths, use some sort of
text
-like type for the column.- Overrides:
getMaxVarcharLength
in classDialect
-
getMaxNVarcharLength
public int getMaxNVarcharLength()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
The biggest size value that can be supplied as argument to aTypes.NVARCHAR
-like type.For longer column lengths, use some sort of
ntext
-like type for the column.- Overrides:
getMaxNVarcharLength
in classDialect
-
getMaxVarbinaryLength
public int getMaxVarbinaryLength()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
The biggest size value that can be supplied as argument to aTypes.VARBINARY
-like type.For longer column lengths, use some sort of
image
-like type for the column.- Overrides:
getMaxVarbinaryLength
in classDialect
-
initializeFunctionRegistry
public void initializeFunctionRegistry(FunctionContributions functionContributions)
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Initialize the given registry with any dialect-specific functions.Support for certain SQL functions is required, and if the database does not support a required function, then the dialect must define a way to emulate it.
These required functions include the functions defined by the JPA query language specification:
-
avg(arg)
- aggregate function -
count([distinct ]arg)
- aggregate function -
max(arg)
- aggregate function -
min(arg)
- aggregate function -
sum(arg)
- aggregate function
-
coalesce(arg0, arg1, ...)
-
nullif(arg0, arg1)
-
lower(arg)
-
upper(arg)
-
length(arg)
-
concat(arg0, arg1, ...)
-
locate(pattern, string[, start])
-
substring(string, start[, length])
-
trim([[spec ][character ]from] string)
-
abs(arg)
-
mod(arg0, arg1)
-
sqrt(arg)
-
current date
-
current time
-
current timestamp
-
any(arg)
- aggregate function -
every(arg)
- aggregate function
-
var_samp(arg)
- aggregate function -
var_pop(arg)
- aggregate function -
stddev_samp(arg)
- aggregate function -
stddev_pop(arg)
- aggregate function
-
cast(arg as Type)
-
extract(field from arg)
-
ln(arg)
-
exp(arg)
-
power(arg0, arg1)
-
floor(arg)
-
ceiling(arg)
-
position(pattern in string)
-
substring(string from start[ for length])
-
overlay(string placing replacement from start[ for length])
java.time
types:-
local date
-
local time
-
local datetime
-
offset datetime
-
instant
-
left(string, length)
-
right(string, length)
-
replace(string, pattern, replacement)
-
pad(string with length spec[ character])
-
repeat(string, times)
-
pi
-
log10(arg)
-
log(base, arg)
-
sign(arg)
-
sin(arg)
-
cos(arg)
-
tan(arg)
-
asin(arg)
-
acos(arg)
-
atan(arg)
-
atan2(arg0, arg1)
-
round(arg0[, arg1])
-
truncate(arg0[, arg1])
-
sinh(arg)
-
tanh(arg)
-
cosh(arg)
-
least(arg0, arg1, ...)
-
greatest(arg0, arg1, ...)
-
degrees(arg)
-
radians(arg)
-
bitand(arg1, arg1)
-
bitor(arg1, arg1)
-
bitxor(arg1, arg1)
-
format(datetime as pattern)
-
collate(string as collation)
-
str(arg)
- synonym ofcast(a as String)
-
ifnull(arg0, arg1)
- synonym ofcoalesce(a, b)
extract()
, and desugared by the parser:-
second(arg)
- synonym ofextract(second from a)
-
minute(arg)
- synonym ofextract(minute from a)
-
hour(arg)
- synonym ofextract(hour from a)
-
day(arg)
- synonym ofextract(day from a)
-
month(arg)
- synonym ofextract(month from a)
-
year(arg)
- synonym ofextract(year from a)
second()
function returns a floating point value, contrary to the integer type returned by the native function with this name on many databases. Thus, we don't just naively map these HQL functions to the native SQL functions with the same names.- Overrides:
initializeFunctionRegistry
in classDialect
-
-
getSqlAstTranslatorFactory
public SqlAstTranslatorFactory getSqlAstTranslatorFactory()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
- Overrides:
getSqlAstTranslatorFactory
in classDialect
- See Also:
StandardSqlAstTranslatorFactory
,JdbcEnvironment.getSqlAstTranslatorFactory()
-
extractPattern
public String extractPattern(TemporalUnit unit)
Deprecated, for removal: This API element is subject to removal in a future version.HANA has no extract() function, but we can emulate it using the appropriate named functions instead of extract(). The supported fields areTemporalUnit.YEAR
,TemporalUnit.MONTH
TemporalUnit.DAY
,TemporalUnit.HOUR
,TemporalUnit.MINUTE
,TemporalUnit.SECOND
TemporalUnit.WEEK
,TemporalUnit.DAY_OF_WEEK
,TemporalUnit.DAY_OF_MONTH
,TemporalUnit.DAY_OF_YEAR
.- Overrides:
extractPattern
in classDialect
- Parameters:
unit
- the first argument
-
buildSQLExceptionConversionDelegate
public SQLExceptionConversionDelegate buildSQLExceptionConversionDelegate()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
An instance ofSQLExceptionConversionDelegate
for interpreting dialect-specific error or SQLState codes.If this method is overridden to return a non-null value, the default
SQLExceptionConverter
will use the returnedSQLExceptionConversionDelegate
in addition to the following standard delegates:- a "static" delegate based on the JDBC4-defined
SQLException
hierarchy, and - a delegate that interprets SQLState codes as either X/Open or SQL-2003 codes, depending on what is reported by the JDBC driver.
It is strongly recommended that every
Dialect
implementation override this method, since interpretation of a SQL error is much more accurate when based on the vendor-specific error code, rather than on the SQLState.- Overrides:
buildSQLExceptionConversionDelegate
in classDialect
- Returns:
- The
SQLExceptionConversionDelegate
for this dialect
- a "static" delegate based on the JDBC4-defined
-
getWriteRowLockStrategy
public RowLockStrategy getWriteRowLockStrategy()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
The row lock strategy to use for write locks.- Overrides:
getWriteRowLockStrategy
in classDialect
-
getCreateTableString
public String getCreateTableString()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
The command used to create a table, usuallycreate table
.- Overrides:
getCreateTableString
in classDialect
- Returns:
- The command used to create a table.
-
getAddColumnString
public String getAddColumnString()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
The subcommand of thealter table
command used to add a column to a table, usuallyadd column
oradd
.- Overrides:
getAddColumnString
in classDialect
- Returns:
- The
add column
fragment.
-
getAddColumnSuffixString
public String getAddColumnSuffixString()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
The syntax for the suffix used to add a column to a table.- Overrides:
getAddColumnSuffixString
in classDialect
- Returns:
- The suffix of the
add column
fragment.
-
getCascadeConstraintsString
public String getCascadeConstraintsString()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
The keyword that specifies that adrop table
operation should be cascaded to its constraints, typically" cascade"
where the leading space is required, or the empty string if there is no such keyword in this dialect.- Overrides:
getCascadeConstraintsString
in classDialect
- Returns:
- The cascade drop keyword, if any, with a leading space
-
getCurrentTimestampSelectString
public String getCurrentTimestampSelectString()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
The command used to retrieve the current timestamp from the database.- Overrides:
getCurrentTimestampSelectString
in classDialect
-
getForUpdateString
public String getForUpdateString(String aliases)
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Get theFOR UPDATE OF column_list
fragment appropriate for this dialect, given the aliases of the columns to be write locked.- Overrides:
getForUpdateString
in classDialect
- Parameters:
aliases
- The columns to be write locked.- Returns:
- The appropriate
FOR UPDATE OF column_list
clause string.
-
getForUpdateString
public String getForUpdateString(String aliases, LockOptions lockOptions)
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Get theFOR UPDATE OF
orFOR SHARE OF
fragment appropriate for this dialect, given the aliases of the columns to be locked.- Overrides:
getForUpdateString
in classDialect
- Parameters:
aliases
- The columns to be locked.lockOptions
- the lock options to apply- Returns:
- The appropriate
FOR UPDATE OF column_list
clause string.
-
getForUpdateNowaitString
public String getForUpdateNowaitString()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Retrieves theFOR UPDATE NOWAIT
syntax specific to this dialect.- Overrides:
getForUpdateNowaitString
in classDialect
- Returns:
- The appropriate
FOR UPDATE NOWAIT
clause string.
-
getQuerySequencesString
public String getQuerySequencesString()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Get theselect
command used retrieve the names of all sequences.- Overrides:
getQuerySequencesString
in classDialect
- Returns:
- The select command; or null if sequences are not supported.
-
getSequenceInformationExtractor
public SequenceInformationExtractor getSequenceInformationExtractor()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
ASequenceInformationExtractor
which is able to extractSequenceInformation
from the JDBC result set returned whenDialect.getQuerySequencesString()
is executed.- Overrides:
getSequenceInformationExtractor
in classDialect
-
isCurrentTimestampSelectStringCallable
public boolean isCurrentTimestampSelectStringCallable()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Is the command returned byDialect.getCurrentTimestampSelectString()
treated as callable?Typically, this indicates the use of the JDBC escape syntax.
- Overrides:
isCurrentTimestampSelectStringCallable
in classDialect
- Returns:
- if the
Dialect.getCurrentTimestampSelectString()
is treated as callable; false otherwise.
-
registerDefaultKeywords
protected void registerDefaultKeywords()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Register the reserved words of ANSI-standard SQL as keywords.- Overrides:
registerDefaultKeywords
in classDialect
- See Also:
AnsiSqlKeywords
-
defaultScrollMode
public ScrollMode defaultScrollMode()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
A defaultScrollMode
to be used byQuery.scroll()
.- Overrides:
defaultScrollMode
in classDialect
- Returns:
- the default
ScrollMode
to use.
-
supportsColumnCheck
public boolean supportsColumnCheck()
Deprecated, for removal: This API element is subject to removal in a future version.HANA currently does not support check constraints.- Overrides:
supportsColumnCheck
in classDialect
- Returns:
- True if column-level
check
constraints are supported; false otherwise.
-
supportsCurrentTimestampSelection
public boolean supportsCurrentTimestampSelection()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Does this dialect support some way to retrieve the current timestamp value from the database?- Overrides:
supportsCurrentTimestampSelection
in classDialect
- Returns:
- True if the current timestamp can be retrieved; false otherwise.
-
doesRoundTemporalOnOverflow
public boolean doesRoundTemporalOnOverflow()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Does this dialect round a temporal when converting from a precision higher to a lower one?- Overrides:
doesRoundTemporalOnOverflow
in classDialect
- Returns:
- true if rounding is applied, false if truncation is applied
-
supportsExistsInSelect
public boolean supportsExistsInSelect()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Does the dialect support an exists statement in the select clause?- Overrides:
supportsExistsInSelect
in classDialect
- Returns:
- True if exists checks are allowed in the select clause; false otherwise.
-
supportsExpectedLobUsagePattern
public boolean supportsExpectedLobUsagePattern()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
"Expected" LOB usage pattern is such that I can perform an insert via prepared statement with a parameter binding for a LOB value without crazy casting to JDBC driver implementation-specific classes.- Overrides:
supportsExpectedLobUsagePattern
in classDialect
- Returns:
- True if normal LOB usage patterns can be used with this driver; false if driver-specific hookiness needs to be applied.
-
supportsUnboundedLobLocatorMaterialization
public boolean supportsUnboundedLobLocatorMaterialization()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Is it supported to materialize a LOB locator outside the transaction in which it was created?- Overrides:
supportsUnboundedLobLocatorMaterialization
in classDialect
- Returns:
- True if unbounded materialization is supported; false otherwise.
-
getSequenceSupport
public SequenceSupport getSequenceSupport()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Get the appropriateSequenceSupport
for this dialect.- Overrides:
getSequenceSupport
in classDialect
-
supportsTableCheck
public boolean supportsTableCheck()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Does this dialect support table-level check constraints?- Overrides:
supportsTableCheck
in classDialect
- Returns:
- True if table-level
check
constraints are supported; false otherwise.
-
supportsTupleDistinctCounts
public boolean supportsTupleDistinctCounts()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Does this dialect supportcount(distinct a,b)
?- Overrides:
supportsTupleDistinctCounts
in classDialect
- Returns:
- True if the database supports counting distinct tuples; false otherwise.
-
dropConstraints
public boolean dropConstraints()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Do we need to drop constraints before dropping tables in this dialect?- Overrides:
dropConstraints
in classDialect
- Returns:
- True if constraints must be dropped prior to dropping the table; false otherwise.
-
getMaxAliasLength
public int getMaxAliasLength()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
What is the maximum length Hibernate can use for generated aliases?- Overrides:
getMaxAliasLength
in classDialect
- Returns:
- The maximum length.
-
getMaxIdentifierLength
public int getMaxIdentifierLength()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
What is the maximum identifier length supported by this dialect?- Overrides:
getMaxIdentifierLength
in classDialect
- Returns:
- The maximum length.
-
getLimitHandler
public LimitHandler getLimitHandler()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Obtain aLimitHandler
that implements pagination support forQuery.setMaxResults(int)
andQuery.setFirstResult(int)
.- Overrides:
getLimitHandler
in classDialect
-
getSelectGUIDString
public String getSelectGUIDString()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Get the command used to select a GUID from the database.Optional operation.
- Overrides:
getSelectGUIDString
in classDialect
- Returns:
- The appropriate command.
-
getNameQualifierSupport
public NameQualifierSupport getNameQualifierSupport()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
The support for qualified identifiers.By default, decide based on
DatabaseMetaData
.- Overrides:
getNameQualifierSupport
in classDialect
- Returns:
- The
NameQualifierSupport
, or null to useDatabaseMetaData
.
-
buildIdentifierHelper
public IdentifierHelper buildIdentifierHelper(IdentifierHelperBuilder builder, DatabaseMetaData dbMetaData) throws SQLException
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
TheIdentifierHelper
indicated by this dialect for handling identifier conversions. Returningnull
is allowed and indicates that Hibernate should fall back to building a "standard" helper. In the fallback path, any changes made to the IdentifierHelperBuilder during this call will still be incorporated into the built IdentifierHelper.The incoming builder will have the following set:
IdentifierHelperBuilder.isGloballyQuoteIdentifiers()
IdentifierHelperBuilder.getUnquotedCaseStrategy()
- initialized to UPPERIdentifierHelperBuilder.getQuotedCaseStrategy()
- initialized to MIXED
By default, Hibernate will do the following:
- Call
IdentifierHelperBuilder.applyIdentifierCasing(DatabaseMetaData)
- Call
IdentifierHelperBuilder.applyReservedWords(DatabaseMetaData)
- Applies
AnsiSqlKeywords.sql2003()
as reserved words - Applies the {#link #sqlKeywords} collected here as reserved words
- Applies the Dialect's
NameQualifierSupport
, if it defines one
- Overrides:
buildIdentifierHelper
in classDialect
- Parameters:
builder
- A partially-configuredIdentifierHelperBuilder
.dbMetaData
- Access to the metadata returned from the driver if needed and if available. WARNING: it may benull
.- Returns:
- The
IdentifierHelper
instance to use, ornull
to indicate Hibernate should use its fallback path - Throws:
SQLException
- Accessing theDatabaseMetaData
can throw it. Just rethrow and Hibernate will handle it.- See Also:
Dialect.getNameQualifierSupport()
-
getCurrentSchemaCommand
public String getCurrentSchemaCommand()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Get the SQL command used to retrieve the current schema name.Works in conjunction with
Dialect.getSchemaNameResolver()
, unless the resultingSchemaNameResolver
does not need this information. For example, a custom implementation might make use of the Java 1.7Connection.getSchema()
method.- Overrides:
getCurrentSchemaCommand
in classDialect
- Returns:
- The current schema retrieval SQL
-
getForUpdateNowaitString
public String getForUpdateNowaitString(String aliases)
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Get theFOR UPDATE OF column_list NOWAIT
fragment appropriate for this dialect, given the aliases of the columns to be write locked.- Overrides:
getForUpdateNowaitString
in classDialect
- Parameters:
aliases
- The columns to be write locked.- Returns:
- The appropriate
FOR UPDATE OF colunm_list NOWAIT
clause string.
-
getReadLockString
public String getReadLockString(int timeout)
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Get the string to append toSELECT
statements to acquire READ locks for this dialect.Location of the returned string is treated the same as
Dialect.getForUpdateString()
.- Overrides:
getReadLockString
in classDialect
- Parameters:
timeout
- in milliseconds, -1 for indefinite wait and 0 for no wait.- Returns:
- The appropriate
LOCK
clause string.
-
getReadLockString
public String getReadLockString(String aliases, int timeout)
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Get the string to append toSELECT
statements to acquire READ locks for this dialect, given the aliases of the columns to be read locked.Location of the returned string is treated the same as
Dialect.getForUpdateString()
.- Overrides:
getReadLockString
in classDialect
- 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.
-
getWriteLockString
public String getWriteLockString(int timeout)
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Get the string to append toSELECT
statements to acquire pessimistic WRITE locks for this dialect.Location of the returned string is treated the same as
Dialect.getForUpdateString()
.- Overrides:
getWriteLockString
in classDialect
- 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)
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Get the string to append toSELECT
statements to acquire WRITE locks for this dialect, given the aliases of the columns to be write locked.Location of the returned string is treated the same as
Dialect.getForUpdateString()
.- Overrides:
getWriteLockString
in classDialect
- 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.
-
getQueryHintString
public String getQueryHintString(String query, List<String> hints)
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Apply a hint to the given SQL query.The entire query is provided, allowing full control over the placement and syntax of the hint.
By default, ignore the hint and simply return the query.
- Overrides:
getQueryHintString
in classDialect
- Parameters:
query
- The query to which to apply the hint.hints
- The hints to apply- Returns:
- The modified SQL
-
getTableComment
public String getTableComment(String comment)
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Get the comment into a form supported for table definition.- Overrides:
getTableComment
in classDialect
- Parameters:
comment
- The comment to apply- Returns:
- The comment fragment
-
getColumnComment
public String getColumnComment(String comment)
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Get the comment into a form supported for column definition.- Overrides:
getColumnComment
in classDialect
- Parameters:
comment
- The comment to apply- Returns:
- The comment fragment
-
supportsCommentOn
public boolean supportsCommentOn()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Does this dialect support commenting on tables and columns?- Overrides:
supportsCommentOn
in classDialect
- Returns:
true
if commenting is supported
-
supportsPartitionBy
public boolean supportsPartitionBy()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Does is dialect supportpartition by
?- Overrides:
supportsPartitionBy
in classDialect
-
contributeTypes
public void contributeTypes(TypeContributions typeContributions, ServiceRegistry serviceRegistry)
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
A callback which allows theDialect
to contribute types.- Overrides:
contributeTypes
in classDialect
- Parameters:
typeContributions
- Callback to contribute the typesserviceRegistry
- The service registry
-
appendBooleanValueString
public void appendBooleanValueString(SqlAppender appender, boolean bool)
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Append the SQL literal expression representing the given boolean value to the givenSqlAppender
.- Overrides:
appendBooleanValueString
in classDialect
- Parameters:
appender
- TheSqlAppender
to append the literal expression tobool
- The boolean value
-
getIdentityColumnSupport
public IdentityColumnSupport getIdentityColumnSupport()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Get the appropriateIdentityColumnSupport
for this dialect.- Overrides:
getIdentityColumnSupport
in classDialect
- Returns:
- the IdentityColumnSupport
-
getTableExporter
public Exporter<Table> getTableExporter()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
- Overrides:
getTableExporter
in classDialect
-
getCallableStatementSupport
public CallableStatementSupport getCallableStatementSupport()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
TheCallableStatementSupport
for this database. Does this database support returning cursors?- Overrides:
getCallableStatementSupport
in classDialect
-
registerResultSetOutParameter
public int registerResultSetOutParameter(CallableStatement statement, int position) throws SQLException
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Registers a parameter capable of returning aResultSet
by position, either anOUT
parameter, or aREF_CURSOR
parameter as defined in Java 8.- Overrides:
registerResultSetOutParameter
in classDialect
- Parameters:
statement
- The callable statement.position
- The bind position at which to register the output param.- Returns:
- The number of (contiguous) bind positions used.
- Throws:
SQLException
- Indicates problems registering the param.
-
registerResultSetOutParameter
public int registerResultSetOutParameter(CallableStatement statement, String name) throws SQLException
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Registers a parameter capable of returning aResultSet
by name, either anOUT
parameter, or aREF_CURSOR
parameter as defined in Java 8.- Overrides:
registerResultSetOutParameter
in classDialect
- 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.
-
supportsOffsetInSubquery
public boolean supportsOffsetInSubquery()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Does this dialect supportoffset
in subqueries?For example:
select * from Table1 where col1 in (select col1 from Table2 order by col2 limit 1 offset 1)
- Overrides:
supportsOffsetInSubquery
in classDialect
- Returns:
true
if it does
-
supportsWindowFunctions
public boolean supportsWindowFunctions()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Does this dialect support window functions likerow_number() over (..)
?- Overrides:
supportsWindowFunctions
in classDialect
- Returns:
true
if the underlying database supports window functions,false
otherwise. The default isfalse
.
-
supportsLateral
public boolean supportsLateral()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Does this dialect support the SQLlateral
keyword or a proprietary alternative?- Overrides:
supportsLateral
in classDialect
- Returns:
true
if the underlying database supports lateral,false
otherwise. The default isfalse
.
-
supportsNoWait
public boolean supportsNoWait()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Does this dialect supportNO_WAIT
timeout.- Overrides:
supportsNoWait
in classDialect
- Returns:
true
ifNO_WAIT
is supported
-
supportsJdbcConnectionLobCreation
public boolean supportsJdbcConnectionLobCreation(DatabaseMetaData databaseMetaData)
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Check whether the JDBCConnection
supports creating LOBs viaConnection.createBlob()
,Connection.createNClob()
, orConnection.createClob()
.- Overrides:
supportsJdbcConnectionLobCreation
in classDialect
- Parameters:
databaseMetaData
- JDBCDatabaseMetaData
which can be used if LOB creation is supported only starting from a given driver version- Returns:
true
if LOBs can be created via the JDBC Connection.
-
supportsNoColumnsInsert
public boolean supportsNoColumnsInsert()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Is theINSERT
statement is allowed to contain no columns?- Overrides:
supportsNoColumnsInsert
in classDialect
- Returns:
- if this dialect supports no-column
INSERT
.
-
supportsOrderByInSubquery
public boolean supportsOrderByInSubquery()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Does this dialect support theorder by
clause in subqueries?For example:
select * from Table1 where col1 in (select col1 from Table2 order by col2 limit 1)
- Overrides:
supportsOrderByInSubquery
in classDialect
- Returns:
true
if it does
-
getNullOrdering
public NullOrdering getNullOrdering()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Returns the default ordering of null.- Overrides:
getNullOrdering
in classDialect
-
appendDatetimeFormat
public void appendDatetimeFormat(SqlAppender appender, String format)
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Translate the given datetime format string from the pattern language defined by Java'sDateTimeFormatter
to whatever pattern language is understood by the native datetime formatting function for this database (often theto_char()
function).Since it's never possible to translate every pattern letter sequences understood by
DateTimeFormatter
, only the following subset of pattern letters is accepted by Hibernate:- G: era
- y: year of era
- Y: year of week-based year
- M: month of year
- w: week of week-based year (ISO week number)
- W: week of month
- E: day of week (name)
- e: day of week (number)
- d: day of month
- D: day of year
- a: AM/PM
- H: hour of day (24 hour time)
- h: hour of AM/PM (12 hour time)
- m: minutes
- s: seconds
- z,Z,x: timezone offset
In addition, punctuation characters and single-quoted literal strings are accepted.
Appends a pattern accepted by the function that formats dates and times in this dialect to a SQL fragment that is being constructed.
- Overrides:
appendDatetimeFormat
in classDialect
-
supportsFractionalTimestampArithmetic
public boolean supportsFractionalTimestampArithmetic()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Whether the database supports adding a fractional interval to a timestamp, for exampletimestamp + 0.5 second
.- Overrides:
supportsFractionalTimestampArithmetic
in classDialect
-
getFractionalSecondPrecisionInNanos
public long getFractionalSecondPrecisionInNanos()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
The "native" precision for arithmetic with datetimes and day-to-second durations. Datetime differences will be calculated with this precision except when a precision is explicitly specified as aTemporalUnit
.Usually 1 (nanoseconds), 1_000 (microseconds), or 1_000_000 (milliseconds).
- Overrides:
getFractionalSecondPrecisionInNanos
in classDialect
- Returns:
- the precision, specified as a quantity of nanoseconds
- See Also:
TemporalUnit.NATIVE
-
timestampaddPattern
public String timestampaddPattern(TemporalUnit unit, TemporalType temporalType, IntervalType intervalType)
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Obtain a pattern for the SQL equivalent to atimestampadd()
function call. The resulting pattern must contain ?1, ?2, and ?3 placeholders for the arguments.- Overrides:
timestampaddPattern
in classDialect
- Parameters:
unit
- The unit to add to the temporaltemporalType
- The type of the temporalintervalType
- The type of interval to add or null if it's not a native interval
-
timestampdiffPattern
public String timestampdiffPattern(TemporalUnit unit, TemporalType fromTemporalType, TemporalType toTemporalType)
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Obtain a pattern for the SQL equivalent to atimestampdiff()
function call. The resulting pattern must contain ?1, ?2, and ?3 placeholders for the arguments.- Overrides:
timestampdiffPattern
in classDialect
- Parameters:
unit
- the first argumentfromTemporalType
- true if the first argument is a timestamp, false if a datetoTemporalType
- true if the second argument is
-
appendDateTimeLiteral
public void appendDateTimeLiteral(SqlAppender appender, TemporalAccessor temporalAccessor, TemporalType precision, TimeZone jdbcTimeZone)
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Append a datetime literal representing the givenjava.time
value to the givenSqlAppender
.- Overrides:
appendDateTimeLiteral
in classDialect
-
appendDateTimeLiteral
public void appendDateTimeLiteral(SqlAppender appender, Date date, TemporalType precision, TimeZone jdbcTimeZone)
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Append a datetime literal representing the givenDate
value to the givenSqlAppender
.- Overrides:
appendDateTimeLiteral
in classDialect
-
generatedAs
public String generatedAs(String generatedAs)
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Thegenerated as
clause, or similar, for generated column declarations in DDL statements.- Overrides:
generatedAs
in classDialect
- Parameters:
generatedAs
- a SQL expression used to generate the column value- Returns:
- The
generated as
clause containing the given expression
-
isUseUnicodeStringTypes
public boolean isUseUnicodeStringTypes()
Deprecated, for removal: This API element is subject to removal in a future version.
-
supportsAsciiStringTypes
protected boolean supportsAsciiStringTypes()
Deprecated, for removal: This API element is subject to removal in a future version.
-
useUnicodeStringTypesDefault
protected Boolean useUnicodeStringTypesDefault()
Deprecated, for removal: This API element is subject to removal in a future version.
-
getFallbackSqmMutationStrategy
public SqmMultiTableMutationStrategy getFallbackSqmMutationStrategy(EntityMappingType entityDescriptor, RuntimeModelCreationContext runtimeModelCreationContext)
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
TheSqmMultiTableMutationStrategy
to use when not specified byQueryEngineOptions.getCustomSqmMultiTableMutationStrategy()
.
-
getFallbackSqmInsertStrategy
public SqmMultiTableInsertStrategy getFallbackSqmInsertStrategy(EntityMappingType entityDescriptor, RuntimeModelCreationContext runtimeModelCreationContext)
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
TheSqmMultiTableInsertStrategy
to use when not specified byQueryEngineOptions.getCustomSqmMultiTableInsertStrategy()
.
-
getSupportedTemporaryTableKind
public TemporaryTableKind getSupportedTemporaryTableKind()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
The kind of temporary tables that are supported on this database.- Overrides:
getSupportedTemporaryTableKind
in classDialect
-
getTemporaryTableCreateOptions
public String getTemporaryTableCreateOptions()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
An arbitrary SQL fragment appended to the end of the statement to create a temporary table, specifying dialect-specific options, ornull
if there are no options to specify.- Overrides:
getTemporaryTableCreateOptions
in classDialect
-
getTemporaryTableCreateCommand
public String getTemporaryTableCreateCommand()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
The command to create a temporary table.- Overrides:
getTemporaryTableCreateCommand
in classDialect
-
getTemporaryTableTruncateCommand
public String getTemporaryTableTruncateCommand()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
The command to truncate a temporary table.- Overrides:
getTemporaryTableTruncateCommand
in classDialect
-
getDmlTargetColumnQualifierSupport
public DmlTargetColumnQualifierSupport getDmlTargetColumnQualifierSupport()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Get the minimumDmlTargetColumnQualifierSupport
required by this dialect.- Overrides:
getDmlTargetColumnQualifierSupport
in classDialect
- Returns:
- the column qualifier support required by this dialect
-
supportsSkipLocked
public boolean supportsSkipLocked()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Does this dialect supportSKIP_LOCKED
timeout.- Overrides:
supportsSkipLocked
in classDialect
- Returns:
true
if SKIP_LOCKED is supported
-
getForUpdateSkipLockedString
public String getForUpdateSkipLockedString()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Retrieves theFOR UPDATE SKIP LOCKED
syntax specific to this dialect.- Overrides:
getForUpdateSkipLockedString
in classDialect
- Returns:
- The appropriate
FOR UPDATE SKIP LOCKED
clause string.
-
getForUpdateSkipLockedString
public String getForUpdateSkipLockedString(String aliases)
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Get theFOR UPDATE OF column_list SKIP LOCKED
fragment appropriate for this dialect, given the aliases of the columns to be write locked.- Overrides:
getForUpdateSkipLockedString
in classDialect
- Parameters:
aliases
- The columns to be write locked.- Returns:
- The appropriate
FOR UPDATE colunm_list SKIP LOCKED
clause string.
-
getForUpdateString
public String getForUpdateString(LockMode lockMode)
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Given aLockMode
, determine the appropriatefor update
fragment to use to obtain the lock.- Overrides:
getForUpdateString
in classDialect
- Parameters:
lockMode
- The lock mode to apply.- Returns:
- The appropriate for update fragment.
-
getDual
public String getDual()
Deprecated, for removal: This API element is subject to removal in a future version.Description copied from class:Dialect
Returns a table expression that has one row.
-
getFromDualForSelectOnly
public String getFromDualForSelectOnly()
Deprecated, for removal: This API element is subject to removal in a future version.- Overrides:
getFromDualForSelectOnly
in classDialect
-
-