Nested Class Summary

Field Summary

Constructor Summary

Method Summary

Constructor Details

• HSQLDialect

  public HSQLDialect(DialectResolutionInfo info)

• HSQLDialect

  public HSQLDialect()

• HSQLDialect

  public HSQLDialect(DatabaseVersion version)

Method Details

• getMinimumSupportedVersion

  protected DatabaseVersion getMinimumSupportedVersion()

  Description copied from class: Dialect

  Get the version of the SQL dialect that is the minimum supported by this implementation.

  Overrides:

  getMinimumSupportedVersion in class Dialect

• registerDefaultKeywords

  protected void registerDefaultKeywords()

  Description copied from class: Dialect

  Register the reserved words of ANSI-standard SQL as keywords.

  Overrides:

  registerDefaultKeywords in class Dialect

  See Also:

  • AnsiSqlKeywords

• columnType

  protected String columnType(int sqlTypeCode)

  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 concreteDialects as an alternative toDialect.registerColumnTypes(TypeContributions, ServiceRegistry) for simple registrations.

  Note that:

  1. Implementations of this method are expected to define a sensible mapping forTypes.NCLOBTypes.NCHAR, andTypes.NVARCHAR. On some database, these types are simply remapped toCLOB,CHAR, andVARCHAR.
  2. Mappings forTypes.TIMESTAMP andTypes.TIMESTAMP_WITH_TIMEZONE should support explicit specification of precision if possible.
  3. As specified byDdlTypeRegistry.getDescriptor(int), this method never receivesTypes.LONGVARCHAR,Types.LONGNVARCHAR, norTypes.LONGVARBINARY, which are considered synonyms for their non-LONG counterparts.
  4. On the other hand, the typesSqlTypes.LONG32VARCHAR,SqlTypes.LONG32NVARCHAR, andSqlTypes.LONG32VARBINARY arenot synonyms, and implementations of this method must define sensible mappings, for example to database-nativeTEXT orCLOB types.

  Overrides:

  columnType in class Dialect

  Parameters:

  sqlTypeCode - a SQLtype code

  Returns:

  a column type name, with$l,$p,$s placeholders for length, precision, scale

  See Also:

  • SqlTypes

• resolveSqlTypeCode

  protected Integer resolveSqlTypeCode(String typeName,String baseTypeName,TypeConfiguration typeConfiguration)

  Description copied from class: Dialect

  Resolves theSqlTypes type code for the given column type name as reported by the database and the base type name (i.e. without precision, length and scale), ornull if it can't be resolved.

  Overrides:

  resolveSqlTypeCode in class Dialect

• getDefaultStatementBatchSize

  public int getDefaultStatementBatchSize()

  Description copied from class: Dialect

  The default value to use for the configuration property"hibernate.jdbc.batch_size".

  Overrides:

  getDefaultStatementBatchSize in class Dialect

• initializeFunctionRegistry

  public void initializeFunctionRegistry(FunctionContributions functionContributions)

  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

  Along with an additional set of functions defined by ANSI SQL:

  • 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])

  And the following functions for working withjava.time types:

  • local date
  • local time
  • local datetime
  • offset datetime
  • instant

  And a number of additional "standard" functions:

  • 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)

  Finally, the following functions are defined as abbreviations forextract(), 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)

  Note that according to this definition, thesecond() 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 class Dialect

• getMaximumSeriesSize

  protected int getMaximumSeriesSize()

  HSQLDB doesn't support thegenerate_series function orlateral recursive CTEs, so it has to be emulated with a top level recursive CTE which requires an upper bound on the amount of elements that the series can return.

• getDefaultOrdinalityColumnName

  public @NullableString getDefaultOrdinalityColumnName()

  Description copied from class: Dialect

  Returns the default name of the ordinality column for a set-returning function if it supports that, otherwise returnsnull.

  Overrides:

  getDefaultOrdinalityColumnName in class Dialect

• currentTime

  public String currentTime()

  Description copied from class: Dialect

  Translation of the HQL/JPQLcurrent_time function, which maps to the Java typeTime which is a time with no time zone. This contradicts ANSI SQL wherecurrent_time has the typeTIME WITH TIME ZONE.

  It is recommended to override this in dialects for databases which supportlocaltime ortime at local.

  Overrides:

  currentTime in class Dialect

• currentTimestamp

  public String currentTimestamp()

  Description copied from class: Dialect

  Translation of the HQL/JPQLcurrent_timestamp function, which maps to the Java typeTimestamp which is a datetime with no time zone. This contradicts ANSI SQL wherecurrent_timestamp has the typeTIMESTAMP WITH TIME ZONE.

  It is recommended to override this in dialects for databases which supportlocaltimestamp ortimestamp at local.

  Overrides:

  currentTimestamp in class Dialect

• currentTimestampWithTimeZone

  public String currentTimestampWithTimeZone()

  Description copied from class: Dialect

  Translation of the HQLoffset_datetime function, which maps to the Java typeOffsetDateTime which is a datetime with a time zone. This in principle correctly maps to the ANSI SQLcurrent_timestamp which has the typeTIMESTAMP WITH TIME ZONE.

  Overrides:

  currentTimestampWithTimeZone in class Dialect

• getSqlAstTranslatorFactory

  public SqlAstTranslatorFactory getSqlAstTranslatorFactory()

  Description copied from class: Dialect

  Return aSqlAstTranslatorFactory specific to this dialect, ornull to use thestandard translator.

  Overrides:

  getSqlAstTranslatorFactory in class Dialect

  See Also:

  • StandardSqlAstTranslatorFactory
  • JdbcEnvironment.getSqlAstTranslatorFactory()

• castPattern

  public String castPattern(CastType from,CastType to)

  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 class Dialect

  Parameters:

  from - aCastType indicating the type of the value argument

  to - aCastType indicating the type the value argument is cast to

• timestampaddPattern

  public String timestampaddPattern(TemporalUnit unit,TemporalType temporalType,IntervalType intervalType)

  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 class Dialect

  Parameters:

  unit - The unit to add to the temporal

  temporalType - The type of the temporal

  intervalType - 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)

  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 class Dialect

  Parameters:

  unit - the first argument

  fromTemporalType - true if the first argument is a timestamp, false if a date

  toTemporalType - true if the second argument is

• extractPattern

  public String extractPattern(TemporalUnit unit)

  Description copied from class: Dialect

  Obtain a pattern for the SQL equivalent to anextract() function call. The resulting pattern must contain ?1 and ?2 placeholders for the arguments.

  This method does not need to handleTemporalUnit.NANOSECOND,TemporalUnit.NATIVE,TemporalUnit.OFFSET,TemporalUnit.DATE,TemporalUnit.TIME,TemporalUnit.WEEK_OF_YEAR, orTemporalUnit.WEEK_OF_MONTH, which are already desugared byExtractFunction.

  Overrides:

  extractPattern in class Dialect

  Parameters:

  unit - the first argument

• supportsDistinctFromPredicate

  public boolean supportsDistinctFromPredicate()

  Description copied from class: Dialect

  Does this dialect support some kind ofdistinct from predicate?

  That is, does it support syntax like:

   ... where FIRST_NAME IS DISTINCT FROM LAST_NAME

  Overrides:

  supportsDistinctFromPredicate in class Dialect

  Returns:

  True if this SQL dialect is known to support some kind ofdistinct from predicate; false otherwise

• supportsLockTimeouts

  public boolean supportsLockTimeouts()

  Description copied from class: Dialect

  Does this dialect support specifying timeouts when requesting locks.

  Overrides:

  supportsLockTimeouts in class Dialect

  Returns:

  True is this dialect supports specifying lock timeouts.

• getLimitHandler

  public LimitHandler getLimitHandler()

  Description copied from class: Dialect

  Obtain aLimitHandler that implements pagination support forQuery.setMaxResults(int) andQuery.setFirstResult(int).

  Overrides:

  getLimitHandler in class Dialect

• supportsIfExistsAfterTableName

  public boolean supportsIfExistsAfterTableName()

  Description copied from class: Dialect

  For dropping a table, can the phraseif exists be applied after the table name?

  Overrides:

  supportsIfExistsAfterTableName in class Dialect

  Returns:

  true ifif exists can be applied after the table name

• supportsIfExistsBeforeTableName

  public boolean supportsIfExistsBeforeTableName()

  Description copied from class: Dialect

  For dropping a table, can the phraseif exists be applied before the table name?

  Overrides:

  supportsIfExistsBeforeTableName in class Dialect

  Returns:

  true ifif exists can be applied before the table name

• getSequenceSupport

  public SequenceSupport getSequenceSupport()

  Description copied from class: Dialect

  Get the appropriateSequenceSupport for this dialect.

  Overrides:

  getSequenceSupport in class Dialect

• getQuerySequencesString

  public String getQuerySequencesString()

  Description copied from class: Dialect

  Get theselect command used retrieve the names of all sequences.

  Overrides:

  getQuerySequencesString in class Dialect

  Returns:

  The select command; or null if sequences are not supported.

• getSequenceInformationExtractor

  public SequenceInformationExtractor getSequenceInformationExtractor()

  Description copied from class: Dialect

  ASequenceInformationExtractor which is able to extractSequenceInformation from the JDBC result set returned whenDialect.getQuerySequencesString() is executed.

  Overrides:

  getSequenceInformationExtractor in class Dialect

• supportsStandardArrays

  public boolean supportsStandardArrays()

  Description copied from class: Dialect

  Does this database have native support for ANSI SQL standard arrays which are expressed in terms of the element type name:integer array.

  Overrides:

  supportsStandardArrays in class Dialect

  Returns:

  boolean

• getViolatedConstraintNameExtractor

  public ViolatedConstraintNameExtractor getViolatedConstraintNameExtractor()

  Description copied from class: Dialect

  AViolatedConstraintNameExtractor for extracting the name of a violated constraint from aSQLException.

  Specified by:

  getViolatedConstraintNameExtractor in interface ConversionContext

  Overrides:

  getViolatedConstraintNameExtractor in class Dialect

• buildSQLExceptionConversionDelegate

  public SQLExceptionConversionDelegate buildSQLExceptionConversionDelegate()

  Description copied from class: Dialect

  An instance ofSQLExceptionConversionDelegate for interpreting dialect-specificerror orSQLState codes.

  If this method is overridden to return a non-null value, the defaultSQLExceptionConverter will use the returnedSQLExceptionConversionDelegate in addition to the following standard delegates:

  1. a "static" delegate based on the JDBC4-definedSQLException hierarchy, and
  2. a delegate that interprets SQLState codes as either X/Open or SQL-2003 codes, depending on what isreported by the JDBC driver.

  It is strongly recommended that everyDialect implementation override this method, since interpretation of a SQL error is much more accurate when based on the vendor-specificerror code, rather than on the SQLState.

  Overrides:

  buildSQLExceptionConversionDelegate in class Dialect

  Returns:

  TheSQLExceptionConversionDelegate for this dialect

• getSelectClauseNullString

  public String getSelectClauseNullString(int sqlType,TypeConfiguration typeConfiguration)

  Description copied from class: Dialect

  Given aJDBC type code, return the expression for a literal null value of that type, to use in aselect clause.

  Theselect query will be an element of aUNION orUNION ALL.

  Overrides:

  getSelectClauseNullString in class Dialect

  Parameters:

  sqlType - TheTypes type code.

  typeConfiguration - The type configuration

  Returns:

  The appropriate select clause value fragment.

• getNullOrdering

  public NullOrdering getNullOrdering()

  Description copied from class: Dialect

  Returns the default ordering of null.

  Overrides:

  getNullOrdering in class Dialect

• getFallbackSqmMutationStrategy

  public SqmMultiTableMutationStrategy getFallbackSqmMutationStrategy(EntityMappingType rootEntityDescriptor,RuntimeModelCreationContext runtimeModelCreationContext)

  Description copied from class: Dialect

  TheSqmMultiTableMutationStrategy to use when not specified byQueryEngineOptions.getCustomSqmMultiTableMutationStrategy().

  Overrides:

  getFallbackSqmMutationStrategy in class Dialect

  See Also:

  • SqmMultiTableMutationStrategyProvider.createMutationStrategy(org.hibernate.metamodel.mapping.EntityMappingType, org.hibernate.metamodel.mapping.internal.MappingModelCreationProcess)

• getFallbackSqmInsertStrategy

  public SqmMultiTableInsertStrategy getFallbackSqmInsertStrategy(EntityMappingType rootEntityDescriptor,RuntimeModelCreationContext runtimeModelCreationContext)

  Description copied from class: Dialect

  TheSqmMultiTableInsertStrategy to use when not specified byQueryEngineOptions.getCustomSqmMultiTableInsertStrategy().

  Overrides:

  getFallbackSqmInsertStrategy in class Dialect

  See Also:

  • SqmMultiTableMutationStrategyProvider.createInsertStrategy(org.hibernate.metamodel.mapping.EntityMappingType, org.hibernate.metamodel.mapping.internal.MappingModelCreationProcess)

• getSupportedTemporaryTableKind

  public TemporaryTableKind getSupportedTemporaryTableKind()

  Description copied from class: Dialect

  The kind of temporary tables that are supported on this database.

  Overrides:

  getSupportedTemporaryTableKind in class Dialect

• getTemporaryTableCreateCommand

  public String getTemporaryTableCreateCommand()

  Description copied from class: Dialect

  The command to create a temporary table.

  Overrides:

  getTemporaryTableCreateCommand in class Dialect

• getTemporaryTableAfterUseAction

  public AfterUseAction getTemporaryTableAfterUseAction()

  Description copied from class: Dialect

  The action to take after finishing use of a temporary table.

  Overrides:

  getTemporaryTableAfterUseAction in class Dialect

• getTemporaryTableBeforeUseAction

  public BeforeUseAction getTemporaryTableBeforeUseAction()

  Description copied from class: Dialect

  The action to take before beginning use of a temporary table.

  Overrides:

  getTemporaryTableBeforeUseAction in class Dialect

• supportsCurrentTimestampSelection

  public boolean supportsCurrentTimestampSelection()

  Description copied from class: Dialect

  Does this dialect support some way to retrieve the current timestamp value from the database?

  Overrides:

  supportsCurrentTimestampSelection in class Dialect

  Returns:

  True if the current timestamp can be retrieved; false otherwise.

• isCurrentTimestampSelectStringCallable

  public boolean isCurrentTimestampSelectStringCallable()

  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 class Dialect

  Returns:

  if theDialect.getCurrentTimestampSelectString() is treated as callable; false otherwise.

• getCurrentTimestampSelectString

  public String getCurrentTimestampSelectString()

  Description copied from class: Dialect

  The command used to retrieve the current timestamp from the database.

  Overrides:

  getCurrentTimestampSelectString in class Dialect

• doesRoundTemporalOnOverflow

  public boolean doesRoundTemporalOnOverflow()

  Description copied from class: Dialect

  Does this dialect round a temporal when converting from a precision higher to a lower one?

  Overrides:

  doesRoundTemporalOnOverflow in class Dialect

  Returns:

  true if rounding is applied, false if truncation is applied

• supportsCommentOn

  public boolean supportsCommentOn()

  Description copied from class: Dialect

  Does this dialect support commenting on tables and columns?

  Overrides:

  supportsCommentOn in class Dialect

  Returns:

  true if commenting is supported

• doesReadCommittedCauseWritersToBlockReaders

  public boolean doesReadCommittedCauseWritersToBlockReaders()

  Description copied from class: Dialect

  For the underlying database, isREAD_COMMITTED isolation implemented by forcing readers to wait for write locks to be released?

  Overrides:

  doesReadCommittedCauseWritersToBlockReaders in class Dialect

  Returns:

  True if writers block readers to achieveREAD_COMMITTED; false otherwise.

• doesRepeatableReadCauseReadersToBlockWriters

  public boolean doesRepeatableReadCauseReadersToBlockWriters()

  Description copied from class: Dialect

  For the underlying database, isREPEATABLE_READ isolation implemented by forcing writers to wait for read locks to be released?

  Overrides:

  doesRepeatableReadCauseReadersToBlockWriters in class Dialect

  Returns:

  True if readers block writers to achieveREPEATABLE_READ; false otherwise.

• supportsLobValueChangePropagation

  public boolean supportsLobValueChangePropagation()

  Description copied from class: Dialect

  Does the dialect support propagating changes to LOB values back to the database? Talking about mutating the internal value of the locator, as opposed to supplying a new locator instance.

  • For BLOBs, the internal value might be changed by:Blob.setBinaryStream(long),Blob.setBytes(long, byte[]),Blob.setBytes(long, byte[], int, int), orBlob.truncate(long).
  • For CLOBs, the internal value might be changed by:Clob.setAsciiStream(long),Clob.setCharacterStream(long),Clob.setString(long, String),Clob.setString(long, String, int, int), orClob.truncate(long).

  Overrides:

  supportsLobValueChangePropagation in class Dialect

  Returns:

  True if the changes are propagated back to the database; false otherwise.

• appendBooleanValueString

  public void appendBooleanValueString(SqlAppender appender, boolean bool)

  Description copied from class: Dialect

  Append the SQL literal expression representing the given boolean value to the givenSqlAppender.

  Overrides:

  appendBooleanValueString in class Dialect

  Parameters:

  appender - TheSqlAppender to append the literal expression to

  bool - The boolean value

• supportsTupleCounts

  public boolean supportsTupleCounts()

  Description copied from class: Dialect

  Does this dialect supportcount(a,b)?

  Overrides:

  supportsTupleCounts in class Dialect

  Returns:

  True if the database supports counting tuples; false otherwise.

• supportsTupleDistinctCounts

  public boolean supportsTupleDistinctCounts()

  Description copied from class: Dialect

  Does this dialect supportcount(distinct a,b)?

  Overrides:

  supportsTupleDistinctCounts in class Dialect

  Returns:

  True if the database supports counting distinct tuples; false otherwise.

• supportsOffsetInSubquery

  public boolean supportsOffsetInSubquery()

  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 class Dialect

  Returns:

  true if it does

• supportsLateral

  public boolean supportsLateral()

  Description copied from class: Dialect

  Does this dialect support the SQLlateral keyword or a proprietary alternative?

  Overrides:

  supportsLateral in class Dialect

  Returns:

  true if the underlying database supports lateral,false otherwise. The default isfalse.

• supportsRecursiveCTE

  public boolean supportsRecursiveCTE()

  Description copied from class: Dialect

  Does this dialect/database support recursive CTEs?

  Overrides:

  supportsRecursiveCTE in class Dialect

  Returns:

  true if recursive CTEs are supported

• requiresFloatCastingOfIntegerDivision

  public boolean requiresFloatCastingOfIntegerDivision()

  Description copied from class: Dialect

  Does this dialect require that integer divisions be wrapped incast() calls to tell the db parser the expected type.

  Overrides:

  requiresFloatCastingOfIntegerDivision in class Dialect

  Returns:

  True if integer divisions must becast()ed to float

• supportsValuesList

  public boolean supportsValuesList()

  Description copied from class: Dialect

  Does this dialect supportvalues lists of formVALUES (1), (2), (3)?

  Overrides:

  supportsValuesList in class Dialect

  Returns:

  true ifvalues list are supported

• getIdentityColumnSupport

  public IdentityColumnSupport getIdentityColumnSupport()

  Description copied from class: Dialect

  Get the appropriateIdentityColumnSupport for this dialect.

  Overrides:

  getIdentityColumnSupport in class Dialect

  Returns:

  the IdentityColumnSupport

• getNameQualifierSupport

  public NameQualifierSupport getNameQualifierSupport()

  Description copied from class: Dialect

  Thesupport for qualified identifiers.

  By default, decide based onDatabaseMetaData.

  Overrides:

  getNameQualifierSupport in class Dialect

  Returns:

  TheNameQualifierSupport, or null to useDatabaseMetaData.

• supportsNamedParameters

  public boolean supportsNamedParameters(DatabaseMetaData databaseMetaData)

  Description copied from class: Dialect

  OverrideDatabaseMetaData.supportsNamedParameters().

  Overrides:

  supportsNamedParameters in class Dialect

• getFunctionalDependencyAnalysisSupport

  public FunctionalDependencyAnalysisSupport getFunctionalDependencyAnalysisSupport()

  Description copied from class: Dialect

  Get this dialect's level of support for primary key functional dependency analysis withinGROUP BY andORDER BY clauses.

  Overrides:

  getFunctionalDependencyAnalysisSupport in class Dialect

• dropConstraints

  public boolean dropConstraints()

  Description copied from class: Dialect

  Do we need to drop constraints before dropping tables in this dialect?

  Overrides:

  dropConstraints in class Dialect

  Returns:

  True if constraints must be dropped prior to dropping the table; false otherwise.

• getCascadeConstraintsString

  public String getCascadeConstraintsString()

  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 class Dialect

  Returns:

  The cascade drop keyword, if any, with a leading space

• appendDatetimeFormat

  public void appendDatetimeFormat(SqlAppender appender,String format)

  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 byDateTimeFormatter, 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 class Dialect

• translateExtractField

  public String translateExtractField(TemporalUnit unit)

  Description copied from class: Dialect

  Return the name used to identify the given field as an argument to theextract() function, or of this dialect'sequivalent function.

  This method does not need to handleTemporalUnit.NANOSECOND,TemporalUnit.NATIVE,TemporalUnit.OFFSET,TemporalUnit.DATE,TemporalUnit.TIME,TemporalUnit.WEEK_OF_YEAR, norTemporalUnit.WEEK_OF_MONTH, which are already desugared byExtractFunction.

  Overrides:

  translateExtractField in class Dialect

• buildIdentifierHelper

  public IdentifierHelper buildIdentifierHelper(IdentifierHelperBuilder builder,DatabaseMetaData dbMetaData) throwsSQLException

  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 UPPER
  • IdentifierHelperBuilder.getQuotedCaseStrategy() - initialized to MIXED

  By default, Hibernate will do the following:

  • CallIdentifierHelperBuilder.applyIdentifierCasing(DatabaseMetaData)
  • CallIdentifierHelperBuilder.applyReservedWords(DatabaseMetaData)
  • AppliesAnsiSqlKeywords.sql2003() as reserved words
  • Applies the {#link #sqlKeywords} collected here as reserved words
  • Applies the Dialect'sNameQualifierSupport, if it defines one

  Overrides:

  buildIdentifierHelper in class Dialect

  Parameters:

  builder - A partially-configuredIdentifierHelperBuilder.

  dbMetaData - Access to the metadata returned from the driver if needed and if available.WARNING: it may benull.

  Returns:

  TheIdentifierHelper 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()

• getUniqueDelegate

  public UniqueDelegate getUniqueDelegate()

  Description copied from class: Dialect

  Get theUniqueDelegate supported by this dialect

  Overrides:

  getUniqueDelegate in class Dialect

  Returns:

  The UniqueDelegate

• quoteCollation

  public String quoteCollation(String collation)

  Description copied from class: Dialect

  Quote the given collation name if necessary.

  Overrides:

  quoteCollation in class Dialect

• getDmlTargetColumnQualifierSupport

  public DmlTargetColumnQualifierSupport getDmlTargetColumnQualifierSupport()

  Description copied from class: Dialect

  Get the minimumDmlTargetColumnQualifierSupport required by this dialect.

  Overrides:

  getDmlTargetColumnQualifierSupport in class Dialect

  Returns:

  the column qualifier support required by this dialect

• getFromDualForSelectOnly

  public String getFromDualForSelectOnly()

  Overrides:

  getFromDualForSelectOnly in class Dialect

• supportsFilterClause

  public boolean supportsFilterClause()

  Description copied from class: Dialect

  Whether the FILTER clause for aggregate functions is supported.

  Overrides:

  supportsFilterClause in class Dialect

• supportsArrayConstructor

  public boolean supportsArrayConstructor()

  Description copied from class: Dialect

  Whether the SQL array constructor is supported.

  Overrides:

  supportsArrayConstructor in class Dialect

• supportsRowValueConstructorSyntax

  public boolean supportsRowValueConstructorSyntax()

  Description copied from class: Dialect

  Is this dialect known to support what ANSI-SQL terms "row value constructor" syntax; sometimes called tuple syntax.

  Basically, does it support syntax like... where (FIRST_NAME, LAST_NAME) = ('Steve', 'Ebersole') ...

  Overrides:

  supportsRowValueConstructorSyntax in class Dialect

  Returns:

  True if this SQL dialect is known to support "row value constructor" syntax; false otherwise.

• supportsWithClauseInSubquery

  public boolean supportsWithClauseInSubquery()

  Description copied from class: Dialect

  Whether the SQL with clause is supported within a subquery.

  Overrides:

  supportsWithClauseInSubquery in class Dialect

• supportsRowValueConstructorSyntaxInQuantifiedPredicates

  public boolean supportsRowValueConstructorSyntaxInQuantifiedPredicates()

  Description copied from class: Dialect

  Is this dialect known to support what ANSI-SQL terms "row value constructor" syntax; sometimes called tuple syntax with quantified predicates.

  Basically, does it support syntax like... where (FIRST_NAME, LAST_NAME) = ALL (select ...) ...

  Overrides:

  supportsRowValueConstructorSyntaxInQuantifiedPredicates in class Dialect

  Returns:

  True if this SQL dialect is known to support "row value constructor" syntax with quantified predicates; false otherwise.

• supportsRowValueConstructorSyntaxInInList

  public boolean supportsRowValueConstructorSyntaxInInList()

  Description copied from class: Dialect

  If the dialect supportsrow values, does it offer such support in IN lists as well?

  For example,... where (FIRST_NAME, LAST_NAME) IN ( (?, ?), (?, ?) ) ...

  Overrides:

  supportsRowValueConstructorSyntaxInInList in class Dialect

  Returns:

  True if this SQL dialect is known to support "row value constructor" syntax in the IN list; false otherwise.