org.jpox.store.rdbms.adapter
Interface SpatialRDBMSAdapter

All Superinterfaces:

org.jpox.store.mapped.DatastoreAdapter, org.jpox.store.mapped.expression.ExpressionConversionAdapter, org.jpox.store.mapped.expression.ExpressionLogicSetAdapter, org.jpox.store.mapped.expression.ExpressionMethodAdapter, org.jpox.store.mapped.expression.ExpressionOperatorAdapter, org.jpox.store.mapped.expression.ExpressionPatternAdapter, org.jpox.store.mapped.expression.ExpressionSupportedFeaturesAdapter, org.jpox.store.rdbms.adapter.RDBMSAdapter

All Known Implementing Classes:

MySQLSpatialAdapter, OracleSpatialAdapter, PostGISAdapter

public interface SpatialRDBMSAdapter
extends org.jpox.store.rdbms.adapter.RDBMSAdapter

Adapter for spatially enabled databases.

Version:

$Revision: 1.1 $

Field Summary

static java.lang.String	DIMENSION_EXTENSION_KEY Key name for the dimension extension.
static java.lang.String	SRID_EXTENSION_KEY Key name for the srid extension.

Method Summary

java.lang.String	getCalculateBoundsStatement(org.jpox.store.rdbms.table.Table table, org.jpox.store.rdbms.Column column) Returns the appropriate SQL statement that calculates the bounds of all geometries in the given column.
java.lang.String	getRetrieveCrsNameStatement(org.jpox.store.rdbms.table.Table table, int srid) Returns the appropriate SQL statement to retrieve the name of the Coordinate Reference System (CRS) with the given srid.
java.lang.String	getRetrieveCrsWktStatement(org.jpox.store.rdbms.table.Table table, int srid) Returns the appropriate SQL statement to retrieve description of the Coordinate Reference System (CRS) with the given srid.
boolean	isGeometryColumn(org.jpox.store.rdbms.Column column) Checks whether the given column is geometry backed by the datastore.

Methods inherited from interface org.jpox.store.rdbms.adapter.RDBMSAdapter

closeConnection, createIndexesBeforeForeignKeys, getAddCandidateKeyStatement, getAddColumnStatement, getAddForeignKeyStatement, getAddPrimaryKeyStatement, getAutoIncrementKeyword, getAutoIncrementStmt, getCatalogName, getCatalogSeparator, getCharColumnsPaddedWithSpaces, getCheckConstraintForValues, getColumns, getColumns, getConnection, getCreateIndexStatement, getCreateTableStatement, getDatastoreDateStatement, getDropTableStatement, getDropViewStatement, getExistingIndexes, getIdentifierQuoteString, getInsertStatementForNoColumns, getMaxColumnNameLength, getMaxConstraintNameLength, getMaxForeignKeys, getMaxIndexes, getMaxIndexNameLength, getMaxTableNameLength, getNonAnsiInnerJoinWhereClause, getNonAnsiLeftOuterJoinWhereClause, getPlaceWithOptionAfterFromClause, getPlaceWithOptionWithinJoinClauses, getRangeByLimitSelectClause, getRangeByLimitWhereClause, getRangeByRowNumberColumn, getRequiredTransactionIsolationLevel, getSchemaName, getSelectNewUUIDStmt, getSelectWithLockOption, getSequenceCreateStmt, getSequenceNextStmt, getSupportsPersistOfUnassignedChar, getSurrogateForEmptyStrings, getTables, getTransactionIsolationForSchemaCreation, getTypeInfo, getUnlimitedLengthPrecisionValue, includeOrderByColumnsInSelect, isNullEqualsEmptyStrings, isSQLKeyword, isValidPrimaryKeyType, iteratorReservedWords, iteratorTypeInfo, logConfiguration, newColumnInfo, newForeignKeyInfo, newTableExpression, requiresColumnDefaultsInitialising, supportsAlterTableDropConstraint, supportsAlterTableDropForeignKeyConstraint, supportsAnalysisMethods, supportsAnsiJoinSyntax, supportsAutoIncrementColumnTypeSpecification, supportsAutoIncrementKeysNullSpecification, supportsCatalogsInTableDefinitions, supportsCheckInCreateStatements, supportsDefaultBeforeNullInColumnOptions, supportsDefaultKeywordInColumnOptions, supportsDefaultKeywordWithNotNullInColumnOptions, supportsDeferredConstraints, supportsDistinctWithSelectForUpdate, supportsExistsSyntax, supportsForeignKeyDeleteAction, supportsForeignKeyUpdateAction, supportsLockWithSelectForUpdate, supportsNullsInCandidateKeys, supportsNullsKeywordInColumnOptions, supportsPrimaryKeyInCreateStatements, supportsSchemasInTableDefinitions, supportsSequences, supportsSettingBlobUsingSetString, supportsSettingClobUsingSetString, supportsStatementBatching, supportsStatementGetGeneratedKeys, supportsTransactionIsolationLevel, supportsUnionSyntax, supportsUniqueConstraintsInEndCreateStatements, useUnionAll

Methods inherited from interface org.jpox.store.mapped.DatastoreAdapter

getAdapterTime, getDatastoreMajorVersion, getDatastoreMinorVersion, getMapping, getMapping, getMapping, getMapping, getMappingManager, getVendorID, initialiseDatastore, isBitReallyBoolean, isIdentityFieldDataType, isReservedKeyword, isStoresLowerCaseIdentifiers, isStoresLowerCaseQuotedIdentifiers, isStoresMixedCaseIdentifiers, isStoresMixedCaseQuotedIdentifiers, isStoresUpperCaseIdentifiers, isStoresUpperCaseQuotedIdentifiers, loadDatastoreMapping, modOperator, newQueryStatement, newQueryStatement, supportsIdentityFields, supportsProjectionInTableReferenceJoins, supportsQueryFetchSize, toString

Methods inherited from interface org.jpox.store.mapped.expression.ExpressionConversionAdapter

toNumericExpression, toStringExpression, toStringExpression

Methods inherited from interface org.jpox.store.mapped.expression.ExpressionOperatorAdapter

concatOperator, getOperatorConcat

Methods inherited from interface org.jpox.store.mapped.expression.ExpressionMethodAdapter

absMethod, acosMethod, asinMethod, atanMethod, ceilMethod, cosMethod, endsWithMethod, expMethod, floorMethod, getCurrentDateMethod, getCurrentTimeMethod, getCurrentTimestampMethod, getDayMethod, getHourMethod, getMinuteMethod, getMonthMethod, getSecondMethod, getYearMethod, indexOfMethod, lengthMethod, logMethod, matchesMethod, sinMethod, sqrtMethod, startsWithMethod, substringMethod, substringMethod, tanMethod, translateMethod, trimMethod

Methods inherited from interface org.jpox.store.mapped.expression.ExpressionSupportedFeaturesAdapter

supportsBooleanComparison, supportsEscapeExpressionInLikePredicate

Methods inherited from interface org.jpox.store.mapped.expression.ExpressionPatternAdapter

getEscapeCharacter, getEscapedPatternExpression, getEscapePatternExpression, getPatternExpressionAnyCharacter, getPatternExpressionZeroMoreCharacters

Methods inherited from interface org.jpox.store.mapped.expression.ExpressionLogicSetAdapter

cartersianProduct

Field Detail

SRID_EXTENSION_KEY

static final java.lang.String SRID_EXTENSION_KEY

Key name for the srid extension.

See Also:

Constant Field Values

DIMENSION_EXTENSION_KEY

static final java.lang.String DIMENSION_EXTENSION_KEY

Key name for the dimension extension.

See Also:

Constant Field Values

Method Detail

isGeometryColumn

boolean isGeometryColumn(org.jpox.store.rdbms.Column column)

Checks whether the given column is geometry backed by the datastore.

Parameters:

column - Column to check

Returns:

true if the given column is geometry backed, false otherwise

getRetrieveCrsWktStatement

java.lang.String getRetrieveCrsWktStatement(org.jpox.store.rdbms.table.Table table,
                                            int srid)

Returns the appropriate SQL statement to retrieve description of the Coordinate Reference System (CRS) with the given srid.

Parameters:

table - A table

srid - The srid

Returns:

SQL statement, null if not available for the datastore

getRetrieveCrsNameStatement

java.lang.String getRetrieveCrsNameStatement(org.jpox.store.rdbms.table.Table table,
                                             int srid)

Returns the appropriate SQL statement to retrieve the name of the Coordinate Reference System (CRS) with the given srid.

Parameters:

table - A table

srid - The srid

Returns:

SQL statement, null if not available for the datastore

getCalculateBoundsStatement

java.lang.String getCalculateBoundsStatement(org.jpox.store.rdbms.table.Table table,
                                             org.jpox.store.rdbms.Column column)

Returns the appropriate SQL statement that calculates the bounds of all geometries in the given column.

Parameters:

table - The table

column - The column

Returns:

SQL statement, null if not available for the datastore