DatastoreAdapter (DataNucleus RDBMS plugin 4.1.19-SNAPSHOT API)

All Known Implementing Classes:

BaseDatastoreAdapter, DB2Adapter, DB2AS400Adapter, DerbyAdapter, FirebirdAdapter, H2Adapter, HSQLAdapter, InformixAdapter, McKoiAdapter, MSSQLServerAdapter, MySQLAdapter, NuoDBAdapter, OracleAdapter, PointbaseAdapter, PostgreSQLAdapter, SAPDBAdapter, SQLAnywhereAdapter, SQLiteAdapter, SybaseAdapter, TimesTenAdapter, VirtuosoAdapter
```
public interface DatastoreAdapter
```
Definition of a datastore adapter, providing all characteristics of the underlying datastore such as whether it supports FKs, indexes, and what statement syntax to use.

Field Summary

Fields
Modifier and Type	Field and Description
`static String`	`ACCESS_PARENTQUERY_IN_SUBQUERY_JOINED` Whether this database supports joining outer and inner queries using columns.
`static String`	`ALTER_TABLE_DROP_CONSTRAINT_SYNTAX` Whether this datastore supports ALTER TABLE DROP constraints
`static String`	`ALTER_TABLE_DROP_FOREIGN_KEY_CONSTRAINT` Whether this datastore supports ALTER TABLE DROP FOREIGN KEY constraints
`static String`	`ANALYSIS_METHODS` Accessor for whether the SQL extensions CUBE, ROLLUP are supported.
`static String`	`ANSI_CROSSJOIN_SYNTAX` Accessor for whether the RDBMS supports ANSI cross-join syntax.
`static String`	`ANSI_JOIN_SYNTAX` Accessor for whether the RDBMS supports ANSI join syntax.
`static String`	`AUTO_INCREMENT_COLUMN_TYPE_SPECIFICATION` Whether we support auto-increment/identity keys with column type specification.
`static String`	`AUTO_INCREMENT_KEYS_NULL_SPECIFICATION` Whether we support auto-increment/identity keys with nullability specification.
`static String`	`AUTO_INCREMENT_PK_IN_CREATE_TABLE_COLUMN_DEF` Whether this adapter requires any specification of primary key in the column definition of CREATE TABLE.
`static String`	`BIT_IS_REALLY_BOOLEAN` Whether "Types.BIT" is really mapped as BOOLEAN.
`static String`	`BLOB_SET_USING_SETSTRING` Accessor for whether setting a BLOB value allows use of PreparedStatement.setString()
`static String`	`BOOLEAN_COMPARISON` Whether we support Boolean comparisons.
`static String`	`CATALOGS_IN_TABLE_DEFINITIONS` Whether this datastore supports the use of the catalog name in ORM table definitions (DDL).
`static String`	`CHAR_COLUMNS_PADDED_WITH_SPACES` Some databases store character strings in CHAR(XX) columns and when read back in have been padded with spaces.
`static String`	`CHECK_IN_CREATE_STATEMENTS` Whether this datastore supports the use of "CHECK" in CREATE TABLE statements (DDL).
`static String`	`CHECK_IN_END_CREATE_STATEMENTS` Whether this datastore supports the use of CHECK after the column definitions in the CREATE TABLE statements (DDL).
`static String`	`CLOB_SET_USING_SETSTRING` Accessor for whether setting a CLOB value allows use of PreparedStatement.setString()
`static String`	`CREATE_INDEXES_BEFORE_FOREIGN_KEYS` Whether to create indexes before foreign keys.
`static String`	`CROSSJOIN_ASINNER11_SYNTAX` Accessor for whether the RDBMS supports cross-join as "INNER 1=1" syntax.
`static String`	`DATETIME_STORES_MILLISECS` Whether DATETIME stores milliseconds.
`static String`	`DEFAULT_BEFORE_NULL_IN_COLUMN_OPTIONS` Whether any DEFAULT tag will be before any NULL/NOT NULL in the column options.
`static String`	`DEFAULT_KEYWORD_IN_COLUMN_OPTIONS` Whether we support DEFAULT tag in CREATE TABLE statements
`static String`	`DEFAULT_KEYWORD_WITH_NOT_NULL_IN_COLUMN_OPTIONS` Whether we support DEFAULT tag together with NOT NULL in CREATE TABLE statements.
`static String`	`DEFERRED_CONSTRAINTS` Whether this datastore supports deferred constraints.
`static String`	`DISTINCT_WITH_SELECT_FOR_UPDATE`
`static String`	`ESCAPE_EXPRESSION_IN_LIKE_PREDICATE`
`static String`	`EXISTS_SYNTAX` Whether the RDBMS supports use of EXISTS syntax.
`static String`	`FK_DELETE_ACTION_CASCADE`
`static String`	`FK_DELETE_ACTION_DEFAULT`
`static String`	`FK_DELETE_ACTION_NULL`
`static String`	`FK_DELETE_ACTION_RESTRICT`
`static String`	`FK_IN_END_CREATE_STATEMENTS` Whether this datastore supports the use of FOREIGN KEY after the column definitions in CREATE TABLE statements (DDL).
`static String`	`FK_UPDATE_ACTION_CASCADE`
`static String`	`FK_UPDATE_ACTION_DEFAULT`
`static String`	`FK_UPDATE_ACTION_NULL`
`static String`	`FK_UPDATE_ACTION_RESTRICT`
`static String`	`GET_GENERATED_KEYS_STATEMENT` Whether the datastore supports "Statement.getGeneratedKeys".
`static String`	`GROUP_BY_REQUIRES_ALL_SELECT_PRIMARIES` Whether the GROUP BY has to include all primary expressions selected.
`static String`	`GROUPING_WITH_SELECT_FOR_UPDATE`
`static String`	`HAVING_WITH_SELECT_FOR_UPDATE`
`static String`	`HOLD_CURSORS_OVER_COMMIT`
`static String`	`IDENTIFIERS_LOWERCASE`
`static String`	`IDENTIFIERS_LOWERCASE_QUOTED`
`static String`	`IDENTIFIERS_MIXEDCASE`
`static String`	`IDENTIFIERS_MIXEDCASE_QUOTED`
`static String`	`IDENTIFIERS_MIXEDCASE_QUOTED_SENSITIVE`
`static String`	`IDENTIFIERS_MIXEDCASE_SENSITIVE`
`static String`	`IDENTIFIERS_UPPERCASE`
`static String`	`IDENTIFIERS_UPPERCASE_QUOTED`
`static String`	`IDENTITY_COLUMNS` Whether this datastore adapter support identity fields.
`static String`	`INCLUDE_ORDERBY_COLS_IN_SELECT` Whether to include any ORDER BY columns in a SELECT.
`static String`	`LOCK_OPTION_PLACED_AFTER_FROM` Whether the lock option (when doing SELECT FOR UPDATE) is to be placed after the FROM.
`static String`	`LOCK_OPTION_PLACED_WITHIN_JOIN` Whether the lock option (when doing SELECT FOR UPDATE) is to be placed within the JOIN clause.
`static String`	`LOCK_WITH_SELECT_FOR_UPDATE` Whether this datastore supports SELECT ...
`static String`	`MULTITABLES_WITH_SELECT_FOR_UPDATE`
`static String`	`NULL_EQUALS_EMPTY_STRING` Some databases, Oracle, treats an empty string (0 length) equals null.
`static String`	`NULLS_IN_CANDIDATE_KEYS` Whether we support NULLs in candidate keys.
`static String`	`NULLS_KEYWORD_IN_COLUMN_OPTIONS` Whether the database support NULLs in the column options for table creation.
`static String`	`OPERATOR_BITWISE_AND`
`static String`	`OPERATOR_BITWISE_OR`
`static String`	`OPERATOR_BITWISE_XOR`
`static String`	`ORDERBY_NULLS_DIRECTIVES` Whether we support ANSI "NULLS [FIRST\|LAST]" directives in ORDER expressions.
`static String`	`ORDERBY_NULLS_USING_CASE_NULL` Whether we support ordering of NULLs using "(CASE WHEN [Order] IS NULL THEN 0 ELSE 1 END), [Order]"
`static String`	`ORDERBY_NULLS_USING_COLUMN_IS_NULL` Whether we support ordering of NULLs using {col} IS NULL.
`static String`	`ORDERBY_NULLS_USING_ISNULL` Whether we support ordering of NULLs using ISNULL.
`static String`	`ORDERBY_USING_SELECT_COLUMN_INDEX` In SAPDB any orderby has to be using the index(es) of any SELECT column(s) rather than their name(s).
`static String`	`ORDERING_WITH_SELECT_FOR_UPDATE`
`static String`	`PERSIST_OF_UNASSIGNED_CHAR` Whether the database server supports persist of an unassigned character ("0x0").
`static String`	`PRIMARYKEY_IN_CREATE_STATEMENTS` Whether the datastore supports specification of the primary key in CREATE TABLE statements.
`static String`	`PROJECTION_IN_TABLE_REFERENCE_JOINS` Whether this datastore supports "SELECT a.* FROM (SELECT * FROM TBL1 INNER JOIN TBL2 ON tbl1.x = tbl2.y ) a" If the database does not support the SQL statement generated is like "SELECT a.* FROM (TBL1 INNER JOIN TBL2 ON tbl1.x = tbl2.y ) a"
`static String`	`RESULTSET_TYPE_FORWARD_ONLY`
`static String`	`RESULTSET_TYPE_SCROLL_INSENSITIVE`
`static String`	`RESULTSET_TYPE_SCROLL_SENSITIVE`
`static String`	`RIGHT_OUTER_JOIN` Do we support right outer join?
`static String`	`SCHEMAS_IN_TABLE_DEFINITIONS` Whether this datastore supports the use of the schema name in ORM table definitions (DDL).
`static String`	`SELECT_FOR_UPDATE_NOWAIT` Whether this datastore supports SELECT ...
`static String`	`SEQUENCES` Whether we support sequences.
`static String`	`SOME_ANY_ALL_SUBQUERY_EXPRESSIONS` Do we support SOME\|ALL\|ANY {subquery}.
`static String`	`STATEMENT_BATCHING` Whether this datastore supports batching of statements.
`static String`	`STORED_PROCEDURES` Whether this datastore supports stored procedures.
`static String`	`SUBQUERY_IN_HAVING` Whether the adapter supports subqueries in the HAVING clause.
`static String`	`TX_ISOLATION_NONE`
`static String`	`TX_ISOLATION_READ_COMMITTED`
`static String`	`TX_ISOLATION_READ_UNCOMMITTED`
`static String`	`TX_ISOLATION_REPEATABLE_READ`
`static String`	`TX_ISOLATION_SERIALIZABLE`
`static String`	`UNION_SYNTAX` Whether the RDBMS supports UNION syntax.
`static String`	`UNIQUE_IN_END_CREATE_STATEMENTS` Whether this datastore supports the use of UNIQUE after the column definitions in CREATE TABLE statements (DDL).
`static String`	`UPDATE_DELETE_STATEMENT_ALLOW_TABLE_ALIAS_IN_WHERE_CLAUSE`
`static String`	`UPDATE_STATEMENT_ALLOW_TABLE_ALIAS_IN_SET_CLAUSE`
`static String`	`USE_UNION_ALL` Union combines the results of two or more queries into a single result set.
`static String`	`VIEWS` Whether the RDBMS supports SQL VIEWs.

Method Summary

All Methods Instance Methods Abstract Methods
Modifier and Type	Method and Description
`long`	`getAdapterTime(Timestamp time)` Utility to return the adapter time in case there are rounding issues with millisecs etc.
`String`	`getAddCandidateKeyStatement(CandidateKey ck, IdentifierFactory factory)` Returns the appropriate SQL to add a candidate key to its table.
`String`	`getAddColumnStatement(Table table, Column col)` Accessor for the SQL statement to add a column to a table.
`String`	`getAddForeignKeyStatement(ForeignKey fk, IdentifierFactory factory)` Returns the appropriate SQL to add a foreign key to its table.
`String`	`getAddPrimaryKeyStatement(PrimaryKey pk, IdentifierFactory factory)` Returns the appropriate SQL to add a primary key to its table.
`Class`	`getAutoIncrementJavaTypeForType(Class type)` Return the java type that represents any autoincrement/identity column value.
`String`	`getAutoIncrementKeyword()` Accessor for the auto-increment/identity keyword for generating DDLs.
`String`	`getAutoIncrementStmt(Table table, String columnName)` Accessor for the auto-increment/identity sql statement for this datastore.
`String`	`getCatalogName(Connection conn)` Accessor for the Catalog Name for this datastore.
`String`	`getCatalogSeparator()` Accessor for the catalog separator (string to separate the catalog/schema and the identifier).
`String`	`getCheckConstraintForValues(DatastoreIdentifier identifier, Object[] values, boolean nullable)` Creates a CHECK constraint definition based on the given values e.g.
`ResultSet`	`getColumns(Connection conn, String catalog, String schema, String table, String columnNamePattern)` Accessor for table and column information for a catalog/schema in this datastore.
`String`	`getCreateDatabaseStatement(String catalogName, String schemaName)` Method to return the statement necessary to create a database with this RDBMS.
`String`	`getCreateIndexStatement(Index idx, IdentifierFactory factory)` Returns the appropriate SQL to add an index to its table.
`String`	`getCreateTableStatement(TableImpl table, Column[] columns, Properties props, IdentifierFactory factory)` Returns the appropriate SQL to create the given table having the given columns.
`String`	`getDatastoreDateStatement()` Accessor for a statement that will return the statement to use to get the datastore date.
`String`	`getDatastoreDriverName()` Accessor for the datastore driver name.
`String`	`getDatastoreDriverVersion()` Accessor for the datastore driver version.
`int`	`getDatastoreIdentifierMaxLength(IdentifierType identifierType)` Method to return the maximum length of a datastore identifier of the specified type.
`String`	`getDatastoreProductName()` Accessor for the datastore product name.
`String`	`getDatastoreProductVersion()` Accessor for the datastore product version.
`String`	`getDeleteTableStatement(SQLTable tbl)` Method to return the basic SQL for a DELETE TABLE statement.
`int`	`getDriverMajorVersion()` Accessor for the driver major version
`int`	`getDriverMinorVersion()` Accessor for the driver minor version
`String`	`getDropDatabaseStatement(String catalogName, String schemaName)` Method to return the statement necessary to drop a database with this RDBMS.
`String`	`getDropTableStatement(Table table)` Returns the appropriate SQL to drop the given table.
`String`	`getDropViewStatement(ViewImpl view)` Returns the appropriate SQL to drop the given view.
`String`	`getEscapeCharacter()` The character for escaping characters in pattern expressions.
`String`	`getEscapePatternExpression()` The character for escaping characters in pattern expressions.
`ResultSet`	`getExistingIndexes(Connection conn, String catalog, String schema, String table)` Provide the existing indexes in the database for the table
`String`	`getIdentifierQuoteString()` Accessor for the quote string to use when quoting identifiers.
`String`	`getInsertStatementForNoColumns(Table table)` Method to retutn the INSERT statement to use when inserting into a table that has no columns specified.
`int`	`getJDBCTypeForName(String typeName)` Method to return the type given the "jdbc-type" name.
`MappingManager`	`getMappingManager(RDBMSStoreManager storeMgr)` Accessor for a Mapping Manager suitable for use with this datastore adapter.
`int`	`getMaxForeignKeys()` Accessor for the maximum foreign keys by table permitted in this datastore.
`int`	`getMaxIndexes()` Accessor for the maximum indexes by table permitted in this datastore.
`String`	`getNameForJDBCType(int jdbcType)` Return a name for a JDBC Types value.
`String`	`getNumericConversionFunction()` Accessor for the function to use for converting to numeric.
`String`	`getOrderString(org.datanucleus.store.StoreManager storeMgr, String orderString, SQLExpression sqlExpr)` Convenience method to allow adaption of an ordering string before applying it.
`String`	`getPatternExpressionAnyCharacter()` The pattern string for representing one character that is expanded in word searches.
`String`	`getPatternExpressionZeroMoreCharacters()` The pattern string for representing zero or more characters that is expanded in word searches.
`String`	`getRangeByLimitEndOfStatementClause(long offset, long count, boolean hasOrdering)` Method to return the SQL to append to the end of the SELECT statement to handle restriction of ranges using the LIMIT keyword.
`String`	`getRangeByRowNumberColumn()` Method to return the column name to use when handling ranges via a rownumber on the select using the original method (DB2).
`String`	`getRangeByRowNumberColumn2()` Method to return the column name to use when handling ranges via a rownumber on the select using the second method (Oracle).
`int`	`getRequiredTransactionIsolationLevel()` Accessor for the "required" transaction isolation level if it has to be a certain value for this adapter.
`String`	`getSchemaName(Connection conn)` Accessor for the Schema Name for this datastore.
`String`	`getSelectForUpdateText()` Method returning the text to append to the end of the SELECT to perform the equivalent of "SELECT ...
`String`	`getSelectNewUUIDStmt()` The function to creates a unique value of type uniqueidentifier.
`String`	`getSelectWithLockOption()` The option to specify in "SELECT ...
`String`	`getSequenceCreateStmt(String sequence_name, Integer min, Integer max, Integer start, Integer increment, Integer cache_size)` Accessor for the sequence create statement for this datastore.
`String`	`getSequenceNextStmt(String sequence_name)` Accessor for the sequence statement to get the next id for this datastore.
`Collection<String>`	`getSupportedOptions()` Accessor for the options that are supported by this datastore adapter and the underlying datastore.
`String`	`getSurrogateForEmptyStrings()` Some databases, Oracle, treats an empty string (0 length) equals null
`int`	`getTransactionIsolationForSchemaCreation()` Accessor for the transaction isolation level to use during schema creation.
`int`	`getUnlimitedLengthPrecisionValue(SQLTypeInfo typeInfo)` Returns the precision value to be used when creating string columns of "unlimited" length.
`SQLText`	`getUpdateTableStatement(SQLTable tbl, SQLText setSQL)` Method to return the basic SQL for an UPDATE TABLE statement.
`String`	`getVendorID()` Accessor for the Vendor ID for this datastore.
`void`	`initialiseDatastore(Object conn)` Creates the auxiliary functions/procedures in the datastore
`void`	`initialiseTypes(org.datanucleus.store.schema.StoreSchemaHandler handler, org.datanucleus.store.connection.ManagedConnection mconn)` Initialise the types for this datastore.
`boolean`	`isIdentityFieldDataType(String columnDef)` Verifies if the given `columnDef` is an identity field type for the datastore.
`boolean`	`isReservedKeyword(String word)` Method to check if a word is reserved for this datastore.
`boolean`	`isStatementCancel(SQLException sqle)` return whether this exception represents a cancelled statement.
`boolean`	`isStatementTimeout(SQLException sqle)` return whether this exception represents a timed out statement.
`boolean`	`isValidPrimaryKeyType(org.datanucleus.metadata.JdbcType datatype)` Method to return whether the specified JDBC type is valid for use in a PrimaryKey.
`Iterator`	`iteratorReservedWords()` Iterator for the reserved words constructed from the method DataBaseMetaData.getSQLKeywords + standard SQL reserved words
`ForeignKeyInfo`	`newFKInfo(ResultSet rs)` Method to return ForeignKeyInfo for the current row of the ResultSet which will have been obtained from a call to DatabaseMetaData.getImportedKeys() or DatabaseMetaData.getExportedKeys().
`RDBMSColumnInfo`	`newRDBMSColumnInfo(ResultSet rs)` Create a new column info from the current row of the passed ResultSet.
`SQLTypeInfo`	`newSQLTypeInfo(ResultSet rs)` Create a new SQL type info from the current row of the passed ResultSet.
`void`	`removeUnsupportedMappings(org.datanucleus.store.schema.StoreSchemaHandler handler, org.datanucleus.store.connection.ManagedConnection mconn)` Remove all mappings from the mapping manager that don't have a datastore type initialised.
`boolean`	`sequenceExists(Connection conn, String catalogName, String schemaName, String seqName)` Convenience method to return whether the specified sequence already exists.
`void`	`setProperties(Map<String,Object> props)` Set any properties controlling how the adapter is configured.
`boolean`	`supportsOption(String option)` Accessor for whether the supplied option is supported.
`boolean`	`supportsQueryFetchSize(int size)` Whether the datastore will support setting the query fetch size to the supplied value.
`boolean`	`supportsTransactionIsolation(int level)` Accessor for whether this database adapter supports the specified transaction isolation.
`String`	`toString()` Method to return this object as a string.
`boolean`	`validToIndexMapping(JavaTypeMapping mapping)` Method to return whether the specified mapping is indexable.
`boolean`	`validToSelectMappingInStatement(SQLStatement stmt, JavaTypeMapping m)` Method to return if it is valid to select the specified mapping for the specified statement for this datastore adapter.

- Field Detail
  - IDENTITY_COLUMNS
```
static final String IDENTITY_COLUMNS
```
    Whether this datastore adapter support identity fields. In SQL this would be things like "AUTOINCREMENT", "IDENTITY", "SERIAL".
    
    See Also:
    
    Constant Field Values
  - SEQUENCES
```
static final String SEQUENCES
```
    Whether we support sequences.
    
    See Also:
    
    Constant Field Values
  - BIT_IS_REALLY_BOOLEAN
```
static final String BIT_IS_REALLY_BOOLEAN
```
    Whether "Types.BIT" is really mapped as BOOLEAN.
    
    See Also:
    
    Constant Field Values
  - RIGHT_OUTER_JOIN
```
static final String RIGHT_OUTER_JOIN
```
    Do we support right outer join?
    
    See Also:
    
    Constant Field Values
  - SOME_ANY_ALL_SUBQUERY_EXPRESSIONS
```
static final String SOME_ANY_ALL_SUBQUERY_EXPRESSIONS
```
    Do we support SOME|ALL|ANY {subquery}.
    
    See Also:
    
    Constant Field Values
  - BOOLEAN_COMPARISON
```
static final String BOOLEAN_COMPARISON
```
    Whether we support Boolean comparisons.
    
    See Also:
    
    Constant Field Values
  - ESCAPE_EXPRESSION_IN_LIKE_PREDICATE
```
static final String ESCAPE_EXPRESSION_IN_LIKE_PREDICATE
```
    See Also:
    
    Constant Field Values
  - PROJECTION_IN_TABLE_REFERENCE_JOINS
```
static final String PROJECTION_IN_TABLE_REFERENCE_JOINS
```
    Whether this datastore supports "SELECT a.* FROM (SELECT * FROM TBL1 INNER JOIN TBL2 ON tbl1.x = tbl2.y ) a" If the database does not support the SQL statement generated is like "SELECT a.* FROM (TBL1 INNER JOIN TBL2 ON tbl1.x = tbl2.y ) a"
    
    See Also:
    
    Constant Field Values
  - ANALYSIS_METHODS
```
static final String ANALYSIS_METHODS
```
    Accessor for whether the SQL extensions CUBE, ROLLUP are supported. TODO Move this to a plugin extension as cube and rollup options (separate)
    
    See Also:
    
    Constant Field Values
  - CATALOGS_IN_TABLE_DEFINITIONS
```
static final String CATALOGS_IN_TABLE_DEFINITIONS
```
    Whether this datastore supports the use of the catalog name in ORM table definitions (DDL).
    
    See Also:
    
    Constant Field Values
  - SCHEMAS_IN_TABLE_DEFINITIONS
```
static final String SCHEMAS_IN_TABLE_DEFINITIONS
```
    Whether this datastore supports the use of the schema name in ORM table definitions (DDL).
    
    See Also:
    
    Constant Field Values
  - IDENTIFIERS_LOWERCASE
```
static final String IDENTIFIERS_LOWERCASE
```
    See Also:
    
    Constant Field Values
  - IDENTIFIERS_MIXEDCASE
```
static final String IDENTIFIERS_MIXEDCASE
```
    See Also:
    
    Constant Field Values
  - IDENTIFIERS_UPPERCASE
```
static final String IDENTIFIERS_UPPERCASE
```
    See Also:
    
    Constant Field Values
  - IDENTIFIERS_LOWERCASE_QUOTED
```
static final String IDENTIFIERS_LOWERCASE_QUOTED
```
    See Also:
    
    Constant Field Values
  - IDENTIFIERS_MIXEDCASE_QUOTED
```
static final String IDENTIFIERS_MIXEDCASE_QUOTED
```
    See Also:
    
    Constant Field Values
  - IDENTIFIERS_UPPERCASE_QUOTED
```
static final String IDENTIFIERS_UPPERCASE_QUOTED
```
    See Also:
    
    Constant Field Values
  - IDENTIFIERS_MIXEDCASE_SENSITIVE
```
static final String IDENTIFIERS_MIXEDCASE_SENSITIVE
```
    See Also:
    
    Constant Field Values
  - IDENTIFIERS_MIXEDCASE_QUOTED_SENSITIVE
```
static final String IDENTIFIERS_MIXEDCASE_QUOTED_SENSITIVE
```
    See Also:
    
    Constant Field Values
  - VIEWS
```
static final String VIEWS
```
    Whether the RDBMS supports SQL VIEWs.
    
    See Also:
    
    Constant Field Values
  - UNION_SYNTAX
```
static final String UNION_SYNTAX
```
    Whether the RDBMS supports UNION syntax.
    
    See Also:
    
    Constant Field Values
  - USE_UNION_ALL
```
static final String USE_UNION_ALL
```
    Union combines the results of two or more queries into a single result set. Union include only distinct rows and Union all may include duplicates. When using the UNION statement, keep in mind that, by default, it performs the equivalent of a SELECT DISTINCT on the final result set. In other words, UNION takes the results of two like recordsets, combines them, and then performs a SELECT DISTINCT in order to eliminate any duplicate rows. This process occurs even if there are no duplicate records in the final recordset. If you know that there are duplicate records, and this presents a problem for your application, then by all means use the UNION statement to eliminate the duplicate rows. On the other hand, if you know that there will never be any duplicate rows, or if there are, and this presents no problem to your application, then you should use the UNION ALL statement instead of the UNION statement. The advantage of the UNION ALL is that is does not perform the SELECT DISTINCT function, which saves a lot of unnecessary SQL Server resources from being using.
    
    See Also:
    
    Constant Field Values
  - EXISTS_SYNTAX
```
static final String EXISTS_SYNTAX
```
    Whether the RDBMS supports use of EXISTS syntax.
    
    See Also:
    
    Constant Field Values
  - ALTER_TABLE_DROP_CONSTRAINT_SYNTAX
```
static final String ALTER_TABLE_DROP_CONSTRAINT_SYNTAX
```
    Whether this datastore supports ALTER TABLE DROP constraints
    
    See Also:
    
    Constant Field Values
  - ALTER_TABLE_DROP_FOREIGN_KEY_CONSTRAINT
```
static final String ALTER_TABLE_DROP_FOREIGN_KEY_CONSTRAINT
```
    Whether this datastore supports ALTER TABLE DROP FOREIGN KEY constraints
    
    See Also:
    
    Constant Field Values
  - DEFERRED_CONSTRAINTS
```
static final String DEFERRED_CONSTRAINTS
```
    Whether this datastore supports deferred constraints.
    
    See Also:
    
    Constant Field Values
  - DISTINCT_WITH_SELECT_FOR_UPDATE
```
static final String DISTINCT_WITH_SELECT_FOR_UPDATE
```
    See Also:
    
    Constant Field Values
  - GROUPING_WITH_SELECT_FOR_UPDATE
```
static final String GROUPING_WITH_SELECT_FOR_UPDATE
```
    See Also:
    
    Constant Field Values
  - HAVING_WITH_SELECT_FOR_UPDATE
```
static final String HAVING_WITH_SELECT_FOR_UPDATE
```
    See Also:
    
    Constant Field Values
  - ORDERING_WITH_SELECT_FOR_UPDATE
```
static final String ORDERING_WITH_SELECT_FOR_UPDATE
```
    See Also:
    
    Constant Field Values
  - MULTITABLES_WITH_SELECT_FOR_UPDATE
```
static final String MULTITABLES_WITH_SELECT_FOR_UPDATE
```
    See Also:
    
    Constant Field Values
  - UPDATE_STATEMENT_ALLOW_TABLE_ALIAS_IN_SET_CLAUSE
```
static final String UPDATE_STATEMENT_ALLOW_TABLE_ALIAS_IN_SET_CLAUSE
```
    See Also:
    
    Constant Field Values
  - UPDATE_DELETE_STATEMENT_ALLOW_TABLE_ALIAS_IN_WHERE_CLAUSE
```
static final String UPDATE_DELETE_STATEMENT_ALLOW_TABLE_ALIAS_IN_WHERE_CLAUSE
```
    See Also:
    
    Constant Field Values
  - GROUP_BY_REQUIRES_ALL_SELECT_PRIMARIES
```
static final String GROUP_BY_REQUIRES_ALL_SELECT_PRIMARIES
```
    Whether the GROUP BY has to include all primary expressions selected.
    
    See Also:
    
    Constant Field Values
  - PERSIST_OF_UNASSIGNED_CHAR
```
static final String PERSIST_OF_UNASSIGNED_CHAR
```
    Whether the database server supports persist of an unassigned character ("0x0"). If not, any unassigned character will be replaced by " " (space) on persist.
    
    See Also:
    
    Constant Field Values
  - CHAR_COLUMNS_PADDED_WITH_SPACES
```
static final String CHAR_COLUMNS_PADDED_WITH_SPACES
```
    Some databases store character strings in CHAR(XX) columns and when read back in have been padded with spaces.
    
    See Also:
    
    Constant Field Values
  - NULL_EQUALS_EMPTY_STRING
```
static final String NULL_EQUALS_EMPTY_STRING
```
    Some databases, Oracle, treats an empty string (0 length) equals null.
    
    See Also:
    
    Constant Field Values
  - STATEMENT_BATCHING
```
static final String STATEMENT_BATCHING
```
    Whether this datastore supports batching of statements.
    
    See Also:
    
    Constant Field Values
  - CHECK_IN_CREATE_STATEMENTS
```
static final String CHECK_IN_CREATE_STATEMENTS
```
    Whether this datastore supports the use of "CHECK" in CREATE TABLE statements (DDL).
    
    See Also:
    
    Constant Field Values
  - CHECK_IN_END_CREATE_STATEMENTS
```
static final String CHECK_IN_END_CREATE_STATEMENTS
```
    Whether this datastore supports the use of CHECK after the column definitions in the CREATE TABLE statements (DDL). for example
```
 CREATE TABLE MYTABLE
 (
     COL_A int,
     COL_B char(1),
     PRIMARY KEY (COL_A),
     CHECK (COL_B IN ('Y','N'))
 )
 
```
    See Also:
    
    Constant Field Values
  - UNIQUE_IN_END_CREATE_STATEMENTS
```
static final String UNIQUE_IN_END_CREATE_STATEMENTS
```
    Whether this datastore supports the use of UNIQUE after the column definitions in CREATE TABLE statements (DDL). For example
```
 CREATE TABLE MYTABLE
 (
     COL_A int,
     COL_B char(1),
     PRIMARY KEY (COL_A),
     UNIQUE (COL_B ...)
 )
 
```
    See Also:
    
    Constant Field Values
  - FK_IN_END_CREATE_STATEMENTS
```
static final String FK_IN_END_CREATE_STATEMENTS
```
    Whether this datastore supports the use of FOREIGN KEY after the column definitions in CREATE TABLE statements (DDL). For example
```
 CREATE TABLE MYTABLE
 (
     COL_A int,
     COL_B char(1),
     FOREIGN KEY (COL_A) REFERENCES TBL2(COL_X)
 )
 
```
    See Also:
    
    Constant Field Values
  - PRIMARYKEY_IN_CREATE_STATEMENTS
```
static final String PRIMARYKEY_IN_CREATE_STATEMENTS
```
    Whether the datastore supports specification of the primary key in CREATE TABLE statements.
    
    See Also:
    
    Constant Field Values
  - GET_GENERATED_KEYS_STATEMENT
```
static final String GET_GENERATED_KEYS_STATEMENT
```
    Whether the datastore supports "Statement.getGeneratedKeys".
    
    See Also:
    
    Constant Field Values
  - NULLS_IN_CANDIDATE_KEYS
```
static final String NULLS_IN_CANDIDATE_KEYS
```
    Whether we support NULLs in candidate keys.
    
    See Also:
    
    Constant Field Values
  - NULLS_KEYWORD_IN_COLUMN_OPTIONS
```
static final String NULLS_KEYWORD_IN_COLUMN_OPTIONS
```
    Whether the database support NULLs in the column options for table creation.
    
    See Also:
    
    Constant Field Values
  - DEFAULT_KEYWORD_IN_COLUMN_OPTIONS
```
static final String DEFAULT_KEYWORD_IN_COLUMN_OPTIONS
```
    Whether we support DEFAULT tag in CREATE TABLE statements
    
    See Also:
    
    Constant Field Values
  - DEFAULT_KEYWORD_WITH_NOT_NULL_IN_COLUMN_OPTIONS
```
static final String DEFAULT_KEYWORD_WITH_NOT_NULL_IN_COLUMN_OPTIONS
```
    Whether we support DEFAULT tag together with NOT NULL in CREATE TABLE statements.
```
CREATE TABLE X ( MEMORY_SIZE BIGINT DEFAULT 0 NOT NULL )
```
    Some databases only support DEFAULT {ConstantExpression | NULL}
    See Also:
    
    Constant Field Values
  - DEFAULT_BEFORE_NULL_IN_COLUMN_OPTIONS
```
static final String DEFAULT_BEFORE_NULL_IN_COLUMN_OPTIONS
```
    Whether any DEFAULT tag will be before any NULL/NOT NULL in the column options.
    
    See Also:
    
    Constant Field Values
  - ANSI_JOIN_SYNTAX
```
static final String ANSI_JOIN_SYNTAX
```
    Accessor for whether the RDBMS supports ANSI join syntax.
    
    See Also:
    
    Constant Field Values
  - ANSI_CROSSJOIN_SYNTAX
```
static final String ANSI_CROSSJOIN_SYNTAX
```
    Accessor for whether the RDBMS supports ANSI cross-join syntax.
    
    See Also:
    
    Constant Field Values
  - CROSSJOIN_ASINNER11_SYNTAX
```
static final String CROSSJOIN_ASINNER11_SYNTAX
```
    Accessor for whether the RDBMS supports cross-join as "INNER 1=1" syntax.
    
    See Also:
    
    Constant Field Values
  - AUTO_INCREMENT_KEYS_NULL_SPECIFICATION
```
static final String AUTO_INCREMENT_KEYS_NULL_SPECIFICATION
```
    Whether we support auto-increment/identity keys with nullability specification.
    
    See Also:
    
    Constant Field Values
  - AUTO_INCREMENT_COLUMN_TYPE_SPECIFICATION
```
static final String AUTO_INCREMENT_COLUMN_TYPE_SPECIFICATION
```
    Whether we support auto-increment/identity keys with column type specification.
    
    See Also:
    
    Constant Field Values
  - AUTO_INCREMENT_PK_IN_CREATE_TABLE_COLUMN_DEF
```
static final String AUTO_INCREMENT_PK_IN_CREATE_TABLE_COLUMN_DEF
```
    Whether this adapter requires any specification of primary key in the column definition of CREATE TABLE.
    
    See Also:
    
    Constant Field Values
  - LOCK_WITH_SELECT_FOR_UPDATE
```
static final String LOCK_WITH_SELECT_FOR_UPDATE
```
    Whether this datastore supports SELECT ... FOR UPDATE.
    
    See Also:
    
    Constant Field Values
  - SELECT_FOR_UPDATE_NOWAIT
```
static final String SELECT_FOR_UPDATE_NOWAIT
```
    Whether this datastore supports SELECT ... FOR UPDATE NOWAIT.
    
    See Also:
    
    Constant Field Values
  - LOCK_OPTION_PLACED_AFTER_FROM
```
static final String LOCK_OPTION_PLACED_AFTER_FROM
```
    Whether the lock option (when doing SELECT FOR UPDATE) is to be placed after the FROM.
    
    See Also:
    
    Constant Field Values
  - LOCK_OPTION_PLACED_WITHIN_JOIN
```
static final String LOCK_OPTION_PLACED_WITHIN_JOIN
```
    Whether the lock option (when doing SELECT FOR UPDATE) is to be placed within the JOIN clause.
    
    See Also:
    
    Constant Field Values
  - BLOB_SET_USING_SETSTRING
```
static final String BLOB_SET_USING_SETSTRING
```
    Accessor for whether setting a BLOB value allows use of PreparedStatement.setString()
    
    See Also:
    
    Constant Field Values
  - CLOB_SET_USING_SETSTRING
```
static final String CLOB_SET_USING_SETSTRING
```
    Accessor for whether setting a CLOB value allows use of PreparedStatement.setString()
    
    See Also:
    
    Constant Field Values
  - CREATE_INDEXES_BEFORE_FOREIGN_KEYS
```
static final String CREATE_INDEXES_BEFORE_FOREIGN_KEYS
```
    Whether to create indexes before foreign keys.
    
    See Also:
    
    Constant Field Values
  - INCLUDE_ORDERBY_COLS_IN_SELECT
```
static final String INCLUDE_ORDERBY_COLS_IN_SELECT
```
    Whether to include any ORDER BY columns in a SELECT.
    
    See Also:
    
    Constant Field Values
  - DATETIME_STORES_MILLISECS
```
static final String DATETIME_STORES_MILLISECS
```
    Whether DATETIME stores milliseconds.
    
    See Also:
    
    Constant Field Values
  - ACCESS_PARENTQUERY_IN_SUBQUERY_JOINED
```
static final String ACCESS_PARENTQUERY_IN_SUBQUERY_JOINED
```
    Whether this database supports joining outer and inner queries using columns. i.e can you refer to a column of the outer query in a subquery when the outer query table is not the primary table of the outer query (i.e joined)
    
    See Also:
    
    Constant Field Values
  - SUBQUERY_IN_HAVING
```
static final String SUBQUERY_IN_HAVING
```
    Whether the adapter supports subqueries in the HAVING clause.
    
    See Also:
    
    Constant Field Values
  - ORDERBY_USING_SELECT_COLUMN_INDEX
```
static final String ORDERBY_USING_SELECT_COLUMN_INDEX
```
    In SAPDB any orderby has to be using the index(es) of any SELECT column(s) rather than their name(s).
    
    See Also:
    
    Constant Field Values
  - ORDERBY_NULLS_DIRECTIVES
```
static final String ORDERBY_NULLS_DIRECTIVES
```
    Whether we support ANSI "NULLS [FIRST|LAST]" directives in ORDER expressions.
    
    See Also:
    
    Constant Field Values
  - ORDERBY_NULLS_USING_ISNULL
```
static final String ORDERBY_NULLS_USING_ISNULL
```
    Whether we support ordering of NULLs using ISNULL.
    
    See Also:
    
    Constant Field Values
  - ORDERBY_NULLS_USING_COLUMN_IS_NULL
```
static final String ORDERBY_NULLS_USING_COLUMN_IS_NULL
```
    Whether we support ordering of NULLs using {col} IS NULL.
    
    See Also:
    
    Constant Field Values
  - ORDERBY_NULLS_USING_CASE_NULL
```
static final String ORDERBY_NULLS_USING_CASE_NULL
```
    Whether we support ordering of NULLs using "(CASE WHEN [Order] IS NULL THEN 0 ELSE 1 END), [Order]"
    
    See Also:
    
    Constant Field Values
  - STORED_PROCEDURES
```
static final String STORED_PROCEDURES
```
    Whether this datastore supports stored procedures.
    
    See Also:
    
    Constant Field Values
  - FK_UPDATE_ACTION_CASCADE
```
static final String FK_UPDATE_ACTION_CASCADE
```
    See Also:
    
    Constant Field Values
  - FK_UPDATE_ACTION_DEFAULT
```
static final String FK_UPDATE_ACTION_DEFAULT
```
    See Also:
    
    Constant Field Values
  - FK_UPDATE_ACTION_NULL
```
static final String FK_UPDATE_ACTION_NULL
```
    See Also:
    
    Constant Field Values
  - FK_UPDATE_ACTION_RESTRICT
```
static final String FK_UPDATE_ACTION_RESTRICT
```
    See Also:
    
    Constant Field Values
  - FK_DELETE_ACTION_CASCADE
```
static final String FK_DELETE_ACTION_CASCADE
```
    See Also:
    
    Constant Field Values
  - FK_DELETE_ACTION_DEFAULT
```
static final String FK_DELETE_ACTION_DEFAULT
```
    See Also:
    
    Constant Field Values
  - FK_DELETE_ACTION_NULL
```
static final String FK_DELETE_ACTION_NULL
```
    See Also:
    
    Constant Field Values
  - FK_DELETE_ACTION_RESTRICT
```
static final String FK_DELETE_ACTION_RESTRICT
```
    See Also:
    
    Constant Field Values
  - TX_ISOLATION_NONE
```
static final String TX_ISOLATION_NONE
```
    See Also:
    
    Constant Field Values
  - TX_ISOLATION_READ_COMMITTED
```
static final String TX_ISOLATION_READ_COMMITTED
```
    See Also:
    
    Constant Field Values
  - TX_ISOLATION_READ_UNCOMMITTED
```
static final String TX_ISOLATION_READ_UNCOMMITTED
```
    See Also:
    
    Constant Field Values
  - TX_ISOLATION_REPEATABLE_READ
```
static final String TX_ISOLATION_REPEATABLE_READ
```
    See Also:
    
    Constant Field Values
  - TX_ISOLATION_SERIALIZABLE
```
static final String TX_ISOLATION_SERIALIZABLE
```
    See Also:
    
    Constant Field Values
  - RESULTSET_TYPE_FORWARD_ONLY
```
static final String RESULTSET_TYPE_FORWARD_ONLY
```
    See Also:
    
    Constant Field Values
  - RESULTSET_TYPE_SCROLL_SENSITIVE
```
static final String RESULTSET_TYPE_SCROLL_SENSITIVE
```
    See Also:
    
    Constant Field Values
  - RESULTSET_TYPE_SCROLL_INSENSITIVE
```
static final String RESULTSET_TYPE_SCROLL_INSENSITIVE
```
    See Also:
    
    Constant Field Values
  - HOLD_CURSORS_OVER_COMMIT
```
static final String HOLD_CURSORS_OVER_COMMIT
```
    See Also:
    
    Constant Field Values
  - OPERATOR_BITWISE_AND
```
static final String OPERATOR_BITWISE_AND
```
    See Also:
    
    Constant Field Values
  - OPERATOR_BITWISE_OR
```
static final String OPERATOR_BITWISE_OR
```
    See Also:
    
    Constant Field Values
  - OPERATOR_BITWISE_XOR
```
static final String OPERATOR_BITWISE_XOR
```
    See Also:
    
    Constant Field Values
- Method Detail
  - getSupportedOptions
```
Collection<String> getSupportedOptions()
```
    Accessor for the options that are supported by this datastore adapter and the underlying datastore.
    
    Returns:
    
    The options (Collection<String>)
  - supportsOption
```
boolean supportsOption(String option)
```
    Accessor for whether the supplied option is supported.
    
    Parameters:
    
    option - The option
    
    Returns:
    
    Whether supported.
  - getNameForJDBCType
```
String getNameForJDBCType(int jdbcType)
```
    Return a name for a JDBC Types value.
    
    Parameters:
    
    jdbcType - The jdbc type
    
    Returns:
    
    The name
  - getJDBCTypeForName
```
int getJDBCTypeForName(String typeName)
```
    Method to return the type given the "jdbc-type" name.
    
    Parameters:
    
    typeName - "jdbc-type" name
    
    Returns:
    
    Whether it is valid
  - getMappingManager
```
MappingManager getMappingManager(RDBMSStoreManager storeMgr)
```
    Accessor for a Mapping Manager suitable for use with this datastore adapter.
    
    Parameters:
    
    storeMgr - The StoreManager
    
    Returns:
    
    The Mapping Manager.
  - getVendorID
```
String getVendorID()
```
    Accessor for the Vendor ID for this datastore.
    
    Returns:
    
    Vendor id for this datastore
  - initialiseTypes
```
void initialiseTypes(org.datanucleus.store.schema.StoreSchemaHandler handler,
                     org.datanucleus.store.connection.ManagedConnection mconn)
```
    Initialise the types for this datastore.
    
    Parameters:
    
    handler - SchemaHandler that we initialise the types for
    
    mconn - Managed connection to use
  - setProperties
```
void setProperties(Map<String,Object> props)
```
    Set any properties controlling how the adapter is configured.
    
    Parameters:
    
    props - The properties
  - removeUnsupportedMappings
```
void removeUnsupportedMappings(org.datanucleus.store.schema.StoreSchemaHandler handler,
                               org.datanucleus.store.connection.ManagedConnection mconn)
```
    Remove all mappings from the mapping manager that don't have a datastore type initialised.
    
    Parameters:
    
    handler - Schema handler
    
    mconn - Managed connection to use
  - isReservedKeyword
```
boolean isReservedKeyword(String word)
```
    Method to check if a word is reserved for this datastore.
    
    Parameters:
    
    word - The word
    
    Returns:
    
    Whether it is reserved
  - initialiseDatastore
```
void initialiseDatastore(Object conn)
```
    Creates the auxiliary functions/procedures in the datastore
    
    Parameters:
    
    conn - the connection to the datastore
  - getIdentifierQuoteString
```
String getIdentifierQuoteString()
```
    Accessor for the quote string to use when quoting identifiers.
    
    Returns:
    
    The quote string for the identifier
  - getCatalogSeparator
```
String getCatalogSeparator()
```
    Accessor for the catalog separator (string to separate the catalog/schema and the identifier).
    
    Returns:
    
    Catalog separator string.
  - getAdapterTime
```
long getAdapterTime(Timestamp time)
```
    Utility to return the adapter time in case there are rounding issues with millisecs etc.
    
    Parameters:
    
    time - The timestamp
    
    Returns:
    
    The time in millisecs
  - getDatastoreProductName
```
String getDatastoreProductName()
```
    Accessor for the datastore product name.
    
    Returns:
    
    product name
  - getDatastoreProductVersion
```
String getDatastoreProductVersion()
```
    Accessor for the datastore product version.
    
    Returns:
    
    product version
  - getDatastoreDriverName
```
String getDatastoreDriverName()
```
    Accessor for the datastore driver name.
    
    Returns:
    
    product name
  - getDatastoreDriverVersion
```
String getDatastoreDriverVersion()
```
    Accessor for the datastore driver version.
    
    Returns:
    
    driver version
  - getDriverMajorVersion
```
int getDriverMajorVersion()
```
    Accessor for the driver major version
    
    Returns:
    
    The driver major version
  - getDriverMinorVersion
```
int getDriverMinorVersion()
```
    Accessor for the driver minor version
    
    Returns:
    
    The driver minor version
  - isIdentityFieldDataType
```
boolean isIdentityFieldDataType(String columnDef)
```
    Verifies if the given columnDef is an identity field type for the datastore.
    
    Parameters:
    
    columnDef - the datastore type name
    
    Returns:
    
    true when the columnDef has values for identity generation in the datastore
  - getDatastoreIdentifierMaxLength
```
int getDatastoreIdentifierMaxLength(IdentifierType identifierType)
```
    Method to return the maximum length of a datastore identifier of the specified type. If no limit exists then returns -1
    
    Parameters:
    
    identifierType - Type of identifier
    
    Returns:
    
    The max permitted length of this type of identifier
  - getAutoIncrementJavaTypeForType
```
Class getAutoIncrementJavaTypeForType(Class type)
```
    Return the java type that represents any autoincrement/identity column value.
    
    Parameters:
    
    type - The type of the member mapping to an IDENTITY column
    
    Returns:
    
    The type that should be used in generating the column
  - getMaxForeignKeys
```
int getMaxForeignKeys()
```
    Accessor for the maximum foreign keys by table permitted in this datastore.
    
    Returns:
    
    Max number of foreign keys
  - getMaxIndexes
```
int getMaxIndexes()
```
    Accessor for the maximum indexes by table permitted in this datastore.
    
    Returns:
    
    Max number of indices
  - supportsQueryFetchSize
```
boolean supportsQueryFetchSize(int size)
```
    Whether the datastore will support setting the query fetch size to the supplied value.
    
    Parameters:
    
    size - The value to set to
    
    Returns:
    
    Whether it is supported.
  - toString
```
String toString()
```
    Method to return this object as a string.
    
    Overrides:
    
    toString in class Object
    
    Returns:
    
    String version of this object.
  - supportsTransactionIsolation
```
boolean supportsTransactionIsolation(int level)
```
    Accessor for whether this database adapter supports the specified transaction isolation.
    
    Parameters:
    
    level - The isolation level (as defined by Connection enums).
    
    Returns:
    
    Whether it is supported.
  - getRangeByLimitEndOfStatementClause
```
String getRangeByLimitEndOfStatementClause(long offset,
                                           long count,
                                           boolean hasOrdering)
```
    Method to return the SQL to append to the end of the SELECT statement to handle restriction of ranges using the LIMIT keyword. Defaults to an empty string (not supported). SELECT param ... WHERE {LIMIT}
    
    Parameters:
    
    offset - The offset to return from
    
    count - The number of items to return
    
    hasOrdering - Whether there is ordering present
    
    Returns:
    
    The SQL to append to allow for ranges using LIMIT.
  - getRangeByRowNumberColumn
```
String getRangeByRowNumberColumn()
```
    Method to return the column name to use when handling ranges via a rownumber on the select using the original method (DB2). Defaults to an empty string (not supported).
    
    Returns:
    
    The row number column.
  - getRangeByRowNumberColumn2
```
String getRangeByRowNumberColumn2()
```
    Method to return the column name to use when handling ranges via a rownumber on the select using the second method (Oracle). Defaults to an empty string (not supported).
    
    Returns:
    
    The row number column.
  - getColumns
```
ResultSet getColumns(Connection conn,
                     String catalog,
                     String schema,
                     String table,
                     String columnNamePattern)
              throws SQLException
```
    Accessor for table and column information for a catalog/schema in this datastore.
    
    Parameters:
    
    conn - Connection to use
    
    catalog - The catalog (null if none)
    
    schema - The schema (null if none)
    
    table - The table (null if all)
    
    columnNamePattern - The column name (null if all)
    
    Returns:
    
    ResultSet containing the table/column information
    
    Throws:
    
    SQLException - Thrown if an error occurs
  - getInsertStatementForNoColumns
```
String getInsertStatementForNoColumns(Table table)
```
    Method to retutn the INSERT statement to use when inserting into a table that has no columns specified. This is the case when we have a single column in the table and that column is autoincrement/identity (and so is assigned automatically in the datastore).
    
    Parameters:
    
    table - The table
    
    Returns:
    
    The statement for the INSERT
  - getUnlimitedLengthPrecisionValue
```
int getUnlimitedLengthPrecisionValue(SQLTypeInfo typeInfo)
```
    Returns the precision value to be used when creating string columns of "unlimited" length. Usually, if this value is needed it is provided in the database metadata. However, for some types in some databases the value must be computed.
    
    Parameters:
    
    typeInfo - the typeInfo object for which the precision value is needed.
    
    Returns:
    
    the precision value to be used when creating the column, or -1 if no value should be used.
  - getAutoIncrementStmt
```
String getAutoIncrementStmt(Table table,
                            String columnName)
```
    Accessor for the auto-increment/identity sql statement for this datastore.
    
    Parameters:
    
    table - Table (that the autoincrement is for)
    
    columnName - (that the autoincrement is for)
    
    Returns:
    
    The statement for getting the latest auto-increment/identity key
  - getAutoIncrementKeyword
```
String getAutoIncrementKeyword()
```
    Accessor for the auto-increment/identity keyword for generating DDLs. (CREATE TABLEs...).
    
    Returns:
    
    The keyword for a column using auto-increment/identity
  - getCreateDatabaseStatement
```
String getCreateDatabaseStatement(String catalogName,
                                  String schemaName)
```
    Method to return the statement necessary to create a database with this RDBMS. Note that some RDBMS don't support this.
    
    Parameters:
    
    catalogName - name of the catalog
    
    schemaName - Name of the schema
    
    Returns:
    
    The DDL statement
  - getDropDatabaseStatement
```
String getDropDatabaseStatement(String catalogName,
                                String schemaName)
```
    Method to return the statement necessary to drop a database with this RDBMS. Note that some RDBMS don't support this.
    
    Parameters:
    
    catalogName - Name of the catalog
    
    schemaName - Name of the schema
    
    Returns:
    
    The DDL statement
  - getDropTableStatement
```
String getDropTableStatement(Table table)
```
    Returns the appropriate SQL to drop the given table. It should return something like:
```
 DROP TABLE FOO CASCADE
 
```
    Parameters:
    
    table - The table to drop.
    
    Returns:
    
    The text of the SQL statement.
  - getDeleteTableStatement
```
String getDeleteTableStatement(SQLTable tbl)
```
    Method to return the basic SQL for a DELETE TABLE statement. Returns a String like
```
DELETE FROM tbl t1
```
    . Doesn't include any where clause.
    Parameters:
    
    tbl - The SQLTable to delete
    
    Returns:
    
    The delete table string
  - getUpdateTableStatement
```
SQLText getUpdateTableStatement(SQLTable tbl,
                                SQLText setSQL)
```
    Method to return the basic SQL for an UPDATE TABLE statement. Returns a String like
```
UPDATE tbl t1 SET x1 = val1
```
    . Doesn't include any WHERE clause.
    Parameters:
    
    tbl - The SQLTable to update
    
    setSQL - The SQLText for the SET component
    
    Returns:
    
    The update table string
  - getAddCandidateKeyStatement
```
String getAddCandidateKeyStatement(CandidateKey ck,
                                   IdentifierFactory factory)
```
    Returns the appropriate SQL to add a candidate key to its table. It should return something like:
```
 ALTER TABLE FOO ADD CONSTRAINT FOO_CK UNIQUE (BAZ)
 
```
    Parameters:
    
    ck - An object describing the candidate key.
    
    factory - Identifier factory
    
    Returns:
    
    The text of the SQL statement.
  - isValidPrimaryKeyType
```
boolean isValidPrimaryKeyType(org.datanucleus.metadata.JdbcType datatype)
```
    Method to return whether the specified JDBC type is valid for use in a PrimaryKey.
    
    Parameters:
    
    datatype - The JDBC type.
    
    Returns:
    
    Whether it is valid for use in the PK
  - getAddColumnStatement
```
String getAddColumnStatement(Table table,
                             Column col)
```
    Accessor for the SQL statement to add a column to a table.
    
    Parameters:
    
    table - The table
    
    col - The column
    
    Returns:
    
    The SQL necessary to add the column
  - getCreateIndexStatement
```
String getCreateIndexStatement(Index idx,
                               IdentifierFactory factory)
```
    Returns the appropriate SQL to add an index to its table. It should return something like:
```
 CREATE INDEX FOO_N1 ON FOO (BAR,BAZ)
 CREATE UNIQUE INDEX FOO_U1 ON FOO (BAR,BAZ)
 
```
    Parameters:
    
    idx - An object describing the index.
    
    factory - Identifier factory
    
    Returns:
    
    The text of the SQL statement.
  - getExistingIndexes
```
ResultSet getExistingIndexes(Connection conn,
                             String catalog,
                             String schema,
                             String table)
                      throws SQLException
```
    Provide the existing indexes in the database for the table
    
    Parameters:
    
    conn - the JDBC connection
    
    catalog - the catalog name
    
    schema - the schema name
    
    table - the table name
    
    Returns:
    
    a ResultSet with the format @see DatabaseMetaData#getIndexInfo(java.lang.String, java.lang.String, java.lang.String, boolean, boolean)
    
    Throws:
    
    SQLException - if an error occurs
  - getCreateTableStatement
```
String getCreateTableStatement(TableImpl table,
                               Column[] columns,
                               Properties props,
                               IdentifierFactory factory)
```
    Returns the appropriate SQL to create the given table having the given columns. No column constraints or key definitions should be included. It should return something like:
```
 CREATE TABLE FOO (BAR VARCHAR(30), BAZ INTEGER)
 
```
    Parameters:
    
    table - The table to create.
    
    columns - The columns of the table.
    
    props - Properties for controlling the table creation
    
    factory - Identifier factory
    
    Returns:
    
    The text of the SQL statement.
  - getAddPrimaryKeyStatement
```
String getAddPrimaryKeyStatement(PrimaryKey pk,
                                 IdentifierFactory factory)
```
    Returns the appropriate SQL to add a primary key to its table. It should return something like:
```
 ALTER TABLE FOO ADD CONSTRAINT FOO_PK PRIMARY KEY (BAR)
 
```
    Parameters:
    
    pk - An object describing the primary key.
    
    factory - Identifier factory
    
    Returns:
    
    The text of the SQL statement.
  - getAddForeignKeyStatement
```
String getAddForeignKeyStatement(ForeignKey fk,
                                 IdentifierFactory factory)
```
    Returns the appropriate SQL to add a foreign key to its table. It should return something like:
```
 ALTER TABLE FOO ADD CONSTRAINT FOO_FK1 FOREIGN KEY (BAR, BAZ) REFERENCES ABC (COL1, COL2)
 
```
    Parameters:
    
    fk - An object describing the foreign key.
    
    factory - Identifier factory
    
    Returns:
    
    The text of the SQL statement.
  - getDropViewStatement
```
String getDropViewStatement(ViewImpl view)
```
    Returns the appropriate SQL to drop the given view. It should return something like:
```
 DROP VIEW FOO
 
```
    Parameters:
    
    view - The view to drop.
    
    Returns:
    
    The text of the SQL statement.
  - getSelectForUpdateText
```
String getSelectForUpdateText()
```
    Method returning the text to append to the end of the SELECT to perform the equivalent of "SELECT ... FOR UPDATE" (on some RDBMS). This method means that we can have different text with some datastores (e.g Derby).
    
    Returns:
    
    The "FOR UPDATE" text
  - getSurrogateForEmptyStrings
```
String getSurrogateForEmptyStrings()
```
    Some databases, Oracle, treats an empty string (0 length) equals null
    
    Returns:
    
    returns a surrogate to replace the empty string in the database otherwise it would be treated as null
  - getTransactionIsolationForSchemaCreation
```
int getTransactionIsolationForSchemaCreation()
```
    Accessor for the transaction isolation level to use during schema creation.
    
    Returns:
    
    The transaction isolation level for schema generation process
  - getRequiredTransactionIsolationLevel
```
int getRequiredTransactionIsolationLevel()
```
    Accessor for the "required" transaction isolation level if it has to be a certain value for this adapter.
    
    Returns:
    
    Transaction isolation level (-1 implies no restriction)
  - getCatalogName
```
String getCatalogName(Connection conn)
               throws SQLException
```
    Accessor for the Catalog Name for this datastore.
    
    Parameters:
    
    conn - Connection to the datastore
    
    Returns:
    
    The catalog name
    
    Throws:
    
    SQLException - Thrown if error occurs in determining the catalog name.
  - getSchemaName
```
String getSchemaName(Connection conn)
              throws SQLException
```
    Accessor for the Schema Name for this datastore.
    
    Parameters:
    
    conn - Connection to the datastore
    
    Returns:
    
    The schema name
    
    Throws:
    
    SQLException - Thrown if error occurs in determining the schema name.
  - getSelectWithLockOption
```
String getSelectWithLockOption()
```
    The option to specify in "SELECT ... FROM TABLE ... WITH (option)" to lock instances Null if not supported.
    
    Returns:
    
    The option to specify with "SELECT ... FROM TABLE ... WITH (option)"
  - getSelectNewUUIDStmt
```
String getSelectNewUUIDStmt()
```
    The function to creates a unique value of type uniqueidentifier.
    
    Returns:
    
    The function. e.g. "SELECT NEWID()"
  - getSequenceNextStmt
```
String getSequenceNextStmt(String sequence_name)
```
    Accessor for the sequence statement to get the next id for this datastore.
    
    Parameters:
    
    sequence_name - Name of the sequence
    
    Returns:
    
    The statement for getting the next id for the sequence
  - getSequenceCreateStmt
```
String getSequenceCreateStmt(String sequence_name,
                             Integer min,
                             Integer max,
                             Integer start,
                             Integer increment,
                             Integer cache_size)
```
    Accessor for the sequence create statement for this datastore.
    
    Parameters:
    
    sequence_name - Name of the sequence
    
    min - Minimum value for the sequence
    
    max - Maximum value for the sequence
    
    start - Start value for the sequence
    
    increment - Increment value for the sequence
    
    cache_size - Cache size for the sequence
    
    Returns:
    
    The statement for getting the next id from the sequence
  - sequenceExists
```
boolean sequenceExists(Connection conn,
                       String catalogName,
                       String schemaName,
                       String seqName)
```
    Convenience method to return whether the specified sequence already exists.
    
    Parameters:
    
    conn - Connection to use for checking
    
    catalogName - Catalog name
    
    schemaName - Schema name
    
    seqName - Name of the sequence
    
    Returns:
    
    Whether it exists
  - iteratorReservedWords
```
Iterator iteratorReservedWords()
```
    Iterator for the reserved words constructed from the method DataBaseMetaData.getSQLKeywords + standard SQL reserved words
    
    Returns:
    
    an Iterator with a set of reserved words
  - getDatastoreDateStatement
```
String getDatastoreDateStatement()
```
    Accessor for a statement that will return the statement to use to get the datastore date.
    
    Returns:
    
    SQL statement to get the datastore date
  - getCheckConstraintForValues
```
String getCheckConstraintForValues(DatastoreIdentifier identifier,
                                   Object[] values,
                                   boolean nullable)
```
    Creates a CHECK constraint definition based on the given values e.g.
```
CHECK ("COLUMN" IN ('VAL1','VAL2') OR "COLUMN" IS NULL)
```
    Parameters:
    
    identifier - Column identifier
    
    values - valid values
    
    nullable - whether the datastore identifier is null
    
    Returns:
    
    The check constraint
  - newSQLTypeInfo
```
SQLTypeInfo newSQLTypeInfo(ResultSet rs)
```
    Create a new SQL type info from the current row of the passed ResultSet. Allows an adapter to override particular types where the JDBC driver is known to be buggy.
    
    Parameters:
    
    rs - ResultSet
    
    Returns:
    
    The SQL type info
  - newRDBMSColumnInfo
```
RDBMSColumnInfo newRDBMSColumnInfo(ResultSet rs)
```
    Create a new column info from the current row of the passed ResultSet. Allows an adapter to override particular column information where the JDBC driver is known to be buggy.
    
    Parameters:
    
    rs - Result Set
    
    Returns:
    
    The column info
  - newFKInfo
```
ForeignKeyInfo newFKInfo(ResultSet rs)
```
    Method to return ForeignKeyInfo for the current row of the ResultSet which will have been obtained from a call to DatabaseMetaData.getImportedKeys() or DatabaseMetaData.getExportedKeys().
    
    Parameters:
    
    rs - The result set returned from DatabaseMetaData.get??portedKeys()
    
    Returns:
    
    The foreign key info
  - getOrderString
```
String getOrderString(org.datanucleus.store.StoreManager storeMgr,
                      String orderString,
                      SQLExpression sqlExpr)
```
    Convenience method to allow adaption of an ordering string before applying it. This is useful where the datastore accepts some conversion adapter around the ordering column for example.
    
    Parameters:
    
    storeMgr - StoreManager
    
    orderString - The basic ordering string
    
    sqlExpr - The sql expression being represented here
    
    Returns:
    
    The adapted ordering string
  - validToSelectMappingInStatement
```
boolean validToSelectMappingInStatement(SQLStatement stmt,
                                        JavaTypeMapping m)
```
    Method to return if it is valid to select the specified mapping for the specified statement for this datastore adapter. Sometimes, dependent on the type of the column(s), and what other components are present in the statement, it may be invalid to select the mapping.
    
    Parameters:
    
    stmt - The statement
    
    m - The mapping that we want to select
    
    Returns:
    
    Whether it is valid
  - isStatementCancel
```
boolean isStatementCancel(SQLException sqle)
```
    return whether this exception represents a cancelled statement.
    
    Parameters:
    
    sqle - the exception
    
    Returns:
    
    whether it is a cancel
  - isStatementTimeout
```
boolean isStatementTimeout(SQLException sqle)
```
    return whether this exception represents a timed out statement.
    
    Parameters:
    
    sqle - the exception
    
    Returns:
    
    whether it is a timeout
  - getNumericConversionFunction
```
String getNumericConversionFunction()
```
    Accessor for the function to use for converting to numeric.
    
    Returns:
    
    The numeric conversion function for this datastore.
  - getEscapePatternExpression
```
String getEscapePatternExpression()
```
    The character for escaping characters in pattern expressions.
    
    Returns:
    
    the character.
  - getEscapeCharacter
```
String getEscapeCharacter()
```
    The character for escaping characters in pattern expressions.
    
    Returns:
    
    the character.
  - getPatternExpressionAnyCharacter
```
String getPatternExpressionAnyCharacter()
```
    The pattern string for representing one character that is expanded in word searches. Most of databases will use the underscore character.
    
    Returns:
    
    the pattern string.
  - getPatternExpressionZeroMoreCharacters
```
String getPatternExpressionZeroMoreCharacters()
```
    The pattern string for representing zero or more characters that is expanded in word searches. Most of databases will use the percent sign character.
    
    Returns:
    
    the pattern string.
  - validToIndexMapping
```
boolean validToIndexMapping(JavaTypeMapping mapping)
```
    Method to return whether the specified mapping is indexable. Allows a datastore to not index particular column types.
    
    Parameters:
    
    mapping - The mapping
    
    Returns:
    
    Whether it is indexable

Interface DatastoreAdapter

Field Summary

Method Summary

Field Detail

IDENTITY_COLUMNS

SEQUENCES

BIT_IS_REALLY_BOOLEAN

RIGHT_OUTER_JOIN

SOME_ANY_ALL_SUBQUERY_EXPRESSIONS

BOOLEAN_COMPARISON

ESCAPE_EXPRESSION_IN_LIKE_PREDICATE

PROJECTION_IN_TABLE_REFERENCE_JOINS

ANALYSIS_METHODS

CATALOGS_IN_TABLE_DEFINITIONS

SCHEMAS_IN_TABLE_DEFINITIONS

IDENTIFIERS_LOWERCASE

IDENTIFIERS_MIXEDCASE

IDENTIFIERS_UPPERCASE

IDENTIFIERS_LOWERCASE_QUOTED

IDENTIFIERS_MIXEDCASE_QUOTED

IDENTIFIERS_UPPERCASE_QUOTED

IDENTIFIERS_MIXEDCASE_SENSITIVE

IDENTIFIERS_MIXEDCASE_QUOTED_SENSITIVE

VIEWS

UNION_SYNTAX

USE_UNION_ALL

EXISTS_SYNTAX

ALTER_TABLE_DROP_CONSTRAINT_SYNTAX

ALTER_TABLE_DROP_FOREIGN_KEY_CONSTRAINT

DEFERRED_CONSTRAINTS

DISTINCT_WITH_SELECT_FOR_UPDATE

GROUPING_WITH_SELECT_FOR_UPDATE

HAVING_WITH_SELECT_FOR_UPDATE

ORDERING_WITH_SELECT_FOR_UPDATE

MULTITABLES_WITH_SELECT_FOR_UPDATE

UPDATE_STATEMENT_ALLOW_TABLE_ALIAS_IN_SET_CLAUSE

UPDATE_DELETE_STATEMENT_ALLOW_TABLE_ALIAS_IN_WHERE_CLAUSE

GROUP_BY_REQUIRES_ALL_SELECT_PRIMARIES

PERSIST_OF_UNASSIGNED_CHAR

CHAR_COLUMNS_PADDED_WITH_SPACES

NULL_EQUALS_EMPTY_STRING

STATEMENT_BATCHING

CHECK_IN_CREATE_STATEMENTS

CHECK_IN_END_CREATE_STATEMENTS

UNIQUE_IN_END_CREATE_STATEMENTS

FK_IN_END_CREATE_STATEMENTS

PRIMARYKEY_IN_CREATE_STATEMENTS

GET_GENERATED_KEYS_STATEMENT

NULLS_IN_CANDIDATE_KEYS

NULLS_KEYWORD_IN_COLUMN_OPTIONS

DEFAULT_KEYWORD_IN_COLUMN_OPTIONS

DEFAULT_KEYWORD_WITH_NOT_NULL_IN_COLUMN_OPTIONS

DEFAULT_BEFORE_NULL_IN_COLUMN_OPTIONS

ANSI_JOIN_SYNTAX

ANSI_CROSSJOIN_SYNTAX

CROSSJOIN_ASINNER11_SYNTAX

AUTO_INCREMENT_KEYS_NULL_SPECIFICATION

AUTO_INCREMENT_COLUMN_TYPE_SPECIFICATION

AUTO_INCREMENT_PK_IN_CREATE_TABLE_COLUMN_DEF

LOCK_WITH_SELECT_FOR_UPDATE

SELECT_FOR_UPDATE_NOWAIT

LOCK_OPTION_PLACED_AFTER_FROM

LOCK_OPTION_PLACED_WITHIN_JOIN

BLOB_SET_USING_SETSTRING

CLOB_SET_USING_SETSTRING

CREATE_INDEXES_BEFORE_FOREIGN_KEYS

INCLUDE_ORDERBY_COLS_IN_SELECT

DATETIME_STORES_MILLISECS

ACCESS_PARENTQUERY_IN_SUBQUERY_JOINED

SUBQUERY_IN_HAVING

ORDERBY_USING_SELECT_COLUMN_INDEX

ORDERBY_NULLS_DIRECTIVES

ORDERBY_NULLS_USING_ISNULL

ORDERBY_NULLS_USING_COLUMN_IS_NULL

ORDERBY_NULLS_USING_CASE_NULL

STORED_PROCEDURES

FK_UPDATE_ACTION_CASCADE

FK_UPDATE_ACTION_DEFAULT

FK_UPDATE_ACTION_NULL

FK_UPDATE_ACTION_RESTRICT