org.hibernate.spatial.dialect.mysql

Class MySQL56SpatialDialect

java.lang.Object

org.hibernate.dialect.Dialect

org.hibernate.dialect.MySQLDialect

org.hibernate.dialect.MySQL5Dialect

org.hibernate.spatial.dialect.mysql.MySQL56SpatialDialect

All Implemented Interfaces:

Serializable, ConversionContext, SpatialDialect

Direct Known Subclasses:

MySQL56InnoDBSpatialDialect

public class MySQL56SpatialDialect
extends MySQL5Dialect
implements SpatialDialect

Extends the MySQL5Dialect by including support for the spatial operators. This SpatialDialect uses the ST_* spatial operators that operate on exact geometries which have been added in MySQL version 5.6.1. Previous versions of MySQL only supported operators that operated on Minimum Bounding Rectangles (MBR's). This dialect my therefore produce different results than the other MySQL spatial dialects.

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, STREAM_XFER_LOB_MERGE_STRATEGY

Constructor Summary

Constructors

Constructor and Description
MySQL56SpatialDialect() Constructs the dialect

Method Summary

Modifier and Type	Method and Description
void	contributeTypes(TypeContributions typeContributions, ServiceRegistry serviceRegistry) Allows the Dialect to contribute additional types
String	getDWithinSQL(String columnName) Returns The SQL fragment when parsing a DWithinExpression.
String	getHavingSridSQL(String columnName) Returns the SQL fragment when parsing an HavingSridExpression.
String	getIsEmptySQL(String columnName, boolean isEmpty) Returns the SQL fragment when parsing a IsEmptyExpression or IsNotEmpty 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 org.hibernate.spatial.criterion.SpatialFilterExpressions into prepared statements.
String	getSpatialRelateSQL(String columnName, int spatialRelation) Returns the SQL fragment for the SQL WHERE-clause when parsing org.hibernatespatial.criterion.SpatialRelateExpressions into prepared statements.
String	getTypeName(int code, long length, int precision, int scale) Get the name of the database type associated with the given Types typecode with the given storage specification parameters.
SqlTypeDescriptor	remapSqlTypeDescriptor(SqlTypeDescriptor sqlTypeDescriptor) Allows the dialect to override a SqlTypeDescriptor.
boolean	supports(SpatialFunction function) Does this dialect supports the specified SpatialFunction.
boolean	supportsFiltering() Returns true if this SpatialDialect supports a specific filtering function.

Methods inherited from class org.hibernate.dialect.MySQL5Dialect

getViolatedConstraintNameExtracter, registerVarcharTypes, supportsColumnCheck

Methods inherited from class org.hibernate.dialect.MySQLDialect

areStringComparisonsCaseInsensitive, buildSQLExceptionConversionDelegate, canCreateCatalog, canCreateSchema, closeQuote, fixedPointNumberCastTarget, floatingPointNumberCastTarget, getAddColumnString, getAddForeignKeyConstraintString, getCastTypeName, getColumnComment, getCreateCatalogCommand, getCreateSchemaCommand, getCurrentTimestampSelectString, getDefaultMultiTableBulkIdStrategy, getDropCatalogCommand, getDropForeignKeyString, getDropSchemaCommand, getForUpdateString, getIdentityColumnString, getIdentitySelectString, getLimitHandler, getLimitString, getNotExpression, getReadLockString, getResultSet, getSelectGUIDString, getTableComment, getWriteLockString, isCurrentTimestampSelectStringCallable, openQuote, qualifyIndexName, registerResultSetOutParameter, renderOrderByElement, smallIntegerCastTarget, supportsCascadeDelete, supportsCurrentTimestampSelection, supportsEmptyInList, supportsIdentityColumns, supportsIfExistsBeforeTableName, supportsLimit, supportsLobValueChangePropogation, supportsLockTimeouts, supportsRowValueConstructorSyntax, supportsSubqueryOnMutatingTable

Methods inherited from class org.hibernate.dialect.Dialect

appendIdentitySelectToInsert, appendLockHint, appendLockHint, applyLocksToSql, bindLimitParametersFirst, bindLimitParametersInReverseOrder, buildIdentifierHelper, buildSQLExceptionConverter, cast, cast, cast, convertToFirstRowValue, createCaseFragment, createOuterJoinFragment, defaultScrollMode, doesReadCommittedCauseWritersToBlockReaders, doesRepeatableReadCauseReadersToBlockWriters, dropConstraints, forceLimitUsage, forceLobAsLastValue, forUpdateOfColumns, getAddColumnSuffixString, getAddPrimaryKeyConstraintString, getAddUniqueConstraintString, getAuxiliaryDatabaseObjectExporter, getCallableStatementSupport, getCascadeConstraintsString, getCaseInsensitiveLike, getColumnAliasExtractor, getCreateMultisetTableString, getCreateSequenceString, getCreateSequenceString, getCreateSequenceStrings, getCreateSequenceStrings, getCreateTableString, getCrossJoinSeparator, getCurrentSchemaCommand, getCurrentTimestampSQLFunctionName, getDefaultProperties, getDialect, getDialect, getDropSequenceString, getDropSequenceStrings, getDropTableString, getForeignKeyExporter, getForUpdateNowaitString, getForUpdateNowaitString, getForUpdateSkipLockedString, getForUpdateSkipLockedString, getForUpdateString, getForUpdateString, getForUpdateString, getForUpdateString, getFunctions, getHibernateTypeName, getHibernateTypeName, getIdentityColumnString, getIdentityColumnSupport, getIdentityInsertString, getIdentitySelectString, getIndexExporter, getInExpressionCountLimit, getKeywords, getLimitString, getLobMergeStrategy, getLockingStrategy, getLowercaseFunction, getMaxAliasLength, getNameQualifierSupport, getNativeIdentifierGeneratorClass, getNativeIdentifierGeneratorStrategy, getNoColumnsInsertString, getNullColumnString, getQueryHintString, getQuerySequencesString, getResultSet, getResultSet, getSchemaNameResolver, getSelectClauseNullString, getSelectSequenceNextValString, getSequenceExporter, getSequenceInformationExtractor, getSequenceNextValString, getSqlTypeDescriptorOverride, getTableExporter, getTableTypeString, getTypeName, getUniqueDelegate, getUniqueKeyExporter, hasAlterTable, hasDataTypeInIdentityColumn, hasSelfReferentialForeignKeyBug, isLockTimeoutParameterized, quote, registerColumnType, registerColumnType, registerFunction, registerHibernateType, registerHibernateType, registerKeyword, registerResultSetOutParameter, replaceResultVariableInOrderByClauseWithPosition, requiresCastingOfParametersInSelectClause, requiresParensForTupleDistinctCounts, supportsBindAsCallableArgument, supportsCaseInsensitiveLike, supportsCircularCascadeDeleteConstraints, supportsCommentOn, supportsExistsInSelect, supportsExpectedLobUsagePattern, supportsIfExistsAfterConstraintName, supportsIfExistsAfterTableName, supportsIfExistsBeforeConstraintName, supportsInsertSelectIdentity, supportsLimitOffset, supportsNamedParameters, supportsNotNullUnique, supportsOuterJoinForUpdate, supportsParametersInInsertSelect, supportsPooledSequences, supportsResultSetPositionQueryMethodsOnForwardOnlyCursor, supportsRowValueConstructorSyntaxInInList, supportsSequences, supportsSubselectAsInPredicateLHS, supportsTableCheck, supportsTupleCounts, supportsTupleDistinctCounts, supportsTuplesInSubqueries, supportsUnboundedLobLocatorMaterialization, supportsUnionAll, supportsUnique, supportsUniqueConstraintInCreateAlterTable, supportsVariableLimit, toBooleanValueString, toString, transformSelectString, useFollowOnLocking, useInputStreamToInsertBlob, useMaxForLimit

Methods inherited from class java.lang.Object

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

Constructor Detail

MySQL56SpatialDialect

public MySQL56SpatialDialect()

Constructs the dialect

Method Detail

remapSqlTypeDescriptor

public SqlTypeDescriptor remapSqlTypeDescriptor(SqlTypeDescriptor sqlTypeDescriptor)

Description copied from class: Dialect

Allows the dialect to override a SqlTypeDescriptor.

If the passed sqlTypeDescriptor allows itself to be remapped (per SqlTypeDescriptor.canBeRemapped()), then this method uses Dialect.getSqlTypeDescriptorOverride(int) to get an optional override based on the SQL code returned by SqlTypeDescriptor.getSqlType().

If this dialect does not provide an override or if the sqlTypeDescriptor doe not allow itself to be remapped, then this method simply returns the original passed sqlTypeDescriptor

Overrides:

remapSqlTypeDescriptor in class Dialect

Parameters:

sqlTypeDescriptor - The SqlTypeDescriptor to override

Returns:

The SqlTypeDescriptor that should be used for this dialect; if there is no override, then original sqlTypeDescriptor is returned.

See Also:

Dialect.getSqlTypeDescriptorOverride(int)

getTypeName

public String getTypeName(int code,
                          long length,
                          int precision,
                          int scale)
                   throws HibernateException

Description copied from class: Dialect

Get the name of the database type associated with the given Types typecode with the given storage specification parameters.

Overrides:

getTypeName in class Dialect

Parameters:

code - The Types typecode

length - The datatype length

precision - The datatype precision

scale - The datatype scale

Returns:

the database type name

Throws:

HibernateException - If no mapping was specified for that type.

contributeTypes

public void contributeTypes(TypeContributions typeContributions,
                            ServiceRegistry serviceRegistry)

Allows the Dialect to contribute additional types

Overrides:

contributeTypes in class Dialect

Parameters:

typeContributions - Callback to contribute the types

serviceRegistry - The service registry

getSpatialRelateSQL

public String getSpatialRelateSQL(String columnName,
                                  int spatialRelation)

Description copied from interface: SpatialDialect

Returns the SQL fragment for the SQL WHERE-clause when parsing org.hibernatespatial.criterion.SpatialRelateExpressions into prepared statements.

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 SpatialRelation).

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 parsing org.hibernate.spatial.criterion.SpatialFilterExpressions 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

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 SpatialAggregate

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 DWithinExpression.

Specified by:

getDWithinSQL in interface SpatialDialect

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 an HavingSridExpression.

Specified by:

getHavingSridSQL in interface SpatialDialect

Parameters:

columnName - The geometry column to test against

Returns:

The SQL fragment for an HavingSridExpression.

getIsEmptySQL

public String getIsEmptySQL(String columnName,
                            boolean isEmpty)

Description copied from interface: SpatialDialect

Returns the SQL fragment when parsing a IsEmptyExpression or IsNotEmpty 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 SpatialDialect supports a specific filtering function.

This is intended to signal DB-support for fast window queries, or MBR-overlap queries.

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 SpatialFunction.

Specified by:

supports in interface SpatialDialect

Parameters:

function - SpatialFunction

Returns:

True if this SpatialDialect supports the spatial function specified by the function parameter.