Apache Derby Database Engine and Embedded JDBC Driver 10.17.1.0 · org.apache.derby.impl.jdbc.EmbedDatabaseMetaData

Modifier and Type	Field and Description
private GenericConstantActionFactory	constantActionFactory
private static final int	ILLEGAL_UDT_TYPE
private static Properties	queryDescriptions Cached query descriptions from metadata.properties.
private static Properties	queryDescriptions_net Cached query descriptions from metadata_net.properties.
private final String	url

Access	Constructor and Description
public	EmbedDatabaseMetaData(EmbedConnection connection, String url)

Method Summary

Modifier and Type	Method and Description
public boolean	Returns: true if so allProceduresAreCallable() Implements java.sql.DatabaseMetaData.allProceduresAreCallable. Can all the procedures returned by getProcedures be called by the current user?
public boolean	Returns: true if so allTablesAreSelectable() Implements java.sql.DatabaseMetaData.allTablesAreSelectable. Can all the tables returned by getTable be SELECTed by the current user?
public boolean	Returns: `true`, since the embedded driver will close the open `ResultSet`s autoCommitFailureClosesAllResultSets() Implements java.sql.DatabaseMetaData.autoCommitFailureClosesAllResultSets. Returns whether or not all open `ResultSet`s on a `Connection` are closed if an error occurs when auto-commit in enabled.
public boolean	Returns: true if so dataDefinitionCausesTransactionCommit() Implements java.sql.DatabaseMetaData.dataDefinitionCausesTransactionCommit. Does a data definition statement within a transaction force the transaction to commit?
public boolean	Returns: true if so dataDefinitionIgnoredInTransactions() Implements java.sql.DatabaseMetaData.dataDefinitionIgnoredInTransactions. Is a data definition statement within a transaction ignored?
public boolean	Returns: true if deletes are detected by the resultset type deletesAreDetected(int result set type, i.e. ResultSet.TYPE_XXX type) Implements java.sql.DatabaseMetaData.deletesAreDetected. JDBC 2.0 Determine whether or not a visible row delete can be detected by calling ResultSet.rowDeleted().
public boolean	Returns: true if so doesMaxRowSizeIncludeBlobs() Implements java.sql.DatabaseMetaData.doesMaxRowSizeIncludeBlobs. Did getMaxRowSize() include LONGVARCHAR and LONGVARBINARY blobs?
private ResultSet	doGetBestRowId(String catalogPattern, String schemaPattern, String table, int scope, boolean nullable, String Prefix to be appended to the names of the queries used in this method. This is used to determine whether the result set should conform to JDBC or ODBC specifications. queryPrefix) Does the actual work for the getBestRowIdentifier metadata calls.
private ResultSet	doGetCols(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern, String Name of the query to execute; is used to determine whether the result set should conform to JDBC or ODBC specifications. queryName) Does the actual work for the getColumns metadata calls.
private ResultSet	doGetIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate, String Name of the query to execute; is used to determine whether the result set should conform to JDBC or ODBC specifications. queryName) Does the actual work for the getIndexInfo metadata calls.
private ResultSet	doGetProcCols(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern, String Name of the query to execute; is used to determine whether the result set should conform to JDBC or ODBC specifications. queryName) Does the actual work for the getProcedureColumns metadata calls.
private ResultSet	doGetProcs(String catalog, String schemaPattern, String procedureNamePattern, String Name of the query to execute; is used to determine whether the result set should conform to JDBC or ODBC specifications. queryName) Does the actual work for the getProcedures and getFunctions metadata calls.
private ResultSet	doGetVersionCols(String catalog, String schema, String table, String Name of the query to execute; is used to determine whether the result set should conform to JDBC or ODBC specifications. queryName) Does the actual work for the getVersionColumns metadata calls.
public boolean	generatedKeyAlwaysReturned() Implements java.sql.DatabaseMetaData.generatedKeyAlwaysReturned. See DatabaseMetaData javadoc
public ResultSet	Returns: a ResultSet object in which each row is a type description getAttributes(String - a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search catalog, String - a schema name pattern; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search schemaPattern, String - a type name pattern; must match the type name as it is stored in the database typeNamePattern, String - an attribute name pattern; must match the attribute name as it is declared in the database attributeNamePattern) Implements java.sql.DatabaseMetaData.getAttributes. JDBC 3.0 Retrieves a description of the given attribute of the given type for a user-defined type (UDT) that is available in the given schema and catalog.
public ResultSet	Returns: ResultSet - each row is a column description getBestRowIdentifier(String a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria catalogPattern, String a schema name; "" retrieves those without a schema schemaPattern, String a table name table, int the scope of interest; use same values as SCOPE scope, boolean include columns that are nullable? nullable) Implements java.sql.DatabaseMetaData.getBestRowIdentifier. Get a description of a table's optimal set of columns that uniquely identifies a row.
public ResultSet	getBestRowIdentifierForODBC(String catalogPattern, String schemaPattern, String table, int scope, boolean nullable) Get a description of a table's optimal set of columns that uniquely identifies a row.
public ResultSet	Returns: ResultSet - each row has a single String column that is a catalog name getCatalogs() Implements java.sql.DatabaseMetaData.getCatalogs. Get the catalog names available in this database.
public String	Returns: the separator string getCatalogSeparator() Implements java.sql.DatabaseMetaData.getCatalogSeparator. What's the separator between catalog and table name?
public String	Returns: the vendor term getCatalogTerm() Implements java.sql.DatabaseMetaData.getCatalogTerm. What's the database vendor's preferred term for "catalog"?
public ResultSet	Returns: the result set returned by SYSIBM.METADATA getClientCachedMetaData() Get metadata that the client driver will cache.
public ResultSet	Returns: A `ResultSet` object; each row is a supported client info property getClientInfoProperties() Implements java.sql.DatabaseMetaData.getClientInfoProperties. JDBC 4.0 Returns a list of the client info properties supported by the driver.
public ResultSet	Returns: ResultSet - each row is a column privilege description getColumnPrivileges(String a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria catalog, String a schema name; "" retrieves those without a schema schema, String a table name table, String a column name pattern columnNamePattern) Implements java.sql.DatabaseMetaData.getColumnPrivileges. Get a description of the access rights for a table's columns.
public ResultSet	Returns: ResultSet - each row is a column description getColumns(String a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria catalog, String a schema name pattern; "" retrieves those without a schema schemaPattern, String a table name pattern tableNamePattern, String a column name pattern columnNamePattern) Implements java.sql.DatabaseMetaData.getColumns. Get a description of table columns available in a catalog.
public ResultSet	getColumnsForODBC(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) Get a description of table columns available in a catalog.
public Connection	getConnection() Implements java.sql.DatabaseMetaData.getConnection. JDBC 2.0 Return the connection that produced this metadata object.
public ResultSet	Returns: ResultSet - each row is a foreign key column description getCrossReference(String a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria primaryCatalog, String a schema name pattern; "" retrieves those without a schema primarySchema, String the table name that exports the key primaryTable, String a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria foreignCatalog, String a schema name pattern; "" retrieves those without a schema foreignSchema, String the table name that imports the key foreignTable) Implements java.sql.DatabaseMetaData.getCrossReference. 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.
public ResultSet	getCrossReferenceForODBC(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable) In contrast to the JDBC version of getCrossReference, this method allows null values for table names.
public int	Returns: the underlying database's major version getDatabaseMajorVersion() Implements java.sql.DatabaseMetaData.getDatabaseMajorVersion. JDBC 3.0 Retrieves the major version number of the underlying database.
public int	Returns: the underlying database's minor version getDatabaseMinorVersion() Implements java.sql.DatabaseMetaData.getDatabaseMinorVersion. JDBC 3.0 Retrieves the minor version number of the underlying database.
public String	Returns: database product name getDatabaseProductName() Implements java.sql.DatabaseMetaData.getDatabaseProductName. What's the name of this database product?
public String	Returns: database version getDatabaseProductVersion() Implements java.sql.DatabaseMetaData.getDatabaseProductVersion. What's the version of this database product?
public int	Returns: the default isolation level getDefaultTransactionIsolation() Implements java.sql.DatabaseMetaData.getDefaultTransactionIsolation. What's the database's default transaction isolation level?
public int	Returns: JDBC driver major version getDriverMajorVersion() Implements java.sql.DatabaseMetaData.getDriverMajorVersion. What's this JDBC driver's major version number?
public int	Returns: JDBC driver minor version number getDriverMinorVersion() Implements java.sql.DatabaseMetaData.getDriverMinorVersion. What's this JDBC driver's minor version number?
public String	Returns: JDBC driver name getDriverName() Implements java.sql.DatabaseMetaData.getDriverName. What's the name of this JDBC driver?
public String	Returns: JDBC driver version getDriverVersion() Implements java.sql.DatabaseMetaData.getDriverVersion. What's the version of this JDBC driver?
public ResultSet	Returns: ResultSet - each row is a foreign key column description getExportedKeys(String a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria catalog, String a schema name pattern; "" retrieves those without a schema schema, String a table name table) Implements java.sql.DatabaseMetaData.getExportedKeys. Get a description of the foreign key columns that reference a table's primary key columns (the foreign keys exported by a table).
public String	Returns: the string containing the extra characters getExtraNameCharacters() Implements java.sql.DatabaseMetaData.getExtraNameCharacters. Get all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _).
public ResultSet	Returns: a ResultSet with metadata information getFunctionColumns(String limit the search to functions in this catalog (not used) catalog, String limit the search to functions in schemas matching this pattern schemaPattern, String limit the search to functions matching this pattern functionNamePattern, String limit the search parameters matching this pattern parameterNamePattern) Implements java.sql.DatabaseMetaData.getFunctionColumns. Implements DatabaseMetaData.getFunctionColumns() for an embedded database.
public ResultSet	Returns: a ResultSet with metadata information getFunctions(String limit the search to functions in this catalog (not used) catalog, String limit the search to functions in schemas matching this pattern schemaPattern, String limit the search to functions matching this pattern functionNamePattern) Implements java.sql.DatabaseMetaData.getFunctions. Implements DatabaseMetaData.getFunctions() for an embedded database.
public String	Returns: the quoting string getIdentifierQuoteString() Implements java.sql.DatabaseMetaData.getIdentifierQuoteString. What's the string used to quote SQL identifiers?
public ResultSet	Returns: ResultSet - each row is a primary key column description getImportedKeys(String a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria catalog, String a schema name pattern; "" retrieves those without a schema schema, String a table name table) Implements java.sql.DatabaseMetaData.getImportedKeys. 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).
public ResultSet	Returns: ResultSet - each row is an index column description getIndexInfo(String a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria catalog, String a schema name pattern; "" retrieves those without a schema schema, String a table name table, boolean when true, return only indices for unique values; when false, return indices regardless of whether unique or not unique, boolean when true, result is allowed to reflect approximate or out of data values; when false, results are requested to be accurate approximate) Implements java.sql.DatabaseMetaData.getIndexInfo. Get a description of a table's indices and statistics.
public ResultSet	getIndexInfoForODBC(String catalog, String schema, String table, boolean unique, boolean approximate) Get a description of a table's indices and statistics.
public int	Returns: JDBC version major number getJDBCMajorVersion() Implements java.sql.DatabaseMetaData.getJDBCMajorVersion. JDBC 3.0 Retrieves the major JDBC version number for this driver.
public int	Returns: JDBC version minor number getJDBCMinorVersion() Implements java.sql.DatabaseMetaData.getJDBCMinorVersion. JDBC 3.0 Retrieves the minor JDBC version number for this driver.
private LanguageConnectionContext	Returns: the lcc for this connection getLanguageConnectionContext() Gets the LanguageConnectionContext for this connection.
public int	Returns: max literal length getMaxBinaryLiteralLength() Implements java.sql.DatabaseMetaData.getMaxBinaryLiteralLength. How many hex characters can you have in an inline binary literal?
public int	Returns: max name length in bytes getMaxCatalogNameLength() Implements java.sql.DatabaseMetaData.getMaxCatalogNameLength. What's the maximum length of a catalog name?
public int	Returns: max literal length getMaxCharLiteralLength() Implements java.sql.DatabaseMetaData.getMaxCharLiteralLength. What's the max length for a character literal?
public int	Returns: max literal length getMaxColumnNameLength() Implements java.sql.DatabaseMetaData.getMaxColumnNameLength. What's the limit on column name length?
public int	Returns: max number of columns getMaxColumnsInGroupBy() Implements java.sql.DatabaseMetaData.getMaxColumnsInGroupBy. What's the maximum number of columns in a "GROUP BY" clause?
public int	Returns: max columns getMaxColumnsInIndex() Implements java.sql.DatabaseMetaData.getMaxColumnsInIndex. What's the maximum number of columns allowed in an index?
public int	Returns: max columns getMaxColumnsInOrderBy() Implements java.sql.DatabaseMetaData.getMaxColumnsInOrderBy. What's the maximum number of columns in an "ORDER BY" clause?
public int	Returns: max columns getMaxColumnsInSelect() Implements java.sql.DatabaseMetaData.getMaxColumnsInSelect. What's the maximum number of columns in a "SELECT" list?
public int	Returns: max columns getMaxColumnsInTable() Implements java.sql.DatabaseMetaData.getMaxColumnsInTable. What's the maximum number of columns in a table?
public int	Returns: max connections getMaxConnections() Implements java.sql.DatabaseMetaData.getMaxConnections. How many active connections can we have at a time to this database?
public int	Returns: max cursor name length in bytes getMaxCursorNameLength() Implements java.sql.DatabaseMetaData.getMaxCursorNameLength. What's the maximum cursor name length?
public int	Returns: max index length in bytes getMaxIndexLength() Implements java.sql.DatabaseMetaData.getMaxIndexLength. What's the maximum length of an index (in bytes)?
public long	Returns: max index length in bytes getMaxLogicalLobSize() Overrides default java.sql.DatabaseMetaData.getMaxLogicalLobSize. Added in JDBC 4.2.
public int	Returns: max name length in bytes getMaxProcedureNameLength() Implements java.sql.DatabaseMetaData.getMaxProcedureNameLength. What's the maximum length of a procedure name?
public int	Returns: max row size in bytes getMaxRowSize() Implements java.sql.DatabaseMetaData.getMaxRowSize. What's the maximum length of a single row?
public int	Returns: max name length in bytes getMaxSchemaNameLength() Implements java.sql.DatabaseMetaData.getMaxSchemaNameLength. What's the maximum length allowed for a schema name?
public int	Returns: max length in bytes getMaxStatementLength() Implements java.sql.DatabaseMetaData.getMaxStatementLength. What's the maximum length of a SQL statement?
public int	Returns: the maximum getMaxStatements() Implements java.sql.DatabaseMetaData.getMaxStatements. How many active statements can we have open at one time to this database?
public int	Returns: max name length in bytes getMaxTableNameLength() Implements java.sql.DatabaseMetaData.getMaxTableNameLength. What's the maximum length of a table name?
public int	Returns: the maximum getMaxTablesInSelect() Implements java.sql.DatabaseMetaData.getMaxTablesInSelect. What's the maximum number of tables in a SELECT?
public int	Returns: max name length in bytes getMaxUserNameLength() Implements java.sql.DatabaseMetaData.getMaxUserNameLength. What's the maximum length of a user name?
public String	Returns: the list getNumericFunctions() Implements java.sql.DatabaseMetaData.getNumericFunctions. Get a comma separated list of JDBC escaped numeric functions.
private PreparedStatement	Returns: PreparedStatement getPreparedQuery(String Name of the metadata query for which we need a prepared statement queryName, boolean if `true`, use metadata_net.properties instead of metadata.properties net) Either get the prepared query for the metadata call from the system tables, or from the metadata.properties or metadata_net.properties file.
protected PreparedStatement	Returns: a `PreparedStatement` value getPreparedQuery(String name of the query queryName) Get a prepared query from system tables or metadata.properties.
private PreparedStatement	Returns: a `PreparedStatement` value getPreparedQueryUsingSystemTables(String the name of the query nameKey, boolean if `true`, find query in SYSIBM schema; otherwise, find query in SYS schema net) Get a stored prepared statement from the system tables.
public ResultSet	Returns: ResultSet - each row is a primary key column description getPrimaryKeys(String a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria catalog, String a schema name pattern; "" retrieves those without a schema schema, String a table name table) Implements java.sql.DatabaseMetaData.getPrimaryKeys. Get a description of a table's primary key columns.
public ResultSet	Returns: ResultSet - each row is a stored procedure parameter or column description getProcedureColumns(String a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria catalog, String a schema name pattern; "" retrieves those without a schema schemaPattern, String a procedure name pattern procedureNamePattern, String a column name pattern columnNamePattern) Implements java.sql.DatabaseMetaData.getProcedureColumns. Get a description of a catalog's stored procedure parameters and result columns.
public ResultSet	getProcedureColumnsForODBC(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) Get a description of a catalog's stored procedure parameters and result columns.
public ResultSet	Returns: ResultSet - each row is a procedure description getProcedures(String a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria catalog, String a schema name pattern; "" retrieves those without a schema schemaPattern, String a procedure name pattern procedureNamePattern) Implements java.sql.DatabaseMetaData.getProcedures. Get a description of stored procedures available in a catalog.
public ResultSet	getProceduresForODBC(String catalog, String schemaPattern, String procedureNamePattern) Get a description of stored procedures available in a catalog.
public String	Returns: the vendor term getProcedureTerm() Implements java.sql.DatabaseMetaData.getProcedureTerm. What's the database vendor's preferred term for "procedure"?
public ResultSet	getPseudoColumns(String a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; `null` means that the catalog name should not be used to narrow the search catalog, String a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema; `null` means that the schema name should not be used to narrow the search schemaPattern, String a table name pattern; must match the table name as it is stored in the database tableNamePattern, String a column name pattern; must match the column name as it is stored in the database columnNamePattern) Implements java.sql.DatabaseMetaData.getPseudoColumns. See DatabaseMetaData javadoc.
private Properties	Returns: a `Properties` value with the queries getQueryDescriptions(boolean if `true`, read metadata_net.properties; otherwise, read metadata.properties. net) Return all queries found in either metadata.properties or metadata_net.properties.
private String	Returns: the query text getQueryFromDescription(String name of the query queryName, boolean if `true`, get the query from metadata_net.properties instead of metadata.properties net) Given a queryName, find closest match in queryDescriptions.
public int	Returns: the default holdability which is ResultSet.HOLD_CURSORS_OVER_COMMIT getResultSetHoldability() Implements java.sql.DatabaseMetaData.getResultSetHoldability. JDBC 3.0 Retrieves the default holdability of this ResultSet object.
public RowIdLifetime	getRowIdLifetime() Implements java.sql.DatabaseMetaData.getRowIdLifetime. Indicates whether this data source supports the SQL `ROWID` type, and the lifetime for which a `RowId` object remains valid.
public ResultSet	Returns: ResultSet - each row is a schema description getSchemas() Implements java.sql.DatabaseMetaData.getSchemas. Get the schema names available in this database.
public ResultSet	Returns: a `ResultSet` object in which each row is a schema description getSchemas(String catalog name used to narrow down the search; "" means no catalog, `null` means any catalog catalog, String schema name used to narrow down the search, `null` means schema name should not be used to narrow down search schemaPattern) Implements java.sql.DatabaseMetaData.getSchemas. JDBC 4.0 Get the schema names available in this database.
public String	Returns: the vendor term getSchemaTerm() Implements java.sql.DatabaseMetaData.getSchemaTerm. What's the database vendor's preferred term for "schema"?
public String	Returns: the string used to escape wildcard characters getSearchStringEscape() Implements java.sql.DatabaseMetaData.getSearchStringEscape. This is the string that can be used to escape '_' or '%' in the string pattern style catalog search parameters.
private ResultSet	Returns: a `ResultSet` value getSimpleQuery(String the name of the query nameKey, boolean if `true`, execute a query in metadata_net.properties; otherwise, execute a query in metadata.properties net) Execute a query in metadata.properties (or SPS in the SYS schema) or metadata_net.properties (or SPS in the SYSIBM schema).
protected ResultSet	Returns: a `ResultSet` value getSimpleQuery(String the name of the query nameKey) Execute a query in metadata.properties, or an SPS in the SYS schema.
public String	Returns: the list getSQLKeywords() Implements java.sql.DatabaseMetaData.getSQLKeywords. Get a comma separated list of all a database's SQL keywords that are NOT also SQL92 keywords.
public int	Returns: the type of SQLSTATEs, one of: sqlStateXOpen or sqlStateSQL99 getSQLStateType() Implements java.sql.DatabaseMetaData.getSQLStateType. JDBC 3.0 Indicates whether the SQLSTATEs returned by SQLException.getSQLState is X/Open (now known as Open Group) SQL CLI or SQL99.
public String	Returns: the list getStringFunctions() Implements java.sql.DatabaseMetaData.getStringFunctions. Get a comma separated list of JDBC escaped string functions.
public ResultSet	Returns: a ResultSet object in which each row is a type description getSuperTables(String - a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria catalog, String - a schema name pattern; "" retrieves those without a schema schemaPattern, String - a UDT name pattern; may be a fully-qualified name typeNamePattern) Implements java.sql.DatabaseMetaData.getSuperTables. JDBC 3.0 Retrieves a description of the table hierarchies defined in a particular schema in this database.
public ResultSet	Returns: a ResultSet object in which a row gives information about the designated UDT getSuperTypes(String - a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria catalog, String - a schema name pattern; "" retrieves those without a schema schemaPattern, String - a UDT name pattern; may be a fully-qualified name typeNamePattern) Implements java.sql.DatabaseMetaData.getSuperTypes. JDBC 3.0 Retrieves a description of the user-defined type (UDT) hierarchies defined in a particular schema in this database.
public String	Returns: the list getSystemFunctions() Implements java.sql.DatabaseMetaData.getSystemFunctions. Get a comma separated list of JDBC escaped system functions.
public ResultSet	Returns: ResultSet - each row is a table privilege description getTablePrivileges(String a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria catalog, String a schema name pattern; "" retrieves those without a schema schemaPattern, String a table name pattern tableNamePattern) Implements java.sql.DatabaseMetaData.getTablePrivileges. Get a description of the access rights for each table available in a catalog.
public ResultSet	Returns: ResultSet - each row is a table description getTables(String a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria catalog, String a schema name pattern; "" retrieves those without a schema schemaPattern, String a table name pattern tableNamePattern, String[] a list of table types to include; null returns all types types) Implements java.sql.DatabaseMetaData.getTables. Get a description of tables available in a catalog.
public ResultSet	Returns: ResultSet - each row has a single String column that is a table type getTableTypes() Implements java.sql.DatabaseMetaData.getTableTypes. Get the table types available in this database.
public String	Returns: the list getTimeDateFunctions() Implements java.sql.DatabaseMetaData.getTimeDateFunctions. Get a comma separated list of JDBC escaped time date functions.
public ResultSet	Returns: ResultSet - each row is a SQL type description getTypeInfo() Implements java.sql.DatabaseMetaData.getTypeInfo. Get a description of all the standard SQL types supported by this database.
public ResultSet	getTypeInfoForODBC() Get a description of all the standard SQL types supported by this database.
private ResultSet	Returns: a result set with SQL type description getTypeInfoMinion(String the name of the query that fetches the information queryName) Get a description of the standard SQL types supported by this database.
public ResultSet	Returns: ResultSet - each row is a type description getUDTs(String a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria catalog, String a schema name pattern; "" retrieves those without a schema schemaPattern, String a type name pattern; may be a fully qualified name typeNamePattern, int[] a list of user-named types to include (JAVA_OBJECT, STRUCT, or DISTINCT); null returns all types types) Implements java.sql.DatabaseMetaData.getUDTs. JDBC 2.0 Get a description of the user-defined types defined in a particular schema.
public final String	Returns: the url or null if it can't be generated getURL() Implements java.sql.DatabaseMetaData.getURL. What's the url for this database?
public String	Returns: our database user name getUserName() Implements java.sql.DatabaseMetaData.getUserName. What's our user name as known to the database?
public ResultSet	Returns: ResultSet - each row is a column description getVersionColumns(String a catalog name; "" retrieves those without a catalog; null means drop catalog name from the selection criteria catalog, String a schema name; "" retrieves those without a schema schema, String a table name table) Implements java.sql.DatabaseMetaData.getVersionColumns. Get a description of a table's columns that are automatically updated when any value in a row is updated.
public ResultSet	getVersionColumnsForODBC(String catalog, String schema, String table) Get a description of a table's columns that are automatically updated when any value in a row is updated.
public boolean	Returns: true if inserts are detected by the resultset type insertsAreDetected(int result set type, i.e. ResultSet.TYPE_XXX type) Implements java.sql.DatabaseMetaData.insertsAreDetected. JDBC 2.0 Determine whether or not a visible row insert can be detected by calling ResultSet.rowInserted().
public boolean	Returns: true if it appears at the start isCatalogAtStart() Implements java.sql.DatabaseMetaData.isCatalogAtStart. Does a catalog appear at the start of a qualified table name?
public boolean	Returns: true if so isReadOnly() Implements java.sql.DatabaseMetaData.isReadOnly. Is the database in read-only mode?
public final boolean	Returns: true if this implements the interface isWrapperFor(Class<?> the interface to check for iface) Implements java.sql.Wrapper.isWrapperFor. Returns whether or not this instance implements the specified interface.
private void	loadQueryDescriptions() Loads the query descriptions from metadata.properties and metadata_net.properties into `queryDescriptions` and `queryDescriptions_net`.
public boolean	Returns: true if updates are made to a copy of the LOB; false if updates are made directly to the LOB locatorsUpdateCopy() Implements java.sql.DatabaseMetaData.locatorsUpdateCopy. JDBC 3.0 Indicates whether updates made to a LOB are made on a copy or directly to the LOB.
private boolean	Returns: true if we are not in soft upgrade mode notInSoftUpgradeMode() check if the dictionary is at the same version as the engine.
public boolean	Returns: true if so nullPlusNonNullIsNull() Implements java.sql.DatabaseMetaData.nullPlusNonNullIsNull. Are concatenations between NULL and non-NULL values NULL?
public boolean	Returns: true if so nullsAreSortedAtEnd() Implements java.sql.DatabaseMetaData.nullsAreSortedAtEnd. Are NULL values sorted at the end regardless of sort order?
public boolean	Returns: true if so nullsAreSortedAtStart() Implements java.sql.DatabaseMetaData.nullsAreSortedAtStart. Are NULL values sorted at the start regardless of sort order?
public boolean	Returns: true if so nullsAreSortedHigh() Implements java.sql.DatabaseMetaData.nullsAreSortedHigh. Are NULL values sorted high?
public boolean	Returns: true if so nullsAreSortedLow() Implements java.sql.DatabaseMetaData.nullsAreSortedLow. Are NULL values sorted low?
public boolean	Returns: true if deletes are visible for the result set type othersDeletesAreVisible(int result set type, i.e. ResultSet.TYPE_XXX type) Implements java.sql.DatabaseMetaData.othersDeletesAreVisible. JDBC 2.0 Determine whether deletes made by others are visible.
public boolean	Returns: true if inserts are visible for the result set type othersInsertsAreVisible(int result set type, i.e. ResultSet.TYPE_XXX type) Implements java.sql.DatabaseMetaData.othersInsertsAreVisible. JDBC 2.0 Determine whether inserts made by others are visible.
public boolean	Returns: true if updates are visible for the result set type othersUpdatesAreVisible(int result set type, i.e. ResultSet.TYPE_XXX type) Implements java.sql.DatabaseMetaData.othersUpdatesAreVisible. JDBC 2.0 Determine whether updates made by others are visible.
public boolean	Returns: true if deletes are visible for the result set type ownDeletesAreVisible(int result set type, i.e. ResultSet.TYPE_XXX type) Implements java.sql.DatabaseMetaData.ownDeletesAreVisible. JDBC 2.0 Determine whether a result set's deletes are visible.
public boolean	Returns: true if inserts are visible for the result set type ownInsertsAreVisible(int result set type, i.e. ResultSet.TYPE_XXX type) Implements java.sql.DatabaseMetaData.ownInsertsAreVisible. JDBC 2.0 Determine whether a result set's inserts are visible.
public boolean	Returns: true if updates are visible for the result set type ownUpdatesAreVisible(int result set type, i.e. ResultSet.TYPE_XXX type) Implements java.sql.DatabaseMetaData.ownUpdatesAreVisible. JDBC 2.0 Determine whether a result set's updates are visible.
private void	PBloadQueryDescriptions() Read the query descriptions from metadata.properties and metadata_net.properties.
private PreparedStatement	prepareSPS(String spsName, String spsText, boolean net)
public final Object	Returns: `null` run() Reads the query descriptions.
public boolean	Returns: true if so storesLowerCaseIdentifiers() Implements java.sql.DatabaseMetaData.storesLowerCaseIdentifiers. Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in lower case?
public boolean	Returns: true if so storesLowerCaseQuotedIdentifiers() Implements java.sql.DatabaseMetaData.storesLowerCaseQuotedIdentifiers. Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in lower case?
public boolean	Returns: true if so storesMixedCaseIdentifiers() Implements java.sql.DatabaseMetaData.storesMixedCaseIdentifiers. Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in mixed case?
public boolean	Returns: true if so storesMixedCaseQuotedIdentifiers() Implements java.sql.DatabaseMetaData.storesMixedCaseQuotedIdentifiers. Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in mixed case?
public boolean	Returns: true if so storesUpperCaseIdentifiers() Implements java.sql.DatabaseMetaData.storesUpperCaseIdentifiers. Does the database treat mixed case unquoted SQL identifiers as case insensitive and store them in upper case?
public boolean	Returns: true if so storesUpperCaseQuotedIdentifiers() Implements java.sql.DatabaseMetaData.storesUpperCaseQuotedIdentifiers. Does the database treat mixed case quoted SQL identifiers as case insensitive and store them in upper case?
public boolean	Returns: true if so supportsAlterTableWithAddColumn() Implements java.sql.DatabaseMetaData.supportsAlterTableWithAddColumn. Is "ALTER TABLE" with add column supported?
public boolean	Returns: true if so supportsAlterTableWithDropColumn() Implements java.sql.DatabaseMetaData.supportsAlterTableWithDropColumn. Is "ALTER TABLE" with drop column supported?
public boolean	Returns: true if so supportsANSI92EntryLevelSQL() Implements java.sql.DatabaseMetaData.supportsANSI92EntryLevelSQL. Is the ANSI92 entry level SQL grammar supported?
public boolean	Returns: true if so supportsANSI92FullSQL() Implements java.sql.DatabaseMetaData.supportsANSI92FullSQL. Is the ANSI92 full SQL grammar supported?
public boolean	Returns: true if so supportsANSI92IntermediateSQL() Implements java.sql.DatabaseMetaData.supportsANSI92IntermediateSQL. Is the ANSI92 intermediate SQL grammar supported?
public boolean	supportsBatchUpdates() Implements java.sql.DatabaseMetaData.supportsBatchUpdates. JDBC 2.0 Return true if the driver supports batch updates, else return false.
public boolean	Returns: true if so supportsCatalogsInDataManipulation() Implements java.sql.DatabaseMetaData.supportsCatalogsInDataManipulation. Can a catalog name be used in a data manipulation statement?
public boolean	Returns: true if so supportsCatalogsInIndexDefinitions() Implements java.sql.DatabaseMetaData.supportsCatalogsInIndexDefinitions. Can a catalog name be used in an index definition statement?
public boolean	Returns: true if so supportsCatalogsInPrivilegeDefinitions() Implements java.sql.DatabaseMetaData.supportsCatalogsInPrivilegeDefinitions. Can a catalog name be used in a privilege definition statement?
public boolean	Returns: true if so supportsCatalogsInProcedureCalls() Implements java.sql.DatabaseMetaData.supportsCatalogsInProcedureCalls. Can a catalog name be used in a procedure call statement?
public boolean	Returns: true if so supportsCatalogsInTableDefinitions() Implements java.sql.DatabaseMetaData.supportsCatalogsInTableDefinitions. Can a catalog name be used in a table definition statement?
public boolean	Returns: true if so supportsColumnAliasing() Implements java.sql.DatabaseMetaData.supportsColumnAliasing. Is column aliasing supported?
public boolean	Returns: true if so supportsConvert() Implements java.sql.DatabaseMetaData.supportsConvert. Is the CONVERT function between SQL types supported?
public boolean	Returns: true if so supportsConvert(int the type to convert from fromType, int the type to convert to toType) Implements java.sql.DatabaseMetaData.supportsConvert. Is CONVERT between the given SQL types supported?
public boolean	Returns: true if so supportsCoreSQLGrammar() Implements java.sql.DatabaseMetaData.supportsCoreSQLGrammar. Is the ODBC Core SQL grammar supported?
public boolean	Returns: true if so supportsCorrelatedSubqueries() Implements java.sql.DatabaseMetaData.supportsCorrelatedSubqueries. Are correlated subqueries supported?
public boolean	Returns: true if so supportsDataDefinitionAndDataManipulationTransactions() Implements java.sql.DatabaseMetaData.supportsDataDefinitionAndDataManipulationTransactions. Are both data definition and data manipulation statements within a transaction supported?
public boolean	Returns: true if so supportsDataManipulationTransactionsOnly() Implements java.sql.DatabaseMetaData.supportsDataManipulationTransactionsOnly. Are only data manipulation statements within a transaction supported?
public boolean	Returns: true if so supportsDifferentTableCorrelationNames() Implements java.sql.DatabaseMetaData.supportsDifferentTableCorrelationNames. If table correlation names are supported, are they restricted to be different from the names of the tables?
public boolean	Returns: true if so supportsExpressionsInOrderBy() Implements java.sql.DatabaseMetaData.supportsExpressionsInOrderBy. Are expressions in "ORDER BY" lists supported?
public boolean	Returns: true if so supportsExtendedSQLGrammar() Implements java.sql.DatabaseMetaData.supportsExtendedSQLGrammar. Is the ODBC Extended SQL grammar supported?
public boolean	Returns: true if so supportsFullOuterJoins() Implements java.sql.DatabaseMetaData.supportsFullOuterJoins. Are full nested outer joins supported?
public boolean	Returns: true if auto-generated keys can be retrieved after a statement has executed; false otherwise supportsGetGeneratedKeys() Implements java.sql.DatabaseMetaData.supportsGetGeneratedKeys. JDBC 3.0 Retrieves whether auto-generated keys can be retrieved after a statement has been executed.
public boolean	Returns: true if so supportsGroupBy() Implements java.sql.DatabaseMetaData.supportsGroupBy. Is some form of "GROUP BY" clause supported?
public boolean	Returns: true if so supportsGroupByBeyondSelect() Implements java.sql.DatabaseMetaData.supportsGroupByBeyondSelect. Can a "GROUP BY" clause add columns not in the SELECT provided it specifies all the columns in the SELECT?
public boolean	Returns: true if so supportsGroupByUnrelated() Implements java.sql.DatabaseMetaData.supportsGroupByUnrelated. Can a "GROUP BY" clause use columns not in the SELECT?
public boolean	Returns: true if so supportsIntegrityEnhancementFacility() Implements java.sql.DatabaseMetaData.supportsIntegrityEnhancementFacility. Is the SQL Integrity Enhancement Facility supported?
public boolean	Returns: true if so supportsLikeEscapeClause() Implements java.sql.DatabaseMetaData.supportsLikeEscapeClause. Is the escape character in "LIKE" clauses supported?
public boolean	Returns: true if so supportsLimitedOuterJoins() Implements java.sql.DatabaseMetaData.supportsLimitedOuterJoins. Is there limited support for outer joins?
public boolean	Returns: true if so supportsMinimumSQLGrammar() Implements java.sql.DatabaseMetaData.supportsMinimumSQLGrammar. Is the ODBC Minimum SQL grammar supported?
public boolean	Returns: true if so supportsMixedCaseIdentifiers() Implements java.sql.DatabaseMetaData.supportsMixedCaseIdentifiers. Does the database treat mixed case unquoted SQL identifiers as case sensitive and as a result store them in mixed case?
public boolean	Returns: true if so supportsMixedCaseQuotedIdentifiers() Implements java.sql.DatabaseMetaData.supportsMixedCaseQuotedIdentifiers. Does the database treat mixed case quoted SQL identifiers as case sensitive and as a result store them in mixed case?
public boolean	Returns: true if a CallableStatement object can return multiple ResultSet objects simultaneously; false otherwise supportsMultipleOpenResults() Implements java.sql.DatabaseMetaData.supportsMultipleOpenResults. JDBC 3.0 Retrieves whether it is possible to have multiple ResultSet objects returned from a CallableStatement object simultaneously.
public boolean	Returns: true if so supportsMultipleResultSets() Implements java.sql.DatabaseMetaData.supportsMultipleResultSets. Are multiple ResultSets from a single execute supported?
public boolean	Returns: true if so supportsMultipleTransactions() Implements java.sql.DatabaseMetaData.supportsMultipleTransactions. Can we have multiple transactions open at once (on different connections)?
public boolean	Returns: true if named parameters are supported; false otherwise supportsNamedParameters() Implements java.sql.DatabaseMetaData.supportsNamedParameters. JDBC 3.0 Retrieves whether this database supports named parameters to callable statements.
public boolean	Returns: true if so supportsNonNullableColumns() Implements java.sql.DatabaseMetaData.supportsNonNullableColumns. Can columns be defined as non-nullable?
public boolean	Returns: true if cursors always remain open; false if they might not remain open supportsOpenCursorsAcrossCommit() Implements java.sql.DatabaseMetaData.supportsOpenCursorsAcrossCommit. Can cursors remain open across commits?
public boolean	Returns: true if cursors always remain open; false if they might not remain open supportsOpenCursorsAcrossRollback() Implements java.sql.DatabaseMetaData.supportsOpenCursorsAcrossRollback. Can cursors remain open across rollbacks?
public boolean	Returns: true if statements always remain open; false if they might not remain open supportsOpenStatementsAcrossCommit() Implements java.sql.DatabaseMetaData.supportsOpenStatementsAcrossCommit. Can statements remain open across commits?
public boolean	Returns: true if statements always remain open; false if they might not remain open supportsOpenStatementsAcrossRollback() Implements java.sql.DatabaseMetaData.supportsOpenStatementsAcrossRollback. Can statements remain open across rollbacks?
public boolean	Returns: true if so supportsOrderByUnrelated() Implements java.sql.DatabaseMetaData.supportsOrderByUnrelated. Can an "ORDER BY" clause use columns not in the SELECT?
public boolean	Returns: true if so supportsOuterJoins() Implements java.sql.DatabaseMetaData.supportsOuterJoins. Is some form of outer join supported?
public boolean	Returns: true if so supportsPositionedDelete() Implements java.sql.DatabaseMetaData.supportsPositionedDelete. Is positioned DELETE supported?
public boolean	Returns: true if so supportsPositionedUpdate() Implements java.sql.DatabaseMetaData.supportsPositionedUpdate. Is positioned UPDATE supported?
public boolean	Returns: true if so supportsRefCursors() Overrides default java.sql.DatabaseMetaData.supportsRefCursors. Added in JDBC 4.2.
public boolean	Returns: true if so supportsResultSetConcurrency(int defined in java.sql.ResultSet type, int type defined in java.sql.ResultSet concurrency) Implements java.sql.DatabaseMetaData.supportsResultSetConcurrency. JDBC 2.0 Does the database support the concurrency type in combination with the given result set type?
public boolean	Returns: true if so; false otherwise executed; false otherwise supportsResultSetHoldability(int - one of the following constants: ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT holdability) Implements java.sql.DatabaseMetaData.supportsResultSetHoldability. JDBC 3.0 Retrieves whether this database supports the given result set holdability.
public boolean	Returns: true if so supportsResultSetType(int defined in java.sql.ResultSet type) Implements java.sql.DatabaseMetaData.supportsResultSetType. JDBC 2.0 Does the database support the given result set type?
public boolean	Returns: true if savepoints are supported; false otherwise supportsSavepoints() Implements java.sql.DatabaseMetaData.supportsSavepoints. JDBC 3.0 Retrieves whether this database supports savepoints.
public boolean	Returns: true if so supportsSchemasInDataManipulation() Implements java.sql.DatabaseMetaData.supportsSchemasInDataManipulation. Can a schema name be used in a data manipulation statement?
public boolean	Returns: true if so supportsSchemasInIndexDefinitions() Implements java.sql.DatabaseMetaData.supportsSchemasInIndexDefinitions. Can a schema name be used in an index definition statement?
public boolean	Returns: true if so supportsSchemasInPrivilegeDefinitions() Implements java.sql.DatabaseMetaData.supportsSchemasInPrivilegeDefinitions. Can a schema name be used in a privilege definition statement?
public boolean	Returns: true if so supportsSchemasInProcedureCalls() Implements java.sql.DatabaseMetaData.supportsSchemasInProcedureCalls. Can a schema name be used in a procedure call statement?
public boolean	Returns: true if so supportsSchemasInTableDefinitions() Implements java.sql.DatabaseMetaData.supportsSchemasInTableDefinitions. Can a schema name be used in a table definition statement?
public boolean	Returns: true if so supportsSelectForUpdate() Implements java.sql.DatabaseMetaData.supportsSelectForUpdate. Is SELECT for UPDATE supported?
public boolean	Returns: true if statement pooling is supported; false otherwise supportsStatementPooling() Implements java.sql.DatabaseMetaData.supportsStatementPooling. JDBC 3.0 Retrieves whether this database supports statement pooling.
public boolean	supportsStoredFunctionsUsingCallSyntax() Implements java.sql.DatabaseMetaData.supportsStoredFunctionsUsingCallSyntax. Retrieves whether this database supports invoking user-defined or vendor functions using the stored procedure escape syntax.
public boolean	Returns: true if so supportsStoredProcedures() Implements java.sql.DatabaseMetaData.supportsStoredProcedures. Are stored procedure calls using the stored procedure escape syntax supported?
public boolean	Returns: true if so supportsSubqueriesInComparisons() Implements java.sql.DatabaseMetaData.supportsSubqueriesInComparisons. Are subqueries in comparison expressions supported?
public boolean	Returns: true if so supportsSubqueriesInExists() Implements java.sql.DatabaseMetaData.supportsSubqueriesInExists. Are subqueries in 'exists' expressions supported?
public boolean	Returns: true if so supportsSubqueriesInIns() Implements java.sql.DatabaseMetaData.supportsSubqueriesInIns. Are subqueries in 'in' statements supported?
public boolean	Returns: true if so supportsSubqueriesInQuantifieds() Implements java.sql.DatabaseMetaData.supportsSubqueriesInQuantifieds. Are subqueries in quantified expressions supported?
public boolean	Returns: true if so supportsTableCorrelationNames() Implements java.sql.DatabaseMetaData.supportsTableCorrelationNames. Are table correlation names supported?
public boolean	Returns: true if so supportsTransactionIsolationLevel(int the values are defined in java.sql.Connection level) Implements java.sql.DatabaseMetaData.supportsTransactionIsolationLevel. Does the database support the given transaction isolation level?
public boolean	Returns: true if transactions are supported supportsTransactions() Implements java.sql.DatabaseMetaData.supportsTransactions. Are transactions supported?
public boolean	Returns: true if so supportsUnion() Implements java.sql.DatabaseMetaData.supportsUnion. Is SQL UNION supported?
public boolean	Returns: true if so supportsUnionAll() Implements java.sql.DatabaseMetaData.supportsUnionAll. Is SQL UNION ALL supported?
protected static final String	swapNull(String s)
public final <T> T	Returns: an object that implements the interface unwrap(Class<T> the interface iface) Implements java.sql.Wrapper.unwrap. Returns `this` if this class implements the interface.
public boolean	Returns: true if updates are detected by the resultset type updatesAreDetected(int result set type, i.e. ResultSet.TYPE_XXX type) Implements java.sql.DatabaseMetaData.updatesAreDetected. JDBC 2.0 Determine whether or not a visible row update can be detected by calling ResultSet.rowUpdated().
public boolean	Returns: true if the database uses a local file for each table usesLocalFilePerTable() Implements java.sql.DatabaseMetaData.usesLocalFilePerTable. Does the database use a file for each table?
public boolean	Returns: true if so usesLocalFiles() Implements java.sql.DatabaseMetaData.usesLocalFiles. Does the database store tables in a local file?

Inherited from org.apache.derby.impl.jdbc.ConnectionChild:: commitIfAutoCommit commitIfNeeded getCal getConnectionSynchronization getEmbedConnection getLanguageConnectionContext getLCC handleException needCommit newSQLException restoreContextStack restoreIntrFlagIfSeen setupContextStack

public Class EmbedDatabaseMetaData

Field Summary

Constructor Summary

Method Summary