org.datanucleus.store.rdbms.adapter
Interface SpatialRDBMSAdapter

All Superinterfaces:
org.datanucleus.store.mapped.DatastoreAdapter, org.datanucleus.store.mapped.expression.ExpressionConversionAdapter, org.datanucleus.store.mapped.expression.ExpressionLogicSetAdapter, org.datanucleus.store.mapped.expression.ExpressionMethodAdapter, org.datanucleus.store.mapped.expression.ExpressionOperatorAdapter, org.datanucleus.store.mapped.expression.ExpressionPatternAdapter, org.datanucleus.store.rdbms.adapter.RDBMSAdapter
All Known Implementing Classes:
MySQLSpatialAdapter, OracleSpatialAdapter, PostGISAdapter

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

Adapter for spatially enabled databases.


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.
 
Fields inherited from interface org.datanucleus.store.rdbms.adapter.RDBMSAdapter
ACCESS_PARENTQUERY_IN_SUBQUERY, ALTER_TABLE_DROP_CONSTRAINT_SYNTAX, ALTER_TABLE_DROP_FOREIGN_KEY_CONSTRAINT, ANSI_JOIN_SYNTAX, AUTO_INCREMENT_COLUMN_TYPE_SPECIFICATION, AUTO_INCREMENT_KEYS_NULL_SPECIFICATION, BLOB_SET_USING_SETSTRING, CHAR_COLUMNS_PADDED_WITH_SPACES, CHECK_IN_CREATE_STATEMENTS, CHECK_IN_END_CREATE_STATEMENTS, CLOB_SET_USING_SETSTRING, CREATE_INDEXES_BEFORE_FOREIGN_KEYS, DATETIME_STORES_MILLISECS, DEFAULT_BEFORE_NULL_IN_COLUMN_OPTIONS, DEFAULT_KEYWORD_IN_COLUMN_OPTIONS, DEFAULT_KEYWORD_WITH_NOT_NULL_IN_COLUMN_OPTIONS, DEFERRED_CONSTRAINTS, DISTINCT_WITH_SELECT_FOR_UPDATE, EXISTS_SYNTAX, FK_DELETE_ACTION_CASCADE, FK_DELETE_ACTION_DEFAULT, FK_DELETE_ACTION_NULL, FK_DELETE_ACTION_RESTRICT, FK_UPDATE_ACTION_CASCADE, FK_UPDATE_ACTION_DEFAULT, FK_UPDATE_ACTION_NULL, FK_UPDATE_ACTION_RESTRICT, GET_GENERATED_KEYS_STATEMENT, INCLUDE_ORDERBY_COLS_IN_SELECT, LOCK_OPTION_PLACED_AFTER_FROM, LOCK_OPTION_PLACED_WITHIN_JOIN, LOCK_WITH_SELECT_FOR_UPDATE, NULL_EQUALS_EMPTY_STRING, NULLS_IN_CANDIDATE_KEYS, NULLS_KEYWORD_IN_COLUMN_OPTIONS, ORDERBY_USING_SELECT_COLUMN_INDEX, PERSIST_OF_UNASSIGNED_CHAR, PRIMARYKEY_IN_CREATE_STATEMENTS, STATEMENT_BATCHING, TX_ISOLATION_NONE, TX_ISOLATION_READ_COMMITTED, TX_ISOLATION_READ_UNCOMMITTED, TX_ISOLATION_REPEATABLE_READ, TX_ISOLATION_SERIALIZABLE, UNION_SYNTAX, UNIQUE_IN_END_CREATE_STATEMENTS, USE_UNION_ALL, VIEWS
 
Fields inherited from interface org.datanucleus.store.mapped.DatastoreAdapter
ANALYSIS_METHODS, BIT_IS_REALLY_BOOLEAN, BOOLEAN_COMPARISON, CATALOGS_IN_TABLE_DEFINITIONS, ESCAPE_EXPRESSION_IN_LIKE_PREDICATE, IDENTIFIERS_LOWERCASE, IDENTIFIERS_LOWERCASE_QUOTED, IDENTIFIERS_MIXEDCASE, IDENTIFIERS_MIXEDCASE_QUOTED, IDENTIFIERS_MIXEDCASE_QUOTED_SENSITIVE, IDENTIFIERS_MIXEDCASE_SENSITIVE, IDENTIFIERS_UPPERCASE, IDENTIFIERS_UPPERCASE_QUOTED, IDENTITY_COLUMNS, PROJECTION_IN_TABLE_REFERENCE_JOINS, SCHEMAS_IN_TABLE_DEFINITIONS, SEQUENCES
 
Method Summary
 java.lang.String getCalculateBoundsStatement(org.datanucleus.store.rdbms.table.Table table, org.datanucleus.store.rdbms.table.Column column)
          Returns the appropriate SQL statement that calculates the bounds of all geometries in the given column.
 java.lang.String getRetrieveCrsNameStatement(org.datanucleus.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.datanucleus.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.datanucleus.store.rdbms.table.Column column)
          Checks whether the given column is geometry backed by the datastore.
 
Methods inherited from interface org.datanucleus.store.rdbms.adapter.RDBMSAdapter
getAddCandidateKeyStatement, getAddColumnStatement, getAddForeignKeyStatement, getAddPrimaryKeyStatement, getAutoIncrementKeyword, getAutoIncrementStmt, getCatalogName, getCheckConstraintForValues, getColumns, getConnection, getCreateIndexStatement, getCreateTableStatement, getDatastoreDateStatement, getDropTableStatement, getDropViewStatement, getExistingIndexes, getInsertStatementForNoColumns, getNonAnsiInnerJoinWhereClause, getNonAnsiLeftOuterJoinWhereClause, getRangeByLimitSelectClause, getRangeByLimitWhereClause, getRangeByRowNumberColumn, getRequiredTransactionIsolationLevel, getSchemaName, getSelectNewUUIDStmt, getSelectWithLockOption, getSequenceCreateStmt, getSequenceNextStmt, getSurrogateForEmptyStrings, getTransactionIsolationForSchemaCreation, getUnlimitedLengthPrecisionValue, isValidPrimaryKeyType, iteratorReservedWords, logConfiguration, newFKInfo, newRDBMSColumnInfo, newSQLTypeInfo, newTableExpression, supportsTransactionIsolation
 
Methods inherited from interface org.datanucleus.store.mapped.DatastoreAdapter
getAdapterTime, getCatalogSeparator, getDatastoreIdentifierMaxLength, getDatastoreMajorVersion, getDatastoreMinorVersion, getIdentifierQuoteString, getMappingManager, getMaxForeignKeys, getMaxIndexes, getNumericExpressionForMethod, getSupportedOptions, getVendorID, initialiseDatastore, initialiseTypes, isIdentityFieldDataType, isReservedKeyword, modOperator, newQueryStatement, removeUnsupportedMappings, setProperties, supportsOption, supportsQueryFetchSize, toString
 
Methods inherited from interface org.datanucleus.store.mapped.expression.ExpressionConversionAdapter
toNumericExpression, toStringExpression, toStringExpression
 
Methods inherited from interface org.datanucleus.store.mapped.expression.ExpressionOperatorAdapter
concatOperator, getOperatorConcat
 
Methods inherited from interface org.datanucleus.store.mapped.expression.ExpressionMethodAdapter
endsWithMethod, getCurrentDateMethod, getCurrentTimeMethod, getCurrentTimestampMethod, indexOfMethod, lowerMethod, matchesMethod, startsWithMethod, substringMethod, substringMethod, translateMethod, trimMethod, upperMethod
 
Methods inherited from interface org.datanucleus.store.mapped.expression.ExpressionPatternAdapter
getEscapeCharacter, getEscapedPatternExpression, getEscapePatternExpression, getPatternExpressionAnyCharacter, getPatternExpressionZeroMoreCharacters
 
Methods inherited from interface org.datanucleus.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.datanucleus.store.rdbms.table.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.datanucleus.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.datanucleus.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.datanucleus.store.rdbms.table.Table table,
                                             org.datanucleus.store.rdbms.table.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


Copyright © 2009. All Rights Reserved.