Top Description Fields Constructors Methods
org.hsqldb.jdbc

public Class JDBCDatabaseMetaData

extends Object
implements DatabaseMetaData, Wrapper
Class Inheritance
All Implemented Interfaces
java.sql.Wrapper, java.sql.DatabaseMetaData
Imports
java.sql.Connection, .DatabaseMetaData, .ResultSet, .RowIdLifetime, .SQLException, org.hsqldb.lib.StringConverter, .StringUtil, org.hsqldb.persist.HsqlDatabaseProperties, org.hsqldb.types.BlobType, .Type

Comprehensive information about the database as a whole.

This interface is implemented by driver vendors to let users know the capabilities of a Database Management System (DBMS) in combination with the driver based on JDBC technology ("JDBC driver") that is used with it. Different relational DBMSs often support different features, implement features in different ways, and use different data types. In addition, a driver may implement a feature on top of what the DBMS offers. Information returned by methods in this interface applies to the capabilities of a particular driver and a particular DBMS working together. Note that as used in this documentation, the term "database" is used generically to refer to both the driver and DBMS.

A user for this interface is commonly a tool that needs to discover how to deal with the underlying DBMS. This is especially true for applications that are intended to be used with more than one DBMS. For example, a tool might use the method getTypeInfo to find out what data types can be used in a CREATE TABLE statement. Or a user might call the method supportsCorrelatedSubqueries to see if it is possible to use a correlated subquery or supportsBatchUpdates to see if it is possible to use batch updates.

Some DatabaseMetaData methods return lists of information in the form of ResultSet objects. Regular ResultSet methods, such as getString and getInt, can be used to retrieve the data from these ResultSet objects. If a given form of metadata is not available, an empty ResultSet will be returned. Additional columns beyond the columns defined to be returned by the ResultSet object for a given method can be defined by the JDBC driver vendor and must be accessed by their column label.

Some DatabaseMetaData 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 null, that argument's criterion will be dropped from the search.

HSQLDB-Specific Information:

Metadata Table Production

Starting with HSQLDB 1.7.2, the metadata table (a.k.a system table) production implementation provided in the default build filters metadata based on each SQL session user's access rights which in turn lifts the pre-HSQLDB 1.7.2 restriction that only users with the DBA role ('admin' users in older HSQLDB parlance) could expect trouble-free access to all metadata.

Also starting with HSQLDB 1.7.2, the metadata table production implementation classes are loaded dynamically, using a precedence policy to find and load the richest producer available at runtime. In the event that no better alternative is found, the default minimal (completely restricted) provider is selected. Under this scheme, it is possible for third party packagers to create custom distributions targeted at supporting full (design-time), custom-written (proprietary / micro environment), minimal (production-time) or completely-restricted (space-constrained | device embedded | real-time | hostile environment) metadata table production scenarios. To learn more about this option, interested parties can review the documentation and source code for the org.hsqldb.dbinfo.DatabaseInformation class.

Please also note that in addition to the metadata tables produced to directly support this class, starting with HSQLDB 1.7.2, the default build provides many additional tables covering all or most HSQLDB features, such as descriptions of the triggers and aliases defined in the database.

For instance, in the default build, a fairly comprehensive description of each INFORMATION_SCHEMA table and each INFORMATION_SCHEMA table column is included in the REMARKS column of the getTables(...) and getColumns(...) results, which derive from INFORMATION_SCHEMA.SYSTEM_TABLES and INFORMATION_SCHEMA.SYSTEM_COLUMNS, respectively.

Since HSQLDB 2.0 the INFORMATION_SCHEMA views have been vastly expanded in compliance with the SQL:2011 Standard and report the properties of all database objects.

Schema Metadata

The SQL SCHEMA concept became fully supported in the HSQLDB 1.8.x series and this fact is reflected in the all subsequent versions of this class.

Catalog Metadata

Starting with HSQLDB 2.0, SQL standards compliance up to SQL:2008 and beyond is a major theme which is reflected in the provision of the majority of the standard-defined full-name INFORMATION_SCHEMA views.

However, just as CATALOG semantics and handling are still considered to be implementation defined by the most recent SQL standard (SQL:2011), so is the HSQLDB CATALOG concept still in the process of being defined and refined in HSQLDB 2.x. and beyond.

Similarly, starting with HSQLDB 2.x, from the perspective of SQL identification, an HSQLDB JDBC URL connects to a single HSQLDB database instance which consists of a single, default CATALOG named PUBLIC in which each SCHEMA instance of the database resides. The name of this catalog can be changed with the ALTER CATALOG <name> RENAME TO statement. As of version 2.1.0, HSQLDB supports qualification by the containing CATALOG of database objects at the syntactic level, but does not yet support operations such as opening, manipulating or querying against multiple database catalogs within a single session, not even in a one-at-a-time fashion.

Index Metadata

It must still be noted that as of the most recent release, HSQLDB continues to ignore the approximate argument of getIndexInfo() as no data is returned for CARDINALITY and PAGES coloumns.

Notes

for developers extending metadata table production

Note that in the absence of an ORDER BY clause, queries against the metadata tables that directly support this class are expected to return rows in JDBC contract order. The reason for this is that results typically come back much faster when no "ORDER BY" clause is used.

As such, when adding, extending or replacing a JDBC database metadata table production routine, developers need to be aware of this fact and either add the contract "ORDER BY" clause to the driving SQL or, when possible, preferably maintain rows in the contract order by correctly coding the primary index definition in the table producer class.


(fredt@users)
(campbell-burnet@users)
Authors
Campbell Burnet (campbell-burnet@users dot sourceforge.net), Fred Toussi (fredt@users dot sourceforge.net)
Since
JDK 1.1 HSQLDB 1.9.0
Version
2.7.4
See Also
org.hsqldb.dbinfo.DatabaseInformation

Field Summary

Modifier and TypeField and Description
private static final String
BRI_SESSION_SCOPE_IN_LIST

A CSV list representing the SQL IN list to use when generating queries for getBestRowIdentifier when the scope argument is bestRowSession.

private static final String
BRI_TEMPORARY_SCOPE_IN_LIST

A CSV list representing the SQL IN list to use when generating queries for getBestRowIdentifier when the scope argument is bestRowTemporary.

private static final String
BRI_TRANSACTION_SCOPE_IN_LIST

A CSV list representing the SQL IN list to use when generating queries for getBestRowIdentifier when the scope argument is bestRowTransaction.

private boolean
concatNulls

NULL related properties are updated on each call.

private JDBCConnection
connection

The connection this object uses to retrieve database instance-specific metadata.

pack-priv static final Integer
INT_COLUMNS_NO_NULLS

Used by getBestRowIdentifier to avoid extra object construction

public static final int
public static final int
private boolean
private boolean
private static final String[]
private static final String[]
private static final String[]
private static final String[]
private static final String
selstar

"SELECT * FROM ".

public static final String
private final boolean
useSchemaDefault

Connection property for schema reporting.

private static final String
whereTrue

" WHERE TRUE ".

Constructor Summary

AccessConstructor and Description
pack-priv
JDBCDatabaseMetaData(JDBCConnection
the connection this object will use to retrieve instance-specific metadata
c
)

Constructs a new JDBCDatabaseMetaData object using the specified connection.

Method Summary

Modifier and TypeMethod and Description
public boolean

Returns:

true if so; false otherwise
allProceduresAreCallable
()

Implements java.sql.DatabaseMetaData.allProceduresAreCallable.

Retrieves whether the current user can call all the procedures returned by the method getProcedures.

public boolean

Returns:

true if so; false otherwise
allTablesAreSelectable
()

Implements java.sql.DatabaseMetaData.allTablesAreSelectable.

Retrieves whether the current user can use all the tables returned by the method getTables in a SELECT statement.

private static String

Returns:

an "AND" predicate built from the arguments
and
(String
the simple, non-quoted identifier of a system table column upon which to filter.

No checking is done for column name validity.
It is assumed the system table column name is correct.

id
,
String
the conditional operation to perform using the system table column name value and the val argument.
op
,
Object
an object representing the value to use in some conditional operation, op, between the column identified by the id argument and this argument.
  • null causes the empty string to be returned.
  • toString().length() == 0 causes the returned expression to be built so that the IS NULL operation will occur against the specified column.
  • instanceof String causes the returned expression to be built so that the specified operation will occur between the specified column and the specified value, converted to an SQL string (single quoted, with internal single quotes escaped by doubling). If op is "LIKE" and val does not contain any "%" or "_" wild card characters, then op is silently converted to "=".
  • !instanceof String causes an expression to built so that the specified operation will occur between the specified column and String.valueOf(val).
val
)

Retrieves an "AND" predicate based on the (column) id, op(erator) andval(ue) arguments to be included in an SQL "WHERE" clause, using the conventions laid out for JDBC DatabaseMetaData filter parameter values.

public boolean

Returns:

true if so; false otherwise
autoCommitFailureClosesAllResultSets
()

Implements java.sql.DatabaseMetaData.autoCommitFailureClosesAllResultSets.

Retrieves whether a SQLException while autoCommit is true indicates that all open ResultSets are closed, even ones that are holdable.

public boolean

Returns:

true if so; false otherwise
dataDefinitionCausesTransactionCommit
()

Implements java.sql.DatabaseMetaData.dataDefinitionCausesTransactionCommit.

Retrieves whether a data definition statement within a transaction forces the transaction to commit.

public boolean

Returns:

true if so; false otherwise
dataDefinitionIgnoredInTransactions
()

Implements java.sql.DatabaseMetaData.dataDefinitionIgnoredInTransactions.

Retrieves whether this database ignores a data definition statement within a transaction.

public boolean

Returns:

true if deletes are detected by the given result set type; false otherwise
deletesAreDetected
(int
the ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
type
)

Implements java.sql.DatabaseMetaData.deletesAreDetected.

Retrieves whether or not a visible row delete can be detected by calling the method ResultSet.rowDeleted.

public boolean

Returns:

true if so; false otherwise
doesMaxRowSizeIncludeBlobs
()

Implements java.sql.DatabaseMetaData.doesMaxRowSizeIncludeBlobs.

Retrieves whether the return value for the method getMaxRowSize includes the SQL data types LONGVARCHAR and LONGVARBINARY.

private ResultSet

Returns:

the result of issuing the statement
execute
(String
SQL statement to execute
sql
)

The main SQL statement executor.

private ResultSet

Returns:

the result of executing "SELECT * FROM " + table " " + where
executeSelect
(String
the name of a table to "select * from"
table
,
String
the where condition for the select
where
)

An SQL statement executor that knows how to create a "SELECT * FROM" statement, given a table name and a where clause.

public boolean

Returns:

true if so; false otherwise
generatedKeyAlwaysReturned
()

Implements java.sql.DatabaseMetaData.generatedKeyAlwaysReturned.

Retrieves whether a generated key will always be returned if the column name(s) or index(es) specified for the auto generated key column(s) are valid and the statement succeeds.

public ResultSet

Returns:

a ResultSet object in which each row is an attribute 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; 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 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.

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; 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; 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
schema
,
String
a table name; must match the table name as it is stored in the database
table
,
int
the scope of interest; use same values as SCOPE
scope
,
boolean
include columns that are nullable.
nullable
)

Implements java.sql.DatabaseMetaData.getBestRowIdentifier.

Retrieves a description of a table's optimal set of columns that uniquely identifies a row.

public ResultSet

Returns:

a ResultSet object in which each row has a single String column that is a catalog name
getCatalogs
()

Implements java.sql.DatabaseMetaData.getCatalogs.

Retrieves the catalog names available in this database.

public String

Returns:

the separator string
getCatalogSeparator
()

Implements java.sql.DatabaseMetaData.getCatalogSeparator.

Retrieves the String that this database uses as the separator between a catalog and table name.

public String

Returns:

the vendor term for "catalog"
getCatalogTerm
()

Implements java.sql.DatabaseMetaData.getCatalogTerm.

Retrieves the database vendor's preferred term for "catalog".

public ResultSet

Returns:

A ResultSet object; each row is a supported client info property
getClientInfoProperties
()

Implements java.sql.DatabaseMetaData.getClientInfoProperties.

Retrieves a list of the client info properties that the driver supports.

public ResultSet

Returns:

ResultSet - each row is a column privilege description
getColumnPrivileges
(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; 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
schema
,
String
a table name; must match the table name as it is stored in the database
table
,
String
a column name pattern; must match the column name as it is stored in the database
columnNamePattern
)

Implements java.sql.DatabaseMetaData.getColumnPrivileges.

Retrieves 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; 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.getColumns.

Retrieves a description of table columns available in the specified catalog.

public Connection

Returns:

the connection that produced this metadata object
getConnection
()

Implements java.sql.DatabaseMetaData.getConnection.

Retrieves the connection that produced this metadata object.

pack-priv String
public ResultSet

Returns:

ResultSet - each row is a foreign key column description
getCrossReference
(String
a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means drop catalog name from the selection criteria
parentCatalog
,
String
a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means drop schema name from the selection criteria
parentSchema
,
String
the name of the table that exports the key; must match the table name as it is stored in the database
parentTable
,
String
a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means drop catalog name from the selection criteria
foreignCatalog
,
String
a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means drop schema name from the selection criteria
foreignSchema
,
String
the name of the table that imports the key; must match the table name as it is stored in the database
foreignTable
)

Implements java.sql.DatabaseMetaData.getCrossReference.

Retrieves a description of the foreign key columns in the given foreign key table that reference the primary key or the columns representing a unique constraint of the parent table (could be the same or a different table).

pack-priv String
getDatabaseDefaultCatalog()

Returns the name of the catalog of the default schema.

public String

Returns:

name of collation
getDatabaseDefaultCollation
()

Returns the name of the default collation for database.

pack-priv String
getDatabaseDefaultSchema()

Returns the name of the default schema for database.

public int

Returns:

the underlying database's major version
getDatabaseMajorVersion
()

Implements java.sql.DatabaseMetaData.getDatabaseMajorVersion.

Retrieves the major version number of the underlying database.

public int

Returns:

underlying database's minor version
getDatabaseMinorVersion
()

Implements java.sql.DatabaseMetaData.getDatabaseMinorVersion.

Retrieves the minor version number of the underlying database.

public String

Returns:

database product name
getDatabaseProductName
()

Implements java.sql.DatabaseMetaData.getDatabaseProductName.

Retrieves the name of this database product.

public String

Returns:

database version number
getDatabaseProductVersion
()

Implements java.sql.DatabaseMetaData.getDatabaseProductVersion.

Retrieves the version number of this database product.

public int

Returns:

the default isolation level
getDefaultTransactionIsolation
()

Implements java.sql.DatabaseMetaData.getDefaultTransactionIsolation.

Retrieves this database's default transaction isolation level.

public int

Returns:

JDBC driver major version
getDriverMajorVersion
()

Implements java.sql.DatabaseMetaData.getDriverMajorVersion.

Retrieves this JDBC driver's major version number.

public int

Returns:

JDBC driver minor version number
getDriverMinorVersion
()

Implements java.sql.DatabaseMetaData.getDriverMinorVersion.

Retrieves this JDBC driver's minor version number.

public String

Returns:

JDBC driver name
getDriverName
()

Implements java.sql.DatabaseMetaData.getDriverName.

Retrieves the name of this JDBC driver.

public String

Returns:

JDBC driver version
getDriverVersion
()

Implements java.sql.DatabaseMetaData.getDriverVersion.

Retrieves the version number of this JDBC driver as a String.

public ResultSet

Returns:

a ResultSet object in which each row is a foreign key column description
getExportedKeys
(String
a catalog name; must match the catalog name as it is stored in this 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; 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
schema
,
String
a table name; must match the table name as it is stored in this database
table
)

Implements java.sql.DatabaseMetaData.getExportedKeys.

Retrieves a description of the foreign key columns that reference the given 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.

Retrieves all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _).

public ResultSet

Returns:

ResultSet - each row describes a user function parameter, column or return type
getFunctionColumns
(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 procedure name pattern; must match the function name as it is stored in the database
functionNamePattern
,
String
a parameter name pattern; must match the parameter or column name as it is stored in the database
columnNamePattern
)

Implements java.sql.DatabaseMetaData.getFunctionColumns.

Retrieves a description of the given catalog's system or user function parameters and return type.

public ResultSet

Returns:

ResultSet - each row is a function description
getFunctions
(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 function name pattern; must match the function name as it is stored in the database
functionNamePattern
)

Implements java.sql.DatabaseMetaData.getFunctions.

Retrieves a description of the system and user functions available in the given catalog.

public String

Returns:

the quoting string or a space if quoting is not supported
getIdentifierQuoteString
()

Implements java.sql.DatabaseMetaData.getIdentifierQuoteString.

Retrieves the string used to quote SQL identifiers.

public ResultSet

Returns:

ResultSet - each row is a primary key column description
getImportedKeys
(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; 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
schema
,
String
a table name; must match the table name as it is stored in the database
table
)

Implements java.sql.DatabaseMetaData.getImportedKeys.

Retrieves a description of the primary key columns that are referenced by the given 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; must match the catalog name as it is stored in this 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; must match the schema name as it is stored in this database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search
schema
,
String
a table name; must match the table name as it is stored in this database
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.

Retrieves a description of the given table's indices and statistics.

public int

Returns:

JDBC version major number
getJDBCMajorVersion
()

Implements java.sql.DatabaseMetaData.getJDBCMajorVersion.

Retrieves the major JDBC version number for this driver.

public int

Returns:

JDBC version minor number
getJDBCMinorVersion
()

Implements java.sql.DatabaseMetaData.getJDBCMinorVersion.

Retrieves the minor JDBC version number for this driver.

public int

Returns:

max the maximum length (in hex characters) for a binary literal; a result of zero means that there is no limit or the limit is not known
getMaxBinaryLiteralLength
()

Implements java.sql.DatabaseMetaData.getMaxBinaryLiteralLength.

Retrieves the maximum number of hex characters this database allows in an inline binary literal.

public int

Returns:

the maximum number of characters allowed in a catalog name; a result of zero means that there is no limit or the limit is not known
getMaxCatalogNameLength
()

Implements java.sql.DatabaseMetaData.getMaxCatalogNameLength.

Retrieves the maximum number of characters that this database allows in a catalog name.

public int

Returns:

the maximum number of characters allowed for a character literal; a result of zero means that there is no limit or the limit is not known
getMaxCharLiteralLength
()

Implements java.sql.DatabaseMetaData.getMaxCharLiteralLength.

Retrieves the maximum number of characters this database allows for a character literal.

public int

Returns:

the maximum number of characters allowed for a column name; a result of zero means that there is no limit or the limit is not known
getMaxColumnNameLength
()

Implements java.sql.DatabaseMetaData.getMaxColumnNameLength.

Retrieves the maximum number of characters this database allows for a column name.

public int

Returns:

the maximum number of columns allowed; a result of zero means that there is no limit or the limit is not known
getMaxColumnsInGroupBy
()

Implements java.sql.DatabaseMetaData.getMaxColumnsInGroupBy.

Retrieves the maximum number of columns this database allows in a GROUP BY clause.

public int

Returns:

the maximum number of columns allowed; a result of zero means that there is no limit or the limit is not known
getMaxColumnsInIndex
()

Implements java.sql.DatabaseMetaData.getMaxColumnsInIndex.

Retrieves the maximum number of columns this database allows in an index.

public int

Returns:

the maximum number of columns allowed; a result of zero means that there is no limit or the limit is not known
getMaxColumnsInOrderBy
()

Implements java.sql.DatabaseMetaData.getMaxColumnsInOrderBy.

Retrieves the maximum number of columns this database allows in an ORDER BY clause.

public int

Returns:

the maximum number of columns allowed; a result of zero means that there is no limit or the limit is not known
getMaxColumnsInSelect
()

Implements java.sql.DatabaseMetaData.getMaxColumnsInSelect.

Retrieves the maximum number of columns this database allows in a SELECT list.

public int

Returns:

the maximum number of columns allowed; a result of zero means that there is no limit or the limit is not known
getMaxColumnsInTable
()

Implements java.sql.DatabaseMetaData.getMaxColumnsInTable.

Retrieves the maximum number of columns this database allows in a table.

public int

Returns:

the maximum number of active connections possible at one time; a result of zero means that there is no limit or the limit is not known
getMaxConnections
()

Implements java.sql.DatabaseMetaData.getMaxConnections.

Retrieves the maximum number of concurrent connections to this database that are possible.

public int

Returns:

the maximum number of characters allowed in a cursor name; a result of zero means that there is no limit or the limit is not known
getMaxCursorNameLength
()

Implements java.sql.DatabaseMetaData.getMaxCursorNameLength.

Retrieves the maximum number of characters that this database allows in a cursor name.

public int

Returns:

the maximum number of bytes allowed; this limit includes the composite of all the constituent parts of the index; a result of zero means that there is no limit or the limit is not known
getMaxIndexLength
()

Implements java.sql.DatabaseMetaData.getMaxIndexLength.

Retrieves the maximum number of bytes this database allows for an index, including all of the parts of the index.

public long

Returns:

the maximum number of bytes allowed; a result of zero means that there is no limit or the limit is not known
getMaxLogicalLobSize
()

Overrides default java.sql.DatabaseMetaData.getMaxLogicalLobSize.

Retrieves the maximum number of bytes this database allows for the logical size for a LOB.

public int

Returns:

the maximum number of characters allowed in a procedure name; a result of zero means that there is no limit or the limit is not known
getMaxProcedureNameLength
()

Implements java.sql.DatabaseMetaData.getMaxProcedureNameLength.

Retrieves the maximum number of characters that this database allows in a procedure name.

public int

Returns:

the maximum number of bytes allowed for a row; a result of zero means that there is no limit or the limit is not known
getMaxRowSize
()

Implements java.sql.DatabaseMetaData.getMaxRowSize.

Retrieves the maximum number of bytes this database allows in a single row.

public int

Returns:

the maximum number of characters allowed in a schema name; a result of zero means that there is no limit or the limit is not known
getMaxSchemaNameLength
()

Implements java.sql.DatabaseMetaData.getMaxSchemaNameLength.

Retrieves the maximum number of characters that this database allows in a schema name.

public int

Returns:

the maximum number of characters allowed for an SQL statement; a result of zero means that there is no limit or the limit is not known
getMaxStatementLength
()

Implements java.sql.DatabaseMetaData.getMaxStatementLength.

Retrieves the maximum number of characters this database allows in an SQL statement.

public int

Returns:

the maximum number of statements that can be open at one time; a result of zero means that there is no limit or the limit is not known
getMaxStatements
()

Implements java.sql.DatabaseMetaData.getMaxStatements.

Retrieves the maximum number of active statements to this database that can be open at the same time.

public int

Returns:

the maximum number of characters allowed for a table name; a result of zero means that there is no limit or the limit is not known
getMaxTableNameLength
()

Implements java.sql.DatabaseMetaData.getMaxTableNameLength.

Retrieves the maximum number of characters this database allows in a table name.

public int

Returns:

the maximum number of tables allowed in a SELECT statement; a result of zero means that there is no limit or the limit is not known
getMaxTablesInSelect
()

Implements java.sql.DatabaseMetaData.getMaxTablesInSelect.

Retrieves the maximum number of tables this database allows in a SELECT statement.

public int

Returns:

the maximum number of characters allowed for a user name; a result of zero means that there is no limit or the limit is not known
getMaxUserNameLength
()

Implements java.sql.DatabaseMetaData.getMaxUserNameLength.

Retrieves the maximum number of characters this database allows in a user name.

public String

Returns:

the list of math functions supported by this database
getNumericFunctions
()

Implements java.sql.DatabaseMetaData.getNumericFunctions.

Retrieves a comma-separated list of math functions available with this database.

public ResultSet

Returns:

ResultSet - each row is a primary key column description
getPrimaryKeys
(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; 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
schema
,
String
a table name; must match the table name as it is stored in the database
table
)

Implements java.sql.DatabaseMetaData.getPrimaryKeys.

Retrieves a description of the given table's primary key columns.

public ResultSet

Returns:

ResultSet - each row describes a stored procedure parameter or column
getProcedureColumns
(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 procedure name pattern; must match the procedure name as it is stored in the database
procedureNamePattern
,
String
a column name pattern; must match the column name as it is stored in the database
columnNamePattern
)

Implements java.sql.DatabaseMetaData.getProcedureColumns.

Retrieves a description of the given catalog's stored procedure parameter and result columns.

public ResultSet

Returns:

ResultSet - each row is a procedure description
getProcedures
(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 procedure name pattern; must match the procedure name as it is stored in the database
procedureNamePattern
)

Implements java.sql.DatabaseMetaData.getProcedures.

Retrieves a description of the stored procedures available in the given catalog.

public String

Returns:

the vendor term for "procedure"
getProcedureTerm
()

Implements java.sql.DatabaseMetaData.getProcedureTerm.

Retrieves the database vendor's preferred term for "procedure".

public ResultSet

Returns:

ResultSet - each row is a column description
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.

Retrieves a description of the pseudo or hidden columns available in a given table within the specified catalog and schema.

public int

Returns:

the default holdability; either ResultSet.HOLD_CURSORS_OVER_COMMIT or ResultSet.CLOSE_CURSORS_AT_COMMIT
getResultSetHoldability
()

Implements java.sql.DatabaseMetaData.getResultSetHoldability.

Retrieves this database's default holdability for ResultSet objects.

public RowIdLifetime

Returns:

the status indicating the lifetime of a RowId
getRowIdLifetime
()

Implements java.sql.DatabaseMetaData.getRowIdLifetime.

Indicates whether this data source supports the SQL ROWID type, and the lifetime for which a java.sql.RowId object remains valid.

public ResultSet

Returns:

a ResultSet object in which each row is a schema description
getSchemas
()

Implements java.sql.DatabaseMetaData.getSchemas.

Retrieves the schema names available in this database.

public ResultSet

Returns:

a ResultSet object in which each row is a schema description
getSchemas
(String
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.
catalog
,
String
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.
schemaPattern
)

Implements java.sql.DatabaseMetaData.getSchemas.

Retrieves the schema names available in this database.

public String

Returns:

the vendor term for "schema"
getSchemaTerm
()

Implements java.sql.DatabaseMetaData.getSchemaTerm.

Retrieves the database vendor's preferred term for "schema".

public String

Returns:

the string used to escape wildcard characters
getSearchStringEscape
()

Implements java.sql.DatabaseMetaData.getSearchStringEscape.

Retrieves the string that can be used to escape wildcard characters.

public String

Returns:

the list of this database's keywords that are not also SQL:2003 keywords
getSQLKeywords
()

Implements java.sql.DatabaseMetaData.getSQLKeywords.

Retrieves a comma-separated list of all of this database's SQL keywords that are NOT also SQL:2003 keywords.

public int

Returns:

the type of SQLSTATE; one of: sqlStateXOpen or sqlStateSQL
getSQLStateType
()

Implements java.sql.DatabaseMetaData.getSQLStateType.

Indicates whether the SQLSTATE returned by SQLException.getSQLState is X/Open (now known as Open Group) SQL CLI or SQL:2003.

public String

Returns:

the list of string functions supported by this database
getStringFunctions
()

Implements java.sql.DatabaseMetaData.getStringFunctions.

Retrieves a comma-separated list of string functions available with this database.

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 table name pattern; may be a fully-qualified name
tableNamePattern
)

Implements java.sql.DatabaseMetaData.getSuperTables.

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.

Retrieves a description of the user-defined type (UDT) hierarchies defined in a particular schema in this database.

public String

Returns:

a list of system functions supported by this database
getSystemFunctions
()

Implements java.sql.DatabaseMetaData.getSystemFunctions.

Retrieves a comma-separated list of system functions available with this database.

public ResultSet

Returns:

ResultSet - each row is a table privilege description
getTablePrivileges
(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
)

Implements java.sql.DatabaseMetaData.getTablePrivileges.

Retrieves 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; 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 list of table types, which must be from the list of table types returned from getTableTypes, to include; null returns all types
types
)

Implements java.sql.DatabaseMetaData.getTables.

Retrieves a description of the tables available in the given catalog.

public ResultSet

Returns:

a ResultSet object in which each row has a single String column that is a table type
getTableTypes
()

Implements java.sql.DatabaseMetaData.getTableTypes.

Retrieves the table types available in this database.

public String

Returns:

the list of time and date functions supported by this database
getTimeDateFunctions
()

Implements java.sql.DatabaseMetaData.getTimeDateFunctions.

Retrieves a comma-separated list of the time and date functions available with this database.

public ResultSet

Returns:

a ResultSet object in which each row is an SQL type description
getTypeInfo
()

Implements java.sql.DatabaseMetaData.getTypeInfo.

Retrieves a description of all the data types supported by this database.

public ResultSet

Returns:

ResultSet object in which each row describes a UDT
getUDTs
(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 pattern name; 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 type name pattern; must match the type name as it is stored in the database; may be a fully qualified name
typeNamePattern
,
int[]
a list of user-defined types (JAVA_OBJECT, STRUCT, or DISTINCT) to include; null returns all types
types
)

Implements java.sql.DatabaseMetaData.getUDTs.

Retrieves a description of the user-defined types (UDTs) defined in a particular schema.

public String

Returns:

the URL for this DBMS or null if it cannot be generated
getURL
()

Implements java.sql.DatabaseMetaData.getURL.

Retrieves the URL for this DBMS.

public String

Returns:

the database user name
getUserName
()

Implements java.sql.DatabaseMetaData.getUserName.

Retrieves the user name as known to this database.

public ResultSet

Returns:

a ResultSet object in which each row is a column description
getVersionColumns
(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; 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
schema
,
String
a table name; must match the table name as it is stored in the database
table
)

Implements java.sql.DatabaseMetaData.getVersionColumns.

Retrieves a description of a table's columns that are automatically updated when any value in a row is updated.

public boolean

Returns:

true if changes are detected by the specified result set type; false otherwise
insertsAreDetected
(int
the ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
type
)

Implements java.sql.DatabaseMetaData.insertsAreDetected.

Retrieves whether or not a visible row insert can be detected by calling the method ResultSet.rowInserted.

public boolean

Returns:

true if the catalog name appears at the beginning of a fully qualified table name; false otherwise
isCatalogAtStart
()

Implements java.sql.DatabaseMetaData.isCatalogAtStart.

Retrieves whether a catalog appears at the start of a fully qualified table name.

public boolean

Returns:

true if so; false otherwise
isReadOnly
()

Implements java.sql.DatabaseMetaData.isReadOnly.

Retrieves whether this database is in read-only mode.

public boolean

Returns:

true if this implements the interface or directly or indirectly wraps an object that does.
isWrapperFor
(Class<?>
a Class defining an interface.
iface
)

Implements java.sql.Wrapper.isWrapperFor.

Returns true if this either implements the interface argument or is directly or indirectly a wrapper for an object that does.

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.

Indicates whether updates made to a LOB are made on a copy or directly to the LOB.

public boolean

Returns:

true if so; false otherwise
nullPlusNonNullIsNull
()

Implements java.sql.DatabaseMetaData.nullPlusNonNullIsNull.

Retrieves whether this database supports concatenations between NULL and non-NULL values being NULL.

public boolean

Returns:

true if so; false otherwise
nullsAreSortedAtEnd
()

Implements java.sql.DatabaseMetaData.nullsAreSortedAtEnd.

Retrieves whether NULL values are sorted at the end regardless of sort order.

public boolean

Returns:

true if so; false otherwise
nullsAreSortedAtStart
()

Implements java.sql.DatabaseMetaData.nullsAreSortedAtStart.

Retrieves whether NULL values are sorted at the start regardless of sort order.

public boolean

Returns:

true if so; false otherwise
nullsAreSortedHigh
()

Implements java.sql.DatabaseMetaData.nullsAreSortedHigh.

Retrieves whether NULL values are sorted high.

public boolean

Returns:

true if so; false otherwise
nullsAreSortedLow
()

Implements java.sql.DatabaseMetaData.nullsAreSortedLow.

Retrieves whether NULL values are sorted low.

public boolean

Returns:

true if deletes made by others are visible for the given result set type; false otherwise
othersDeletesAreVisible
(int
the ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
type
)

Implements java.sql.DatabaseMetaData.othersDeletesAreVisible.

Retrieves whether deletes made by others are visible.

public boolean

Returns:

true if inserts made by others are visible for the given result set type; false otherwise
othersInsertsAreVisible
(int
the ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
type
)

Implements java.sql.DatabaseMetaData.othersInsertsAreVisible.

Retrieves whether inserts made by others are visible.

public boolean

Returns:

true if updates made by others are visible for the given result set type; false otherwise
othersUpdatesAreVisible
(int
the ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
type
)

Implements java.sql.DatabaseMetaData.othersUpdatesAreVisible.

Retrieves whether updates made by others are visible.

public boolean

Returns:

true if deletes are visible for the given result set type; false otherwise
ownDeletesAreVisible
(int
the ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
type
)

Implements java.sql.DatabaseMetaData.ownDeletesAreVisible.

Retrieves whether a result set's own deletes are visible.

public boolean

Returns:

true if inserts are visible for the given result set type; false otherwise
ownInsertsAreVisible
(int
the ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
type
)

Implements java.sql.DatabaseMetaData.ownInsertsAreVisible.

Retrieves whether a result set's own inserts are visible.

public boolean

Returns:

true if updates are visible for the given result set type; false otherwise
ownUpdatesAreVisible
(int
the ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
type
)

Implements java.sql.DatabaseMetaData.ownUpdatesAreVisible.

Retrieves whether for the given type of ResultSet object, the result set's own updates are visible.

pack-priv void
private void
public boolean

Returns:

true if so; false otherwise
storesLowerCaseIdentifiers
()

Implements java.sql.DatabaseMetaData.storesLowerCaseIdentifiers.

Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in lower case.

public boolean

Returns:

true if so; false otherwise
storesLowerCaseQuotedIdentifiers
()

Implements java.sql.DatabaseMetaData.storesLowerCaseQuotedIdentifiers.

Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in lower case.

public boolean

Returns:

true if so; false otherwise
storesMixedCaseIdentifiers
()

Implements java.sql.DatabaseMetaData.storesMixedCaseIdentifiers.

Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case.

public boolean

Returns:

true if so; false otherwise
storesMixedCaseQuotedIdentifiers
()

Implements java.sql.DatabaseMetaData.storesMixedCaseQuotedIdentifiers.

Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in mixed case.

public boolean

Returns:

true if so; false otherwise
storesUpperCaseIdentifiers
()

Implements java.sql.DatabaseMetaData.storesUpperCaseIdentifiers.

Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in upper case.

public boolean

Returns:

true if so; false otherwise
storesUpperCaseQuotedIdentifiers
()

Implements java.sql.DatabaseMetaData.storesUpperCaseQuotedIdentifiers.

Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in upper case.

public boolean

Returns:

true if so; false otherwise
supportsAlterTableWithAddColumn
()

Implements java.sql.DatabaseMetaData.supportsAlterTableWithAddColumn.

Retrieves whether this database supports ALTER TABLE with add column.

public boolean

Returns:

true if so; false otherwise
supportsAlterTableWithDropColumn
()

Implements java.sql.DatabaseMetaData.supportsAlterTableWithDropColumn.

Retrieves whether this database supports ALTER TABLE with drop column.

public boolean

Returns:

true if so; false otherwise
supportsANSI92EntryLevelSQL
()

Implements java.sql.DatabaseMetaData.supportsANSI92EntryLevelSQL.

Retrieves whether this database supports the ANSI92 entry level SQL grammar.

public boolean

Returns:

true if so; false otherwise
supportsANSI92FullSQL
()

Implements java.sql.DatabaseMetaData.supportsANSI92FullSQL.

Retrieves whether this database supports the ANSI92 full SQL grammar supported.

public boolean

Returns:

true if so; false otherwise
supportsANSI92IntermediateSQL
()

Implements java.sql.DatabaseMetaData.supportsANSI92IntermediateSQL.

Retrieves whether this database supports the ANSI92 intermediate SQL grammar supported.

public boolean

Returns:

true if this database supports batch updates; false otherwise
supportsBatchUpdates
()

Implements java.sql.DatabaseMetaData.supportsBatchUpdates.

Retrieves whether this database supports batch updates.

public boolean

Returns:

true if so; false otherwise
supportsCatalogsInDataManipulation
()

Implements java.sql.DatabaseMetaData.supportsCatalogsInDataManipulation.

Retrieves whether a catalog name can be used in a data manipulation statement.

public boolean

Returns:

true if so; false otherwise
supportsCatalogsInIndexDefinitions
()

Implements java.sql.DatabaseMetaData.supportsCatalogsInIndexDefinitions.

Retrieves whether a catalog name can be used in an index definition statement.

public boolean

Returns:

true if so; false otherwise
supportsCatalogsInPrivilegeDefinitions
()

Implements java.sql.DatabaseMetaData.supportsCatalogsInPrivilegeDefinitions.

Retrieves whether a catalog name can be used in a privilege definition statement.

public boolean

Returns:

true if so; false otherwise
supportsCatalogsInProcedureCalls
()

Implements java.sql.DatabaseMetaData.supportsCatalogsInProcedureCalls.

Retrieves whether a catalog name can be used in a procedure call statement.

public boolean

Returns:

true if so; false otherwise
supportsCatalogsInTableDefinitions
()

Implements java.sql.DatabaseMetaData.supportsCatalogsInTableDefinitions.

Retrieves whether a catalog name can be used in a table definition statement.

public boolean

Returns:

true if so; false otherwise
supportsColumnAliasing
()

Implements java.sql.DatabaseMetaData.supportsColumnAliasing.

Retrieves whether this database supports column aliasing.

public boolean

Returns:

true if so; false otherwise
supportsConvert
()

Implements java.sql.DatabaseMetaData.supportsConvert.

Retrieves whether this database supports the JDBC scalar function CONVERT for the conversion of one JDBC type to another.

public boolean

Returns:

true if so; false otherwise
supportsConvert
(int
the type to convert from; one of the type codes from the class java.sql.Types
fromType
,
int
the type to convert to; one of the type codes from the class java.sql.Types
toType
)

Implements java.sql.DatabaseMetaData.supportsConvert.

Retrieves whether this database supports the JDBC scalar function CONVERT for conversions between the JDBC types fromType and toType.

public boolean

Returns:

true if so; false otherwise
supportsCoreSQLGrammar
()

Implements java.sql.DatabaseMetaData.supportsCoreSQLGrammar.

Retrieves whether this database supports the ODBC Core SQL grammar.

public boolean

Returns:

true if so; false otherwise
supportsCorrelatedSubqueries
()

Implements java.sql.DatabaseMetaData.supportsCorrelatedSubqueries.

Retrieves whether this database supports correlated subqueries.

public boolean

Returns:

true if so; false otherwise
supportsDataDefinitionAndDataManipulationTransactions
()

Implements java.sql.DatabaseMetaData.supportsDataDefinitionAndDataManipulationTransactions.

Retrieves whether this database supports both data definition and data manipulation statements within a transaction.

public boolean

Returns:

true if so; false otherwise
supportsDataManipulationTransactionsOnly
()

Implements java.sql.DatabaseMetaData.supportsDataManipulationTransactionsOnly.

Retrieves whether this database supports only data manipulation statements within a transaction.

public boolean

Returns:

true if so; false otherwise
supportsDifferentTableCorrelationNames
()

Implements java.sql.DatabaseMetaData.supportsDifferentTableCorrelationNames.

Retrieves whether, when table correlation names are supported, they are restricted to being different from the names of the tables.

public boolean

Returns:

true if so; false otherwise
supportsExpressionsInOrderBy
()

Implements java.sql.DatabaseMetaData.supportsExpressionsInOrderBy.

Retrieves whether this database supports expressions in ORDER BY lists.

public boolean

Returns:

true if so; false otherwise
supportsExtendedSQLGrammar
()

Implements java.sql.DatabaseMetaData.supportsExtendedSQLGrammar.

Retrieves whether this database supports the ODBC Extended SQL grammar.

public boolean

Returns:

true if so; false otherwise
supportsFullOuterJoins
()

Implements java.sql.DatabaseMetaData.supportsFullOuterJoins.

Retrieves whether this database supports full nested outer joins.

public boolean

Returns:

true if auto-generated keys can be retrieved after a statement has executed; false otherwise

If true is returned, the JDBC driver must support the returning of auto-generated keys for at least SQL INSERT statements

supportsGetGeneratedKeys
()

Implements java.sql.DatabaseMetaData.supportsGetGeneratedKeys.

Retrieves whether auto-generated keys can be retrieved after a statement has been executed

HSQLDB-Specific Information: HSQLDB supports retrieval of autogenerated keys through the JDBC interface; this method always returns true.

public boolean

Returns:

true if so; false otherwise
supportsGroupBy
()

Implements java.sql.DatabaseMetaData.supportsGroupBy.

Retrieves whether this database supports some form of GROUP BY clause.

public boolean

Returns:

true if so; false otherwise
supportsGroupByBeyondSelect
()

Implements java.sql.DatabaseMetaData.supportsGroupByBeyondSelect.

Retrieves whether this database supports using columns not included in the SELECT statement in a GROUP BY clause provided that all of the columns in the SELECT statement are included in the GROUP BY clause.

public boolean

Returns:

true if so; false otherwise
supportsGroupByUnrelated
()

Implements java.sql.DatabaseMetaData.supportsGroupByUnrelated.

Retrieves whether this database supports using a column that is not in the SELECT statement in a GROUP BY clause.

public boolean

Returns:

true if so; false otherwise
supportsIntegrityEnhancementFacility
()

Implements java.sql.DatabaseMetaData.supportsIntegrityEnhancementFacility.

Retrieves whether this database supports the SQL Integrity Enhancement Facility.

public boolean

Returns:

true if so; false otherwise
supportsLikeEscapeClause
()

Implements java.sql.DatabaseMetaData.supportsLikeEscapeClause.

Retrieves whether this database supports specifying a LIKE escape clause.

public boolean

Returns:

true if so; false otherwise
supportsLimitedOuterJoins
()

Implements java.sql.DatabaseMetaData.supportsLimitedOuterJoins.

Retrieves whether this database provides limited support for outer joins.

public boolean

Returns:

true if so; false otherwise
supportsMinimumSQLGrammar
()

Implements java.sql.DatabaseMetaData.supportsMinimumSQLGrammar.

Retrieves whether this database supports the ODBC Minimum SQL grammar.

public boolean

Returns:

true if so; false otherwise
supportsMixedCaseIdentifiers
()

Implements java.sql.DatabaseMetaData.supportsMixedCaseIdentifiers.

Retrieves whether this database treats mixed case unquoted SQL identifiers as case sensitive and as a result stores them in mixed case.

public boolean

Returns:

true if so; false otherwise
supportsMixedCaseQuotedIdentifiers
()

Implements java.sql.DatabaseMetaData.supportsMixedCaseQuotedIdentifiers.

Retrieves whether this database treats mixed case quoted SQL identifiers as case sensitive and as a result stores 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.

Retrieves whether it is possible to have multiple ResultSet objects returned from a CallableStatement object simultaneously.

public boolean

Returns:

true if so; false otherwise
supportsMultipleResultSets
()

Implements java.sql.DatabaseMetaData.supportsMultipleResultSets.

Retrieves whether this database supports getting multiple ResultSet objects from a single call to the method execute.

public boolean

Returns:

true if so; false otherwise
supportsMultipleTransactions
()

Implements java.sql.DatabaseMetaData.supportsMultipleTransactions.

Retrieves whether this database allows having 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.

Retrieves whether this database supports named parameters to callable statements.

public boolean

Returns:

true if so; false otherwise
supportsNonNullableColumns
()

Implements java.sql.DatabaseMetaData.supportsNonNullableColumns.

Retrieves whether columns in this database may 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.

Retrieves whether this database supports keeping cursors 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.

Retrieves whether this database supports keeping cursors 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.

Retrieves whether this database supports keeping statements 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.

Retrieves whether this database supports keeping statements open across rollbacks.

public boolean

Returns:

true if so; false otherwise
supportsOrderByUnrelated
()

Implements java.sql.DatabaseMetaData.supportsOrderByUnrelated.

Retrieves whether this database supports using a column that is not in the SELECT statement in an ORDER BY clause.

public boolean

Returns:

true if so; false otherwise
supportsOuterJoins
()

Implements java.sql.DatabaseMetaData.supportsOuterJoins.

Retrieves whether this database supports some form of outer join.

public boolean

Returns:

true if so; false otherwise
supportsPositionedDelete
()

Implements java.sql.DatabaseMetaData.supportsPositionedDelete.

Retrieves whether this database supports positioned DELETE statements.

public boolean

Returns:

true if so; false otherwise
supportsPositionedUpdate
()

Implements java.sql.DatabaseMetaData.supportsPositionedUpdate.

Retrieves whether this database supports positioned UPDATE statements.

public boolean

Returns:

true if this database supports REF CURSOR; false otherwise
supportsRefCursors
()

Overrides default java.sql.DatabaseMetaData.supportsRefCursors.

Retrieves whether this database supports REF CURSOR.

public boolean

Returns:

true if so; false otherwise
supportsResultSetConcurrency
(int
defined in java.sql.ResultSet
type
,
int
type defined in java.sql.ResultSet
concurrency
)

Implements java.sql.DatabaseMetaData.supportsResultSetConcurrency.

Retrieves whether this database supports the given concurrency type in combination with the given result set type.

public boolean

Returns:

true if so; 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.

Retrieves whether this database supports the given result set holdability.

public boolean

Returns:

true if so; false otherwise
supportsResultSetType
(int
defined in java.sql.ResultSet
type
)

Implements java.sql.DatabaseMetaData.supportsResultSetType.

Retrieves whether this database supports the given result set type.

public boolean

Returns:

true if savepoints are supported; false otherwise
supportsSavepoints
()

Implements java.sql.DatabaseMetaData.supportsSavepoints.

Retrieves whether this database supports savepoints.

public boolean

Returns:

true if so; false otherwise
supportsSchemasInDataManipulation
()

Implements java.sql.DatabaseMetaData.supportsSchemasInDataManipulation.

Retrieves whether a schema name can be used in a data manipulation statement.

public boolean

Returns:

true if so; false otherwise
supportsSchemasInIndexDefinitions
()

Implements java.sql.DatabaseMetaData.supportsSchemasInIndexDefinitions.

Retrieves whether a schema name can be used in an index definition statement.

public boolean

Returns:

true if so; false otherwise
supportsSchemasInPrivilegeDefinitions
()

Implements java.sql.DatabaseMetaData.supportsSchemasInPrivilegeDefinitions.

Retrieves whether a schema name can be used in a privilege definition statement.

public boolean

Returns:

true if so; false otherwise
supportsSchemasInProcedureCalls
()

Implements java.sql.DatabaseMetaData.supportsSchemasInProcedureCalls.

Retrieves whether a schema name can be used in a procedure call statement.

public boolean

Returns:

true if so; false otherwise
supportsSchemasInTableDefinitions
()

Implements java.sql.DatabaseMetaData.supportsSchemasInTableDefinitions.

Retrieves whether a schema name can be used in a table definition statement.

public boolean

Returns:

true if so; false otherwise
supportsSelectForUpdate
()

Implements java.sql.DatabaseMetaData.supportsSelectForUpdate.

Retrieves whether this database supports SELECT FOR UPDATE statements.

public boolean

Returns:

true if so; false otherwise
supportsStatementPooling
()

Implements java.sql.DatabaseMetaData.supportsStatementPooling.

Retrieves whether this database supports statement pooling.

public boolean

Returns:

true if so; false otherwise
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; false otherwise
supportsStoredProcedures
()

Implements java.sql.DatabaseMetaData.supportsStoredProcedures.

Retrieves whether this database supports stored procedure calls that use the stored procedure escape syntax.

public boolean

Returns:

true if so; false otherwise
supportsSubqueriesInComparisons
()

Implements java.sql.DatabaseMetaData.supportsSubqueriesInComparisons.

Retrieves whether this database supports subqueries in comparison expressions.

public boolean

Returns:

true if so; false otherwise
supportsSubqueriesInExists
()

Implements java.sql.DatabaseMetaData.supportsSubqueriesInExists.

Retrieves whether this database supports subqueries in EXISTS expressions.

public boolean

Returns:

true if so; false otherwise
supportsSubqueriesInIns
()

Implements java.sql.DatabaseMetaData.supportsSubqueriesInIns.

Retrieves whether this database supports subqueries in IN expressions.

public boolean

Returns:

true if so; false otherwise
supportsSubqueriesInQuantifieds
()

Implements java.sql.DatabaseMetaData.supportsSubqueriesInQuantifieds.

Retrieves whether this database supports subqueries in quantified expressions.

public boolean

Returns:

true if so; false otherwise
supportsTableCorrelationNames
()

Implements java.sql.DatabaseMetaData.supportsTableCorrelationNames.

Retrieves whether this database supports table correlation names.

public boolean

Returns:

true if so; false otherwise
supportsTransactionIsolationLevel
(int
one of the transaction isolation levels defined in java.sql.Connection
level
)

Implements java.sql.DatabaseMetaData.supportsTransactionIsolationLevel.

Retrieves whether this database supports the given transaction isolation level.

public boolean

Returns:

true if transactions are supported; false otherwise
supportsTransactions
()

Implements java.sql.DatabaseMetaData.supportsTransactions.

Retrieves whether this database supports transactions.

public boolean

Returns:

true if so; false otherwise
supportsUnion
()

Implements java.sql.DatabaseMetaData.supportsUnion.

Retrieves whether this database supports SQL UNION.

public boolean

Returns:

true if so; false otherwise
supportsUnionAll
()

Implements java.sql.DatabaseMetaData.supportsUnionAll.

Retrieves whether this database supports SQL UNION ALL.

private StringBuilder

Returns:

an StringBuilder whose content is: "SELECT * FROM <table> WHERE 1=1"
toQueryPrefix
(String
the name of the table
t
)

Retrieves "SELECT * FROM INFORMATION_SCHEMA.

private String
translateCatalog(String catalogName)

For compatibility, when the connection property "default_schema=true" is present, any DatabaseMetaData call with an empty string as the catalog parameter will use the default catalog "PUBLIC".

private String
translateSchema(String schemaName)

For compatibility, when the connection property "default_schema=true" is present, any DatabaseMetaData call with an empty string as the schema parameter will use the default schema (normally "PUBLIC").

public <T> T

Returns:

an object that implements the interface. May be a proxy for the actual implementing object.
unwrap
(Class<T>
A Class defining an interface that the result must implement.
iface
)

Implements java.sql.Wrapper.unwrap.

Returns an object that implements the given interface to allow access to non-standard methods, or standard methods not exposed by the proxy.

public boolean

Returns:

true if changes are detected by the result set type; false otherwise
updatesAreDetected
(int
the ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
type
)

Implements java.sql.DatabaseMetaData.updatesAreDetected.

Retrieves whether or not a visible row update can be detected by calling the method ResultSet.rowUpdated.

public boolean

Returns:

true if this database uses a local file for each table; false otherwise
usesLocalFilePerTable
()

Implements java.sql.DatabaseMetaData.usesLocalFilePerTable.

Retrieves whether this database uses a file for each table.

public boolean

Returns:

true if so; false otherwise
usesLocalFiles
()

Implements java.sql.DatabaseMetaData.usesLocalFiles.

Retrieves whether this database stores tables in a local file.

private static boolean

Returns:

true if the argument, s, is filter parameter value that requires a corresponding IS NULL predicate
wantsIsNull
(String
the filter parameter to test
s
)

Retrieves whether the JDBC DatabaseMetaData contract specifies that the argument s is filter parameter value that requires a corresponding IS NULL predicate.

Inherited from java.lang.Object:
cloneequalsfinalizegetClasshashCodenotifynotifyAlltoStringwaitwaitwait