public class PostgisPG10Dialect extends PostgreSQL10Dialect
| Modifier and Type | Field and Description |
|---|---|
static PostgisSupport |
support |
CLOSED_QUOTE, DEFAULT_BATCH_SIZE, LEGACY_LOB_MERGE_STRATEGY, NEW_LOCATOR_LOB_MERGE_STRATEGY, NO_BATCH, QUOTE, STANDARD_DEFAULT_BATCH_LOAD_SIZING_STRATEGY, STREAM_XFER_LOB_MERGE_STRATEGY, TWO_SINGLE_QUOTES_REPLACEMENT| Constructor and Description |
|---|
PostgisPG10Dialect() |
| Modifier and Type | Method and Description |
|---|---|
void |
contributeTypes(TypeContributions typeContributions,
ServiceRegistry serviceRegistry)
Allows the Dialect to contribute additional types
|
boolean |
equivalentTypes(int typeCode1,
int typeCode2)
Do the given JDBC type codes, as defined in
Types represent
essentially the same type in this dialect of SQL? The default
implementation treats NUMERIC and
DECIMAL as the same type, and
FLOAT, REAL, and
DOUBLE as essentially the same type, since the
ANSI SQL specification fails to meaningfully distinguish them. |
default SpatialFunctionsRegistry |
functionsToRegister() |
default String |
getDWithinSQL(String columnName)
Returns The SQL fragment when parsing a
DWithinExpression. |
default String |
getHavingSridSQL(String columnName)
Returns the SQL fragment when parsing a
HavingSridExpression. |
default String |
getIsEmptySQL(String columnName,
boolean isEmpty)
Returns the SQL fragment when parsing a
IsEmptyExpression or
IsNotEmpty expression. |
default String |
getSpatialAggregateSQL(String columnName,
int aggregation)
Returns the SQL fragment for the specfied Spatial aggregate expression.
|
default String |
getSpatialFilterExpression(String columnName)
Returns the SQL fragment for the SQL WHERE-expression when parsing
org.hibernate.spatial.criterion.SpatialFilterExpressions
into prepared statements. |
default String |
getSpatialRelateSQL(String columnName,
int spatialRelation)
Returns the SQL fragment for the SQL WHERE-clause when parsing
org.hibernatespatial.criterion.SpatialRelateExpressions
into prepared statements. |
default boolean |
isSpatial(int typeCode)
Checks whether the typeCode is (potentially) the code for a spatial type
|
default boolean |
supports(SpatialFunction function)
Does this dialect supports the specified
SpatialFunction. |
default boolean |
supportsFiltering()
Returns true if this
SpatialDialect supports a specific filtering function. |
augmentRecognizedTableTypes, getIdentityColumnSupportgetForUpdateSkipLockedString, getForUpdateSkipLockedString, getReadLockString, getReadLockString, getWriteLockString, getWriteLockString, supportsSkipLockedsupportsIfExistsAfterAlterTablesupportsNonQueryWithCTE, supportsPartitionBysupportsIfExistsBeforeConstraintNamegetDefaultMultiTableBulkIdStrategy, getDropSequenceString, supportsIfExistsBeforeTableName, supportsRowValueConstructorSyntaxInInList, supportsValuesListbindLimitParametersInReverseOrder, buildIdentifierHelper, buildSQLExceptionConversionDelegate, dropConstraints, getAddColumnString, getCallableStatementSupport, getCascadeConstraintsString, getCaseInsensitiveLike, getCreateSequenceString, getCreateSequenceString, getCurrentTimestampSelectString, getForUpdateNowaitString, getForUpdateNowaitString, getForUpdateString, getForUpdateString, getForUpdateString, getLimitHandler, getLimitString, getNativeIdentifierGeneratorStrategy, getNoColumnsInsertString, getQuerySequencesString, getResultSet, getResultSet, getResultSet, getSelectClauseNullString, getSelectSequenceNextValString, getSequenceNextValString, getSqlTypeDescriptorOverride, getViolatedConstraintNameExtracter, isCurrentTimestampSelectStringCallable, qualifyIndexName, registerResultSetOutParameter, requiresParensForTupleDistinctCounts, supportsCaseInsensitiveLike, supportsCommentOn, supportsCurrentTimestampSelection, supportsEmptyInList, supportsExpectedLobUsagePattern, supportsJdbcConnectionLobCreation, supportsLimit, supportsLobValueChangePropogation, supportsNationalizedTypes, supportsNoWait, supportsOuterJoinForUpdate, supportsPooledSequences, supportsRowValueConstructorSyntax, supportsSelectAliasInGroupByClause, supportsSequences, supportsUnboundedLobLocatorMaterialization, supportsUnionAll, toBooleanValueString, useInputStreamToInsertBlobaddSqlHintOrComment, appendLockHint, appendLockHint, applyLocksToSql, areStringComparisonsCaseInsensitive, bindLimitParametersFirst, buildSQLExceptionConverter, canCreateCatalog, canCreateSchema, cast, cast, cast, closeQuote, convertToFirstRowValue, createCaseFragment, createOuterJoinFragment, defaultScrollMode, doesReadCommittedCauseWritersToBlockReaders, doesRepeatableReadCauseReadersToBlockWriters, escapeComment, escapeLiteral, forceLimitUsage, forceLobAsLastValue, forUpdateOfColumns, getAddColumnSuffixString, getAddForeignKeyConstraintString, getAddForeignKeyConstraintString, getAddPrimaryKeyConstraintString, getAddUniqueConstraintString, getAlterTableString, getAuxiliaryDatabaseObjectExporter, getCastTypeName, getColumnAliasExtractor, getColumnComment, getCreateCatalogCommand, getCreateMultisetTableString, getCreateSchemaCommand, getCreateSequenceStrings, getCreateSequenceStrings, getCreateTableString, getCreateTemporaryTableColumnAnnotation, getCrossJoinSeparator, getCurrentSchemaCommand, getCurrentTimestampSQLFunctionName, getDefaultBatchLoadSizingStrategy, getDefaultProperties, getDialect, getDialect, getDropCatalogCommand, getDropForeignKeyString, getDropSchemaCommand, getDropSequenceStrings, getDropTableString, getForeignKeyExporter, getForUpdateString, getForUpdateString, getFunctions, getHibernateTypeName, getHibernateTypeName, getIndexExporter, getInExpressionCountLimit, getKeywords, getLimitString, getLobMergeStrategy, getLockingStrategy, getLowercaseFunction, getMaxAliasLength, getNameQualifierSupport, getNativeIdentifierGeneratorClass, getNotExpression, getNullColumnString, getQueryHintString, getQueryHintString, getSchemaNameResolver, getSelectGUIDString, getSequenceExporter, getSequenceInformationExtractor, getTableComment, getTableExporter, getTableTypeString, getTypeName, getTypeName, getUniqueDelegate, getUniqueKeyExporter, hasAlterTable, hasSelfReferentialForeignKeyBug, inlineLiteral, isJdbcLogWarningsEnabledByDefault, isLegacyLimitHandlerBehaviorEnabled, isLockTimeoutParameterized, isTypeNameRegistered, openQuote, prependComment, quote, registerColumnType, registerColumnType, registerFunction, registerHibernateType, registerHibernateType, registerKeyword, registerResultSetOutParameter, remapSqlTypeDescriptor, renderOrderByElement, replaceResultVariableInOrderByClauseWithPosition, requiresCastingOfParametersInSelectClause, supportsBindAsCallableArgument, supportsCascadeDelete, supportsCircularCascadeDeleteConstraints, supportsColumnCheck, supportsExistsInSelect, supportsIfExistsAfterConstraintName, supportsIfExistsAfterTableName, supportsLimitOffset, supportsLockTimeouts, supportsNamedParameters, supportsNoColumnsInsert, supportsNotNullUnique, supportsParametersInInsertSelect, supportsResultSetPositionQueryMethodsOnForwardOnlyCursor, supportsRowValueConstructorSyntaxInSet, supportsSubqueryOnMutatingTable, supportsSubselectAsInPredicateLHS, supportsTableCheck, supportsTupleCounts, supportsTupleDistinctCounts, supportsTuplesInSubqueries, supportsUnique, supportsUniqueConstraintInCreateAlterTable, supportsVariableLimit, toString, transformSelectString, useFollowOnLocking, useFollowOnLocking, useMaxForLimitpublic static final PostgisSupport support
public void contributeTypes(TypeContributions typeContributions, ServiceRegistry serviceRegistry)
DialectcontributeTypes in class PostgreSQL82DialecttypeContributions - Callback to contribute the typesserviceRegistry - The service registrypublic boolean equivalentTypes(int typeCode1,
int typeCode2)
DialectTypes represent
essentially the same type in this dialect of SQL? The default
implementation treats NUMERIC and
DECIMAL as the same type, and
FLOAT, REAL, and
DOUBLE as essentially the same type, since the
ANSI SQL specification fails to meaningfully distinguish them.equivalentTypes in class DialecttypeCode1 - the first JDBC type codetypeCode2 - the second JDBC type codetrue if the two type codes are equivalentpublic SpatialFunctionsRegistry functionsToRegister()
public String getSpatialRelateSQL(String columnName, int spatialRelation)
org.hibernatespatial.criterion.SpatialRelateExpressions
into prepared statements.
getSpatialRelateSQL in interface SpatialDialectcolumnName - The name of the geometry-typed column to which the relation is
appliedspatialRelation - The type of spatial relation (as defined in
SpatialRelation).SpatialRelateExpressionpublic String getSpatialFilterExpression(String columnName)
org.hibernate.spatial.criterion.SpatialFilterExpressions
into prepared statements.getSpatialFilterExpression in interface SpatialDialectcolumnName - The name of the geometry-typed column to which the filter is
be appliedSpatialFilterExpressionpublic String getSpatialAggregateSQL(String columnName, int aggregation)
getSpatialAggregateSQL in interface SpatialDialectcolumnName - The name of the Geometry propertyaggregation - The type of SpatialAggregatepublic String getDWithinSQL(String columnName)
DWithinExpression.getDWithinSQL in interface SpatialDialectcolumnName - The geometry column to test againstDWithinExpression.public String getHavingSridSQL(String columnName)
HavingSridExpression.getHavingSridSQL in interface SpatialDialectcolumnName - The geometry column to test againstHavingSridExpression.public String getIsEmptySQL(String columnName, boolean isEmpty)
IsEmptyExpression or
IsNotEmpty expression.getIsEmptySQL in interface SpatialDialectcolumnName - The geometry columnisEmpty - Whether the geometry is tested for empty or non-emptypublic boolean supportsFiltering()
SpatialDialect supports a specific filtering function.
This is intended to signal DB-support for fast window queries, or MBR-overlap queries.
supportsFiltering in interface SpatialDialectpublic boolean supports(SpatialFunction function)
SpatialFunction.supports in interface SpatialDialectfunction - SpatialFunctionSpatialDialect supports the spatial function specified by the function parameter.public boolean isSpatial(int typeCode)
typeCode - the JDBC type codeCopyright © 2001-2021 Red Hat, Inc. All Rights Reserved.