| Modifier and Type | Field and Description |
|---|---|
| private static final Pattern | |
| protected final PostgreSQLDriverKind | |
| private static final ViolatedConstraintNameExtractor | EXTRACTOR
Constraint-name extractor for Postgres constraint violation exceptions.
|
| private static final CoreMessageLogger | |
| protected static final DatabaseVersion |
| Access | Constructor and Description |
|---|---|
| public | |
| public | |
| public | |
| public | |
| public |
| Modifier and Type | Method and Description |
|---|---|
| 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.
|
| protected String | castType(int
The JDBC type code representing the target type sqlTypeCode)Overrides org. cast( ...
|
| protected String | columnType(int
a SQL sqlTypeCode)type codeOverrides org. Types or SqlTypes.
|
| protected void | |
| public void | contributeTypes(TypeContributions
Callback to contribute the types typeContributions, ServiceRegistry The service registry serviceRegistry)Overrides org. Dialect to contribute types.
|
| public String | extractPattern(TemporalUnit
the first argument unit)Overrides org. extract() function returns TemporalUnit#DAY_OF_WEEK
numbered from 0 to 6.
|
| protected static DatabaseVersion | |
| public String | getCascadeConstraintsString()
Overrides org. drop 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.
|
| public String | getCaseInsensitiveLike()
Overrides org. LIKE
comparisons.
|
| public String | getCurrentTimestampSelectString()
Overrides org. |
| public int | getDefaultIntervalSecondScale()
Overrides org. SqlTypes. type code for the given column
Usually 9 (nanosecond) or 6 (microseconds). |
| public String | getForUpdateNowaitString()
Overrides org. FOR UPDATE NOWAIT syntax specific to this dialect.
|
| public String | getForUpdateNowaitString(String
The columns to be write locked. aliases)Overrides org. FOR UPDATE OF column_list NOWAIT fragment appropriate
for this dialect, given the aliases of the columns to be write locked.
|
| 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(String
The columns to be write locked. aliases)Overrides org. FOR UPDATE OF column_list fragment appropriate
for this dialect, given the aliases of the columns to be write
locked.
|
| public String | getForUpdateString(LockOptions
contains the lock mode to apply. lockOptions)Overrides org. LockOptions (lock level, timeout),
determine the appropriate for update fragment to
use to obtain the lock.
|
| public String | getForUpdateString(String
The columns to be locked. aliases, LockOptions the lock options to apply lockOptions)Overrides org. FOR UPDATE OF or FOR SHARE OF fragment
appropriate for this dialect, given the aliases of the columns
to be locked.
|
| public long | getFractionalSecondPrecisionInNanos()
Overrides org. microsecond is the smallest unit for an interval,
and the highest precision for a timestamp.
|
| public FunctionalDependencyAnalysisSupport | getFunctionalDependencyAnalysisSupport()
Overrides org. GROUP BY and ORDER BY clauses.
|
| public IdentityColumnSupport | getIdentityColumnSupport()
Overrides org. IdentityColumnSupport for this dialect.
|
| public LimitHandler | getLimitHandler()
Overrides org. LimitHandler that implements pagination support for
Query#setMaxResults(int) and Query#setFirstResult(int).
|
| public int | getMaxIdentifierLength()
Overrides org. |
| protected DatabaseVersion | getMinimumSupportedVersion()
Overrides org. |
| public NameQualifierSupport | |
| public NationalizationSupport | getNationalizationSupport()
Overrides org. |
| public String | getNativeIdentifierGeneratorStrategy()
Overrides org. |
| public String | getNoColumnsInsertString()
Overrides org. (), but sometimes default values.
|
| public NullOrdering | getNullOrdering()
Returns the default ordering of null.
|
| public String | Returns: the query with hints addedThe query to which to apply the hint. query, List<String> The hints to apply hintList)
Applies the hints to the query string.
|
| 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 String | getReadLockString(String
The columns to be read locked. aliases, int in milliseconds, -1 for indefinite wait and 0 for no wait. timeout)Overrides org. SELECT statements to
acquire READ locks for this dialect, given the aliases of
the columns to be read locked.
|
| 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 TimeZoneSupport | getTimeZoneSupport()
Overrides org. Types#TIMESTAMP_WITH_TIMEZONE.
|
| public ViolatedConstraintNameExtractor | getViolatedConstraintNameExtractor()
Overrides org. Implements org. ViolatedConstraintNameExtractor for extracting the name of
a violated constraint from a SQLException.
|
| 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 String | getWriteLockString(String
The columns to be read locked. aliases, int in milliseconds, -1 for indefinite wait and 0 for no wait. timeout)Overrides org. SELECT statements to
acquire WRITE locks for this dialect, given the aliases of
the columns to be write locked.
|
| public RowLockStrategy | getWriteRowLockStrategy()
Overrides org. |
| public void | initializeFunctionRegistry(FunctionContributions functionContributions)
Overrides org. |
| private static String | |
| public boolean | isCurrentTimestampSelectStringCallable()
Overrides org. getCurrentTimestampSelectString
treated as callable?
|
| public static DatabaseVersion | |
| public boolean | qualifyIndexName()
Do we need to qualify index names with the schema name?
|
| protected void | registerColumnTypes(TypeContributions typeContributions, ServiceRegistry serviceRegistry)
Overrides org. getMaxVarcharLength(), getMaxNVarcharLength(),
and getMaxVarbinaryLength().
|
| public boolean | requiresParensForTupleDistinctCounts()
Overrides org. supportsTupleDistinctCounts() is true, does this dialect
require the tuple to be delimited with parentheses?
|
| protected Integer | resolveSqlTypeCode(String columnTypeName, TypeConfiguration typeConfiguration)
Overrides org. SqlTypes type code for the given column
type name as reported by the database, or null
if it can't be resolved.
|
| public JdbcType | resolveSqlTypeDescriptor(String
the column type name columnTypeName, int the jdbcTypeCode, int type codethe precision or 0 precision, int the scale or 0 scale, JdbcTypeRegistry jdbcTypeRegistry)Overrides org. JdbcType to a column of a JDBC
result set based on the column type name, JDBC type code,
precision, and scale.
|
| public boolean | supportsCaseInsensitiveLike()
Overrides org. LIKE comparisons?
|
| public boolean | supportsCurrentTimestampSelection()
Overrides org. |
| public boolean | supportsDistinctFromPredicate()
Overrides org. distinct from predicate?
|
| public boolean | supportsIfExistsAfterAlterTable()
Overrides org. alter table, can the phrase if exists be
applied?
|
| public boolean | supportsIfExistsBeforeConstraintName()
Overrides org. alter table statement,
can the phrase if exists be applied before the constraint
name?
|
| public boolean | supportsIfExistsBeforeTableName()
Overrides org. if exists be
applied before the table name?
|
| public boolean | supportsLateral()
Overrides org. lateral keyword or a
proprietary alternative?
|
| public boolean | supportsLobValueChangePropagation()
Overrides org. |
| public boolean | supportsNonQueryWithCTE()
Overrides org. |
| public boolean | supportsNoWait()
Overrides org. NO_WAIT timeout.
|
| 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?
|
| public boolean | supportsRecursiveCTE()
Overrides org. |
| public boolean | supportsSkipLocked()
Overrides org. SKIP_LOCKED timeout.
|
| public boolean | supportsStandardArrays()
Overrides org. integer array.
|
| public boolean | supportsTemporalLiteralOffset()
Overrides org. |
| public boolean | supportsTupleCounts()
Overrides org. count(a,b)?
|
| public boolean | supportsValuesList()
Overrides org. values lists of form
VALUES (1), (2), (3)?
|
| public boolean | supportsWait()
Overrides org. WAIT timeout.
|
| 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 String | translateDurationField(TemporalUnit unit)
Overrides org. #timestampadd()
or #timestampdiff(), or of this dialect's
equivalent
functions.
|
| public String | translateExtractField(TemporalUnit unit)
Overrides org. extract() function,
or of this dialect's equivalent
function.
|
| public boolean | useInputStreamToInsertBlob()
Overrides org. PreparedStatement#setBinaryStream).
|
| private String |