Package org.hibernate.community.dialect

Class PostgresPlusLegacyDialect

java.lang.Object

org.hibernate.dialect.Dialect

org.hibernate.community.dialect.PostgreSQLLegacyDialect

org.hibernate.community.dialect.PostgresPlusLegacyDialect

All Implemented Interfaces:

org.hibernate.boot.model.FunctionContributor, org.hibernate.boot.model.TypeContributor, org.hibernate.exception.spi.ConversionContext

public class PostgresPlusLegacyDialect
extends PostgreSQLLegacyDialect

An SQL dialect for Postgres Plus

Nested Class Summary

Nested classes/interfaces inherited from class org.hibernate.dialect.Dialect

org.hibernate.dialect.Dialect.SizeStrategy, org.hibernate.dialect.Dialect.SizeStrategyImpl

Field Summary

Fields inherited from class org.hibernate.community.dialect.PostgreSQLLegacyDialect

driverKind

Fields inherited from class org.hibernate.dialect.Dialect

CLOSED_QUOTE, LEGACY_LOB_MERGE_STRATEGY, LOG_BASE2OF10, NEW_LOCATOR_LOB_MERGE_STRATEGY, QUOTE, STANDARD_MULTI_KEY_LOAD_SIZING_STRATEGY, STREAM_XFER_LOB_MERGE_STRATEGY

Constructor Summary

Constructors

Constructor	Description
PostgresPlusLegacyDialect()	Constructs a PostgresPlusDialect
PostgresPlusLegacyDialect(org.hibernate.dialect.DatabaseVersion version)
PostgresPlusLegacyDialect(org.hibernate.engine.jdbc.dialect.spi.DialectResolutionInfo info)

Method Summary

Modifier and Type	Method	Description
String	castPattern(org.hibernate.query.sqm.CastType from, org.hibernate.query.sqm.CastType to)
String	currentTimestamp()
ResultSet	getResultSet(CallableStatement ps)
String	getSelectGUIDString()
org.hibernate.sql.ast.SqlAstTranslatorFactory	getSqlAstTranslatorFactory()
void	initializeFunctionRegistry(org.hibernate.boot.model.FunctionContributions functionContributions)
int	registerResultSetOutParameter(CallableStatement statement, int col)
String	timestampdiffPattern(org.hibernate.query.sqm.TemporalUnit unit, TemporalType fromTemporalType, TemporalType toTemporalType)

Methods inherited from class org.hibernate.community.dialect.PostgreSQLLegacyDialect

addSqlHintOrComment, appendBinaryLiteral, appendBooleanValueString, appendDatetimeFormat, appendDateTimeLiteral, appendDateTimeLiteral, appendDateTimeLiteral, augmentRecognizedTableTypes, buildIdentifierHelper, buildSQLExceptionConversionDelegate, canBatchTruncate, castType, columnType, contributePostgreSQLTypes, contributeTypes, currentTime, currentTimestampWithTimeZone, datetimeFormat, extractField, extractPattern, getAggregateSupport, getCallableStatementSupport, getCascadeConstraintsString, getCaseInsensitiveLike, getCurrentSchemaCommand, getCurrentTimestampSelectString, getDefaultIntervalSecondScale, getDefaultNonContextualLobCreation, getDefaultStatementBatchSize, getDmlTargetColumnQualifierSupport, getFallbackSqmInsertStrategy, getFallbackSqmMutationStrategy, getForUpdateNowaitString, getForUpdateNowaitString, getForUpdateSkipLockedString, getForUpdateSkipLockedString, getForUpdateString, getForUpdateString, getFractionalSecondPrecisionInNanos, getFunctionalDependencyAnalysisSupport, getGroupBySelectItemReferenceStrategy, getIdentityColumnSupport, getLimitHandler, getMaxIdentifierLength, getMaxVarbinaryLength, getMaxVarcharCapacity, getMaxVarcharLength, getNameQualifierSupport, getNationalizationSupport, getNativeIdentifierGeneratorStrategy, getNoColumnsInsertString, getQueryHintString, getQuerySequencesString, getReadLockString, getReadLockString, getResultSet, getResultSet, getSelectClauseNullString, getSequenceSupport, getTimeZoneSupport, getUniqueDelegate, getViolatedConstraintNameExtractor, getWriteLockString, getWriteLockString, getWriteRowLockStrategy, isCurrentTimestampSelectStringCallable, qualifyIndexName, registerColumnTypes, requiresParensForTupleDistinctCounts, resolveSqlTypeCode, resolveSqlTypeDescriptor, rowId, rowIdSqlType, supportsCaseInsensitiveLike, supportsCommentOn, supportsConflictClauseForInsertCTE, supportsCurrentTimestampSelection, supportsDistinctFromPredicate, supportsFetchClause, supportsFromClauseInUpdate, supportsIfExistsAfterAlterTable, supportsIfExistsBeforeConstraintName, supportsIfExistsBeforeTableName, supportsIfExistsBeforeTypeName, supportsJdbcConnectionLobCreation, supportsLateral, supportsLobValueChangePropagation, supportsMaterializedLobAccess, supportsMinMaxOnUuid, supportsNonQueryWithCTE, supportsNoWait, supportsOffsetInSubquery, supportsOuterJoinForUpdate, supportsPartitionBy, supportsRecursiveCTE, supportsSkipLocked, supportsStandardArrays, supportsTemporalLiteralOffset, supportsTupleCounts, supportsUnboundedLobLocatorMaterialization, supportsValuesList, supportsWait, supportsWindowFunctions, timestampaddPattern, translateExtractField, useInputStreamToInsertBlob

Methods inherited from class org.hibernate.dialect.Dialect

appendArrayLiteral, appendIntervalLiteral, appendLiteral, appendLockHint, appendUUIDLiteral, applyLocksToSql, augmentPhysicalTableTypes, canCreateCatalog, canCreateSchema, canDisableConstraints, checkVersion, closeQuote, contribute, contributeFunctions, createOptionalTableUpdateOperation, currentDate, currentLocalTime, currentLocalTimestamp, defaultScrollMode, doesReadCommittedCauseWritersToBlockReaders, doesRepeatableReadCauseReadersToBlockWriters, doesRoundTemporalOnOverflow, dropConstraints, equivalentTypes, escapeComment, forceLobAsLastValue, generatedAs, getAddColumnString, getAddColumnSuffixString, getAddForeignKeyConstraintString, getAddForeignKeyConstraintString, getAddPrimaryKeyConstraintString, getAlterColumnTypeString, getAlterTableString, getArrayTypeName, getAuxiliaryDatabaseObjectExporter, getBatchLoadSizingStrategy, getCheckCondition, getCheckCondition, getCheckCondition, getCheckCondition, getCheckCondition, getColumnAliasExtractor, getColumnComment, getCreateCatalogCommand, getCreateEnumTypeCommand, getCreateEnumTypeCommand, getCreateIndexString, getCreateIndexTail, getCreateMultisetTableString, getCreateSchemaCommand, getCreateTableString, getCreateTemporaryTableColumnAnnotation, getCreateUserDefinedTypeExtensionsString, getCreateUserDefinedTypeKindString, getDefaultDecimalPrecision, getDefaultLobLength, getDefaultProperties, getDefaultTimestampPrecision, getDefaultUseGetGeneratedKeys, getDisableConstraintsStatement, getDisableConstraintStatement, getDoublePrecision, getDropCatalogCommand, getDropEnumTypeCommand, getDropEnumTypeCommand, getDropForeignKeyString, getDropSchemaCommand, getDropTableString, getDropUniqueKeyString, getEnableConstraintsStatement, getEnableConstraintStatement, getEnumTypeDeclaration, getEnumTypeDeclaration, getFallbackSchemaManagementTool, getFloatPrecision, getForeignKeyExporter, getForUpdateString, getForUpdateString, getForUpdateString, getHqlTranslator, getIndexExporter, getInExpressionCountLimit, getKeywords, getLobMergeStrategy, getLockingStrategy, getLockRowIdentifier, getLowercaseFunction, getMaxAliasLength, getMaxNVarcharCapacity, getMaxNVarcharLength, getMaxVarbinaryCapacity, getMinimumSupportedVersion, getMultiKeyLoadSizingStrategy, getNativeParameterMarkerStrategy, getNullColumnString, getNullColumnString, getNullOrdering, getParameterCountLimit, getPreferredSqlTypeCodeForArray, getPreferredSqlTypeCodeForBoolean, getQueryHintString, getReadRowLockStrategy, getRowIdColumnString, getSchemaNameResolver, getSequenceExporter, getSequenceInformationExtractor, getSizeStrategy, getSqmTranslatorFactory, getSupportedTemporaryTableKind, getTableCleaner, getTableComment, getTableExporter, getTableMigrator, getTableTypeString, getTemporaryTableAfterUseAction, getTemporaryTableBeforeUseAction, getTemporaryTableCreateCommand, getTemporaryTableCreateOptions, getTemporaryTableDdlTransactionHandling, getTemporaryTableDropCommand, getTemporaryTableExporter, getTemporaryTableTruncateCommand, getTimeoutInSeconds, getTruncateTableStatement, getTruncateTableStatements, getUniqueKeyExporter, getUserDefinedTypeComment, getUserDefinedTypeExporter, getVersion, hasAlterTable, hasDataTypeBeforeGeneratedAs, hasSelfReferentialForeignKeyBug, initDefaultProperties, inlineLiteral, isAnsiNullOn, isEmptyStringTreatedAsNull, isJdbcLogWarningsEnabledByDefault, isLob, isLockTimeoutParameterized, openQuote, ordinal, prependComment, quote, quoteCollation, registerDefaultKeywords, registerKeyword, registerKeywords, registerResultSetOutParameter, requiresCastForConcatenatingNonStrings, requiresFloatCastingOfIntegerDivision, requiresParensForTupleCounts, resolveSqlTypeCode, resolveSqlTypeLength, supportsAlterColumnType, supportsBatchUpdates, supportsBindAsCallableArgument, supportsBitType, supportsCascadeDelete, supportsCircularCascadeDeleteConstraints, supportsColumnCheck, supportsExistsInSelect, supportsExpectedLobUsagePattern, supportsFractionalTimestampArithmetic, supportsIfExistsAfterConstraintName, supportsIfExistsAfterTableName, supportsIfExistsAfterTypeName, supportsInsertReturning, supportsInsertReturningGeneratedKeys, supportsInsertReturningRowId, supportsIsTrue, supportsLockTimeouts, supportsNamedParameters, supportsNoColumnsInsert, supportsNullPrecedence, supportsOrderByInSubquery, supportsOrdinalSelectItemReference, supportsParametersInInsertSelect, supportsPredicateAsExpression, supportsRefCursors, supportsResultSetPositionQueryMethodsOnForwardOnlyCursor, supportsStandardCurrentTimestampFunction, supportsSubqueryInSelect, supportsSubqueryOnMutatingTable, supportsSubselectAsInPredicateLHS, supportsTableCheck, supportsTemporaryTablePrimaryKey, supportsTemporaryTables, supportsTruncateWithCast, supportsTupleDistinctCounts, supportsUnionAll, supportsUnionInSubquery, supportsUpdateReturning, supportsValuesListForInsert, toBooleanValueString, toQuotedIdentifier, toString, transformSelectString, translateDurationField, trimPattern, trimPattern, unquoteGetGeneratedKeys, useArrayForMultiValuedParameters, useFollowOnLocking, useMaterializedLobWhenCapacityExceeded

Methods inherited from class java.lang.Object

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

Constructor Details

PostgresPlusLegacyDialect

public PostgresPlusLegacyDialect()

Constructs a PostgresPlusDialect

PostgresPlusLegacyDialect

public PostgresPlusLegacyDialect(org.hibernate.engine.jdbc.dialect.spi.DialectResolutionInfo info)

PostgresPlusLegacyDialect

public PostgresPlusLegacyDialect(org.hibernate.dialect.DatabaseVersion version)

Method Details

initializeFunctionRegistry

public void initializeFunctionRegistry(org.hibernate.boot.model.FunctionContributions functionContributions)

Overrides:

initializeFunctionRegistry in class PostgreSQLLegacyDialect

castPattern

public String castPattern(org.hibernate.query.sqm.CastType from,
 org.hibernate.query.sqm.CastType to)

Overrides:

castPattern in class org.hibernate.dialect.Dialect

currentTimestamp

public String currentTimestamp()

Overrides:

currentTimestamp in class PostgreSQLLegacyDialect

timestampdiffPattern

public String timestampdiffPattern(org.hibernate.query.sqm.TemporalUnit unit,
 TemporalType fromTemporalType,
 TemporalType toTemporalType)

Overrides:

timestampdiffPattern in class PostgreSQLLegacyDialect

registerResultSetOutParameter

public int registerResultSetOutParameter(CallableStatement statement,
 int col)
                                  throws SQLException

Overrides:

registerResultSetOutParameter in class PostgreSQLLegacyDialect

Throws:

SQLException

getResultSet

public ResultSet getResultSet(CallableStatement ps)
                       throws SQLException

Overrides:

getResultSet in class PostgreSQLLegacyDialect

Throws:

SQLException

getSelectGUIDString

public String getSelectGUIDString()

Overrides:

getSelectGUIDString in class org.hibernate.dialect.Dialect

getSqlAstTranslatorFactory

public org.hibernate.sql.ast.SqlAstTranslatorFactory getSqlAstTranslatorFactory()

Overrides:

getSqlAstTranslatorFactory in class PostgreSQLLegacyDialect