Class PostgresPlusDialect

java.lang.Object

org.hibernate.dialect.Dialect

org.hibernate.dialect.PostgreSQLDialect

org.hibernate.dialect.PostgresPlusDialect

All Implemented Interfaces:

CheckConstraintSupport, ForeignKeySupport, IdentifierSupport, KeywordSupport, LiteralSupport, AlterTableSupport, ColumnDefinitionSupport, ConstraintControlSupport, IndexDdlSupport, TableCreationSupport, TruncateSupport, CurrentTemporalSupport, TemporalFormatSupport, TemporalOperationSupport, ConversionContext

public class PostgresPlusDialect
extends PostgreSQLDialect
implements CurrentTemporalSupport, TemporalOperationSupport

An SQL dialect for Postgres Plus

Field Summary

Fields inherited from class PostgreSQLDialect

driverKind, MINIMUM_VERSION

Fields inherited from class Dialect

LEGACY_LOB_MERGE_STRATEGY, NEW_LOCATOR_LOB_MERGE_STRATEGY, STANDARD_MULTI_KEY_LOAD_SIZING_STRATEGY, STREAM_XFER_LOB_MERGE_STRATEGY

Fields inherited from interface ConstraintControlSupport

NONE

Fields inherited from interface TruncateSupport

STANDARD

Constructor Summary

Constructors

Constructor	Description
PostgresPlusDialect()	Constructs a PostgresPlusDialect
PostgresPlusDialect(DatabaseVersion version)
PostgresPlusDialect(DialectResolutionInfo info)

Method Summary

Modifier and Type	Method	Description
String	castPattern(CastType from, CastType to)	Obtain a pattern for the SQL equivalent to a cast() function call.
String	currentTimestamp()	Render the current SQL timestamp expression used for java.sql.Timestamp.
CurrentTemporalSupport	getCurrentTemporalSupport()	Supply current temporal expressions and database-side timestamp retrieval.
RefCursorSupportFactory	getRefCursorSupportFactory()	Supply the stable factory which creates this Dialect's JDBC REF_CURSOR registration and extraction service.
SqlAstTranslatorFactory	getSqlAstTranslatorFactory()	Supply the factory for this Dialect's single-use SQL AST translators.
StringValueSemantics	getStringValueSemantics()	Supply the database's stable string-value semantics.
TemporalOperationSupport	getTemporalOperationSupport()	Supply extraction and timestamp-arithmetic syntax.
void	initializeFunctionRegistry(FunctionContributions functionContributions)	Contribute the database-specific function descriptors after independent function contributors have run.
String	timestampdiffPattern(TemporalUnit unit, TemporalType fromTemporalType, TemporalType toTemporalType)	Return a timestamp-difference pattern containing ?1, ?2, and ?3.

Methods inherited from class PostgreSQLDialect

addPartitionKeyToPrimaryKey, alterColumnType, appendBinaryLiteral, appendBooleanValueString, appendDateTimeLiteral, appendDateTimeLiteral, appendDateTimeLiteral, appendDefinition, appendFormat, augmentRecognizedTableTypes, buildIdentifierHelper, buildSQLExceptionConversionDelegate, castType, causesRollback, columnType, contributeDefaultProperties, contributePostgreSQLTypes, contributeTypes, createOptionalTableUpdateOperation, currentTime, currentTimestampWithTimeZone, datetimeFormat, extractPattern, fractionalSecondPrecisionInNanos, getAggregateSupport, getArraySupport, getCallableStatementSupport, getCteSupport, getCurrentTimestampSelection, getDefaultOrdinalityColumnName, getDirectJavaTimeJdbcSupport, getDmlTargetColumnQualifierSupport, getDriverKind, getEnumSupport, getFetchClauseSupport, getFunctionalDependencyAnalysisSupport, getGeneratedValuesSupport, getIdentityColumnSupport, getIfExistsSupport, getInformationExtractor, getLimitHandler, getLobSupport, getLocalTemporaryTableStrategy, getLockingSupport, getMaxIdentifierLength, getMinimumSupportedVersion, getMultiTableMutationSupport, getMutationSyntaxSupport, getNameQualifierSupport, getNamespaceSupport, getNationalizationSupport, getNativeParameterMarkerStrategy, getNativeValueGenerationStrategy, getObjectNullBindingStrategy, getPredicateSupport, getQueryHintPlacement, getQueryHintString, getRowIdSupport, getRowLevelSecurity, getRowValueSupport, getSchemaCommentSupport, getSchemaDropSupport, getSelectClauseNullString, getSequenceInformationExtractor, getSequenceSupport, getSubquerySupport, getTableExporter, getTemporalFormatSupport, getTemporalTableSupport, getTemporalValueSemantics, getTimeZoneSupport, getTupleCountSupport, getTypeSizingProfile, getUniqueDelegate, getUserDefinedTypeExporter, getValuesListSupport, getViolatedConstraintNameExtractor, getWindowFunctionSupport, isCurrentTimestampStable, nameQualification, quoteCollation, registerArrayFunctions, registerColumnTypes, registerJsonFunction, registerPostgreSQLColumnTypes, registerUtilityFunctions, registerXmlFunctions, renderCommands, resolveSqlTypeCode, resolveSqlTypeDescriptor, supportsFilterClause, supportsMinMaxOnUuid, supportsUserDefinedTypes, timestampaddPattern, translateExtractField, truncateMode

Methods inherited from class Dialect

appendArrayLiteral, augmentPhysicalTableTypes, buildLockingClauseStrategy, buildStringToBooleanCast, buildStringToBooleanCastDecode, constraintControlMode, contributeKeywords, defaultScrollMode, determineDatabaseVersion, equivalentTypes, getAlterTableSupport, getArrayTypeName, getBatchLoadSizingStrategy, getCatalogSeparator, getCheckConstraintSupport, getColumnAliasExtractor, getColumnDefinitionSupport, getConstraintControlSupport, getDefaultProperties, getEntityLockingStrategyFactory, getExpressionCoercionSupport, getForeignKeyExporter, getForeignKeySupport, getGlobalTemporaryTableStrategy, getIdentifierSupport, getIndexDdlSupport, getIndexExporter, getJdbcMetadataOverrides, getKeywords, getKeywordSupport, getLiteralSupport, getLobMergeStrategy, getLockingClauseStrategy, getLowercaseFunction, getMultiKeyLoadSizingStrategy, getNullOrderingSupport, getParameterLimits, getPersistentTemporaryTableStrategy, getPreferredSqlTypeCodeForArray, getPreferredSqlTypeCodeForBoolean, getQueryHintString, getSchemaNameResolver, getSequenceExporter, getSetOperationSupport, getSetOperatorSqlString, getSingleRowTableSupport, getSizeStrategy, getSyntheticTableGroupSupport, getTableCleaner, getTableCreationSupport, getTableMigrator, getTemporaryTableExporter, getTruncateSupport, getVersion, isJdbcLogWarningsEnabledByDefault, narrowCastType, resolveSqlTypeCode, resolveSqlTypeLength, supportsCrossJoin, supportsNationalizedMethods, supportsOrdinalSelectItemReference, throttleDdl, toString, trimPattern

Methods inherited from class Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Methods inherited from interface AlterTableSupport

addColumnPrefix, addColumnSuffix, alterTableCommand

Methods inherited from interface CheckConstraintSupport

render, supports

Methods inherited from interface ConstraintControlSupport

disableCommands, disableConstraintCommands, enableCommands, enableConstraintCommands

Methods inherited from interface CurrentTemporalSupport

currentDate, currentLocalTime, currentLocalTimestamp, currentTime, currentTimestampWithTimeZone, getCurrentTimestampSelection, isCurrentTimestampStable, usesStandardCurrentTimestampFunction

Methods inherited from interface ForeignKeySupport

renderAddConstraint, renderDropConstraint, requiresSelfReferentialForeignKeyNullification, supportsAlterTableConstraints, supportsOnDeleteAction

Methods inherited from interface IdentifierSupport

closeQuote, getMaxAliasLength, openQuote, quote, toQuotedIdentifier

Methods inherited from interface IndexDdlSupport

createCommand, createTail

Methods inherited from interface KeywordSupport

acceptsJdbcKeyword

Methods inherited from interface LiteralSupport

appendIntervalLiteral, appendIntervalLiteral, appendLiteral, appendUUIDLiteral, toBooleanValueString

Methods inherited from interface TableCreationSupport

createTableCommand, requiresViewColumnList, tableCreationOptions

Methods inherited from interface TemporalOperationSupport

extractPattern, fractionalSecondPrecisionInNanos, timestampaddPattern, translateDurationField, translateExtractField

Constructor Details

PostgresPlusDialect

public PostgresPlusDialect()

Constructs a PostgresPlusDialect

PostgresPlusDialect

public PostgresPlusDialect(DialectResolutionInfo info)

PostgresPlusDialect

public PostgresPlusDialect(DatabaseVersion version)

Method Details

getTemporalOperationSupport

@SPI({IMPLEMENT,SUPPLY})
public TemporalOperationSupport getTemporalOperationSupport()

Description copied from class: Dialect

Supply extraction and timestamp-arithmetic syntax. Return one stable, non-null, thread-safe implementation. Providers may implement TemporalOperationSupport directly and return this.

Overrides:

getTemporalOperationSupport in class PostgreSQLDialect

See Also:

• TemporalOperationSupport

getCurrentTemporalSupport

@SPI({IMPLEMENT,SUPPLY})
public CurrentTemporalSupport getCurrentTemporalSupport()

Description copied from class: Dialect

Supply current temporal expressions and database-side timestamp retrieval. Return one stable, non-null, thread-safe implementation. Providers may implement CurrentTemporalSupport directly and return this.

Overrides:

getCurrentTemporalSupport in class PostgreSQLDialect

See Also:

• CurrentTemporalSupport

initializeFunctionRegistry

@SPI({IMPLEMENT,SUPPLY})
public void initializeFunctionRegistry(FunctionContributions functionContributions)

Description copied from class: Dialect

Contribute the database-specific function descriptors after independent function contributors have run.

Override this callback to extend or replace the inherited function set. Invoke super first to retain Hibernate's standard and emulated registrations; omitting it deliberately replaces that set. Mutate the supplied boot-scoped function registry only during this callback, and do not retain the contribution context or registry afterward. Implement an independent FunctionContributor instead when the contribution is not owned by a Dialect.

Overrides:

initializeFunctionRegistry in class PostgreSQLDialect

Parameters:

functionContributions - the Hibernate-supplied function contribution target

See Also:

• FunctionContributions
• FunctionContributor
• SqmFunctionRegistry
• SqmFunctionDescriptor
• CommonFunctionFactory

castPattern

@SPI({USE,IMPLEMENT})
public String castPattern(CastType from,
 CastType to)

Description copied from class: Dialect

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

Overrides:

castPattern in class PostgreSQLDialect

Parameters:

from - a CastType indicating the type of the value argument

to - a CastType indicating the type the value argument is cast to

currentTimestamp

@SPI({USE,IMPLEMENT})
public String currentTimestamp()

Description copied from interface: CurrentTemporalSupport

Render the current SQL timestamp expression used for java.sql.Timestamp.

Specified by:

currentTimestamp in interface CurrentTemporalSupport

Overrides:

currentTimestamp in class PostgreSQLDialect

timestampdiffPattern

@SPI({USE,IMPLEMENT})
public String timestampdiffPattern(TemporalUnit unit,
 TemporalType fromTemporalType,
 TemporalType toTemporalType)

Description copied from interface: TemporalOperationSupport

Return a timestamp-difference pattern containing ?1, ?2, and ?3.

Specified by:

timestampdiffPattern in interface TemporalOperationSupport

Overrides:

timestampdiffPattern in class PostgreSQLDialect

getStringValueSemantics

@SPI({IMPLEMENT,SUPPLY})
public StringValueSemantics getStringValueSemantics()

Description copied from class: Dialect

Supply the database's stable string-value semantics.

Overrides:

getStringValueSemantics in class Dialect

Returns:

the non-null string-value profile

See Also:

• StringValueSemantics

getRefCursorSupportFactory

@SPI({IMPLEMENT,SUPPLY})
public RefCursorSupportFactory getRefCursorSupportFactory()

Description copied from class: Dialect

Supply the stable factory which creates this Dialect's JDBC REF_CURSOR registration and extraction service.

Return one non-null factory whose identity and selection behavior remain stable for this Dialect's lifetime. This factory controls JDBC cursor access; Dialect.getCallableStatementSupport() independently controls whether and how the callable SQL protocol admits a REF_CURSOR parameter.

Overrides:

getRefCursorSupportFactory in class PostgreSQLDialect

Returns:

the REF_CURSOR JDBC access factory

See Also:

• RefCursorSupportFactory

getSqlAstTranslatorFactory

@SPI({IMPLEMENT,SUPPLY})
public SqlAstTranslatorFactory getSqlAstTranslatorFactory()

Description copied from class: Dialect

Supply the factory for this Dialect's single-use SQL AST translators.

Return null to use StandardSqlAstTranslatorFactory. A custom Dialect should normally return a reusable factory derived from that class and create translators derived from AbstractSqlAstTranslator or an appropriate supported family base. The factory must not retain translation requests, and every translator it returns is used for one translation.

Overrides:

getSqlAstTranslatorFactory in class PostgreSQLDialect

See Also:

• SqlAstTranslatorFactory
• JdbcEnvironment.getSqlAstTranslatorFactory()