Top Description Fields Constructors Methods
org.h2.jdbc

public final Class JdbcDatabaseMetaData

extends TraceObject
implements DatabaseMetaData
Class Inheritance
All Implemented Interfaces
java.sql.DatabaseMetaData, java.sql.Wrapper
Imports
java.sql.Connection, .DatabaseMetaData, .ResultSet, .RowIdLifetime, .SQLException, java.util.Map.Entry, .Properties, org.h2.engine.Constants, .Session, org.h2.jdbc.meta.DatabaseMeta, .DatabaseMetaLegacy, org.h2.message.DbException, .Trace, .TraceObject, org.h2.mode.DefaultNullOrdering, org.h2.result.ResultInterface, .SimpleResult, org.h2.value.TypeInfo, .ValueInteger, .ValueVarchar

Represents the meta data for a database.

Field Summary

Modifier and TypeField and Description
private final JdbcConnection
private final DatabaseMeta
Inherited from org.h2.message.TraceObject:
ARRAYBLOBCALLABLE_STATEMENTCLOBCONNECTIONDATA_SOURCEDATABASE_META_DATAPARAMETER_META_DATAPREPARED_STATEMENTRESULT_SETRESULT_SET_META_DATASAVEPOINTSQLXMLSTATEMENTtraceXA_DATA_SOURCEXID

Constructor Summary

AccessConstructor and Description
pack-priv

Method Summary

Modifier and TypeMethod and Description
public boolean

Returns:

true
allProceduresAreCallable
()

Implements java.sql.DatabaseMetaData.allProceduresAreCallable.

Checks if all procedures callable.

public boolean

Returns:

true
allTablesAreSelectable
()

Implements java.sql.DatabaseMetaData.allTablesAreSelectable.

Checks if it possible to query all tables returned by getTables.

public boolean

Returns:

false
autoCommitFailureClosesAllResultSets
()

Implements java.sql.DatabaseMetaData.autoCommitFailureClosesAllResultSets.

Returns whether an exception while auto commit is on closes all result sets.

private void
public boolean

Returns:

true
dataDefinitionCausesTransactionCommit
()

Implements java.sql.DatabaseMetaData.dataDefinitionCausesTransactionCommit.

Returns whether CREATE/DROP commit an open transaction.

public boolean

Returns:

false
dataDefinitionIgnoredInTransactions
()

Implements java.sql.DatabaseMetaData.dataDefinitionIgnoredInTransactions.

Returns whether CREATE/DROP do not affect transactions.

public boolean

Returns:

false
deletesAreDetected
(int
the result set type
type
)

Implements java.sql.DatabaseMetaData.deletesAreDetected.

Returns whether deletes are detected.

public boolean

Returns:

false
doesMaxRowSizeIncludeBlobs
()

Implements java.sql.DatabaseMetaData.doesMaxRowSizeIncludeBlobs.

Returns whether the maximum row size includes blobs.

public boolean

Returns:

true
generatedKeyAlwaysReturned
()

Implements java.sql.DatabaseMetaData.generatedKeyAlwaysReturned.

Returns whether database always returns generated keys if valid names or indexes of columns were specified and command was completed successfully.

public ResultSet
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.

[Not supported]

public ResultSet

Returns:

the primary key index
getBestRowIdentifier
(String
null (to get all objects) or the catalog name
catalog
,
String
null (to get all objects) or a schema name (uppercase for unquoted names)
schema
,
String
table name (must be specified)
table
,
int
ignored
scope
,
boolean
ignored
nullable
)

Implements java.sql.DatabaseMetaData.getBestRowIdentifier.

Gets the list of columns that best identifier a row in a table.

public ResultSet

Returns:

the catalog list
getCatalogs
()

Implements java.sql.DatabaseMetaData.getCatalogs.

Gets the list of catalogs.

public String

Returns:

"."
getCatalogSeparator
()

Implements java.sql.DatabaseMetaData.getCatalogSeparator.

Returns the catalog separator.

public String

Returns:

"catalog"
getCatalogTerm
()

Implements java.sql.DatabaseMetaData.getCatalogTerm.

Returns the term for "catalog".

public ResultSet
getClientInfoProperties()

Implements java.sql.DatabaseMetaData.getClientInfoProperties.

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

public ResultSet

Returns:

the list of privileges
getColumnPrivileges
(String
null (to get all objects) or the catalog name
catalog
,
String
null (to get all objects) or a schema name (uppercase for unquoted names)
schema
,
String
a table name (uppercase for unquoted names)
table
,
String
null (to get all objects) or a column name (uppercase for unquoted names)
columnNamePattern
)

Implements java.sql.DatabaseMetaData.getColumnPrivileges.

Gets the list of column privileges.

public ResultSet

Returns:

the list of columns
getColumns
(String
null (to get all objects) or the catalog name
catalog
,
String
null (to get all objects) or a schema name (uppercase for unquoted names)
schemaPattern
,
String
null (to get all objects) or a table name (uppercase for unquoted names)
tableNamePattern
,
String
null (to get all objects) or a column name (uppercase for unquoted names)
columnNamePattern
)

Implements java.sql.DatabaseMetaData.getColumns.

Gets the list of columns.

public Connection

Returns:

the connection
getConnection
()

Implements java.sql.DatabaseMetaData.getConnection.

Returns the connection that created this object.

public ResultSet

Returns:

the result set
getCrossReference
(String
null or the catalog name
primaryCatalog
,
String
the schema name of the primary table (optional)
primarySchema
,
String
the name of the primary table (must be specified)
primaryTable
,
String
null or the catalog name
foreignCatalog
,
String
the schema name of the foreign table (optional)
foreignSchema
,
String
the name of the foreign table (must be specified)
foreignTable
)

Implements java.sql.DatabaseMetaData.getCrossReference.

Gets the list of foreign key columns that references a table, as well as the list of primary key columns that are references by a table.

public int

Returns:

the major version
getDatabaseMajorVersion
()

Implements java.sql.DatabaseMetaData.getDatabaseMajorVersion.

Gets the major version of the database.

public int

Returns:

the minor version
getDatabaseMinorVersion
()

Implements java.sql.DatabaseMetaData.getDatabaseMinorVersion.

Gets the minor version of the database.

public String

Returns:

the product name ("H2")
getDatabaseProductName
()

Implements java.sql.DatabaseMetaData.getDatabaseProductName.

Gets the database product name.

public String

Returns:

the product version
getDatabaseProductVersion
()

Implements java.sql.DatabaseMetaData.getDatabaseProductVersion.

Gets the product version of the database.

public int

Returns:

Connection.TRANSACTION_READ_COMMITTED
getDefaultTransactionIsolation
()

Implements java.sql.DatabaseMetaData.getDefaultTransactionIsolation.

Returns the default transaction isolation level.

public int

Returns:

the major version number
getDriverMajorVersion
()

Implements java.sql.DatabaseMetaData.getDriverMajorVersion.

Returns the major version of this driver.

public int

Returns:

the minor version number
getDriverMinorVersion
()

Implements java.sql.DatabaseMetaData.getDriverMinorVersion.

Returns the minor version of this driver.

public String

Returns:

the driver name ("H2 JDBC Driver")
getDriverName
()

Implements java.sql.DatabaseMetaData.getDriverName.

Gets the name of the JDBC driver.

public String

Returns:

the version number
getDriverVersion
()

Implements java.sql.DatabaseMetaData.getDriverVersion.

Gets the version number of the driver.

public ResultSet

Returns:

the result set
getExportedKeys
(String
null or the catalog name
catalog
,
String
the schema name of the primary table
schema
,
String
the name of the primary table
table
)

Implements java.sql.DatabaseMetaData.getExportedKeys.

Gets the list of foreign key columns that reference a table.

public String

Returns:

an empty String ("")
getExtraNameCharacters
()

Implements java.sql.DatabaseMetaData.getExtraNameCharacters.

Returns the characters that are allowed for identifiers in addiction to A-Z, a-z, 0-9 and '_'.

public ResultSet
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.

[Not supported] Gets the list of function columns.

public ResultSet
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.

[Not supported] Gets the list of functions.

public String

Returns:

a double quote
getIdentifierQuoteString
()

Implements java.sql.DatabaseMetaData.getIdentifierQuoteString.

Returns the string used to quote identifiers.

public ResultSet

Returns:

the result set
getImportedKeys
(String
null (to get all objects) or the catalog name
catalog
,
String
the schema name of the foreign table
schema
,
String
the name of the foreign table
table
)

Implements java.sql.DatabaseMetaData.getImportedKeys.

Gets the list of primary key columns that are referenced by a table.

public ResultSet

Returns:

the list of indexes and columns
getIndexInfo
(String
null or the catalog name
catalog
,
String
null (to get all objects) or a schema name (uppercase for unquoted names)
schema
,
String
table name (must be specified)
table
,
boolean
only unique indexes
unique
,
boolean
if true, return fast, but approximate CARDINALITY and PAGES
approximate
)

Implements java.sql.DatabaseMetaData.getIndexInfo.

Gets the list of indexes for this database.

public int

Returns:

the major version (4)
getJDBCMajorVersion
()

Implements java.sql.DatabaseMetaData.getJDBCMajorVersion.

Gets the major version of the supported JDBC API.

public int

Returns:

the minor version (2)
getJDBCMinorVersion
()

Implements java.sql.DatabaseMetaData.getJDBCMinorVersion.

Gets the minor version of the supported JDBC API.

public int

Returns:

0 for limit is unknown
getMaxBinaryLiteralLength
()

Implements java.sql.DatabaseMetaData.getMaxBinaryLiteralLength.

Returns the maximum length for hex values (characters).

public int

Returns:

0 for limit is unknown
getMaxCatalogNameLength
()

Implements java.sql.DatabaseMetaData.getMaxCatalogNameLength.

Returns the maximum length for a catalog name.

public int

Returns:

0 for limit is unknown
getMaxCharLiteralLength
()

Implements java.sql.DatabaseMetaData.getMaxCharLiteralLength.

Returns the maximum length for literals.

public int

Returns:

0 for limit is unknown
getMaxColumnNameLength
()

Implements java.sql.DatabaseMetaData.getMaxColumnNameLength.

Returns the maximum length for column names.

public int

Returns:

0 for limit is unknown
getMaxColumnsInGroupBy
()

Implements java.sql.DatabaseMetaData.getMaxColumnsInGroupBy.

Returns the maximum number of columns in GROUP BY.

public int

Returns:

0 for limit is unknown
getMaxColumnsInIndex
()

Implements java.sql.DatabaseMetaData.getMaxColumnsInIndex.

Returns the maximum number of columns in CREATE INDEX.

public int

Returns:

0 for limit is unknown
getMaxColumnsInOrderBy
()

Implements java.sql.DatabaseMetaData.getMaxColumnsInOrderBy.

Returns the maximum number of columns in ORDER BY.

public int

Returns:

0 for limit is unknown
getMaxColumnsInSelect
()

Implements java.sql.DatabaseMetaData.getMaxColumnsInSelect.

Returns the maximum number of columns in SELECT.

public int

Returns:

0 for limit is unknown
getMaxColumnsInTable
()

Implements java.sql.DatabaseMetaData.getMaxColumnsInTable.

Returns the maximum number of columns in CREATE TABLE.

public int

Returns:

0 for limit is unknown
getMaxConnections
()

Implements java.sql.DatabaseMetaData.getMaxConnections.

Returns the maximum number of open connection.

public int

Returns:

0 for limit is unknown
getMaxCursorNameLength
()

Implements java.sql.DatabaseMetaData.getMaxCursorNameLength.

Returns the maximum length for a cursor name.

public int

Returns:

0 for limit is unknown
getMaxIndexLength
()

Implements java.sql.DatabaseMetaData.getMaxIndexLength.

Returns the maximum length for an index (in bytes).

public int

Returns:

0 for limit is unknown
getMaxProcedureNameLength
()

Implements java.sql.DatabaseMetaData.getMaxProcedureNameLength.

Returns the maximum length for a procedure name.

public int

Returns:

0 for limit is unknown
getMaxRowSize
()

Implements java.sql.DatabaseMetaData.getMaxRowSize.

Returns the maximum size of a row (in bytes).

public int

Returns:

0 for limit is unknown
getMaxSchemaNameLength
()

Implements java.sql.DatabaseMetaData.getMaxSchemaNameLength.

Returns the maximum length for a schema name.

public int

Returns:

0 for limit is unknown
getMaxStatementLength
()

Implements java.sql.DatabaseMetaData.getMaxStatementLength.

Returns the maximum length of a statement.

public int

Returns:

0 for limit is unknown
getMaxStatements
()

Implements java.sql.DatabaseMetaData.getMaxStatements.

Returns the maximum number of open statements.

public int

Returns:

0 for limit is unknown
getMaxTableNameLength
()

Implements java.sql.DatabaseMetaData.getMaxTableNameLength.

Returns the maximum length for a table name.

public int

Returns:

0 for limit is unknown
getMaxTablesInSelect
()

Implements java.sql.DatabaseMetaData.getMaxTablesInSelect.

Returns the maximum number of tables in a SELECT.

public int

Returns:

0 for limit is unknown
getMaxUserNameLength
()

Implements java.sql.DatabaseMetaData.getMaxUserNameLength.

Returns the maximum length for a user name.

public String

Returns:

the list
getNumericFunctions
()

Implements java.sql.DatabaseMetaData.getNumericFunctions.

Returns the list of numeric functions supported by this database.

public ResultSet

Returns:

the list of primary key columns
getPrimaryKeys
(String
null or the catalog name
catalog
,
String
null (to get all objects) or a schema name (uppercase for unquoted names)
schema
,
String
table name (must be specified)
table
)

Implements java.sql.DatabaseMetaData.getPrimaryKeys.

Gets the primary key columns for a table.

public ResultSet

Returns:

the procedure columns
getProcedureColumns
(String
null or the catalog name
catalog
,
String
null (to get all objects) or a schema name (uppercase for unquoted names)
schemaPattern
,
String
the procedure name pattern
procedureNamePattern
,
String
the procedure name pattern
columnNamePattern
)

Implements java.sql.DatabaseMetaData.getProcedureColumns.

Gets the list of procedure columns.

public ResultSet

Returns:

the procedures
getProcedures
(String
null or the catalog name
catalog
,
String
null (to get all objects) or a schema name (uppercase for unquoted names)
schemaPattern
,
String
the procedure name pattern
procedureNamePattern
)

Implements java.sql.DatabaseMetaData.getProcedures.

Gets the list of procedures.

public String

Returns:

"procedure"
getProcedureTerm
()

Implements java.sql.DatabaseMetaData.getProcedureTerm.

Returns the term for "procedure".

public ResultSet

Returns:

the list of pseudo and invisible columns
getPseudoColumns
(String
null (to get all objects) or the catalog name
catalog
,
String
null (to get all objects) or a schema name (uppercase for unquoted names)
schemaPattern
,
String
null (to get all objects) or a table name (uppercase for unquoted names)
tableNamePattern
,
String
null (to get all objects) or a column name (uppercase for unquoted names)
columnNamePattern
)

Implements java.sql.DatabaseMetaData.getPseudoColumns.

Gets the list of pseudo and invisible columns.

private JdbcResultSet
public int

Returns:

ResultSet.CLOSE_CURSORS_AT_COMMIT
getResultSetHoldability
()

Implements java.sql.DatabaseMetaData.getResultSetHoldability.

Gets the result set holdability.

public RowIdLifetime

Returns:

ROWID_UNSUPPORTED
getRowIdLifetime
()

Implements java.sql.DatabaseMetaData.getRowIdLifetime.

Get the lifetime of a rowid.

public ResultSet

Returns:

the schema list
getSchemas
()

Implements java.sql.DatabaseMetaData.getSchemas.

Gets the list of schemas.

public ResultSet

Returns:

the schema list
getSchemas
(String
null (to get all objects) or the catalog name
catalogPattern
,
String
null (to get all objects) or a schema name (uppercase for unquoted names)
schemaPattern
)

Implements java.sql.DatabaseMetaData.getSchemas.

Gets the list of schemas in the database.

public String

Returns:

"schema"
getSchemaTerm
()

Implements java.sql.DatabaseMetaData.getSchemaTerm.

Returns the term for "schema".

public String

Returns:

the default escape character (always '\', independent on the mode)
getSearchStringEscape
()

Implements java.sql.DatabaseMetaData.getSearchStringEscape.

Returns the default escape character for DatabaseMetaData search patterns.

public String

Returns:

a list of additional keywords
getSQLKeywords
()

Implements java.sql.DatabaseMetaData.getSQLKeywords.

Gets the comma-separated list of all SQL keywords that are not supported as unquoted identifiers, in addition to the SQL:2003 reserved words.

public int
public String

Returns:

the list
getStringFunctions
()

Implements java.sql.DatabaseMetaData.getStringFunctions.

Returns the list of string functions supported by this database.

public ResultSet

Returns:

an empty result set
getSuperTables
(String
null (to get all objects) or the catalog name
catalog
,
String
null (to get all objects) or a schema name (uppercase for unquoted names)
schemaPattern
,
String
null (to get all objects) or a table name pattern (uppercase for unquoted names)
tableNamePattern
)

Implements java.sql.DatabaseMetaData.getSuperTables.

Get the list of super tables of a table.

public ResultSet
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.

[Not supported]

public String

Returns:

the list
getSystemFunctions
()

Implements java.sql.DatabaseMetaData.getSystemFunctions.

Returns the list of system functions supported by this database.

public ResultSet

Returns:

the list of privileges
getTablePrivileges
(String
null (to get all objects) or the catalog name
catalog
,
String
null (to get all objects) or a schema name (uppercase for unquoted names)
schemaPattern
,
String
null (to get all objects) or a table name (uppercase for unquoted names)
tableNamePattern
)

Implements java.sql.DatabaseMetaData.getTablePrivileges.

Gets the list of table privileges.

public ResultSet

Returns:

the list of columns
getTables
(String
null (to get all objects) or the catalog name
catalog
,
String
null (to get all objects) or a schema name (uppercase for unquoted names)
schemaPattern
,
String
null (to get all objects) or a table name (uppercase for unquoted names)
tableNamePattern
,
String[]
null or a list of table types
types
)

Implements java.sql.DatabaseMetaData.getTables.

Gets the list of tables in the database.

public ResultSet

Returns:

the table types
getTableTypes
()

Implements java.sql.DatabaseMetaData.getTableTypes.

Gets the list of table types.

public String

Returns:

the list
getTimeDateFunctions
()

Implements java.sql.DatabaseMetaData.getTimeDateFunctions.

Returns the list of date and time functions supported by this database.

public ResultSet

Returns:

the list of data types
getTypeInfo
()

Implements java.sql.DatabaseMetaData.getTypeInfo.

Gets the list of data types.

public ResultSet

Returns:

an empty result set
getUDTs
(String
ignored
catalog
,
String
ignored
schemaPattern
,
String
ignored
typeNamePattern
,
int[]
ignored
types
)

Implements java.sql.DatabaseMetaData.getUDTs.

Gets the list of user-defined data types.

public String

Returns:

the url
getURL
()

Implements java.sql.DatabaseMetaData.getURL.

Returns the database URL for this connection.

public String

Returns:

the user name
getUserName
()

Implements java.sql.DatabaseMetaData.getUserName.

Returns the user name as passed to DriverManager.getConnection(url, user, password).

public ResultSet

Returns:

an empty result set
getVersionColumns
(String
null (to get all objects) or the catalog name
catalog
,
String
null (to get all objects) or a schema name
schema
,
String
table name (must be specified)
table
)

Implements java.sql.DatabaseMetaData.getVersionColumns.

Get the list of columns that are update when any value is updated.

public boolean

Returns:

false
insertsAreDetected
(int
the result set type
type
)

Implements java.sql.DatabaseMetaData.insertsAreDetected.

Returns whether inserts are detected.

public boolean

Returns:

true
isCatalogAtStart
()

Implements java.sql.DatabaseMetaData.isCatalogAtStart.

Returns whether the catalog is at the beginning.

public boolean

Returns:

if read only optimization is switched on
isReadOnly
()

Implements java.sql.DatabaseMetaData.isReadOnly.

Returns the same as Connection.isReadOnly().

public boolean

Returns:

whether or not the interface is assignable from this class
isWrapperFor
(Class<?>
the class
iface
)

Implements java.sql.Wrapper.isWrapperFor.

Checks if unwrap can return an object of this class.

public boolean

Returns:

false
locatorsUpdateCopy
()

Implements java.sql.DatabaseMetaData.locatorsUpdateCopy.

Does the database make a copy before updating.

public boolean

Returns:

true
nullPlusNonNullIsNull
()

Implements java.sql.DatabaseMetaData.nullPlusNonNullIsNull.

Returns whether NULL+1 is NULL or not.

public boolean

Returns:

if NULL values are sorted at the end
nullsAreSortedAtEnd
()

Implements java.sql.DatabaseMetaData.nullsAreSortedAtEnd.

Checks if NULL values are sorted at the end (no matter if ASC or DESC is used).

public boolean

Returns:

if NULL values are sorted at the beginning
nullsAreSortedAtStart
()

Implements java.sql.DatabaseMetaData.nullsAreSortedAtStart.

Checks if NULL values are sorted at the beginning (no matter if ASC or DESC is used).

public boolean

Returns:

if NULL values are sorted high
nullsAreSortedHigh
()

Implements java.sql.DatabaseMetaData.nullsAreSortedHigh.

Checks if NULL values are sorted high (bigger than anything that is not null).

public boolean

Returns:

if NULL values are sorted low
nullsAreSortedLow
()

Implements java.sql.DatabaseMetaData.nullsAreSortedLow.

Checks if NULL values are sorted low (smaller than anything that is not null).

public boolean

Returns:

false
othersDeletesAreVisible
(int
the result set type
type
)

Implements java.sql.DatabaseMetaData.othersDeletesAreVisible.

Returns whether other deletes are visible.

public boolean

Returns:

false
othersInsertsAreVisible
(int
the result set type
type
)

Implements java.sql.DatabaseMetaData.othersInsertsAreVisible.

Returns whether other inserts are visible.

public boolean

Returns:

false
othersUpdatesAreVisible
(int
the result set type
type
)

Implements java.sql.DatabaseMetaData.othersUpdatesAreVisible.

Returns whether other updates are visible.

public boolean

Returns:

false
ownDeletesAreVisible
(int
the result set type
type
)

Implements java.sql.DatabaseMetaData.ownDeletesAreVisible.

Returns whether own deletes are visible.

public boolean

Returns:

false
ownInsertsAreVisible
(int
the result set type
type
)

Implements java.sql.DatabaseMetaData.ownInsertsAreVisible.

Returns whether own inserts are visible.

public boolean

Returns:

true
ownUpdatesAreVisible
(int
the result set type
type
)

Implements java.sql.DatabaseMetaData.ownUpdatesAreVisible.

Returns whether own updates are visible.

public boolean

Returns:

true is so, false otherwise
storesLowerCaseIdentifiers
()

Implements java.sql.DatabaseMetaData.storesLowerCaseIdentifiers.

Checks if for CREATE TABLE Test(ID INT), getTables returns test as the table name.

public boolean

Returns:

false
storesLowerCaseQuotedIdentifiers
()

Implements java.sql.DatabaseMetaData.storesLowerCaseQuotedIdentifiers.

Checks if for CREATE TABLE "Test"(ID INT), getTables returns test as the table name.

public boolean

Returns:

true is so, false otherwise
storesMixedCaseIdentifiers
()

Implements java.sql.DatabaseMetaData.storesMixedCaseIdentifiers.

Checks if for CREATE TABLE Test(ID INT), getTables returns Test as the table name and identifiers are not case sensitive.

public boolean

Returns:

true is so, false otherwise
storesMixedCaseQuotedIdentifiers
()

Implements java.sql.DatabaseMetaData.storesMixedCaseQuotedIdentifiers.

Checks if for CREATE TABLE "Test"(ID INT), getTables returns Test as the table name and identifiers are case insensitive.

public boolean

Returns:

true is so, false otherwise
storesUpperCaseIdentifiers
()

Implements java.sql.DatabaseMetaData.storesUpperCaseIdentifiers.

Checks if for CREATE TABLE Test(ID INT), getTables returns TEST as the table name.

public boolean

Returns:

false
storesUpperCaseQuotedIdentifiers
()

Implements java.sql.DatabaseMetaData.storesUpperCaseQuotedIdentifiers.

Checks if for CREATE TABLE "Test"(ID INT), getTables returns TEST as the table name.

public boolean

Returns:

true
supportsAlterTableWithAddColumn
()

Implements java.sql.DatabaseMetaData.supportsAlterTableWithAddColumn.

Returns whether alter table with add column is supported.

public boolean

Returns:

true
supportsAlterTableWithDropColumn
()

Implements java.sql.DatabaseMetaData.supportsAlterTableWithDropColumn.

Returns whether alter table with drop column is supported.

public boolean

Returns:

true
supportsANSI92EntryLevelSQL
()

Implements java.sql.DatabaseMetaData.supportsANSI92EntryLevelSQL.

Returns whether SQL-92 entry level grammar is supported.

public boolean

Returns:

false
supportsANSI92FullSQL
()

Implements java.sql.DatabaseMetaData.supportsANSI92FullSQL.

Returns whether SQL-92 full level grammar is supported.

public boolean

Returns:

false
supportsANSI92IntermediateSQL
()

Implements java.sql.DatabaseMetaData.supportsANSI92IntermediateSQL.

Returns whether SQL-92 intermediate level grammar is supported.

public boolean

Returns:

true
supportsBatchUpdates
()

Implements java.sql.DatabaseMetaData.supportsBatchUpdates.

Returns whether batch updates are supported.

public boolean

Returns:

true
supportsCatalogsInDataManipulation
()

Implements java.sql.DatabaseMetaData.supportsCatalogsInDataManipulation.

Returns whether the catalog name in INSERT, UPDATE, DELETE is supported.

public boolean

Returns:

true
supportsCatalogsInIndexDefinitions
()

Implements java.sql.DatabaseMetaData.supportsCatalogsInIndexDefinitions.

Returns whether the catalog name in CREATE INDEX is supported.

public boolean

Returns:

true
supportsCatalogsInPrivilegeDefinitions
()

Implements java.sql.DatabaseMetaData.supportsCatalogsInPrivilegeDefinitions.

Returns whether the catalog name in GRANT is supported.

public boolean

Returns:

false
supportsCatalogsInProcedureCalls
()

Implements java.sql.DatabaseMetaData.supportsCatalogsInProcedureCalls.

Returns whether the catalog name in procedure calls is supported.

public boolean

Returns:

true
supportsCatalogsInTableDefinitions
()

Implements java.sql.DatabaseMetaData.supportsCatalogsInTableDefinitions.

Returns whether the catalog name in CREATE TABLE is supported.

public boolean

Returns:

true
supportsColumnAliasing
()

Implements java.sql.DatabaseMetaData.supportsColumnAliasing.

Returns whether column aliasing is supported.

public boolean

Returns:

true
supportsConvert
()

Implements java.sql.DatabaseMetaData.supportsConvert.

Returns whether CONVERT is supported.

public boolean

Returns:

true
supportsConvert
(int
the source SQL type
fromType
,
int
the target SQL type
toType
)

Implements java.sql.DatabaseMetaData.supportsConvert.

Returns whether CONVERT is supported for one datatype to another.

public boolean

Returns:

true
supportsCoreSQLGrammar
()

Implements java.sql.DatabaseMetaData.supportsCoreSQLGrammar.

Returns whether ODBC Core SQL grammar is supported.

public boolean

Returns:

true
supportsCorrelatedSubqueries
()

Implements java.sql.DatabaseMetaData.supportsCorrelatedSubqueries.

Returns whether correlated subqueries are supported.

public boolean

Returns:

false
supportsDataDefinitionAndDataManipulationTransactions
()

Implements java.sql.DatabaseMetaData.supportsDataDefinitionAndDataManipulationTransactions.

Returns whether data manipulation and CREATE/DROP is supported in transactions.

public boolean

Returns:

true
supportsDataManipulationTransactionsOnly
()

Implements java.sql.DatabaseMetaData.supportsDataManipulationTransactionsOnly.

Returns whether only data manipulations are supported in transactions.

public boolean

Returns:

false
supportsDifferentTableCorrelationNames
()

Implements java.sql.DatabaseMetaData.supportsDifferentTableCorrelationNames.

Returns whether table correlation names (table alias) are restricted to be different than table names.

public boolean

Returns:

true
supportsExpressionsInOrderBy
()

Implements java.sql.DatabaseMetaData.supportsExpressionsInOrderBy.

Returns whether expression in ORDER BY are supported.

public boolean

Returns:

false
supportsExtendedSQLGrammar
()

Implements java.sql.DatabaseMetaData.supportsExtendedSQLGrammar.

Returns whether ODBC Extended SQL grammar is supported.

public boolean

Returns:

false
supportsFullOuterJoins
()

Implements java.sql.DatabaseMetaData.supportsFullOuterJoins.

Returns whether full outer joins are supported.

public boolean

Returns:

true
supportsGetGeneratedKeys
()

Implements java.sql.DatabaseMetaData.supportsGetGeneratedKeys.

Does the database support getGeneratedKeys.

public boolean

Returns:

true
supportsGroupBy
()

Implements java.sql.DatabaseMetaData.supportsGroupBy.

Returns whether GROUP BY is supported.

public boolean

Returns:

true
supportsGroupByBeyondSelect
()

Implements java.sql.DatabaseMetaData.supportsGroupByBeyondSelect.

Checks whether a GROUP BY clause can use columns that are not in the SELECT clause, provided that it specifies all the columns in the SELECT clause.

public boolean

Returns:

true
supportsGroupByUnrelated
()

Implements java.sql.DatabaseMetaData.supportsGroupByUnrelated.

Returns whether GROUP BY is supported if the column is not in the SELECT list.

public boolean

Returns:

true
supportsIntegrityEnhancementFacility
()

Implements java.sql.DatabaseMetaData.supportsIntegrityEnhancementFacility.

Returns whether referential integrity is supported.

public boolean

Returns:

true
supportsLikeEscapeClause
()

Implements java.sql.DatabaseMetaData.supportsLikeEscapeClause.

Returns whether LIKE...

public boolean

Returns:

true
supportsLimitedOuterJoins
()

Implements java.sql.DatabaseMetaData.supportsLimitedOuterJoins.

Returns whether limited outer joins are supported.

public boolean

Returns:

true
supportsMinimumSQLGrammar
()

Implements java.sql.DatabaseMetaData.supportsMinimumSQLGrammar.

Returns whether ODBC Minimum SQL grammar is supported.

public boolean

Returns:

true is so, false otherwise
supportsMixedCaseIdentifiers
()

Implements java.sql.DatabaseMetaData.supportsMixedCaseIdentifiers.

Checks if for CREATE TABLE Test(ID INT), getTables returns Test as the table name and identifiers are case sensitive.

public boolean

Returns:

true is so, false otherwise
supportsMixedCaseQuotedIdentifiers
()

Implements java.sql.DatabaseMetaData.supportsMixedCaseQuotedIdentifiers.

Checks if a table created with CREATE TABLE "Test"(ID INT) is a different table than a table created with CREATE TABLE "TEST"(ID INT).

public boolean

Returns:

false
supportsMultipleOpenResults
()

Implements java.sql.DatabaseMetaData.supportsMultipleOpenResults.

Does the database support multiple open result sets returned from a CallableStatement.

public boolean

Returns:

false
supportsMultipleResultSets
()

Implements java.sql.DatabaseMetaData.supportsMultipleResultSets.

Returns whether multiple result sets are supported.

public boolean

Returns:

true
supportsMultipleTransactions
()

Implements java.sql.DatabaseMetaData.supportsMultipleTransactions.

Returns whether multiple transactions (on different connections) are supported.

public boolean

Returns:

false
supportsNamedParameters
()

Implements java.sql.DatabaseMetaData.supportsNamedParameters.

Does the database support named parameters.

public boolean

Returns:

true
supportsNonNullableColumns
()

Implements java.sql.DatabaseMetaData.supportsNonNullableColumns.

Returns whether columns with NOT NULL are supported.

public boolean

Returns:

false
supportsOpenCursorsAcrossCommit
()

Implements java.sql.DatabaseMetaData.supportsOpenCursorsAcrossCommit.

Returns whether open result sets across commits are supported.

public boolean

Returns:

false
supportsOpenCursorsAcrossRollback
()

Implements java.sql.DatabaseMetaData.supportsOpenCursorsAcrossRollback.

Returns whether open result sets across rollback are supported.

public boolean

Returns:

true
supportsOpenStatementsAcrossCommit
()

Implements java.sql.DatabaseMetaData.supportsOpenStatementsAcrossCommit.

Returns whether open statements across commit are supported.

public boolean

Returns:

true
supportsOpenStatementsAcrossRollback
()

Implements java.sql.DatabaseMetaData.supportsOpenStatementsAcrossRollback.

Returns whether open statements across rollback are supported.

public boolean

Returns:

true
supportsOrderByUnrelated
()

Implements java.sql.DatabaseMetaData.supportsOrderByUnrelated.

Returns whether ORDER BY is supported if the column is not in the SELECT list.

public boolean

Returns:

true
supportsOuterJoins
()

Implements java.sql.DatabaseMetaData.supportsOuterJoins.

Returns whether outer joins are supported.

public boolean

Returns:

false
supportsPositionedDelete
()

Implements java.sql.DatabaseMetaData.supportsPositionedDelete.

Returns whether positioned deletes are supported.

public boolean

Returns:

false
supportsPositionedUpdate
()

Implements java.sql.DatabaseMetaData.supportsPositionedUpdate.

Returns whether positioned updates are supported.

public boolean

Returns:

true if the type is not ResultSet.TYPE_SCROLL_SENSITIVE
supportsResultSetConcurrency
(int
the result set type
type
,
int
the result set concurrency
concurrency
)

Implements java.sql.DatabaseMetaData.supportsResultSetConcurrency.

Returns whether a specific result set concurrency is supported.

public boolean

Returns:

true if the holdability is ResultSet.CLOSE_CURSORS_AT_COMMIT
supportsResultSetHoldability
(int
ResultSet.HOLD_CURSORS_OVER_COMMIT or CLOSE_CURSORS_AT_COMMIT
holdability
)

Implements java.sql.DatabaseMetaData.supportsResultSetHoldability.

Does this database supports a result set holdability.

public boolean

Returns:

true for all types except ResultSet.TYPE_SCROLL_SENSITIVE
supportsResultSetType
(int
the result set type
type
)

Implements java.sql.DatabaseMetaData.supportsResultSetType.

Returns whether a specific result set type is supported.

public boolean

Returns:

true
supportsSavepoints
()

Implements java.sql.DatabaseMetaData.supportsSavepoints.

Does the database support savepoints.

public boolean

Returns:

true
supportsSchemasInDataManipulation
()

Implements java.sql.DatabaseMetaData.supportsSchemasInDataManipulation.

Returns whether the schema name in INSERT, UPDATE, DELETE is supported.

public boolean

Returns:

true
supportsSchemasInIndexDefinitions
()

Implements java.sql.DatabaseMetaData.supportsSchemasInIndexDefinitions.

Returns whether the schema name in CREATE INDEX is supported.

public boolean

Returns:

true
supportsSchemasInPrivilegeDefinitions
()

Implements java.sql.DatabaseMetaData.supportsSchemasInPrivilegeDefinitions.

Returns whether the schema name in GRANT is supported.

public boolean

Returns:

true
supportsSchemasInProcedureCalls
()

Implements java.sql.DatabaseMetaData.supportsSchemasInProcedureCalls.

Returns whether the schema name in procedure calls is supported.

public boolean

Returns:

true
supportsSchemasInTableDefinitions
()

Implements java.sql.DatabaseMetaData.supportsSchemasInTableDefinitions.

Returns whether the schema name in CREATE TABLE is supported.

public boolean

Returns:

true
supportsSelectForUpdate
()

Implements java.sql.DatabaseMetaData.supportsSelectForUpdate.

Returns whether SELECT ...

public boolean

Returns:

false
supportsStatementPooling
()

Implements java.sql.DatabaseMetaData.supportsStatementPooling.

Does the database support statement pooling.

public boolean

Returns:

true
supportsStoredFunctionsUsingCallSyntax
()

Implements java.sql.DatabaseMetaData.supportsStoredFunctionsUsingCallSyntax.

Returns whether the database supports calling functions using the call syntax.

public boolean

Returns:

false
supportsStoredProcedures
()

Implements java.sql.DatabaseMetaData.supportsStoredProcedures.

Returns whether stored procedures are supported.

public boolean

Returns:

true
supportsSubqueriesInComparisons
()

Implements java.sql.DatabaseMetaData.supportsSubqueriesInComparisons.

Returns whether subqueries (SELECT) in comparisons are supported.

public boolean

Returns:

true
supportsSubqueriesInExists
()

Implements java.sql.DatabaseMetaData.supportsSubqueriesInExists.

Returns whether SELECT in EXISTS is supported.

public boolean

Returns:

true
supportsSubqueriesInIns
()

Implements java.sql.DatabaseMetaData.supportsSubqueriesInIns.

Returns whether IN(SELECT...) is supported.

public boolean

Returns:

true
supportsSubqueriesInQuantifieds
()

Implements java.sql.DatabaseMetaData.supportsSubqueriesInQuantifieds.

Returns whether subqueries in quantified expression are supported.

public boolean

Returns:

true
supportsTableCorrelationNames
()

Implements java.sql.DatabaseMetaData.supportsTableCorrelationNames.

Returns whether table correlation names (table alias) are supported.

public boolean

Returns:

true
supportsTransactionIsolationLevel
(int
the transaction isolation level (Connection.TRANSACTION_*)
level
)

Implements java.sql.DatabaseMetaData.supportsTransactionIsolationLevel.

Returns whether a specific transaction isolation level is supported.

public boolean

Returns:

true
supportsTransactions
()

Implements java.sql.DatabaseMetaData.supportsTransactions.

Returns whether transactions are supported.

public boolean

Returns:

true
supportsUnion
()

Implements java.sql.DatabaseMetaData.supportsUnion.

Returns whether UNION SELECT is supported.

public boolean

Returns:

true
supportsUnionAll
()

Implements java.sql.DatabaseMetaData.supportsUnionAll.

Returns whether UNION ALL SELECT is supported.

public String
toString()

Overrides java.lang.Object.toString.

INTERNAL

public <T> T

Returns:

this
unwrap
(Class<T>
the class
iface
)

Implements java.sql.Wrapper.unwrap.

Return an object of this class if possible.

public boolean

Returns:

false
updatesAreDetected
(int
the result set type
type
)

Implements java.sql.DatabaseMetaData.updatesAreDetected.

Returns whether updates are detected.

public boolean

Returns:

false
usesLocalFilePerTable
()

Implements java.sql.DatabaseMetaData.usesLocalFilePerTable.

Checks if this database use one file per table.

public boolean

Returns:

true
usesLocalFiles
()

Implements java.sql.DatabaseMetaData.usesLocalFiles.

Checks if this database store data in local files.

Inherited from org.h2.message.TraceObject:
debugCodedebugCodeAssigndebugCodeCalldebugCodeCalldebugCodeCallgetNextIdgetTraceIdgetTraceObjectNameisDebugEnabledisInfoEnabledlogAndConvertquotequoteArrayquoteBigDecimalquoteBytesquoteDatequoteIntArrayquoteMapquoteTimequoteTimestampsetTraceunsupported