DB2iDialect, DB2zDialect
| Modifier and Type | Field and Description |
|---|---|
| private static final int | |
| private static final String | |
| private static final String | |
| private static final String | |
| private static final String | |
| private static final String | |
| private final LimitHandler | |
| pack-priv static final DatabaseVersion | |
| private static final String | |
| private final UniqueDelegate |
| Access | Constructor and Description |
|---|---|
| public | |
| public | |
| public |
| Modifier and Type | Method and Description |
|---|---|
| public void | appendBinaryLiteral(SqlAppender appender, byte[] bytes)
Overrides org. SqlAppender.
|
| public void | appendBooleanValueString(SqlAppender
The appender, boolean SqlAppender to append the literal expression toThe boolean value bool)Overrides org. SqlAppender.
|
| public void | appendDatetimeFormat(SqlAppender appender, String format)
Overrides org. java. to
whatever pattern language is understood by the
native datetime formatting function for this
database (often the to_char() function).
|
| public void | appendDateTimeLiteral(SqlAppender appender, TemporalAccessor temporalAccessor, TemporalType precision, TimeZone jdbcTimeZone)
Overrides org. java.
value to the given SqlAppender.
|
| public void | appendDateTimeLiteral(SqlAppender appender, Date date, TemporalType precision, TimeZone jdbcTimeZone)
Overrides org. Date
value to the given SqlAppender.
|
| public void | appendDateTimeLiteral(SqlAppender appender, Calendar calendar, TemporalType precision, TimeZone jdbcTimeZone)
Overrides org. Calendar
value to the given SqlAppender.
|
| public IdentifierHelper | buildIdentifierHelper(IdentifierHelperBuilder
A partially-configured builder, DatabaseMetaData IdentifierHelperBuilder.Access to the metadata returned from the driver if needed and if available dbMetaData)Warning it may be Overrides org. IdentifierHelper indicated by this dialect for handling identifier conversions.
|
| public SQLExceptionConversionDelegate | buildSQLExceptionConversionDelegate()
Overrides org. SQLExceptionConversionDelegate for interpreting
dialect-specific error or
SQLState codes.
|
| public boolean | canDisableConstraints()
Overrides org. |
| protected String | columnType(int
a SQL sqlTypeCode)type codeOverrides org. Types or SqlTypes.
|
| public void | contributeTypes(TypeContributions
Callback to contribute the types typeContributions, ServiceRegistry The service registry serviceRegistry)Overrides org. Dialect to contribute types.
|
| protected UniqueDelegate | |
| public boolean | doesReadCommittedCauseWritersToBlockReaders()
Overrides org. READ_COMMITTED isolation
implemented by forcing readers to wait for write locks to be released?
|
| public boolean | dropConstraints()
Do we need to drop constraints before dropping tables in this dialect?
|
| public String | extractPattern(TemporalUnit
the first argument unit)Overrides org. extract() function call.
|
| public String | generatedAs(String
a SQL expression used to generate the column value generatedAs)Overrides org. generated as clause, or similar, for generated column
declarations in DDL statements.
|
| public AggregateSupport | getAggregateSupport()
Overrides org. SqlTypes#STRUCT.
|
| public String | getAlterColumnTypeString(String
the name of the column columnName, String the new type of the column columnType, String the full column definition columnDefinition)Overrides org. alter table command which modifies a
column type, or null if column types cannot be modified.
|
| public CallableStatementSupport | getCallableStatementSupport()
Overrides org. CallableStatementSupport for this database.
|
| public String | getCreateIndexTail(boolean unique, List<Column> columns)
Overrides org. create index
command, usually to specify that null values are to be
considered distinct.
|
| public String | getCreateUserDefinedTypeExtensionsString()
Overrides org. create type command.
|
| public String | getCurrentTimestampSelectString()
Overrides org. |
| public DatabaseVersion | |
| public int | getDefaultDecimalPrecision()
Overrides org. java.
or java..
|
| public int | getDefaultStatementBatchSize()
Overrides org. |
| public String | getDisableConstraintStatement(String
the name of the table tableName, String the name of the constraint name)Overrides org. |
| public String[] | getDropSchemaCommand(String
The name of the schema to be dropped. schemaName)Overrides org. |
| public String | getEnableConstraintStatement(String
the name of the table tableName, String the name of the constraint name)Overrides org. |
| public SqmMultiTableInsertStrategy | getFallbackSqmInsertStrategy(EntityMappingType rootEntityDescriptor, RuntimeModelCreationContext runtimeModelCreationContext)
Overrides org.
Deprecated
as a consequence of
The RuntimeModelCreationContext being deprecated.
SqmMultiTableInsertStrategy to use when not specified by
org..
|
| public SqmMultiTableMutationStrategy | getFallbackSqmMutationStrategy(EntityMappingType rootEntityDescriptor, RuntimeModelCreationContext runtimeModelCreationContext)
Overrides org.
Deprecated
as a consequence of
The RuntimeModelCreationContext being deprecated.
SqmMultiTableMutationStrategy to use when not specified by
org..
|
| public String | getForUpdateSkipLockedString()
Overrides org. FOR UPDATE SKIP LOCKED syntax specific to this dialect.
|
| public String | getForUpdateSkipLockedString(String
The columns to be write locked. aliases)Overrides org. FOR UPDATE OF column_list SKIP LOCKED fragment appropriate
for this dialect, given the aliases of the columns to be write locked.
|
| public String | getForUpdateString()
Overrides org. SELECT statements to
acquire pessimistic UPGRADE locks for this dialect.
|
| public long | getFractionalSecondPrecisionInNanos()
Overrides org. seconds_between() and
add_seconds(), it makes sense to use
seconds as the "native" precision.
|
| public IdentityColumnSupport | getIdentityColumnSupport()
Overrides org. IdentityColumnSupport for this dialect.
|
| public int | getInExpressionCountLimit()
Overrides org. IN predicate.
|
| public LimitHandler | getLimitHandler()
Overrides org. LimitHandler that implements pagination support for
Query#setMaxResults(int) and Query#setFirstResult(int).
|
| public int | getMaxIdentifierLength()
Overrides org. |
| public int | getMaxVarcharLength()
Overrides org. java.-like type.
|
| protected DatabaseVersion | getMinimumSupportedVersion()
Overrides org. |
| public String | getQuerySequencesString()
Overrides org. select command used retrieve the names of all sequences.
|
| public String | getReadLockString(int
in milliseconds, -1 for indefinite wait and 0 for no wait. timeout)Overrides org. SELECT statements to
acquire READ locks for this dialect.
|
| public ResultSet | getResultSet(CallableStatement
The callable statement. ps)Overrides org. registerResultSetOutParameter, extract the
ResultSet from the OUT parameter.
|
| public String | getSelectClauseNullString(int
The sqlType, TypeConfiguration Types type code.The type configuration typeConfiguration)Overrides org. select
clause.
|
| public SequenceInformationExtractor | getSequenceInformationExtractor()
Overrides org. SequenceInformationExtractor which is able to extract
org.
from the JDBC result set returned when getQuerySequencesString()
is executed.
|
| public SequenceSupport | getSequenceSupport()
Overrides org. SequenceSupport for this dialect.
|
| public SqlAstTranslatorFactory | getSqlAstTranslatorFactory()
Overrides org. SqlAstTranslatorFactory specific to this dialect, or null
to use the standard translator.
|
| public String | getTruncateTableStatement(String
the name of the table tableName)Overrides org. |
| public UniqueDelegate | getUniqueDelegate()
Overrides org. UniqueDelegate supported by this dialect
|
| public String | getWriteLockString(int
in milliseconds, -1 for indefinite wait and 0 for no wait. timeout)Overrides org. SELECT statements to
acquire pessimistic WRITE locks for this dialect.
|
| public void | initializeFunctionRegistry(FunctionContributions functionContributions)
Overrides org. |
| public boolean | isCurrentTimestampSelectStringCallable()
Overrides org. getCurrentTimestampSelectString
treated as callable?
|
| protected void | registerColumnTypes(TypeContributions typeContributions, ServiceRegistry serviceRegistry)
Overrides org. getMaxVarcharLength(), getMaxNVarcharLength(),
and getMaxVarbinaryLength().
|
| protected void | registerDefaultKeywords()
Overrides org. |
| public int | registerResultSetOutParameter(CallableStatement
The callable statement. statement, int The bind position at which to register the output param. col)Overrides org. ResultSet
by position, either an OUT parameter, or a
REF_CURSOR parameter as defined in Java 8.
|
| public boolean | requiresCastForConcatenatingNonStrings()
Overrides org. concat() function?
|
| public String | rowId(String
the name specified by
rowId)org.,
which is ignored if getRowIdColumnString
is not overriddenOverrides org. rid_bit(alias) but here we use alias.rowid.
|
| public int | rowIdSqlType()
Overrides org. rowid-like pseudo-column
which acts as a high-performance row locator.
|
| public static String | |
| public boolean | supportsAlterColumnType()
Overrides org. |
| public boolean | supportsCommentOn()
Does this dialect support commenting on tables and columns?
|
| public boolean | supportsCurrentTimestampSelection()
Overrides org. |
| public boolean | supportsDistinctFromPredicate()
Overrides org. distinct from predicate?
|
| public boolean | supportsExistsInSelect()
Overrides org. |
| public boolean | Returns: true because we can use select ... from new table (insert .... )Overrides org. insert statement, using native SQL syntax?
|
| public boolean | supportsIsTrue()
Overrides org. is true and is false
operators?
|
| public boolean | supportsLateral()
Overrides org. lateral keyword or a
proprietary alternative?
|
| public boolean | supportsLobValueChangePropagation()
Overrides org. |
| public boolean | supportsLockTimeouts()
Overrides org. |
| public boolean | supportsNonQueryWithCTE()
Overrides org. |
| public boolean | supportsNullPrecedence()
Overrides org. nulls first and nulls last?
|
| public boolean | supportsOffsetInSubquery()
Overrides org. offset in subqueries?
|
| public boolean | supportsOuterJoinForUpdate()
Overrides org. FOR UPDATE in conjunction with
outer-joined rows?
|
| public boolean | supportsPartitionBy()
Overrides org. partition by?
|
| protected boolean | supportsPredicateAsExpression()
Overrides org. a > 0 can appear in an expression
context, for example, in a select list item.
|
| public boolean | supportsRecursiveCTE()
Overrides org. |
| public boolean | supportsResultSetPositionQueryMethodsOnForwardOnlyCursor()
Overrides org. |
| public boolean | supportsSkipLocked()
Overrides org. SKIP_LOCKED timeout.
|
| public boolean | supportsTupleDistinctCounts()
Overrides org. count(distinct a,b)?
|
| public boolean | supportsValuesList()
Overrides org. values lists of form
VALUES (1), (2), (3)?
|
| public boolean | supportsWindowFunctions()
Overrides org. row_number() over (..)?
|
| public String | timestampaddPattern(TemporalUnit
The unit to add to the temporal unit, TemporalType The type of the temporal temporalType, IntervalType The type of interval to add or null if it's not a native interval intervalType)Overrides org. timestampadd() function call.
|
| public String | timestampdiffPattern(TemporalUnit
the first argument unit, TemporalType true if the first argument is
a timestamp, false if a date fromTemporalType, TemporalType true if the second argument is toTemporalType)Overrides org. timestampdiff() function call.
|
| public static String | timestampdiffPatternV10(TemporalUnit unit, TemporalType fromTemporalType, TemporalType toTemporalType)
|
| public String | translateExtractField(TemporalUnit unit)
Overrides org. extract() function,
or of this dialect's equivalent
function.
|