Class SqlServer2008SpatialDialect
- java.lang.Object
-
- org.hibernate.dialect.Dialect
-
- org.hibernate.dialect.SQLServerDialect
-
- org.hibernate.dialect.SQLServer2005Dialect
-
- org.hibernate.dialect.SQLServer2008Dialect
-
- org.hibernate.spatial.dialect.sqlserver.SqlServer2008SpatialDialect
-
- All Implemented Interfaces:
Serializable
,org.hibernate.exception.spi.ConversionContext
,SpatialDialect
public class SqlServer2008SpatialDialect extends org.hibernate.dialect.SQLServer2008Dialect implements SpatialDialect
TheSpatialDialect
for Microsoft SQL Server (2008).- See Also:
- Serialized Form
-
-
Field Summary
Fields Modifier and Type Field Description static String
SHORT_NAME
The short name for this dialect
-
Constructor Summary
Constructors Constructor Description SqlServer2008SpatialDialect()
Constructs an instance
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description String
applyLocksToSql(String arg0, org.hibernate.LockOptions arg1, Map<String,String[]> arg2)
void
contributeTypes(org.hibernate.boot.model.TypeContributions typeContributions, org.hibernate.service.ServiceRegistry serviceRegistry)
String
getAddColumnString()
org.hibernate.hql.spi.id.MultiTableBulkIdStrategy
getDefaultMultiTableBulkIdStrategy()
String
getDWithinSQL(String columnName)
Returns The SQL fragment when parsing aDWithinExpression
.String
getForUpdateString()
String
getHavingSridSQL(String columnName)
Returns the SQL fragment when parsing aHavingSridExpression
.String
getIsEmptySQL(String columnName, boolean isEmpty)
Returns the SQL fragment when parsing aIsEmptyExpression
orIsNotEmpty
expression.String
getNullColumnString()
ResultSet
getResultSet(CallableStatement arg0)
String
getSelectGUIDString()
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 parsingorg.hibernate.spatial.criterion.SpatialFilterExpression
s into prepared statements.String
getSpatialRelateSQL(String columnName, int spatialRelation)
Returns the SQL fragment for the SQL WHERE-clause when parsingorg.hibernatespatial.criterion.SpatialRelateExpression
s into prepared statements.boolean
isCurrentTimestampSelectStringCallable()
boolean
qualifyIndexName()
int
registerResultSetOutParameter(CallableStatement arg0, int arg1)
boolean
supports(SpatialFunction function)
Does this dialect supports the specifiedSpatialFunction
.boolean
supportsCurrentTimestampSelection()
boolean
supportsEmptyInList()
boolean
supportsExistsInSelect()
boolean
supportsFiltering()
Returns true if thisSpatialDialect
supports a specific filtering function.boolean
supportsPartitionBy()
boolean
supportsTupleDistinctCounts()
boolean
supportsTuplesInSubqueries()
boolean
supportsUnionAll()
-
Methods inherited from class org.hibernate.dialect.SQLServer2008Dialect
renderOrderByElement, supportsValuesList
-
Methods inherited from class org.hibernate.dialect.SQLServer2005Dialect
appendLockHint, buildSQLExceptionConversionDelegate, getDefaultLimitHandler, supportsNonQueryWithCTE, supportsNoWait, supportsSkipLocked
-
Methods inherited from class org.hibernate.dialect.SQLServerDialect
areStringComparisonsCaseInsensitive, closeQuote, doesReadCommittedCauseWritersToBlockReaders, doesRepeatableReadCauseReadersToBlockWriters, getCurrentSchemaCommand, getCurrentTimestampSelectString, getIdentityColumnSupport, getInExpressionCountLimit, getLimitHandler, getLimitString, getNoColumnsInsertString, getSqlTypeDescriptorOverride, openQuote, supportsCircularCascadeDeleteConstraints, supportsLimit, supportsLimitOffset, supportsLobValueChangePropogation, supportsResultSetPositionQueryMethodsOnForwardOnlyCursor, supportsVariableLimit, useMaxForLimit
-
Methods inherited from class org.hibernate.dialect.Dialect
addSqlHintOrComment, appendLockHint, augmentRecognizedTableTypes, bindLimitParametersFirst, bindLimitParametersInReverseOrder, buildIdentifierHelper, buildSQLExceptionConverter, canCreateCatalog, canCreateSchema, cast, cast, cast, convertToFirstRowValue, createCaseFragment, createOuterJoinFragment, defaultScrollMode, dropConstraints, escapeComment, escapeLiteral, forceLimitUsage, forceLobAsLastValue, forUpdateOfColumns, getAddColumnSuffixString, getAddForeignKeyConstraintString, getAddForeignKeyConstraintString, getAddPrimaryKeyConstraintString, getAddUniqueConstraintString, getAlterTableString, getAuxiliaryDatabaseObjectExporter, getCallableStatementSupport, getCascadeConstraintsString, getCaseInsensitiveLike, getCastTypeName, getColumnAliasExtractor, getColumnComment, getCreateCatalogCommand, getCreateMultisetTableString, getCreateSchemaCommand, getCreateSequenceString, getCreateSequenceString, getCreateSequenceStrings, getCreateSequenceStrings, getCreateTableString, getCrossJoinSeparator, getCurrentTimestampSQLFunctionName, getDefaultBatchLoadSizingStrategy, getDefaultProperties, getDialect, getDialect, getDropCatalogCommand, getDropForeignKeyString, getDropSchemaCommand, getDropSequenceString, getDropSequenceStrings, getDropTableString, getForeignKeyExporter, getForUpdateNowaitString, getForUpdateNowaitString, getForUpdateSkipLockedString, getForUpdateSkipLockedString, getForUpdateString, getForUpdateString, getForUpdateString, getForUpdateString, getFunctions, getHibernateTypeName, getHibernateTypeName, getIndexExporter, getKeywords, getLimitString, getLobMergeStrategy, getLockingStrategy, getLowercaseFunction, getMaxAliasLength, getNameQualifierSupport, getNativeIdentifierGeneratorClass, getNativeIdentifierGeneratorStrategy, getNotExpression, getQueryHintString, getQueryHintString, getQuerySequencesString, getReadLockString, getReadLockString, getResultSet, getResultSet, getSchemaNameResolver, getSelectClauseNullString, getSelectSequenceNextValString, getSequenceExporter, getSequenceInformationExtractor, getSequenceNextValString, getTableComment, getTableExporter, getTableTypeString, getTypeName, getTypeName, getUniqueDelegate, getUniqueKeyExporter, getViolatedConstraintNameExtracter, getWriteLockString, getWriteLockString, hasAlterTable, hasSelfReferentialForeignKeyBug, inlineLiteral, isJdbcLogWarningsEnabledByDefault, isLegacyLimitHandlerBehaviorEnabled, isLockTimeoutParameterized, isTypeNameRegistered, prependComment, quote, registerColumnType, registerColumnType, registerFunction, registerHibernateType, registerHibernateType, registerKeyword, registerResultSetOutParameter, remapSqlTypeDescriptor, replaceResultVariableInOrderByClauseWithPosition, requiresCastingOfParametersInSelectClause, requiresParensForTupleDistinctCounts, supportsBindAsCallableArgument, supportsCascadeDelete, supportsCaseInsensitiveLike, supportsColumnCheck, supportsCommentOn, supportsExpectedLobUsagePattern, supportsIfExistsAfterAlterTable, supportsIfExistsAfterConstraintName, supportsIfExistsAfterTableName, supportsIfExistsBeforeConstraintName, supportsIfExistsBeforeTableName, supportsLockTimeouts, supportsNamedParameters, supportsNationalizedTypes, supportsNotNullUnique, supportsOuterJoinForUpdate, supportsParametersInInsertSelect, supportsPooledSequences, supportsRowValueConstructorSyntax, supportsRowValueConstructorSyntaxInInList, supportsSequences, supportsSubqueryOnMutatingTable, supportsSubselectAsInPredicateLHS, supportsTableCheck, supportsTupleCounts, supportsUnboundedLobLocatorMaterialization, supportsUnique, supportsUniqueConstraintInCreateAlterTable, toBooleanValueString, toString, transformSelectString, useFollowOnLocking, useFollowOnLocking, useInputStreamToInsertBlob
-
-
-
-
Field Detail
-
SHORT_NAME
public static final String SHORT_NAME
The short name for this dialect- See Also:
- Constant Field Values
-
-
Method Detail
-
contributeTypes
public void contributeTypes(org.hibernate.boot.model.TypeContributions typeContributions, org.hibernate.service.ServiceRegistry serviceRegistry)
- Overrides:
contributeTypes
in classorg.hibernate.dialect.Dialect
-
getSpatialRelateSQL
public String getSpatialRelateSQL(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
-
getSpatialFilterExpression
public String getSpatialFilterExpression(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
-
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 interfaceSpatialDialect
- Parameters:
columnName
- The name of the Geometry propertyaggregation
- The type ofSpatialAggregate
- Returns:
- The SQL fragment for the projection
-
getDWithinSQL
public String getDWithinSQL(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 String getHavingSridSQL(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 String getIsEmptySQL(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.
-
getAddColumnString
public String getAddColumnString()
- Overrides:
getAddColumnString
in classorg.hibernate.dialect.Dialect
-
getNullColumnString
public String getNullColumnString()
- Overrides:
getNullColumnString
in classorg.hibernate.dialect.Dialect
-
qualifyIndexName
public boolean qualifyIndexName()
- Overrides:
qualifyIndexName
in classorg.hibernate.dialect.Dialect
-
getForUpdateString
public String getForUpdateString()
- Overrides:
getForUpdateString
in classorg.hibernate.dialect.Dialect
-
applyLocksToSql
public String applyLocksToSql(String arg0, org.hibernate.LockOptions arg1, Map<String,String[]> arg2)
- Overrides:
applyLocksToSql
in classorg.hibernate.dialect.Dialect
-
registerResultSetOutParameter
public int registerResultSetOutParameter(CallableStatement arg0, int arg1) throws SQLException
- Overrides:
registerResultSetOutParameter
in classorg.hibernate.dialect.Dialect
- Throws:
SQLException
-
getResultSet
public ResultSet getResultSet(CallableStatement arg0) throws SQLException
- Overrides:
getResultSet
in classorg.hibernate.dialect.Dialect
- Throws:
SQLException
-
supportsCurrentTimestampSelection
public boolean supportsCurrentTimestampSelection()
- Overrides:
supportsCurrentTimestampSelection
in classorg.hibernate.dialect.Dialect
-
isCurrentTimestampSelectStringCallable
public boolean isCurrentTimestampSelectStringCallable()
- Overrides:
isCurrentTimestampSelectStringCallable
in classorg.hibernate.dialect.Dialect
-
getDefaultMultiTableBulkIdStrategy
public org.hibernate.hql.spi.id.MultiTableBulkIdStrategy getDefaultMultiTableBulkIdStrategy()
- Overrides:
getDefaultMultiTableBulkIdStrategy
in classorg.hibernate.dialect.Dialect
-
getSelectGUIDString
public String getSelectGUIDString()
- Overrides:
getSelectGUIDString
in classorg.hibernate.dialect.Dialect
-
supportsEmptyInList
public boolean supportsEmptyInList()
- Overrides:
supportsEmptyInList
in classorg.hibernate.dialect.Dialect
-
supportsUnionAll
public boolean supportsUnionAll()
- Overrides:
supportsUnionAll
in classorg.hibernate.dialect.Dialect
-
supportsExistsInSelect
public boolean supportsExistsInSelect()
- Overrides:
supportsExistsInSelect
in classorg.hibernate.dialect.Dialect
-
supportsTupleDistinctCounts
public boolean supportsTupleDistinctCounts()
- Overrides:
supportsTupleDistinctCounts
in classorg.hibernate.dialect.Dialect
-
supportsTuplesInSubqueries
public boolean supportsTuplesInSubqueries()
- Overrides:
supportsTuplesInSubqueries
in classorg.hibernate.dialect.Dialect
-
supportsPartitionBy
public boolean supportsPartitionBy()
- Overrides:
supportsPartitionBy
in classorg.hibernate.dialect.Dialect
-
-