Class OracleSpatialSDO10gDialect
- java.lang.Object
-
- org.hibernate.dialect.Dialect
-
- org.hibernate.dialect.Oracle8iDialect
-
- org.hibernate.dialect.Oracle9iDialect
-
- org.hibernate.dialect.Oracle10gDialect
-
- org.hibernate.spatial.dialect.oracle.OracleSpatialSDO10gDialect
-
- All Implemented Interfaces:
java.io.Serializable
,ConversionContext
,SpatialDialect
public class OracleSpatialSDO10gDialect extends Oracle10gDialect implements SpatialDialect, java.io.Serializable
A Spatial Dialect for Oracle 10g/11g that uses the "native" SDO spatial operators.Created by Karel Maesen, Geovise BVBA on 11/02/17.
- See Also:
- Serialized Form
-
-
Field Summary
-
Fields inherited from class org.hibernate.dialect.Dialect
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
-
-
Constructor Summary
Constructors Constructor Description OracleSpatialSDO10gDialect()
Constructs the dialect
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description void
contributeTypes(TypeContributions typeContributions, ServiceRegistry serviceRegistry)
Allows the Dialect to contribute additional typesjava.lang.String
getDWithinSQL(java.lang.String columnName)
Returns The SQL fragment when parsing aDWithinExpression
.java.lang.String
getHavingSridSQL(java.lang.String columnName)
Returns the SQL fragment when parsing aHavingSridExpression
.java.lang.String
getIsEmptySQL(java.lang.String columnName, boolean isEmpty)
Returns the SQL fragment when parsing aIsEmptyExpression
orIsNotEmpty
expression.java.lang.String
getSpatialAggregateSQL(java.lang.String columnName, int aggregation)
Returns the SQL fragment for the specfied Spatial aggregate expression.java.lang.String
getSpatialFilterExpression(java.lang.String columnName)
Returns the SQL fragment for the SQL WHERE-expression when parsingorg.hibernate.spatial.criterion.SpatialFilterExpression
s into prepared statements.java.lang.String
getSpatialRelateSQL(java.lang.String columnName, int spatialRelation)
Returns the SQL fragment for the SQL WHERE-clause when parsingorg.hibernatespatial.criterion.SpatialRelateExpression
s into prepared statements.boolean
supports(SpatialFunction function)
Does this dialect supports the specifiedSpatialFunction
.boolean
supportsFiltering()
Returns true if thisSpatialDialect
supports a specific filtering function.-
Methods inherited from class org.hibernate.dialect.Oracle10gDialect
createOuterJoinFragment, getCrossJoinSeparator, getForUpdateSkipLockedString, getForUpdateSkipLockedString, getResultSet, getResultSet, getWriteLockString, getWriteLockString, registerResultSetOutParameter, supportsSkipLocked
-
Methods inherited from class org.hibernate.dialect.Oracle9iDialect
createCaseFragment, getCurrentTimestampSelectString, getCurrentTimestampSQLFunctionName, getForUpdateString, getLimitHandler, getLimitString, getReadLockString, getSelectClauseNullString, registerCharacterTypeMappings, registerDateTimeTypeMappings, supportsRowValueConstructorSyntaxInInList, supportsTupleDistinctCounts
-
Methods inherited from class org.hibernate.dialect.Oracle8iDialect
bindLimitParametersInReverseOrder, buildSQLExceptionConversionDelegate, canCreateSchema, dropConstraints, forceLobAsLastValue, forUpdateOfColumns, getAddColumnString, getBasicSelectClauseNullString, getCallableStatementSupport, getCascadeConstraintsString, getCreateSequenceString, getCreateSequenceString, getCurrentSchemaCommand, getDefaultMultiTableBulkIdStrategy, getDropSequenceString, getForUpdateNowaitString, getForUpdateNowaitString, getForUpdateString, getInExpressionCountLimit, getMaxAliasLength, getNotExpression, getQueryHintString, getQuerySequencesString, getResultSet, getSelectGUIDString, getSelectSequenceNextValString, getSequenceNextValString, getSqlTypeDescriptorOverride, getViolatedConstraintNameExtracter, isCurrentTimestampSelectStringCallable, registerDefaultProperties, registerFunctions, registerLargeObjectTypeMappings, registerNumericTypeMappings, registerResultSetOutParameter, registerReverseHibernateTypeMappings, statementType, supportsCommentOn, supportsCurrentTimestampSelection, supportsEmptyInList, supportsExistsInSelect, supportsLimit, supportsNoWait, supportsPartitionBy, supportsPooledSequences, supportsSequences, supportsUnionAll, useFollowOnLocking, useMaxForLimit
-
Methods inherited from class org.hibernate.dialect.Dialect
addSqlHintOrComment, appendLockHint, appendLockHint, applyLocksToSql, areStringComparisonsCaseInsensitive, augmentRecognizedTableTypes, bindLimitParametersFirst, buildIdentifierHelper, buildSQLExceptionConverter, canCreateCatalog, cast, cast, cast, closeQuote, convertToFirstRowValue, defaultScrollMode, doesReadCommittedCauseWritersToBlockReaders, doesRepeatableReadCauseReadersToBlockWriters, escapeComment, escapeLiteral, forceLimitUsage, getAddColumnSuffixString, getAddForeignKeyConstraintString, getAddForeignKeyConstraintString, getAddPrimaryKeyConstraintString, getAddUniqueConstraintString, getAlterTableString, getAuxiliaryDatabaseObjectExporter, getCaseInsensitiveLike, getCastTypeName, getColumnAliasExtractor, getColumnComment, getCreateCatalogCommand, getCreateMultisetTableString, getCreateSchemaCommand, getCreateSequenceStrings, getCreateSequenceStrings, getCreateTableString, getDefaultBatchLoadSizingStrategy, getDefaultProperties, getDialect, getDialect, getDropCatalogCommand, getDropForeignKeyString, getDropSchemaCommand, getDropSequenceStrings, getDropTableString, getForeignKeyExporter, getForUpdateString, getForUpdateString, getForUpdateString, getFunctions, getHibernateTypeName, getHibernateTypeName, getIdentityColumnSupport, getIndexExporter, getKeywords, getLimitString, getLobMergeStrategy, getLockingStrategy, getLowercaseFunction, getNameQualifierSupport, getNativeIdentifierGeneratorClass, getNativeIdentifierGeneratorStrategy, getNoColumnsInsertString, getNullColumnString, getQueryHintString, getReadLockString, getSchemaNameResolver, getSequenceExporter, getSequenceInformationExtractor, getTableComment, getTableExporter, getTableTypeString, getTypeName, getTypeName, getUniqueDelegate, getUniqueKeyExporter, hasAlterTable, hasSelfReferentialForeignKeyBug, inlineLiteral, isJdbcLogWarningsEnabledByDefault, isLegacyLimitHandlerBehaviorEnabled, isLockTimeoutParameterized, isTypeNameRegistered, openQuote, prependComment, qualifyIndexName, quote, registerColumnType, registerColumnType, registerFunction, registerHibernateType, registerHibernateType, registerKeyword, remapSqlTypeDescriptor, renderOrderByElement, replaceResultVariableInOrderByClauseWithPosition, requiresCastingOfParametersInSelectClause, requiresParensForTupleDistinctCounts, supportsBindAsCallableArgument, supportsCascadeDelete, supportsCaseInsensitiveLike, supportsCircularCascadeDeleteConstraints, supportsColumnCheck, supportsExpectedLobUsagePattern, supportsIfExistsAfterAlterTable, supportsIfExistsAfterConstraintName, supportsIfExistsAfterTableName, supportsIfExistsBeforeConstraintName, supportsIfExistsBeforeTableName, supportsLimitOffset, supportsLobValueChangePropogation, supportsLockTimeouts, supportsNamedParameters, supportsNationalizedTypes, supportsNonQueryWithCTE, supportsNotNullUnique, supportsOuterJoinForUpdate, supportsParametersInInsertSelect, supportsResultSetPositionQueryMethodsOnForwardOnlyCursor, supportsRowValueConstructorSyntax, supportsSubqueryOnMutatingTable, supportsSubselectAsInPredicateLHS, supportsTableCheck, supportsTupleCounts, supportsTuplesInSubqueries, supportsUnboundedLobLocatorMaterialization, supportsUnique, supportsUniqueConstraintInCreateAlterTable, supportsValuesList, supportsVariableLimit, toBooleanValueString, toString, transformSelectString, useFollowOnLocking, useInputStreamToInsertBlob
-
-
-
-
Method Detail
-
contributeTypes
public void contributeTypes(TypeContributions typeContributions, ServiceRegistry serviceRegistry)
Description copied from class:Dialect
Allows the Dialect to contribute additional types- Overrides:
contributeTypes
in classDialect
- Parameters:
typeContributions
- Callback to contribute the typesserviceRegistry
- The service registry
-
getSpatialFilterExpression
public java.lang.String getSpatialFilterExpression(java.lang.String columnName)
Description copied from interface:SpatialDialect
Returns the SQL fragment for the SQL WHERE-expression when parsingorg.hibernate.spatial.criterion.SpatialFilterExpression
s into prepared statements.- Specified by:
getSpatialFilterExpression
in interfaceSpatialDialect
- Parameters:
columnName
- The name of the geometry-typed column to which the filter is be applied- Returns:
- Rhe SQL fragment for the
SpatialFilterExpression
-
getSpatialRelateSQL
public java.lang.String getSpatialRelateSQL(java.lang.String columnName, int spatialRelation)
Description copied from interface:SpatialDialect
Returns the SQL fragment for the SQL WHERE-clause when parsingorg.hibernatespatial.criterion.SpatialRelateExpression
s into prepared statements.- Specified by:
getSpatialRelateSQL
in interfaceSpatialDialect
- Parameters:
columnName
- The name of the geometry-typed column to which the relation is appliedspatialRelation
- The type of spatial relation (as defined inSpatialRelation
).- Returns:
- SQL fragment
SpatialRelateExpression
-
getSpatialAggregateSQL
public java.lang.String getSpatialAggregateSQL(java.lang.String columnName, int aggregation)
Description copied from interface:SpatialDialect
Returns the SQL fragment for the specfied Spatial aggregate expression.- Specified by:
getSpatialAggregateSQL
in interfaceSpatialDialect
- Parameters:
columnName
- The name of the Geometry propertyaggregation
- The type ofSpatialAggregate
- Returns:
- The SQL fragment for the projection
-
getDWithinSQL
public java.lang.String getDWithinSQL(java.lang.String columnName)
Description copied from interface:SpatialDialect
Returns The SQL fragment when parsing aDWithinExpression
.- Specified by:
getDWithinSQL
in interfaceSpatialDialect
- Parameters:
columnName
- The geometry column to test against- Returns:
- The SQL fragment when parsing a
DWithinExpression
.
-
getHavingSridSQL
public java.lang.String getHavingSridSQL(java.lang.String columnName)
Description copied from interface:SpatialDialect
Returns the SQL fragment when parsing aHavingSridExpression
.- Specified by:
getHavingSridSQL
in interfaceSpatialDialect
- Parameters:
columnName
- The geometry column to test against- Returns:
- The SQL fragment for a
HavingSridExpression
.
-
getIsEmptySQL
public java.lang.String getIsEmptySQL(java.lang.String columnName, boolean isEmpty)
Description copied from interface:SpatialDialect
Returns the SQL fragment when parsing aIsEmptyExpression
orIsNotEmpty
expression.- Specified by:
getIsEmptySQL
in interfaceSpatialDialect
- Parameters:
columnName
- The geometry columnisEmpty
- Whether the geometry is tested for empty or non-empty- Returns:
- The SQL fragment for the isempty function
-
supportsFiltering
public boolean supportsFiltering()
Description copied from interface:SpatialDialect
Returns true if thisSpatialDialect
supports a specific filtering function.This is intended to signal DB-support for fast window queries, or MBR-overlap queries.
- Specified by:
supportsFiltering
in interfaceSpatialDialect
- Returns:
- True if filtering is supported
-
supports
public boolean supports(SpatialFunction function)
Description copied from interface:SpatialDialect
Does this dialect supports the specifiedSpatialFunction
.- Specified by:
supports
in interfaceSpatialDialect
- Parameters:
function
-SpatialFunction
- Returns:
- True if this
SpatialDialect
supports the spatial function specified by the function parameter.
-
-