#include <Ccdb_DatabaseMetaData.h>
Static Public Attributes | |
static const int | TRANSACTION_NONE = 0 |
static const int | TRANSACTION_READ_UNCOMMITTED = 1 |
static const int | TRANSACTION_READ_COMMITTED = 2 |
static const int | TRANSACTION_REPEATABLE_READ = 4 |
static const dtLARGE | TRANSACTION_SERIALIZABLE = 8 |
DatabaseMetaData Class provides information about the database as a whole.
Many of the methods here return lists of information in ResultSets. You can use the normal ResultSet methods such as getString and getInt to retrieve the data from these ResultSets. If a given form of metadata is not available, these methods should throw a DatabaseException.
Some of these methods take arguments that are String patterns. These arguments all have names such as fooPattern. Within a pattern String, "%" means match any substring of 0 or more characters, and "_" means match any one character. Only metadata entries matching the search pattern are returned. If a search pattern argument is set to a null ref, it means that argument's criteria should be dropped from the search.
A DatabaseException will be thrown if a database error occurs and exceptions are enabled. If exceptions are not enabled the following error methods can be used to get information about the error;
dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::AllProceduresAreCallable | ( | ) |
Can all the procedures returned by getProcedures be called by the current user?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::AllTablesAreSelectable | ( | ) |
Can all the tables returned by getTables() be SELECTed by the current user?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::AutoCommitFailureClosesAllResultSets | ( | ) |
Retrieves whether a DatabaseException while autoCommit is TRUE
inidicates that all open ResultSets are closed, even ones that are holdable. When a DatabaseException occurs while autocommit is TRUE
, a rollback operation, or by doing neither a commit nor a rollback. A potential result of this difference is in whether or not hold-able ResultSets are closed.
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::DataDefinitionCausesTransactionCommit | ( | ) |
Does a data definition statement within a transaction force the transaction to commit?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::DataDefinitionIgnoredInTransactions | ( | ) |
Is a data definition statement within a transaction ignored?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::DeletesAreDetected | ( | dtLARGE | ) |
Determine whether or not a visible row delete can be detected by calling ResultSet.rowDeleted(). If deletesAreDetected() returns false, then deleted rows are removed from the result set.
type | The resultset type i.e. ResultSet.TYPE_XXX |
TRUE
if changes are detected by the resultset type; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::DoesMaxRowSizeIncludeBlobs | ( | ) |
Did getMaxRowSize() include LONGVARCHAR and LONGVARBINARY blobs?
TRUE
if so; FALSE
if otherwise. ResultSet * dbSpaces::dbcli::DatabaseMetaData::GetBestRowIdentifier | ( | const dtSTRING * | , |
const dtSTRING * | , | ||
const dtSTRING * | , | ||
const | dtSMALL, | ||
const | dtBOOLEAN | ||
) |
Get a description of a table's optimal set of columns that uniquely identifies a row. They are ordered by SCOPE. Each column description has the following columns: <OL> <LI><B>SCOPE</B> dtSMALL => actual scope of result <UL> <LI> bestRowTemporary - very temporary, while using row <LI> bestRowTransaction - valid for remainder of current transaction <LI> bestRowSession - valid for remainder of current session </UL> <LI><B>COLUMN_NAME</B> dtSTRING* => column name <LI><B>DATA_TYPE</B> dtSMALL => SQL data type <LI><B>TYPE_NAME</B> dtSTRING* => Data source dependent type name, for a UDT the type name is fully qualified <LI><B>COLUMN_SIZE</B> dtLARGE => precision <LI><B>BUFFER_LENGTH</B> dtLARGE => not used <LI><B>DECIMAL_DIGITS</B> dtSMALL => scale <LI><B>PSEUDO_COLUMN</B> dtSMALL => is this a pseudo column like an Oracle ROWID <UL> <LI> bestRowUnknown - may or may not be pseudo column <LI> bestRowNotPseudo - is NOT a pseudo column <LI> bestRowPseudo - is a pseudo column </UL>
@param catalogName A catalog name; "" retrieves those without a catalog, null means drop catalog name from the selection criteria @param schemaName A schema name; "" retrieves those without a schema @param tableName A table name @param scope The scope of interest; use same values as SCOPE @param nullable Include columns that are nullable? @return ResultSet Each row is a column description @throws DatabaseException (if exceptions are enabled) when a database error occurs. @since Version 1.0
ResultSet * dbSpaces::dbcli::DatabaseMetaData::GetCatalogs | ( | ) |
const dtSTRING * dbSpaces::dbcli::DatabaseMetaData::GetCatalogSeparator | ( | ) |
What's the separator between catalog and table name?
const dtSTRING * dbSpaces::dbcli::DatabaseMetaData::GetCatalogTerm | ( | ) |
What's the database vendor's preferred term for "catalog"?
ResultSet * dbSpaces::dbcli::DatabaseMetaData::GetColumnPrivileges | ( | const dtSTRING * | , |
const dtSTRING * | , | ||
const dtSTRING * | , | ||
const dtSTRING * | |||
) |
Get a description of the access rights for a table's columns.
Only privileges matching the column name criteria are returned. They are ordered by COLUMN_NAME and PRIVILEGE.
Each privilege description has the following columns:
catalogName | - a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria |
schemaName | - a schema name; "" retrieves those without a schema |
tableName | - a table name |
columnNamePattern | - a column name pattern |
DatabaseException | (if exceptions are enabled) when a database error occurs. |
ResultSet * dbSpaces::dbcli::DatabaseMetaData::GetColumns | ( | const dtSTRING * | , |
const dtSTRING * | , | ||
const dtSTRING * | , | ||
const dtSTRING * | |||
) |
Get a description of table columns available in a catalog.
Only column descriptions matching the catalog, schema, table and column name criteria are returned. They are ordered by TABLE_SCHEM, TABLE_NAME and ORDINAL_POSITION.
Each column description has the following columns:
catalogName | A catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria |
schemaPattern | A schema name pattern; "" retrieves those without a schema |
tableNamePattern | A table name pattern |
columnNamePattern | A column name pattern |
DatabaseException | (if exceptions are enabled) when a database error occurs. |
ResultSet * dbSpaces::dbcli::DatabaseMetaData::GetCrossReference | ( | const dtSTRING * | , |
const dtSTRING * | , | ||
const dtSTRING * | , | ||
const dtSTRING * | , | ||
const dtSTRING * | , | ||
const dtSTRING * | |||
) |
Get a description of the foreign key columns in the foreign key table that reference the primary key columns of the primary key table (describe how one table imports another's key.) This should normally return a single foreign key/primary key pair (most tables only import a foreign key from a table once.) They are ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and KEY_SEQ.
Each foreign key column description has the following columns:
primaryCatalog | A catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria |
primarySchema | A schema name; "" retrieves those without a schema |
primaryTable | The table name that exports the key |
foreignCatalog | A catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria |
foreignSchema | A schema name; "" retrieves those without a schema |
foreignTable | The table name that imports the key |
DatabaseException | (if exceptions are enabled) when a database error occurs. |
dtLARGE dbSpaces::dbcli::DatabaseMetaData::GetDatabaseMajorVersion | ( | ) |
Return the database major version.
dtLARGE dbSpaces::dbcli::DatabaseMetaData::GetDatabaseMinorVersion | ( | ) |
Return the database minor version.
const dtSTRING * dbSpaces::dbcli::DatabaseMetaData::GetDatabaseProductName | ( | ) |
What's the name of this database product?
const dtSTRING * dbSpaces::dbcli::DatabaseMetaData::GetDatabaseProductVersion | ( | ) |
What's the version of this database product?
DatabaseException | (if exceptions are enabled) when a database error occurs. |
dtLARGE dbSpaces::dbcli::DatabaseMetaData::GetDefaultTransactionIsolation | ( | ) |
What's the database's default transaction isolation level? The values are defined in Connection.
ResultSet * dbSpaces::dbcli::DatabaseMetaData::GetExportedKeys | ( | const dtSTRING * | , |
const dtSTRING * | , | ||
const dtSTRING * | |||
) |
Get a description of the foreign key columns that reference a table's primary key columns (the foreign keys exported by a table). They are ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and KEY_SEQ.
Each foreign key column description has the following columns:
catalogName | A catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria |
schemaName | A schema name; "" retrieves those without a schema |
tableName | A table name |
DatabaseException | (if exceptions are enabled) when a database error occurs. |
const dtSTRING * dbSpaces::dbcli::DatabaseMetaData::GetIdentifierQuotedString | ( | ) |
What's the string used to quote SQL identifiers? This returns a space " " if identifier quoting isn't supported.
ResultSet * dbSpaces::dbcli::DatabaseMetaData::GetImportedKeys | ( | const dtSTRING * | , |
const dtSTRING * | , | ||
const dtSTRING * | |||
) |
Get a description of the primary key columns that are referenced by a table's foreign key columns (the primary keys imported by a table). They are ordered by PKTABLE_CAT, PKTABLE_SCHEM, PKTABLE_NAME, and KEY_SEQ.
Each primary key column description has the following columns:
catalogName | A catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria |
schemaName | A schema name; "" retrieves those without a schema |
tableName | A table name |
DatabaseException | (if exceptions are enabled) when a database error occurs. |
ResultSet * dbSpaces::dbcli::DatabaseMetaData::GetIndexInfo | ( | const dtSTRING * | , |
const dtSTRING * | , | ||
const dtSTRING * | , | ||
const | dtBOOLEAN, | ||
const | dtBOOLEAN | ||
) |
Get a description of a table's indices and statisticallStmt. They are ordered by NON_UNIQUE, TYPE, INDEX_NAME, and ORDINAL_POSITION.
Each index column description has the following columns:
catalogName | A catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria |
schemaName | A schema name; "" retrieves those without a schema |
tableName | A table name |
unique | When TRUE , return only indices for unique values; when FALSE , return indices regardless of whether unique or not |
approximate | When TRUE , result is allowed to reflect approximate or out of data values; when FALSE , results are requested to be accurate |
DatabaseException | (if exceptions are enabled) when a database error occurs. |
dtLARGE dbSpaces::dbcli::DatabaseMetaData::GetMaxBinaryLiteralLength | ( | ) |
How many hex characters can you have in an inline binary literal?
dtLARGE dbSpaces::dbcli::DatabaseMetaData::GetMaxCatalogNameLength | ( | ) |
What's the maximum length of a catalog name?
dtLARGE dbSpaces::dbcli::DatabaseMetaData::GetMaxCharLiteralLength | ( | ) |
What's the max length for a character literal?
dtLARGE dbSpaces::dbcli::DatabaseMetaData::GetMaxColumnNameLength | ( | ) |
What's the limit on column name length?
dtLARGE dbSpaces::dbcli::DatabaseMetaData::GetMaxColumnsInGroupBy | ( | ) |
What's the maximum number of columns in a "GROUP BY" clause?
dtLARGE dbSpaces::dbcli::DatabaseMetaData::GetMaxColumnsInIndex | ( | ) |
What's the maximum number of columns allowed in an index?
dtLARGE dbSpaces::dbcli::DatabaseMetaData::GetMaxColumnsInOrderBy | ( | ) |
What's the maximum number of columns in an "ORDER BY" clause?
dtLARGE dbSpaces::dbcli::DatabaseMetaData::GetMaxColumnsInSelect | ( | ) |
What's the maximum number of columns in a "SELECT" list?
dtLARGE dbSpaces::dbcli::DatabaseMetaData::GetMaxColumnsInTable | ( | ) |
What's the maximum number of columns in a table?
dtLARGE dbSpaces::dbcli::DatabaseMetaData::GetMaxConnections | ( | ) |
How many active connections can we have at a time to this database?
DatabaseException | (if exceptions are enabled) when a database error occurs. |
dtLARGE dbSpaces::dbcli::DatabaseMetaData::GetMaxCursorNameLength | ( | ) |
What's the maximum cursor name length?
dtLARGE dbSpaces::dbcli::DatabaseMetaData::GetMaxCursors | ( | ) |
How many active statements can we have open at one time to this database?
dtLARGE dbSpaces::dbcli::DatabaseMetaData::GetMaxIndexLength | ( | ) |
What's the maximum length of an index (in bytes)?
dtLARGE dbSpaces::dbcli::DatabaseMetaData::GetMaxProcedureNameLength | ( | ) |
What's the maximum length of a procedure name?
dtLARGE dbSpaces::dbcli::DatabaseMetaData::GetMaxRowSize | ( | ) |
What's the maximum length of a single row?
dtLARGE dbSpaces::dbcli::DatabaseMetaData::GetMaxSchemaNameLength | ( | ) |
What's the maximum length allowed for a schema name?
dtLARGE dbSpaces::dbcli::DatabaseMetaData::GetMaxStatementLength | ( | ) |
What's the maximum length of a SQL statement?
dtLARGE dbSpaces::dbcli::DatabaseMetaData::GetMaxTableNameLength | ( | ) |
What's the maximum length of a table name?
dtLARGE dbSpaces::dbcli::DatabaseMetaData::GetMaxTablesInSelect | ( | ) |
What's the maximum number of tables in a SELECT?
dtLARGE dbSpaces::dbcli::DatabaseMetaData::GetMaxUserNameLength | ( | ) |
What's the maximum length of a user name?
const dtSTRING * dbSpaces::dbcli::DatabaseMetaData::GetNumericFunctions | ( | ) |
Get a comma separated list of math functions. These are the X/Open CLI math function names used in the function escape clause.
ResultSet * dbSpaces::dbcli::DatabaseMetaData::GetPrimaryKeys | ( | const dtSTRING * | , |
const dtSTRING * | , | ||
const dtSTRING * | |||
) |
Get a description of a table's primary key columns. They are ordered by COLUMN_NAME.
Each primary key column description has the following columns:
catalogName | A catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria |
schemaName | A schema name; "" retrieves those without a schema |
tableName | A table name |
DatabaseException | (if exceptions are enabled) when a database error occurs. |
ResultSet * dbSpaces::dbcli::DatabaseMetaData::GetProcedureColumns | ( | const dtSTRING * | , |
const dtSTRING * | , | ||
const dtSTRING * | , | ||
const dtSTRING * | |||
) |
Get a description of a catalog's stored procedure parameters and result columns. Only descriptions matching the schema, procedure and parameter name criteria are returned. They are ordered by PROCEDURE_SCHEM and PROCEDURE_NAME. Within this, the return value, if any, is first. Next are the parameter descriptions in call order. The column descriptions follow in column number order. Each row in the ResultSet is a parameter description or column description with the following fields: <OL> <LI><B>PROCEDURE_CAT</B> dtSTRING* => procedure catalog (may be null) <LI><B>PROCEDURE_SCHEM</B> dtSTRING* => procedure schema (may be null) <LI><B>PROCEDURE_NAME</B> dtSTRING* => procedure name <LI><B>COLUMN_NAME</B> dtSTRING* => column/parameter name <LI><B>COLUMN_TYPE</B> dtSMALL => kind of column/parameter: <UL> <LI> procedureColumnUnknown - nobody knows <LI> procedureColumnIn - IN parameter <LI> procedureColumnInOut - INOUT parameter <LI> procedureColumnOut - OUT parameter <LI> procedureColumnReturn - procedure return value <LI> procedureColumnResult - result column in ResultSet </UL>
DATA_TYPE dtSMALL => SQL type TYPE_NAME dtSTRING* => SQL type name, for a UDT type the type name is fully qualified PRECISION dtLARGE => precision LENGTH dtLARGE => length in bytes of data SCALE dtSMALL => scale RADIX dtSMALL => radix NULLABLE dtSMALL => can it contain NULL?
REMARKS dtSTRING* => comment describing parameter/column
Note: Some databases may not return the column descriptions for a procedure. Additional columns beyond REMARKS can be defined by the database.
catalogName | A catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria |
schemaPattern | A schema name pattern; "" retrieves those without a schema |
procedureNamePattern | A procedure name pattern |
columnNamePattern | A column name pattern |
DatabaseException | (if exceptions are enabled) when a database error occurs. |
ResultSet * dbSpaces::dbcli::DatabaseMetaData::GetProcedurePrivileges | ( | const dtSTRING * | , |
const dtSTRING * | , | ||
const dtSTRING * | |||
) |
Get a description of the access rights for each procedure available in a catalog. Note that a procedure privilege applies to one or more parameters in the procedure. It would be wrong to assume that this privilege applies to all parameters (this may be true for some systems but is not true for all.)
Only privileges matching the schema and procedure name criteria are returned. They are ordered by PROC_SCHEM, PROC_NAME, and PRIVILEGE.
Each privilege description has the following columns:
catalogName | A catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria |
schemaPattern | A schema name pattern; "" retrieves those without a schema |
procedureNamePattern | A procedure name pattern |
DatabaseException | (if exceptions are enabled) when a database error occurs. |
ResultSet * dbSpaces::dbcli::DatabaseMetaData::GetProcedures | ( | const dtSTRING * | , |
const dtSTRING * | , | ||
const dtSTRING * | |||
) |
Get a description of stored procedures available in a catalog.
Only procedure descriptions matching the schema and procedure name criteria are returned. They are ordered by PROCEDURE_SCHEM, and PROCEDURE_NAME.
Each procedure description has the the following columns:
catalogName | A catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria |
schemaPattern | A schema name pattern; "" retrieves those without a schema |
procedureNamePattern | A procedure name pattern |
DatabaseException | (if exceptions are enabled) when a database error occurs. |
const dtSTRING * dbSpaces::dbcli::DatabaseMetaData::GetProcedureTerm | ( | ) |
What's the database preferred term for "procedure"?
ResultSet * dbSpaces::dbcli::DatabaseMetaData::GetSchemas | ( | ) |
Get the schema names available in this database. The results are ordered by schema name.
The schema column is:
DatabaseException | (if exceptions are enabled) when a database error occurs. |
ResultSet * dbSpaces::dbcli::DatabaseMetaData::GetSchemas | ( | const dtSTRING * | , |
const dtSTRING * | |||
) |
Retrieves the schema names available in this database. The results are ordered by TABLE_CATALOG
and TABLE_SCHEM
.
The schema columns are:
null
) catalogName | A catalog name; must match the catalog name as it is stored in the database;"" retrieves those without a catalog; null means catalog name should not be used to narrow down the search. |
schemaPattern | A schema name; must match the schema name as it is stored in the database; null means schema name should not be used to narrow down the search. |
DatabaseException | (if exceptions are enabled) when a database error occurs. |
const dtSTRING * dbSpaces::dbcli::DatabaseMetaData::GetSchemaTerm | ( | ) |
What's the database preferred term for "schema"?
const dtSTRING * dbSpaces::dbcli::DatabaseMetaData::GetSearchEscape | ( | ) |
This is the string that can be used to escape '_' or '' in the string pattern style catalog search parameters.
The '_' character represents any single character.
The '' character represents any sequence of zero or more characters.
const dtSTRING * dbSpaces::dbcli::DatabaseMetaData::GetSQLKeywords | ( | ) |
Get a comma separated list of all a database's SQL keywords that are NOT also SQL92 keywords.
dtLARGE dbSpaces::dbcli::DatabaseMetaData::GetSQLStateType | ( | ) |
Indicates whether the SQLSTATE returned by DatabaseException.getSQLState
is X/Open (now known as Open Group) SQL CLI or SQL:2003.
const dtSTRING * dbSpaces::dbcli::DatabaseMetaData::GetStringFunctions | ( | ) |
Get a comma separated list of string functions. These are the X/Open CLI string function names used in the JDBC function escape clause.
const dtSTRING * dbSpaces::dbcli::DatabaseMetaData::GetSystemFunctions | ( | ) |
Get a comma separated list of system functions. These are the X/Open CLI system function names used in the function escape clause.
ResultSet * dbSpaces::dbcli::DatabaseMetaData::GetTablePrivileges | ( | const dtSTRING * | , |
const dtSTRING * | , | ||
const dtSTRING * | |||
) |
Get a description of the access rights for each table available in a catalog. Note that a table privilege applies to one or more columns in the table. It would be wrong to assume that this privilege applies to all columns (this may be true for some systems but is not true for all.)
Only privileges matching the schema and table name criteria are returned. They are ordered by TABLE_SCHEM, TABLE_NAME, and PRIVILEGE.
Each privilege description has the following columns:
catalogName | A catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria |
schemaPattern | A schema name pattern; "" retrieves those without a schema |
tableNamePattern | A table name pattern |
DatabaseException | (if exceptions are enabled) when a database error occurs. |
ResultSet * dbSpaces::dbcli::DatabaseMetaData::GetTables | ( | const dtSTRING * | , |
const dtSTRING * | , | ||
const dtSTRING * | , | ||
const dtSTRING * | |||
) |
Get a description of tables available in a catalog.
Only table descriptions matching the catalog, schema, table name and type criteria are returned. They are ordered by TABLE_TYPE, TABLE_SCHEM and TABLE_NAME.
Each table description has the following columns:
Note: Some databases may not return information for all tables.
catalogName | A catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria |
schemaPattern | A schema name pattern; "" retrieves those without a schema |
tableNamePattern | A table name pattern |
types | A list of table types to include; null returns all types |
DatabaseException | (if exceptions are enabled) when a database error occurs. |
ResultSet * dbSpaces::dbcli::DatabaseMetaData::GetTableTypes | ( | ) |
Get the table types available in this database. The results are ordered by table type.
The table type is:
DatabaseException | (if exceptions are enabled) when a database error occurs. |
const dtSTRING * dbSpaces::dbcli::DatabaseMetaData::GetTimeDateFunctions | ( | ) |
Get a comma separated list of time and date functions.
ResultSet * dbSpaces::dbcli::DatabaseMetaData::GetTypeInfo | ( | const | dtSMALL = 0 | ) |
Get a description of all the standard SQL types supported by this database. They are ordered by DATA_TYPE and then by how closely the data type maps to the corresponding JDBC SQL type.
Each type description has the following columns:
SQLType | SQL Type to return result for (ZERO returns all types). |
DatabaseException | (if exceptions are enabled) when a database error occurs. |
ResultSet * dbSpaces::dbcli::DatabaseMetaData::GetVersionColumns | ( | const dtSTRING * | , |
const dtSTRING * | , | ||
const dtSTRING * | |||
) |
Get a description of a table's columns that are automatically updated when any value in a row is updated. They are unordered.
Each column description has the following columns:
catalogName | A catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria |
schemaName | A schema name; "" retrieves those without a schema |
tableName | A table name |
DatabaseException | (if exceptions are enabled) when a database error occurs. |
dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::InsertsAreDetected | ( | const | dtLARGE | ) |
Determine whether or not a visible row insert can be detected by calling ResultSet.rowInserted().
type | The result set type, i.e. ResultSet.TYPE_XXX |
TRUE
if changes are detected by the resultset type; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::IsCatalogAtStart | ( | ) |
Does a catalog appear at the start of a qualified table name? (Otherwise it appears at the end)
TRUE
if it appears at the start; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::IsReadOnly | ( | ) |
Is the database in read-only mode?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::NullPlusNonNullIsNull | ( | ) |
Are concatenations between NULL and non-NULL values NULL?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::NullsAreSortedAtEnd | ( | ) |
Are NULL values sorted at the end regardless of sort order?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::NullsAreSortedAtStart | ( | ) |
Are NULL values sorted at the start regardless of sort order?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::NullsAreSortedHigh | ( | ) |
Are NULL values sorted high?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::NullsAreSortedLow | ( | ) |
Are NULL values sorted low?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::OthersDeletesAreVisible | ( | const | dtLARGE | ) |
Retrieves whether deletes made by others are visible.
type | The ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY , ResultSet.TYPE_SCROLL_INSENSITIVE , or ResultSet.TYPE_SCROLL_SENSITIVE |
TRUE
if deletes made by others are visible for the given result set type; FALSE
otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::OthersInsertsAreVisible | ( | const | dtLARGE | ) |
Retrieves whether inserts made by others are visible.
type | The ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY , ResultSet.TYPE_SCROLL_INSENSITIVE , or ResultSet.TYPE_SCROLL_SENSITIVE |
TRUE
if inserts made by others are visible for the given result set type; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::OthersUpdatesAreVisible | ( | const | dtLARGE | ) |
Determine whether changes made by others are visible.
type | The resultset type, i.e. ResultSet.TYPE_XXX |
TRUE
if changes are visible for the result set type. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::OwnDeletesAreVisible | ( | const | dtLARGE | ) |
Retrieves whether a result set's own deletes are visible.
type | The ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY , ResultSet.TYPE_SCROLL_INSENSITIVE , or ResultSet.TYPE_SCROLL_SENSITIVE |
TRUE
if deletes are visible for the given result set type; false
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::OwnInsertsAreVisible | ( | const | dtLARGE | ) |
Retrieves whether a result set's own inserts are visible.
type | The ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY , ResultSet.TYPE_SCROLL_INSENSITIVE , or ResultSet.TYPE_SCROLL_SENSITIVE |
TRUE
if inserts are visible for the given result set type; false
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::OwnUpdatesAreVisible | ( | const | dtLARGE | ) |
Retrieves whether for the given type of ResultSet object, the result set's own updates are visible.
type | The ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY , ResultSet.TYPE_SCROLL_INSENSITIVE , or ResultSet.TYPE_SCROLL_SENSITIVE |
TRUE
if updates are visible for the given result set type; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::StoresLowerCaseIdentifiers | ( | ) |
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in lower case?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::StoresLowerCaseQuotedIdentifiers | ( | ) |
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in lower case?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::StoresMixedCaseIdentifiers | ( | ) |
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in mixed case?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::StoresMixedCaseQuotedIdentifiers | ( | ) |
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in mixed case?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::StoresUpperCaseIdentifiers | ( | ) |
Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in upper case?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::StoresUpperCaseQuotedIdentifiers | ( | ) |
Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in upper case?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsAlterTableWithAddColumn | ( | ) |
Is "ALTER TABLE" with add column supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsAlterTableWithDropColumn | ( | ) |
Is "ALTER TABLE" with drop column supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsANSI92EntryLevelSQL | ( | ) |
Is the ANSI92 entry level SQL grammar supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsANSI92FullSQL | ( | ) |
Is the ANSI92 full SQL grammar supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsANSI92IntermediateSQL | ( | ) |
Is the ANSI92 intermediate SQL grammar supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsBatchUpdates | ( | ) |
Does the database support batch update? @return <code>TRUE</code> if batch updates are supported; <code>FALSE</code>
if otherwise.
dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsCatalogsInDataManipulation | ( | ) |
Can a catalog name be used in a data manipulation statement?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsCatalogsInIndexDefinitions | ( | ) |
Can a catalog name be used in an index definition statement?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsCatalogsInPrivilegeDefinitions | ( | ) |
Can a catalog name be used in a privilege definition statement?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsCatalogsInProcedureCalls | ( | ) |
Can a catalog name be used in a procedure call statement?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsCatalogsInTableDefinitions | ( | ) |
Can a catalog name be used in a table definition statement?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsColumnAliasing | ( | ) |
Is column aliasing supported?
If so, the SQL AS clause can be used to provide names for computed columns or to provide alias names for columns as required.
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsConvert | ( | ) |
Is the CONVERT function between SQL types supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsConvert | ( | const | dtLARGE, |
const | dtLARGE | ||
) |
Is CONVERT between the given SQL types supported?
fromType | The type to convert from. |
toType | The type to convert to. |
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsCoreSQLGrammar | ( | ) |
Is the Core SQL grammar supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsCorrelatedSubqueries | ( | ) |
Are correlated subqueries supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsDataDefinitionAndDataManipulationTransactions | ( | ) |
Are both data definition and data manipulation statements within a transaction supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsDataManipulationTransactionsOnly | ( | ) |
Are only data manipulation statements within a transaction supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsDifferentTableCorrelationNames | ( | ) |
If table correlation names are supported, are they restricted to be different from the names of the tables?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsExpressionsInOrderBy | ( | ) |
Are expressions in "ORDER BY" lists supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsExtendedSQLGrammar | ( | ) |
Is Extended SQL grammar supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsFullOuterJoins | ( | ) |
Are full nested outer joins supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsGetGeneratedKeys | ( | ) |
Retrieves whether auto-generated keys can be retrieved after a statement has been executed.
TRUE
if auto-generated keys can be retrieved after a statement has executed; false
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsGroupBy | ( | ) |
Is some form of "GROUP BY" clause supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsGroupByBeyondSelect | ( | ) |
Can a "GROUP BY" clause add columns not in the SELECT provided it specifies all the columns in the SELECT?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsGroupByUnrelated | ( | ) |
Can a "GROUP BY" clause use columns not in the SELECT?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsIntegrityEnhancementFacility | ( | ) |
Is the SQL Integrity Enhancement Facility supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsLikeEscapeClause | ( | ) |
Is the escape character in "LIKE" clauses supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsLimitedOuterJoins | ( | ) |
Is there limited support for outer joins? (This will be true if supportFullOuterJoins is true.)
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsMinimumSQLGrammar | ( | ) |
Is the Minimum SQL grammar supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsMixedCaseIdentifiers | ( | ) |
Does the database treat mixed case unquoted SQL identifiers as case sensitive and as a result store them in mixed case?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsMixedCaseQuotedIdentifiers | ( | ) |
Does the database treat mixed case quoted SQL identifiers as case sensitive and as a result store them in mixed case?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsMultipleOpenResults | ( | ) |
Retrieves whether it is possible to have multiple ResultSet objects returned from a Statment object simultaneously.
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsMultipleResultSets | ( | ) |
Are multiple ResultSets from a single execute supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsMultipleTransactions | ( | ) |
Can we have multiple transactions open at once (on different connections)?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsNamedParameters | ( | ) |
Does dynamic SQL statements support named parameters?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsNonNullableColumns | ( | ) |
Can columns be defined as non-nullable?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsOpenCursorsAcrossCommit | ( | ) |
Can cursors remain open across commits?
TRUE
if cursors always remain open; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsOpenCursorsAcrossRollback | ( | ) |
Can cursors remain open across rollbacks?
TRUE
if cursors always remain open; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsOpenStatementsAcrossCommit | ( | ) |
Can statements remain open across commits?
TRUE
if statements always remain open; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsOpenStatementsAcrossRollback | ( | ) |
Can statements remain open across rollbacks?
TRUE
if statements always remain open; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsOrderByUnrelated | ( | ) |
Can an "ORDER BY" clause use columns not in the SELECT?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsOuterJoins | ( | ) |
Is some form of outer join supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsPositionedDelete | ( | ) |
Is positioned DELETE supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsPositionedUpdate | ( | ) |
Is positioned UPDATE supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsResultSetConcurrency | ( | const | dtLARGE, |
const | dtLARGE | ||
) |
Does the database support the concurrency type in combination with the given result set type?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsResultSetHoldability | ( | const | dtLARGE | ) |
Retrieves whether this database supports the given result set holdability.
holdability | One of the following constants: ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT |
TRUE
if so; FALSE
if otherwise. DatabaseException | (if exceptions are enabled) when a database error occurs |
dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsResultSetType | ( | const | dtLARGE | ) |
Does the database support the given result set type?
type | Defined in ResultSet |
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsSavepoints | ( | ) |
Does transactions support savepoints?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsSchemasInDataManipulation | ( | ) |
Can a schema name be used in a data manipulation statement?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsSchemasInIndexDefinitions | ( | ) |
Can a schema name be used in an index definition statement?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsSchemasInPrivilegeDefinitions | ( | ) |
Can a schema name be used in a privilege definition statement?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsSchemasInProcedureCalls | ( | ) |
Can a schema name be used in a procedure call statement?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsSchemasInTableDefinitions | ( | ) |
Can a schema name be used in a table definition statement?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsSelectForUpdate | ( | ) |
Is SELECT for UPDATE supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsStatementPooling | ( | ) |
Is statement pooling supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsStoredFunctionsUsingCallSyntax | ( | ) |
Retrieves whether this database supports invoking user-defined or system functions using the stored procedure escape syntax.
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsStoredProcedures | ( | ) |
Are stored procedure calls using the stored procedure escape syntax supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsSubqueriesInComparisons | ( | ) |
Are sub-queries in comparison expressions supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsSubqueriesInExists | ( | ) |
Are sub-queries in 'exists' expressions supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsSubqueriesInIns | ( | ) |
Are sub-queries in 'in' statements supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsSubqueriesInQuantifieds | ( | ) |
Are sub-queries in quantified expressions supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsTableCorrelationNames | ( | ) |
Are table correlation names supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsTransactionIsolationLevel | ( | dtLARGE | ) |
Does the database support the given transaction isolation level?
level | The values are defined in Connection |
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsTransactions | ( | ) |
Are transactions supported? If not, commit is ignored and the isolation level is TRANSACTION_NONE.
TRUE
if transactions are supported; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsUnion | ( | ) |
Is SQL UNION supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::SupportsUnionAll | ( | ) |
Is SQL UNION ALL supported?
TRUE
if so; FALSE
if otherwise. dtBOOLEAN dbSpaces::dbcli::DatabaseMetaData::UpdatesAreDetected | ( | const | dtLARGE | ) |
Determine whether or not a visible row update can be detected by calling ResultSet.rowUpdated().
type | The result set type, i.e. ResultSet.TYPE_XXX |
TRUE
if changes are detected by the resultset type; FALSE
if otherwise.
|
static |
Transactions are not supported.
|
static |
Dirty reads are prevented; non-repeatable reads and phantom reads can occur. This level only prohibits a transaction from reading a row with uncommitted changes in it.
|
static |
Dirty reads, non-repeatable reads and phantom reads can occur. This level allows a row changed by one transaction to be read by another transaction before any changes in that row have been committed (a "dirty read"). If any of the changes are rolled back, the second transaction will have retrieved an invalid row.
|
static |
Dirty reads and non-repeatable reads are prevented; phantom reads can occur. This level prohibits a transaction from reading a row with uncommitted changes in it, and it also prohibits the situation where one transaction reads a row, a second transaction alters the row, and the first transaction rereads the row, getting different values the second time (a "non-repeatable read").
|
static |
Dirty reads, non-repeatable reads and phantom reads are prevented. This level includes the prohibitions in TRANSACTION_REPEATABLE_READ and further prohibits the situation where one transaction reads all rows that satisfy a WHERE condition, a second transaction inserts a row that satisfies that WHERE condition, and the first transaction rereads for the same condition, retrieving the additional "phantom" row in the second read.