org.hibernate.spatial.dialect.oracle

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:

Serializable, org.hibernate.exception.spi.ConversionContext, SpatialDialect

public class OracleSpatialSDO10gDialect
extends org.hibernate.dialect.Oracle10gDialect
implements SpatialDialect, Serializable

A Spatial Dialect for Oracle 10g/11g that uses the "native" SDO spatial operators. <p> 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 and Description
OracleSpatialSDO10gDialect() Constructs the dialect

Method Summary

Modifier and Type	Method and Description
void	contributeTypes(org.hibernate.boot.model.TypeContributions typeContributions, org.hibernate.service.ServiceRegistry serviceRegistry)
String	getDWithinSQL(String columnName) Returns The SQL fragment when parsing a <code>DWithinExpression</code>.
String	getHavingSridSQL(String columnName) Returns the SQL fragment when parsing a <code>HavingSridExpression</code>.
String	getIsEmptySQL(String columnName, boolean isEmpty) Returns the SQL fragment when parsing a <code>IsEmptyExpression</code> or <code>IsNotEmpty</code> expression.
String	getSpatialAggregateSQL(String columnName, int aggregation) Returns the SQL fragment for the specfied Spatial aggregate expression.
String	getSpatialFilterExpression(String columnName) Returns the SQL fragment for the SQL WHERE-expression when parsing <code>org.hibernate.spatial.criterion.SpatialFilterExpression</code>s into prepared statements.
String	getSpatialRelateSQL(String columnName, int spatialRelation) Returns the SQL fragment for the SQL WHERE-clause when parsing <code>org.hibernatespatial.criterion.SpatialRelateExpression</code>s into prepared statements.
boolean	supports(SpatialFunction function) Does this dialect supports the specified <code>SpatialFunction</code>.
boolean	supportsFiltering() Returns true if this <code>SpatialDialect</code> 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, 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, 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

Methods inherited from class java.lang.Object

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

Constructor Detail

OracleSpatialSDO10gDialect

public OracleSpatialSDO10gDialect()

Constructs the dialect

Method Detail

contributeTypes

public void contributeTypes(org.hibernate.boot.model.TypeContributions typeContributions,
                            org.hibernate.service.ServiceRegistry serviceRegistry)

Overrides:

contributeTypes in class org.hibernate.dialect.Dialect

getSpatialFilterExpression

public String getSpatialFilterExpression(String columnName)

Description copied from interface: SpatialDialect

Returns the SQL fragment for the SQL WHERE-expression when parsing <code>org.hibernate.spatial.criterion.SpatialFilterExpression</code>s into prepared statements.

Specified by:

getSpatialFilterExpression in interface SpatialDialect

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 String getSpatialRelateSQL(String columnName,
                                  int spatialRelation)

Description copied from interface: SpatialDialect

Returns the SQL fragment for the SQL WHERE-clause when parsing <code>org.hibernatespatial.criterion.SpatialRelateExpression</code>s into prepared statements. <p/>

Specified by:

getSpatialRelateSQL in interface SpatialDialect

Parameters:

columnName - The name of the geometry-typed column to which the relation is applied

spatialRelation - The type of spatial relation (as defined in <code>SpatialRelation</code>).

Returns:

SQL fragment SpatialRelateExpression

getSpatialAggregateSQL

public String getSpatialAggregateSQL(String columnName,
                                     int aggregation)

Description copied from interface: SpatialDialect

Returns the SQL fragment for the specfied Spatial aggregate expression.

Specified by:

getSpatialAggregateSQL in interface SpatialDialect

Parameters:

columnName - The name of the Geometry property

aggregation - The type of <code>SpatialAggregate</code>

Returns:

The SQL fragment for the projection

getDWithinSQL

public String getDWithinSQL(String columnName)

Description copied from interface: SpatialDialect

Returns The SQL fragment when parsing a <code>DWithinExpression</code>.

Specified by:

getDWithinSQL in interface SpatialDialect

Parameters:

columnName - The geometry column to test against

Returns:

The SQL fragment when parsing a <code>DWithinExpression</code>.

getHavingSridSQL

public String getHavingSridSQL(String columnName)

Description copied from interface: SpatialDialect

Returns the SQL fragment when parsing a <code>HavingSridExpression</code>.

Specified by:

getHavingSridSQL in interface SpatialDialect

Parameters:

columnName - The geometry column to test against

Returns:

The SQL fragment for a <code>HavingSridExpression</code>.

getIsEmptySQL

public String getIsEmptySQL(String columnName,
                            boolean isEmpty)

Description copied from interface: SpatialDialect

Returns the SQL fragment when parsing a <code>IsEmptyExpression</code> or <code>IsNotEmpty</code> expression.

Specified by:

getIsEmptySQL in interface SpatialDialect

Parameters:

columnName - The geometry column

isEmpty - 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 this <code>SpatialDialect</code> supports a specific filtering function. <p> This is intended to signal DB-support for fast window queries, or MBR-overlap queries.</p>

Specified by:

supportsFiltering in interface SpatialDialect

Returns:

True if filtering is supported

supports

public boolean supports(SpatialFunction function)

Description copied from interface: SpatialDialect

Does this dialect supports the specified <code>SpatialFunction</code>.

Specified by:

supports in interface SpatialDialect

Parameters:

function - <code>SpatialFunction</code>

Returns:

True if this <code>SpatialDialect</code> supports the spatial function specified by the function parameter.