org.datanucleus.store.types.geospatial.rdbms.adapter

Interface SpatialRDBMSAdapter

All Superinterfaces:

org.datanucleus.store.rdbms.adapter.DatastoreAdapter

All Known Implementing Classes:

MySQLSpatialAdapter, OracleSpatialAdapter, PostGISAdapter

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

Adapter for spatially enabled databases.

Field Summary

Fields

Modifier and Type	Field and Description
static String	DIMENSION_EXTENSION_KEY Key name for the dimension extension.
static String	SRID_EXTENSION_KEY Key name for the srid extension.

Fields inherited from interface org.datanucleus.store.rdbms.adapter.DatastoreAdapter

ACCESS_PARENTQUERY_IN_SUBQUERY_JOINED, ALLOW_TABLE_ALIAS_IN_UPDATE_SET_CLAUSE, ALTER_TABLE_DROP_CONSTRAINT_SYNTAX, ALTER_TABLE_DROP_FOREIGN_KEY_CONSTRAINT, ANALYSIS_METHODS, ANSI_CROSSJOIN_SYNTAX, ANSI_JOIN_SYNTAX, AUTO_INCREMENT_COLUMN_TYPE_SPECIFICATION, AUTO_INCREMENT_KEYS_NULL_SPECIFICATION, AUTO_INCREMENT_PK_IN_CREATE_TABLE_COLUMN_DEF, BIT_IS_REALLY_BOOLEAN, BLOB_SET_USING_SETSTRING, BOOLEAN_COMPARISON, CATALOGS_IN_TABLE_DEFINITIONS, CHAR_COLUMNS_PADDED_WITH_SPACES, CHECK_IN_CREATE_STATEMENTS, CHECK_IN_END_CREATE_STATEMENTS, CLOB_SET_USING_SETSTRING, CREATE_INDEXES_BEFORE_FOREIGN_KEYS, CROSSJOIN_ASINNER11_SYNTAX, 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, ESCAPE_EXPRESSION_IN_LIKE_PREDICATE, EXISTS_SYNTAX, FK_DELETE_ACTION_CASCADE, FK_DELETE_ACTION_DEFAULT, FK_DELETE_ACTION_NULL, FK_DELETE_ACTION_RESTRICT, FK_IN_END_CREATE_STATEMENTS, FK_UPDATE_ACTION_CASCADE, FK_UPDATE_ACTION_DEFAULT, FK_UPDATE_ACTION_NULL, FK_UPDATE_ACTION_RESTRICT, GET_GENERATED_KEYS_STATEMENT, HOLD_CURSORS_OVER_COMMIT, IDENTIFIERS_LOWERCASE, IDENTIFIERS_LOWERCASE_QUOTED, IDENTIFIERS_MIXEDCASE, IDENTIFIERS_MIXEDCASE_QUOTED, IDENTIFIERS_MIXEDCASE_QUOTED_SENSITIVE, IDENTIFIERS_MIXEDCASE_SENSITIVE, IDENTIFIERS_UPPERCASE, IDENTIFIERS_UPPERCASE_QUOTED, IDENTITY_COLUMNS, 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_NULLS_DIRECTIVES, ORDERBY_USING_SELECT_COLUMN_INDEX, PERSIST_OF_UNASSIGNED_CHAR, PRIMARYKEY_IN_CREATE_STATEMENTS, PROJECTION_IN_TABLE_REFERENCE_JOINS, RESULTSET_TYPE_FORWARD_ONLY, RESULTSET_TYPE_SCROLL_INSENSITIVE, RESULTSET_TYPE_SCROLL_SENSITIVE, SCHEMAS_IN_TABLE_DEFINITIONS, SEQUENCES, STATEMENT_BATCHING, STORED_PROCEDURES, 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

Method Summary

Modifier and Type	Method and Description
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.
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.
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.DatastoreAdapter

getAdapterTime, getAddCandidateKeyStatement, getAddColumnStatement, getAddForeignKeyStatement, getAddPrimaryKeyStatement, getAutoIncrementJavaTypeForType, getAutoIncrementKeyword, getAutoIncrementStmt, getCatalogName, getCatalogSeparator, getCheckConstraintForValues, getColumns, getCreateDatabaseStatement, getCreateIndexStatement, getCreateTableStatement, getDatastoreDateStatement, getDatastoreDriverName, getDatastoreDriverVersion, getDatastoreIdentifierMaxLength, getDatastoreProductName, getDatastoreProductVersion, getDeleteTableStatement, getDriverMajorVersion, getDriverMinorVersion, getDropDatabaseStatement, getDropTableStatement, getDropViewStatement, getEscapeCharacter, getEscapePatternExpression, getExistingIndexes, getIdentifierQuoteString, getInsertStatementForNoColumns, getJDBCTypeForName, getMappingManager, getMaxForeignKeys, getMaxIndexes, getNameForJDBCType, getNumericConversionFunction, getOrderString, getPatternExpressionAnyCharacter, getPatternExpressionZeroMoreCharacters, getRangeByLimitEndOfStatementClause, getRangeByRowNumberColumn, getRangeByRowNumberColumn2, getRequiredTransactionIsolationLevel, getSchemaName, getSelectForUpdateText, getSelectNewUUIDStmt, getSelectWithLockOption, getSequenceCreateStmt, getSequenceNextStmt, getSupportedOptions, getSurrogateForEmptyStrings, getTransactionIsolationForSchemaCreation, getUnlimitedLengthPrecisionValue, getUpdateTableStatement, getVendorID, initialiseDatastore, initialiseTypes, isIdentityFieldDataType, isReservedKeyword, isStatementCancel, isStatementTimeout, isValidPrimaryKeyType, iteratorReservedWords, newFKInfo, newRDBMSColumnInfo, newSQLTypeInfo, removeUnsupportedMappings, sequenceExists, setProperties, supportsOption, supportsQueryFetchSize, supportsTransactionIsolation, toString, validToSelectMappingInStatement

Field Detail

SRID_EXTENSION_KEY

static final String SRID_EXTENSION_KEY

Key name for the srid extension.

See Also:

Constant Field Values

DIMENSION_EXTENSION_KEY

static final 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

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

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

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