public class SQLite4JDatabaseMetaData extends java.lang.Object implements DatabaseMetaData
attributeNoNulls, attributeNullable, attributeNullableUnknown, bestRowNotPseudo, bestRowPseudo, bestRowSession, bestRowTemporary, bestRowTransaction, bestRowUnknown, columnNoNulls, columnNullable, columnNullableUnknown, importedKeyCascade, importedKeyInitiallyDeferred, importedKeyInitiallyImmediate, importedKeyNoAction, importedKeyNotDeferrable, importedKeyRestrict, importedKeySetDefault, importedKeySetNull, procedureColumnIn, procedureColumnInOut, procedureColumnOut, procedureColumnResult, procedureColumnReturn, procedureColumnUnknown, procedureNoNulls, procedureNoResult, procedureNullable, procedureNullableUnknown, procedureResultUnknown, procedureReturnsResult, sqlStateSQL99, sqlStateXOpen, tableIndexClustered, tableIndexHashed, tableIndexOther, tableIndexStatistic, typeNoNulls, typeNullable, typeNullableUnknown, typePredBasic, typePredChar, typePredNone, typeSearchable, versionColumnNotPseudo, versionColumnPseudo, versionColumnUnknown
Constructor and Description |
---|
SQLite4JDatabaseMetaData(SQLite4JConnection con,
java.sql.DatabaseMetaData metadata) |
Modifier and Type | Method and Description |
---|---|
boolean |
allProceduresAreCallable()
This method tests whether or not all the procedures returned by
the
getProcedures method can be called by this user. |
boolean |
allTablesAreSelectable()
This method tests whether or not all the table returned by the
getTables method can be selected by this user. |
boolean |
dataDefinitionCausesTransactionCommit()
This method tests whether or not a DDL statement will cause the
current transaction to be automatically committed.
|
boolean |
dataDefinitionIgnoredInTransactions()
This method tests whether or not DDL statements are ignored in
transactions.
|
boolean |
deletesAreDetected(int type)
This method tests whether or not the specified result set type can detect
a visible delete by calling the
rowUpdated method. |
boolean |
doesMaxRowSizeIncludeBlobs()
This method tests whether or not the maximum row size includes BLOB's
|
ResultSet |
getAttributes(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typePattern,
java.lang.String attributePattern) |
ResultSet |
getBestRowIdentifier(java.lang.String catalog,
java.lang.String schema,
java.lang.String tableName,
int scope,
boolean nullable)
This method returns the best set of columns for uniquely identifying
a row.
|
ResultSet |
getCatalogs()
This method returns the list of database catalogs as a
ResultSet with one column - TABLE_CAT - that is the
name of the catalog. |
java.lang.String |
getCatalogSeparator()
This method returns the separator between the catalog name and the
table name.
|
java.lang.String |
getCatalogTerm()
This method returns the vendor's term for "catalog".
|
ResultSet |
getColumnPrivileges(java.lang.String catalog,
java.lang.String schema,
java.lang.String tableName,
java.lang.String columnPattern)
This method returns the access rights that have been granted to the
requested columns.
|
ResultSet |
getColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tablePattern,
java.lang.String columnPattern)
This method returns a list of the tables columns for
the requested tables.
|
Connection |
getConnection()
This method returns the
Connection object that was used
to generate the metadata in this object. |
ResultSet |
getCrossReference(java.lang.String primaryCatalog,
java.lang.String primarySchema,
java.lang.String primaryTableName,
java.lang.String foreignCatalog,
java.lang.String foreignSchema,
java.lang.String foreignTableName)
This method returns a description of how one table imports another
table's primary key as a foreign key.
|
int |
getDatabaseMajorVersion()
This method returns the major version number of the database.
|
int |
getDatabaseMinorVersion()
This method returns the minor version number of the database.
|
java.lang.String |
getDatabaseProductName()
This method returns the name of the database product.
|
java.lang.String |
getDatabaseProductVersion()
This method returns the version of the database product.
|
int |
getDefaultTransactionIsolation()
This method returns the default transaction isolation level of the
database.
|
int |
getDriverMajorVersion()
This method returns the major version number of the JDBC driver.
|
int |
getDriverMinorVersion()
This method returns the minor version number of the JDBC driver.
|
java.lang.String |
getDriverName()
This method returns the name of the JDBC driver.
|
java.lang.String |
getDriverVersion()
This method returns the version of the JDBC driver.
|
ResultSet |
getExportedKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String tableName)
This method returns a list of the table's which use this table's
primary key as a foreign key.
|
java.lang.String |
getExtraNameCharacters()
This methods returns non-standard characters that can appear in
unquoted identifiers.
|
java.lang.String |
getIdentifierQuoteString()
This metohd returns the quote string for SQL identifiers.
|
ResultSet |
getImportedKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String tableName)
This method returns a list of the table's foreign keys.
|
ResultSet |
getIndexInfo(java.lang.String catalog,
java.lang.String schema,
java.lang.String tableName,
boolean unique,
boolean approximate)
This method returns information about a tables indices and statistics.
|
int |
getJDBCMajorVersion()
This method returns the major version number of the JDBC driver.
|
int |
getJDBCMinorVersion()
This method returns the minor version number of the JDBC driver.
|
int |
getMaxBinaryLiteralLength()
This method returns the number of hex characters allowed in an inline
binary literal.
|
int |
getMaxCatalogNameLength()
This method returns the maximum length of a catalog name.
|
int |
getMaxCharLiteralLength()
This method returns the maximum length of a character literal.
|
int |
getMaxColumnNameLength()
This method returns the maximum length of a column name.
|
int |
getMaxColumnsInGroupBy()
This method returns the maximum number of columns in a GROUP BY statement.
|
int |
getMaxColumnsInIndex()
This method returns the maximum number of columns in an index.
|
int |
getMaxColumnsInOrderBy()
This method returns the maximum number of columns in an ORDER BY statement.
|
int |
getMaxColumnsInSelect()
This method returns the maximum number of columns in a SELECT statement.
|
int |
getMaxColumnsInTable()
This method returns the maximum number of columns in a table.
|
int |
getMaxConnections()
This method returns the maximum number of connections this client
can have to the database.
|
int |
getMaxCursorNameLength()
This method returns the maximum length of a cursor name.
|
int |
getMaxIndexLength()
This method returns the maximum length of an index.
|
int |
getMaxProcedureNameLength()
This method returns the maximum length of a procedure name.
|
int |
getMaxRowSize()
This method returns the maximum size of a row in bytes.
|
int |
getMaxSchemaNameLength()
This method returns the maximum length of a schema name.
|
int |
getMaxStatementLength()
This method includes the maximum length of a SQL statement.
|
int |
getMaxStatements()
This method returns the maximum number of statements that can be
active at any time.
|
int |
getMaxTableNameLength()
This method returns the maximum length of a table name.
|
int |
getMaxTablesInSelect()
This method returns the maximum number of tables that may be referenced
in a SELECT statement.
|
int |
getMaxUserNameLength()
This method returns the maximum length of a user name.
|
java.lang.String |
getNumericFunctions()
This method returns a comma separated list of math functions.
|
ResultSet |
getPrimaryKeys(java.lang.String catalog,
java.lang.String schema,
java.lang.String tableName)
This method returns a list of a table's primary key columns.
|
ResultSet |
getProcedureColumns(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String procedurePattern,
java.lang.String columnPattern)
This method returns a list of the parameter and result columns for
the requested stored procedures.
|
ResultSet |
getProcedures(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String procedurePattern)
This method returns a list of all the stored procedures matching the
specified pattern in the given schema and catalog.
|
java.lang.String |
getProcedureTerm()
This method returns the vendor's term for "procedure".
|
int |
getResultSetHoldability()
This method returns the default holdability type of
ResultSet S
retrieved from this database. |
ResultSet |
getSchemas()
This method returns the list of database schemas as a
ResultSet , with one column - TABLE_SCHEM - that is the
name of the schema. |
java.lang.String |
getSchemaTerm()
This method returns the vendor's term for "schema".
|
java.lang.String |
getSearchStringEscape()
This method returns the string used to escape wildcards in search strings.
|
java.lang.String |
getSQLKeywords()
This method returns a comma separated list of all the SQL keywords in
the database that are not in SQL92.
|
int |
getSQLStateType() |
java.lang.String |
getStringFunctions()
This method returns a comma separated list of string functions.
|
ResultSet |
getSuperTables(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tablePattern) |
ResultSet |
getSuperTypes(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typePattern) |
java.lang.String |
getSystemFunctions()
This method returns a comma separated list of of system functions.
|
ResultSet |
getTablePrivileges(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tablePattern)
This method returns the access rights that have been granted to the
requested tables.
|
ResultSet |
getTables(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tablePattern,
java.lang.String[] types)
This method returns a list of the requested table as a
ResultSet with the following columns:
TABLE_CAT - The catalog the table is in, which may be null .
TABLE_SCHEM - The schema the table is in, which may be null .
TABLE_NAME - The name of the table.
TABLE_TYPE - A string describing the table type. |
ResultSet |
getTableTypes()
This method returns the list of database table types as a
ResultSet with one column - TABLE_TYPE - that is the
name of the table type. |
java.lang.String |
getTimeDateFunctions()
This method returns comma separated list of time/date functions.
|
ResultSet |
getTypeInfo()
This method returns a list of the SQL types supported by this
database.
|
ResultSet |
getUDTs(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typePattern,
int[] types)
This method returns the list of user defined data types in use.
|
java.lang.String |
getURL()
This method returns the URL for this database.
|
java.lang.String |
getUserName()
This method returns the database username for this connection.
|
ResultSet |
getVersionColumns(java.lang.String catalog,
java.lang.String schema,
java.lang.String tableName)
This method returns the set of columns that are automatically updated
when the row is update.
|
boolean |
insertsAreDetected(int type)
This method tests whether or not the specified result set type can detect
a visible insert by calling the
rowUpdated method. |
boolean |
isCatalogAtStart()
This method tests whether a catalog name appears at the beginning of
a fully qualified table name.
|
boolean |
isReadOnly()
This method tests whether or not the database is in read only mode.
|
boolean |
locatorsUpdateCopy() |
boolean |
nullPlusNonNullIsNull()
This method tests whether the concatenation of a NULL and non-NULL
value results in a NULL.
|
boolean |
nullsAreSortedAtEnd()
This method test whether or not NULL's are sorted to the end
of the list regardless of ascending or descending sort order.
|
boolean |
nullsAreSortedAtStart()
This method tests whether or not NULL's sort as high values.
|
boolean |
nullsAreSortedHigh()
This method tests whether or not NULL's sort as high values.
|
boolean |
nullsAreSortedLow()
This method tests whether or not NULL's sort as low values.
|
boolean |
othersDeletesAreVisible(int type)
This method tests whether or not the specified result set type sees
deletes committed by others.
|
boolean |
othersInsertsAreVisible(int type)
This method tests whether or not the specified result set type sees
inserts committed by others.
|
boolean |
othersUpdatesAreVisible(int type)
This method tests whether or not the specified result set type sees
updates committed by others.
|
boolean |
ownDeletesAreVisible(int type)
This method tests whether or not the specified result set type sees its
own deletes.
|
boolean |
ownInsertsAreVisible(int type)
This method tests whether or not the specified result set type sees its
own inserts.
|
boolean |
ownUpdatesAreVisible(int type)
This method tests whether or not the specified result set type sees its
own updates.
|
boolean |
storesLowerCaseIdentifiers()
This method tests whether or not the database treats mixed case
identifiers as all lower case.
|
boolean |
storesLowerCaseQuotedIdentifiers()
This method tests whether or not the database treats mixed case
quoted identifiers as all lower case.
|
boolean |
storesMixedCaseIdentifiers()
This method tests whether or not the database stores mixed case
identifers even if it treats them as case insensitive.
|
boolean |
storesMixedCaseQuotedIdentifiers()
This method tests whether or not the database stores mixed case
quoted identifers even if it treats them as case insensitive.
|
boolean |
storesUpperCaseIdentifiers()
This method tests whether or not the database treats mixed case
identifiers as all upper case.
|
boolean |
storesUpperCaseQuotedIdentifiers()
This method tests whether or not the database treats mixed case
quoted identifiers as all upper case.
|
boolean |
supportsAlterTableWithAddColumn()
This method tests whether or not the database supports
"ALTER TABLE ADD COLUMN"
|
boolean |
supportsAlterTableWithDropColumn()
This method tests whether or not the database supports
"ALTER TABLE DROP COLUMN"
|
boolean |
supportsANSI92EntryLevelSQL()
This method tests whether or not the ANSI92 entry level SQL
grammar is supported.
|
boolean |
supportsANSI92FullSQL()
This method tests whether or not the ANSI92 full SQL
grammar is supported.
|
boolean |
supportsANSI92IntermediateSQL()
This method tests whether or not the ANSI92 intermediate SQL
grammar is supported.
|
boolean |
supportsBatchUpdates()
This method tests whether or not the database supports batch updates.
|
boolean |
supportsCatalogsInDataManipulation()
This method tests whether a catalog name can appear in a data
manipulation statement.
|
boolean |
supportsCatalogsInIndexDefinitions()
This method tests whether a catalog name can appear in an index definition.
|
boolean |
supportsCatalogsInPrivilegeDefinitions()
This method tests whether a catalog name can appear in privilege definitions.
|
boolean |
supportsCatalogsInProcedureCalls()
This method tests whether a catalog name can appear in a procedure
call
|
boolean |
supportsCatalogsInTableDefinitions()
This method tests whether a catalog name can appear in a table definition.
|
boolean |
supportsColumnAliasing()
This method tests whether or not column aliasing is supported.
|
boolean |
supportsConvert()
Tests whether or not CONVERT is supported.
|
boolean |
supportsConvert(int fromType,
int toType)
This method tests whether or not CONVERT can be performed between the
specified types.
|
boolean |
supportsCoreSQLGrammar()
This method tests whether or not the core grammer for ODBC is supported.
|
boolean |
supportsCorrelatedSubqueries()
This method test whether or not correlated subqueries are allowed.
|
boolean |
supportsDataDefinitionAndDataManipulationTransactions()
This method tests whether or not DDL and DML statements allowed within
the same transaction.
|
boolean |
supportsDataManipulationTransactionsOnly()
This method tests whether or not only DML statement are allowed
inside a transaction.
|
boolean |
supportsDifferentTableCorrelationNames()
This method tests whether correlation names must be different from the
name of the table.
|
boolean |
supportsExpressionsInOrderBy()
This method tests whether or not expressions are allowed in an
ORDER BY lists.
|
boolean |
supportsExtendedSQLGrammar()
This method tests whether or not the extended grammer for ODBC is supported.
|
boolean |
supportsFullOuterJoins()
This method tests whether or not the database supports full outer joins.
|
boolean |
supportsGetGeneratedKeys() |
boolean |
supportsGroupBy()
This method tests whether or not GROUP BY is supported.
|
boolean |
supportsGroupByBeyondSelect()
This method tests whether or not a GROUP BY can add columns not in the
select if it includes all the columns in the select.
|
boolean |
supportsGroupByUnrelated()
This method tests whether GROUP BY on a non-selected column is
allowed.
|
boolean |
supportsIntegrityEnhancementFacility()
This method tests whether or not the SQL integrity enhancement
facility is supported.
|
boolean |
supportsLikeEscapeClause()
This method tests whether or not the escape character is supported in
LIKE expressions.
|
boolean |
supportsLimitedOuterJoins()
This method tests whether or not the database supports limited outer joins.
|
boolean |
supportsMinimumSQLGrammar()
This method tests whether or not the minimum grammer for ODBC is supported.
|
boolean |
supportsMixedCaseIdentifiers()
This method tests whether or not the database supports identifiers
with mixed case.
|
boolean |
supportsMixedCaseQuotedIdentifiers()
This method tests whether or not the database supports quoted identifiers
with mixed case.
|
boolean |
supportsMultipleOpenResults()
This method tests whether the database supports returning multiple
ResultSet S from a CallableStatement at once. |
boolean |
supportsMultipleResultSets()
This method tests whether multiple result sets for a single statement are
supported.
|
boolean |
supportsMultipleTransactions()
This method test whether or not multiple transactions may be open
at once, as long as they are on different connections.
|
boolean |
supportsNamedParameters()
This method tests whether the database supports named parameters.
|
boolean |
supportsNonNullableColumns()
This method tests whether or not columns can be defined as NOT NULL.
|
boolean |
supportsOpenCursorsAcrossCommit()
This method tests whether or not the database supports cursors
remaining open across commits.
|
boolean |
supportsOpenCursorsAcrossRollback()
This method tests whether or not the database supports cursors
remaining open across rollbacks.
|
boolean |
supportsOpenStatementsAcrossCommit()
This method tests whether or not the database supports statements
remaining open across commits.
|
boolean |
supportsOpenStatementsAcrossRollback()
This method tests whether or not the database supports statements
remaining open across rollbacks.
|
boolean |
supportsOrderByUnrelated()
This method tests whether or ORDER BY on a non-selected column is
allowed.
|
boolean |
supportsOuterJoins()
This method tests whether or not the database supports outer joins.
|
boolean |
supportsPositionedDelete()
This method tests whether or not that database supports positioned
deletes.
|
boolean |
supportsPositionedUpdate()
This method tests whether or not that database supports positioned
updates.
|
boolean |
supportsResultSetConcurrency(int type,
int concurrency)
This method tests whether the specified result set type and result set
concurrency type are supported by the database.
|
boolean |
supportsResultSetHoldability(int holdability)
This method tests if the database supports the specified holdability type.
|
boolean |
supportsResultSetType(int type)
This method tests whether or not the datbase supports the specified
result type.
|
boolean |
supportsSavepoints()
This method tests whether the databse supports savepoints.
|
boolean |
supportsSchemasInDataManipulation()
This method tests whether a catalog name can appear in a data
manipulation statement.
|
boolean |
supportsSchemasInIndexDefinitions()
This method tests whether a catalog name can appear in an index definition.
|
boolean |
supportsSchemasInPrivilegeDefinitions()
This method tests whether a catalog name can appear in privilege definitions.
|
boolean |
supportsSchemasInProcedureCalls()
This method tests whether a catalog name can appear in a procedure
call
|
boolean |
supportsSchemasInTableDefinitions()
This method tests whether a catalog name can appear in a table definition.
|
boolean |
supportsSelectForUpdate()
This method tests whether or not SELECT FOR UPDATE is supported by the
database.
|
boolean |
supportsStatementPooling() |
boolean |
supportsStoredProcedures()
This method tests whether or not stored procedures are supported on
this database.
|
boolean |
supportsSubqueriesInComparisons()
This method tests whether or not subqueries are allowed in comparisons.
|
boolean |
supportsSubqueriesInExists()
This method tests whether or not subqueries are allowed in exists
expressions.
|
boolean |
supportsSubqueriesInIns()
This method tests whether subqueries are allowed in IN statements.
|
boolean |
supportsSubqueriesInQuantifieds()
This method tests whether or not subqueries are allowed in quantified
expressions.
|
boolean |
supportsTableCorrelationNames()
This method tests whether or not table correlation names are
supported.
|
boolean |
supportsTransactionIsolationLevel(int level)
This method tests whether or not the database supports the specified
transaction isolation level.
|
boolean |
supportsTransactions()
This method tests whether or not the database supports transactions.
|
boolean |
supportsUnion()
This method tests whether or not the UNION statement is supported.
|
boolean |
supportsUnionAll()
This method tests whether or not the UNION ALL statement is supported.
|
boolean |
updatesAreDetected(int type)
This method tests whether or not the specified result set type can detect
a visible update by calling the
rowUpdated method. |
boolean |
usesLocalFilePerTable()
This method tests whether or not the database uses a separate file for
each table.
|
boolean |
usesLocalFiles()
This method tests whether or not the database uses local files to
store tables.
|
public SQLite4JDatabaseMetaData(SQLite4JConnection con, java.sql.DatabaseMetaData metadata)
public boolean allProceduresAreCallable() throws java.sql.SQLException
DatabaseMetaData
getProcedures
method can be called by this user.allProceduresAreCallable
in interface DatabaseMetaData
true
if all the procedures can be called,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean allTablesAreSelectable() throws java.sql.SQLException
DatabaseMetaData
getTables
method can be selected by this user.allTablesAreSelectable
in interface DatabaseMetaData
true
if all the procedures can be called,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public java.lang.String getURL() throws java.sql.SQLException
DatabaseMetaData
getURL
in interface DatabaseMetaData
null
if it
is not known.SQLException
- If an error occurs.java.sql.SQLException
public java.lang.String getUserName() throws java.sql.SQLException
DatabaseMetaData
getUserName
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public boolean isReadOnly() throws java.sql.SQLException
DatabaseMetaData
isReadOnly
in interface DatabaseMetaData
true
if the database is in read only mode,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean nullsAreSortedHigh() throws java.sql.SQLException
DatabaseMetaData
nullsAreSortedHigh
in interface DatabaseMetaData
true
if NULL's sort as high values, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean nullsAreSortedLow() throws java.sql.SQLException
DatabaseMetaData
nullsAreSortedLow
in interface DatabaseMetaData
true
if NULL's sort as low values, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean nullsAreSortedAtStart() throws java.sql.SQLException
DatabaseMetaData
nullsAreSortedAtStart
in interface DatabaseMetaData
true
if NULL's sort as high values, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean nullsAreSortedAtEnd() throws java.sql.SQLException
DatabaseMetaData
nullsAreSortedAtEnd
in interface DatabaseMetaData
true
if NULL's always sort to the end,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public java.lang.String getDatabaseProductName() throws java.sql.SQLException
DatabaseMetaData
getDatabaseProductName
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public java.lang.String getDatabaseProductVersion() throws java.sql.SQLException
DatabaseMetaData
getDatabaseProductVersion
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public java.lang.String getDriverName() throws java.sql.SQLException
DatabaseMetaData
getDriverName
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public java.lang.String getDriverVersion() throws java.sql.SQLException
DatabaseMetaData
getDriverVersion
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public int getDriverMajorVersion()
DatabaseMetaData
getDriverMajorVersion
in interface DatabaseMetaData
public int getDriverMinorVersion()
DatabaseMetaData
getDriverMinorVersion
in interface DatabaseMetaData
public boolean usesLocalFiles() throws java.sql.SQLException
DatabaseMetaData
usesLocalFiles
in interface DatabaseMetaData
true
if the database uses local files,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean usesLocalFilePerTable() throws java.sql.SQLException
DatabaseMetaData
usesLocalFilePerTable
in interface DatabaseMetaData
true
if the database uses a separate file for each
table false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsMixedCaseIdentifiers() throws java.sql.SQLException
DatabaseMetaData
supportsMixedCaseIdentifiers
in interface DatabaseMetaData
true
if the database supports mixed case identifiers,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean storesUpperCaseIdentifiers() throws java.sql.SQLException
DatabaseMetaData
storesUpperCaseIdentifiers
in interface DatabaseMetaData
true
if the database treats all identifiers as
upper case, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean storesLowerCaseIdentifiers() throws java.sql.SQLException
DatabaseMetaData
storesLowerCaseIdentifiers
in interface DatabaseMetaData
true
if the database treats all identifiers as
lower case, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean storesMixedCaseIdentifiers() throws java.sql.SQLException
DatabaseMetaData
storesMixedCaseIdentifiers
in interface DatabaseMetaData
true
if the database stores mixed case identifiers,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsMixedCaseQuotedIdentifiers() throws java.sql.SQLException
DatabaseMetaData
supportsMixedCaseQuotedIdentifiers
in interface DatabaseMetaData
true
if the database supports mixed case quoted
identifiers, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean storesUpperCaseQuotedIdentifiers() throws java.sql.SQLException
DatabaseMetaData
storesUpperCaseQuotedIdentifiers
in interface DatabaseMetaData
true
if the database treats all quoted identifiers
as upper case, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean storesLowerCaseQuotedIdentifiers() throws java.sql.SQLException
DatabaseMetaData
storesLowerCaseQuotedIdentifiers
in interface DatabaseMetaData
true
if the database treats all quoted identifiers
as lower case, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean storesMixedCaseQuotedIdentifiers() throws java.sql.SQLException
DatabaseMetaData
storesMixedCaseQuotedIdentifiers
in interface DatabaseMetaData
true
if the database stores mixed case quoted
identifiers, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public java.lang.String getIdentifierQuoteString() throws java.sql.SQLException
DatabaseMetaData
getIdentifierQuoteString
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public java.lang.String getSQLKeywords() throws java.sql.SQLException
DatabaseMetaData
getSQLKeywords
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public java.lang.String getNumericFunctions() throws java.sql.SQLException
DatabaseMetaData
getNumericFunctions
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public java.lang.String getStringFunctions() throws java.sql.SQLException
DatabaseMetaData
getStringFunctions
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public java.lang.String getSystemFunctions() throws java.sql.SQLException
DatabaseMetaData
getSystemFunctions
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public java.lang.String getTimeDateFunctions() throws java.sql.SQLException
DatabaseMetaData
getTimeDateFunctions
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public java.lang.String getSearchStringEscape() throws java.sql.SQLException
DatabaseMetaData
getSearchStringEscape
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public java.lang.String getExtraNameCharacters() throws java.sql.SQLException
DatabaseMetaData
getExtraNameCharacters
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsAlterTableWithAddColumn() throws java.sql.SQLException
DatabaseMetaData
supportsAlterTableWithAddColumn
in interface DatabaseMetaData
true
if column add supported, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsAlterTableWithDropColumn() throws java.sql.SQLException
DatabaseMetaData
supportsAlterTableWithDropColumn
in interface DatabaseMetaData
true
if column drop supported, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsColumnAliasing() throws java.sql.SQLException
DatabaseMetaData
supportsColumnAliasing
in interface DatabaseMetaData
true
if column aliasing is supported,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean nullPlusNonNullIsNull() throws java.sql.SQLException
DatabaseMetaData
nullPlusNonNullIsNull
in interface DatabaseMetaData
true
if concatenating NULL and a non-NULL value
returns a NULL, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsConvert() throws java.sql.SQLException
DatabaseMetaData
supportsConvert
in interface DatabaseMetaData
true
if CONVERT is supported, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsConvert(int fromType, int toType) throws java.sql.SQLException
DatabaseMetaData
Types
.supportsConvert
in interface DatabaseMetaData
fromType
- The SQL type to convert from.toType
- The SQL type to convert to.true
if the conversion can be performed,
false
otherwise.java.sql.SQLException
Types
public boolean supportsTableCorrelationNames() throws java.sql.SQLException
DatabaseMetaData
true
in a fully JDBC
compliant driver.supportsTableCorrelationNames
in interface DatabaseMetaData
true
if table correlation names are supported,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsDifferentTableCorrelationNames() throws java.sql.SQLException
DatabaseMetaData
supportsDifferentTableCorrelationNames
in interface DatabaseMetaData
true
if the correlation name must be different from
the table name, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsExpressionsInOrderBy() throws java.sql.SQLException
DatabaseMetaData
supportsExpressionsInOrderBy
in interface DatabaseMetaData
true
if expressions are allowed in ORDER BY
lists, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsOrderByUnrelated() throws java.sql.SQLException
DatabaseMetaData
supportsOrderByUnrelated
in interface DatabaseMetaData
true
if a non-selected column can be used in an
ORDER BY, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsGroupBy() throws java.sql.SQLException
DatabaseMetaData
supportsGroupBy
in interface DatabaseMetaData
true
if GROUP BY is supported, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsGroupByUnrelated() throws java.sql.SQLException
DatabaseMetaData
supportsGroupByUnrelated
in interface DatabaseMetaData
true
if a non-selected column can be used in a
GROUP BY, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsGroupByBeyondSelect() throws java.sql.SQLException
DatabaseMetaData
supportsGroupByBeyondSelect
in interface DatabaseMetaData
true
if GROUP BY an add columns provided it includes
all columns in the select, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsLikeEscapeClause() throws java.sql.SQLException
DatabaseMetaData
true
.supportsLikeEscapeClause
in interface DatabaseMetaData
true
if escapes are supported in LIKE expressions,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsMultipleResultSets() throws java.sql.SQLException
DatabaseMetaData
supportsMultipleResultSets
in interface DatabaseMetaData
true
if multiple result sets are supported for a
single statement, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsMultipleTransactions() throws java.sql.SQLException
DatabaseMetaData
supportsMultipleTransactions
in interface DatabaseMetaData
true
if multiple transactions on different
connections are supported, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsNonNullableColumns() throws java.sql.SQLException
DatabaseMetaData
true
.supportsNonNullableColumns
in interface DatabaseMetaData
true
if NOT NULL columns are supported,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsMinimumSQLGrammar() throws java.sql.SQLException
DatabaseMetaData
true
.supportsMinimumSQLGrammar
in interface DatabaseMetaData
true
if the ODBC minimum grammar is supported,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsCoreSQLGrammar() throws java.sql.SQLException
DatabaseMetaData
supportsCoreSQLGrammar
in interface DatabaseMetaData
true
if the ODBC core grammar is supported,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsExtendedSQLGrammar() throws java.sql.SQLException
DatabaseMetaData
supportsExtendedSQLGrammar
in interface DatabaseMetaData
true
if the ODBC extended grammar is supported,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsANSI92EntryLevelSQL() throws java.sql.SQLException
DatabaseMetaData
true
.supportsANSI92EntryLevelSQL
in interface DatabaseMetaData
true
if the ANSI92 entry level SQL grammar is
supported, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsANSI92IntermediateSQL() throws java.sql.SQLException
DatabaseMetaData
supportsANSI92IntermediateSQL
in interface DatabaseMetaData
true
if the ANSI92 intermediate SQL grammar is
supported, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsANSI92FullSQL() throws java.sql.SQLException
DatabaseMetaData
supportsANSI92FullSQL
in interface DatabaseMetaData
true
if the ANSI92 full SQL grammar is
supported, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsIntegrityEnhancementFacility() throws java.sql.SQLException
DatabaseMetaData
supportsIntegrityEnhancementFacility
in interface DatabaseMetaData
true
if the integrity enhancement facility is
supported, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsOuterJoins() throws java.sql.SQLException
DatabaseMetaData
supportsOuterJoins
in interface DatabaseMetaData
true
if outer joins are supported, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsFullOuterJoins() throws java.sql.SQLException
DatabaseMetaData
supportsFullOuterJoins
in interface DatabaseMetaData
true
if full outer joins are supported,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsLimitedOuterJoins() throws java.sql.SQLException
DatabaseMetaData
supportsLimitedOuterJoins
in interface DatabaseMetaData
true
if limited outer joins are supported,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public java.lang.String getSchemaTerm() throws java.sql.SQLException
DatabaseMetaData
getSchemaTerm
in interface DatabaseMetaData
SQLException
- if an error occurs.java.sql.SQLException
public java.lang.String getProcedureTerm() throws java.sql.SQLException
DatabaseMetaData
getProcedureTerm
in interface DatabaseMetaData
SQLException
- if an error occurs.java.sql.SQLException
public java.lang.String getCatalogTerm() throws java.sql.SQLException
DatabaseMetaData
getCatalogTerm
in interface DatabaseMetaData
SQLException
- if an error occurs.java.sql.SQLException
public boolean isCatalogAtStart() throws java.sql.SQLException
DatabaseMetaData
isCatalogAtStart
in interface DatabaseMetaData
true
if the catalog name appears at the beginning,
false
if it appears at the end.SQLException
- If an error occurs.java.sql.SQLException
public java.lang.String getCatalogSeparator() throws java.sql.SQLException
DatabaseMetaData
getCatalogSeparator
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsSchemasInDataManipulation() throws java.sql.SQLException
DatabaseMetaData
supportsSchemasInDataManipulation
in interface DatabaseMetaData
true
if a catalog name can appear in a data
manipulation statement, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsSchemasInProcedureCalls() throws java.sql.SQLException
DatabaseMetaData
supportsSchemasInProcedureCalls
in interface DatabaseMetaData
true
if a catalog name can appear in a procedure
call, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsSchemasInTableDefinitions() throws java.sql.SQLException
DatabaseMetaData
supportsSchemasInTableDefinitions
in interface DatabaseMetaData
true
if a catalog name can appear in a table
definition, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsSchemasInIndexDefinitions() throws java.sql.SQLException
DatabaseMetaData
supportsSchemasInIndexDefinitions
in interface DatabaseMetaData
true
if a catalog name can appear in an index
definition, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsSchemasInPrivilegeDefinitions() throws java.sql.SQLException
DatabaseMetaData
supportsSchemasInPrivilegeDefinitions
in interface DatabaseMetaData
true
if a catalog name can appear in privilege
definition, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsCatalogsInDataManipulation() throws java.sql.SQLException
DatabaseMetaData
supportsCatalogsInDataManipulation
in interface DatabaseMetaData
true
if a catalog name can appear in a data
manipulation statement, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsCatalogsInProcedureCalls() throws java.sql.SQLException
DatabaseMetaData
supportsCatalogsInProcedureCalls
in interface DatabaseMetaData
true
if a catalog name can appear in a procedure
call, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsCatalogsInTableDefinitions() throws java.sql.SQLException
DatabaseMetaData
supportsCatalogsInTableDefinitions
in interface DatabaseMetaData
true
if a catalog name can appear in a table
definition, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsCatalogsInIndexDefinitions() throws java.sql.SQLException
DatabaseMetaData
supportsCatalogsInIndexDefinitions
in interface DatabaseMetaData
true
if a catalog name can appear in an index
definition, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsCatalogsInPrivilegeDefinitions() throws java.sql.SQLException
DatabaseMetaData
supportsCatalogsInPrivilegeDefinitions
in interface DatabaseMetaData
true
if a catalog name can appear in privilege
definition, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsPositionedDelete() throws java.sql.SQLException
DatabaseMetaData
supportsPositionedDelete
in interface DatabaseMetaData
true
if positioned deletes are supported,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsPositionedUpdate() throws java.sql.SQLException
DatabaseMetaData
supportsPositionedUpdate
in interface DatabaseMetaData
true
if positioned updates are supported,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsSelectForUpdate() throws java.sql.SQLException
DatabaseMetaData
supportsSelectForUpdate
in interface DatabaseMetaData
true
if SELECT FOR UPDATE is supported
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsStoredProcedures() throws java.sql.SQLException
DatabaseMetaData
supportsStoredProcedures
in interface DatabaseMetaData
true
if stored procedures are supported,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsSubqueriesInComparisons() throws java.sql.SQLException
DatabaseMetaData
true
.supportsSubqueriesInComparisons
in interface DatabaseMetaData
true
if subqueries are allowed in comparisons,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsSubqueriesInExists() throws java.sql.SQLException
DatabaseMetaData
true
.supportsSubqueriesInExists
in interface DatabaseMetaData
true
if subqueries are allowed in exists
expressions, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsSubqueriesInIns() throws java.sql.SQLException
DatabaseMetaData
true
.supportsSubqueriesInIns
in interface DatabaseMetaData
true
if the driver supports subqueries in IN
statements, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsSubqueriesInQuantifieds() throws java.sql.SQLException
DatabaseMetaData
true
.supportsSubqueriesInQuantifieds
in interface DatabaseMetaData
true
if subqueries are allowed in quantified
expressions, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsCorrelatedSubqueries() throws java.sql.SQLException
DatabaseMetaData
true
.supportsCorrelatedSubqueries
in interface DatabaseMetaData
true
if correlated subqueries are allowed,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsUnion() throws java.sql.SQLException
DatabaseMetaData
supportsUnion
in interface DatabaseMetaData
true
if UNION is supported, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsUnionAll() throws java.sql.SQLException
DatabaseMetaData
supportsUnionAll
in interface DatabaseMetaData
true
if UNION ALL is supported, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsOpenCursorsAcrossCommit() throws java.sql.SQLException
DatabaseMetaData
supportsOpenCursorsAcrossCommit
in interface DatabaseMetaData
true
if cursors can remain open across commits,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsOpenCursorsAcrossRollback() throws java.sql.SQLException
DatabaseMetaData
supportsOpenCursorsAcrossRollback
in interface DatabaseMetaData
true
if cursors can remain open across rollbacks,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsOpenStatementsAcrossCommit() throws java.sql.SQLException
DatabaseMetaData
supportsOpenStatementsAcrossCommit
in interface DatabaseMetaData
true
if statements can remain open across commits,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsOpenStatementsAcrossRollback() throws java.sql.SQLException
DatabaseMetaData
supportsOpenStatementsAcrossRollback
in interface DatabaseMetaData
true
if statements can remain open across rollbacks,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public int getMaxBinaryLiteralLength() throws java.sql.SQLException
DatabaseMetaData
getMaxBinaryLiteralLength
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public int getMaxCharLiteralLength() throws java.sql.SQLException
DatabaseMetaData
getMaxCharLiteralLength
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public int getMaxColumnNameLength() throws java.sql.SQLException
DatabaseMetaData
getMaxColumnNameLength
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public int getMaxColumnsInGroupBy() throws java.sql.SQLException
DatabaseMetaData
getMaxColumnsInGroupBy
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public int getMaxColumnsInIndex() throws java.sql.SQLException
DatabaseMetaData
getMaxColumnsInIndex
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public int getMaxColumnsInOrderBy() throws java.sql.SQLException
DatabaseMetaData
getMaxColumnsInOrderBy
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public int getMaxColumnsInSelect() throws java.sql.SQLException
DatabaseMetaData
getMaxColumnsInSelect
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public int getMaxColumnsInTable() throws java.sql.SQLException
DatabaseMetaData
getMaxColumnsInTable
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public int getMaxConnections() throws java.sql.SQLException
DatabaseMetaData
getMaxConnections
in interface DatabaseMetaData
java.sql.SQLException
public int getMaxCursorNameLength() throws java.sql.SQLException
DatabaseMetaData
getMaxCursorNameLength
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public int getMaxIndexLength() throws java.sql.SQLException
DatabaseMetaData
getMaxIndexLength
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public int getMaxSchemaNameLength() throws java.sql.SQLException
DatabaseMetaData
getMaxSchemaNameLength
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public int getMaxProcedureNameLength() throws java.sql.SQLException
DatabaseMetaData
getMaxProcedureNameLength
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public int getMaxCatalogNameLength() throws java.sql.SQLException
DatabaseMetaData
getMaxCatalogNameLength
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public int getMaxRowSize() throws java.sql.SQLException
DatabaseMetaData
getMaxRowSize
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public boolean doesMaxRowSizeIncludeBlobs() throws java.sql.SQLException
DatabaseMetaData
doesMaxRowSizeIncludeBlobs
in interface DatabaseMetaData
true
if the maximum row size includes BLOB's,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public int getMaxStatementLength() throws java.sql.SQLException
DatabaseMetaData
getMaxStatementLength
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public int getMaxStatements() throws java.sql.SQLException
DatabaseMetaData
getMaxStatements
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public int getMaxTableNameLength() throws java.sql.SQLException
DatabaseMetaData
getMaxTableNameLength
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public int getMaxTablesInSelect() throws java.sql.SQLException
DatabaseMetaData
getMaxTablesInSelect
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public int getMaxUserNameLength() throws java.sql.SQLException
DatabaseMetaData
getMaxUserNameLength
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public int getDefaultTransactionIsolation() throws java.sql.SQLException
DatabaseMetaData
getDefaultTransactionIsolation
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
Connection
public boolean supportsTransactions() throws java.sql.SQLException
DatabaseMetaData
supportsTransactions
in interface DatabaseMetaData
true
if the database supports transactions,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsTransactionIsolationLevel(int level) throws java.sql.SQLException
DatabaseMetaData
supportsTransactionIsolationLevel
in interface DatabaseMetaData
level
- The transaction isolation level.true
if the specified transaction isolation level
is supported, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsDataDefinitionAndDataManipulationTransactions() throws java.sql.SQLException
DatabaseMetaData
supportsDataDefinitionAndDataManipulationTransactions
in interface DatabaseMetaData
true
if DDL and DML statements are allowed in the
same transaction, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsDataManipulationTransactionsOnly() throws java.sql.SQLException
DatabaseMetaData
supportsDataManipulationTransactionsOnly
in interface DatabaseMetaData
true
if only DML statements are allowed in
transactions, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean dataDefinitionCausesTransactionCommit() throws java.sql.SQLException
DatabaseMetaData
dataDefinitionCausesTransactionCommit
in interface DatabaseMetaData
true
if DDL causes an immediate transaction commit,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public boolean dataDefinitionIgnoredInTransactions() throws java.sql.SQLException
DatabaseMetaData
dataDefinitionIgnoredInTransactions
in interface DatabaseMetaData
true
if DDL statements are ignored in transactions,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public ResultSet getProcedures(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String procedurePattern) throws java.sql.SQLException
DatabaseMetaData
ResultSet
with the following columns:
null
.null
.procedureResultUnknown
, procedureNoResult
, or
procedureReturnsResult
).getProcedures
in interface DatabaseMetaData
catalog
- The name of the catalog to return stored procedured from,
or "" to return procedures from all catalogs.schemaPattern
- A schema pattern for the schemas to return stored
procedures from, or "" to return procedures from all schemas.procedurePattern
- The pattern of procedure names to return.SQLException
- If an error occurs.java.sql.SQLException
public ResultSet getProcedureColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String procedurePattern, java.lang.String columnPattern) throws java.sql.SQLException
DatabaseMetaData
ResultSet
with the following columns:
null
.null
.procedureColumnUnknown
,
procedureColumnIn
, procedureColumnInOut
,
procedureColumnOut
, procedureColumnReturn
,
or procedureColumnResult
).Types
.procedureNoNulls
,
procedureNullable
, or procedureNullableUnknown
)getProcedureColumns
in interface DatabaseMetaData
catalog
- The name of the catalog to return stored procedured from,
or "" to return procedures from all catalogs.schemaPattern
- A schema pattern for the schemas to return stored
procedures from, or "" to return procedures from all schemas.procedurePattern
- The pattern of procedures names to return.columnPattern
- The pattern of column names to return.SQLException
- If an error occurs.java.sql.SQLException
public ResultSet getTables(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tablePattern, java.lang.String[] types) throws java.sql.SQLException
DatabaseMetaData
ResultSet
with the following columns:
null
.null
.getTableTypes()
method.getTables
in interface DatabaseMetaData
catalog
- The name of the catalog to return tables from,
or "" to return tables from all catalogs.schemaPattern
- A schema pattern for the schemas to return tables
from, or "" to return tables from all schemas.tablePattern
- The pattern of table names to return.types
- The list of table types to include; null returns all types.SQLException
- If an error occurs.java.sql.SQLException
public ResultSet getSchemas() throws java.sql.SQLException
DatabaseMetaData
ResultSet
, with one column - TABLE_SCHEM - that is the
name of the schema.getSchemas
in interface DatabaseMetaData
ResultSet
with all the requested schemas.SQLException
- If an error occurs.java.sql.SQLException
public ResultSet getCatalogs() throws java.sql.SQLException
DatabaseMetaData
ResultSet
with one column - TABLE_CAT - that is the
name of the catalog.getCatalogs
in interface DatabaseMetaData
ResultSet
with all the requested catalogs.SQLException
- If an error occurs.java.sql.SQLException
public ResultSet getTableTypes() throws java.sql.SQLException
DatabaseMetaData
ResultSet
with one column - TABLE_TYPE - that is the
name of the table type.getTableTypes
in interface DatabaseMetaData
ResultSet
with all the requested table types.SQLException
- If an error occurs.java.sql.SQLException
public ResultSet getColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tablePattern, java.lang.String columnPattern) throws java.sql.SQLException
DatabaseMetaData
ResultSet
with the following columns:
null
.null
.Types
.tableNoNulls
,
tableNullable
, or tableNullableUnknown
)null
.getColumns
in interface DatabaseMetaData
catalog
- The name of the catalog to return table from,
or "" to return tables from all catalogs.schemaPattern
- A schema pattern for the schemas to return
tables from, or "" to return tables from all schemas.tablePattern
- The pattern of table names to return.columnPattern
- The pattern of column names to return.SQLException
- If an error occurs.java.sql.SQLException
public ResultSet getColumnPrivileges(java.lang.String catalog, java.lang.String schema, java.lang.String tableName, java.lang.String columnPattern) throws java.sql.SQLException
DatabaseMetaData
ResultSet
with the following columns:
null
.null
.null
if unknown.getColumnPrivileges
in interface DatabaseMetaData
catalog
- The catalog to retrieve information from, or the empty string
to return entities not associated with a catalog, or null
to return information from all catalogs.schema
- The schema to retrieve information from, or the empty string
to return entities not associated with a schema.tableName
- The table name to return information for.columnPattern
- A pattern of column names to return information for.ResultSet
with all the requested privileges.SQLException
- If an error occurs.java.sql.SQLException
public ResultSet getTablePrivileges(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tablePattern) throws java.sql.SQLException
DatabaseMetaData
ResultSet
with the following columns:
null
.null
.null
if unknown.getTablePrivileges
in interface DatabaseMetaData
catalog
- The catalog to retrieve information from, or the empty string
to return entities not associated with a catalog, or null
to return information from all catalogs.schemaPattern
- The schema to retrieve information from, or the empty string
to return entities not associated with a schema.tablePattern
- The table name pattern of tables to return
information for.ResultSet
with all the requested privileges.SQLException
- If an error occurs.java.sql.SQLException
public ResultSet getBestRowIdentifier(java.lang.String catalog, java.lang.String schema, java.lang.String tableName, int scope, boolean nullable) throws java.sql.SQLException
DatabaseMetaData
ResultSet
with
the following columns:
bestRowTemporary
,
bestRowTransaction
, or bestRowSession
).Types
.bestRowUnknown
, bestRowNotPseudo
, or
bestRowPseudo
).getBestRowIdentifier
in interface DatabaseMetaData
catalog
- The catalog to retrieve information from, or the empty string
to return entities not associated with a catalog, or null
to return information from all catalogs.schema
- The schema to retrieve information from, or the empty string
to return entities not associated with a schema.tableName
- The table name to return information for.scope
- One of the best row id scope constants from this class.nullable
- true
to include columns that are nullable,
false
otherwise.ResultSet
with the best row identifier.SQLException
- If an error occurs.java.sql.SQLException
public ResultSet getVersionColumns(java.lang.String catalog, java.lang.String schema, java.lang.String tableName) throws java.sql.SQLException
DatabaseMetaData
ResultSet
with the following columns:
Types
.versionRowUnknown
, versionRowNotPseudo
, or
versionRowPseudo
).getVersionColumns
in interface DatabaseMetaData
catalog
- The catalog to retrieve information from, or the empty string
to return entities not associated with a catalog, or null
to return information from all catalogs.schema
- The schema to retrieve information from, or the empty string
to return entities not associated with a schema.tableName
- The table name to return information forResultSet
with the version columns.SQLException
- If an error occurs.java.sql.SQLException
public ResultSet getPrimaryKeys(java.lang.String catalog, java.lang.String schema, java.lang.String tableName) throws java.sql.SQLException
DatabaseMetaData
ResultSet
with the following columns.
null
.null
.null
.getPrimaryKeys
in interface DatabaseMetaData
catalog
- The catalog to retrieve information from, or the empty string
to return entities not associated with a catalog, or null
to return information from all catalogs.schema
- The schema to retrieve information from, or the empty string
to return entities not associated with a schema.tableName
- The table name to return information for.ResultSet
with the primary key columns.SQLException
- If an error occurs.java.sql.SQLException
public ResultSet getImportedKeys(java.lang.String catalog, java.lang.String schema, java.lang.String tableName) throws java.sql.SQLException
DatabaseMetaData
ResultSet
with the following columns:
importedNoAction
, importedKeyCascade
,
importedKeySetNull
, importedKeySetDefault
, or
importedKeyRestrict
).importedNoAction
, importedKeyCascade
,
importedKeySetNull
, or importedKeySetDefault
)importedKeyInitiallyDeferred
,
importedKeyInitiallyImmediate
, or
importedKeyNotDeferrable
).getImportedKeys
in interface DatabaseMetaData
catalog
- The catalog to retrieve information from, or the empty string
to return entities not associated with a catalog, or null
to return information from all catalogs.schema
- The schema to retrieve information from, or the empty string
to return entities not associated with a schema.tableName
- The table name to return information for.ResultSet
with the foreign key columns.SQLException
- If an error occurs.java.sql.SQLException
public ResultSet getExportedKeys(java.lang.String catalog, java.lang.String schema, java.lang.String tableName) throws java.sql.SQLException
DatabaseMetaData
ResultSet
with the following columns:
importedNoAction
, importedKeyCascade
,
importedKeySetNull
, importedKeySetDefault
, or
importedKeyRestrict
).importedNoAction
, importedKeyCascade
,
importedKeySetNull
, or importedKeySetDefault
)importedKeyInitiallyDeferred
,
importedKeyInitiallyImmediate
, or
importedKeyNotDeferrable
).getExportedKeys
in interface DatabaseMetaData
catalog
- The catalog to retrieve information from, or the empty string
to return entities not associated with a catalog, or null
to return information from all catalogs.schema
- The schema to retrieve information from, or the empty string
to return entities not associated with a schema.tableName
- The table name to return information for.ResultSet
with the requested informationSQLException
- If an error occurs.java.sql.SQLException
public ResultSet getCrossReference(java.lang.String primaryCatalog, java.lang.String primarySchema, java.lang.String primaryTableName, java.lang.String foreignCatalog, java.lang.String foreignSchema, java.lang.String foreignTableName) throws java.sql.SQLException
DatabaseMetaData
ResultSet
with the following columns:
importedNoAction
, importedKeyCascade
,
importedKeySetNull
, importedKeySetDefault
, or
importedKeyRestrict
).importedNoAction
, importedKeyCascade
,
importedKeySetNull
, or importedKeySetDefault
)importedKeyInitiallyDeferred
,
importedKeyInitiallyImmediate
, or
importedKeyNotDeferrable
).getCrossReference
in interface DatabaseMetaData
primaryCatalog
- The catalog to retrieve information from, or the
empty string to return entities not associated with a catalog, or
null
to return information from all catalogs, on the
exporting side.primarySchema
- The schema to retrieve information from, or the empty
string to return entities not associated with a schema, on the
exporting side.primaryTableName
- The table name to return information for, on the
exporting side.foreignCatalog
- The catalog to retrieve information from, or the
empty string to return entities not associated with a catalog,
or null
to return information from all catalogs, on
the importing side.foreignSchema
- The schema to retrieve information from, or the
empty string to return entities not associated with a schema on
the importing side.foreignTableName
- The table name to return information for on the
importing side.ResultSet
with the requested informationSQLException
- If an error occurs.java.sql.SQLException
public ResultSet getTypeInfo() throws java.sql.SQLException
DatabaseMetaData
ResultSet
with the following columns:
Types
for this
type.null
.null
.null
.typeNoNulls
, typeNullable
, or
typeNullableUnknown
).typePredNone
, typePredChar
,
typePredBasic
, or typeSearchable
).getTypeInfo
in interface DatabaseMetaData
ResultSet
with the list of available data types.SQLException
- If an error occurs.java.sql.SQLException
public ResultSet getIndexInfo(java.lang.String catalog, java.lang.String schema, java.lang.String tableName, boolean unique, boolean approximate) throws java.sql.SQLException
DatabaseMetaData
ResultSet
with the following columns:
null
.null
.null
tableIndexStatistic
,
tableIndexClustered
, tableIndexHashed
, or
tableIndexOther
).tableIndexStatistic
.null
if a sort sequence is not
supported.tableIndexStatistic
.tableIndexStatistic
.null
.getIndexInfo
in interface DatabaseMetaData
catalog
- The catalog to retrieve information from, or the empty string
to return entities not associated with a catalog, or
null
to return information from all catalogs.schema
- The schema to retrieve information from, or the empty string
to return entities not associated with a schema.tableName
- The table name to return information for.unique
- true
to return only unique indexes,
false
otherwise.approximate
- true
if data values can be approximations,
false
otherwise.ResultSet
with the requested index informationSQLException
- If an error occurs.java.sql.SQLException
public boolean supportsResultSetType(int type) throws java.sql.SQLException
DatabaseMetaData
supportsResultSetType
in interface DatabaseMetaData
type
- The desired result type, which is one of the constants
defined in ResultSet
.true
if the result set type is supported,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
ResultSet
public boolean supportsResultSetConcurrency(int type, int concurrency) throws java.sql.SQLException
DatabaseMetaData
supportsResultSetConcurrency
in interface DatabaseMetaData
type
- The desired result type, which is one of the constants
defined in ResultSet
.concurrency
- The desired concurrency type, which is one of the
constants defined in ResultSet
.true
if the result set type is supported,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
ResultSet
public boolean ownUpdatesAreVisible(int type) throws java.sql.SQLException
DatabaseMetaData
ownUpdatesAreVisible
in interface DatabaseMetaData
type
- The desired result type, which is one of the constants
defined in ResultSet
.true
if the result set type sees its own updates,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
ResultSet
public boolean ownDeletesAreVisible(int type) throws java.sql.SQLException
DatabaseMetaData
ownDeletesAreVisible
in interface DatabaseMetaData
type
- The desired result type, which is one of the constants
defined in ResultSet
.true
if the result set type sees its own deletes,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
ResultSet
public boolean ownInsertsAreVisible(int type) throws java.sql.SQLException
DatabaseMetaData
ownInsertsAreVisible
in interface DatabaseMetaData
type
- The desired result type, which is one of the constants
defined in ResultSet
.true
if the result set type sees its own inserts,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
ResultSet
public boolean othersUpdatesAreVisible(int type) throws java.sql.SQLException
DatabaseMetaData
othersUpdatesAreVisible
in interface DatabaseMetaData
type
- The desired result type, which is one of the constants
defined in ResultSet
.true
if the result set type sees other updates,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
ResultSet
public boolean othersDeletesAreVisible(int type) throws java.sql.SQLException
DatabaseMetaData
othersDeletesAreVisible
in interface DatabaseMetaData
type
- The desired result type, which is one of the constants
defined in ResultSet
.true
if the result set type sees other deletes,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
ResultSet
public boolean othersInsertsAreVisible(int type) throws java.sql.SQLException
DatabaseMetaData
othersInsertsAreVisible
in interface DatabaseMetaData
type
- The desired result type, which is one of the constants
defined in ResultSet
.true
if the result set type sees other inserts,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
ResultSet
public boolean updatesAreDetected(int type) throws java.sql.SQLException
DatabaseMetaData
rowUpdated
method.updatesAreDetected
in interface DatabaseMetaData
type
- The desired result type, which is one of the constants
defined in ResultSet
.true
if the result set type can detect visible updates
using rowUpdated
, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
ResultSet
public boolean deletesAreDetected(int type) throws java.sql.SQLException
DatabaseMetaData
rowUpdated
method.deletesAreDetected
in interface DatabaseMetaData
type
- The desired result type, which is one of the constants
defined in ResultSet
.true
if the result set type can detect visible deletes
using rowUpdated
, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
ResultSet
public boolean insertsAreDetected(int type) throws java.sql.SQLException
DatabaseMetaData
rowUpdated
method.insertsAreDetected
in interface DatabaseMetaData
type
- The desired result type, which is one of the constants
defined in ResultSet
.true
if the result set type can detect visible inserts
using rowUpdated
, false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
ResultSet
public boolean supportsBatchUpdates() throws java.sql.SQLException
DatabaseMetaData
supportsBatchUpdates
in interface DatabaseMetaData
true
if batch updates are supported,
false
otherwise.SQLException
- If an error occurs.java.sql.SQLException
public ResultSet getUDTs(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typePattern, int[] types) throws java.sql.SQLException
DatabaseMetaData
ResultSet
with the following columns:
null
.null
.Types
for this type.
This will be one of JAVA_OBJECT
, STRUCT
, or
DISTINCT
.getUDTs
in interface DatabaseMetaData
catalog
- The catalog to retrieve information from, or the empty string
to return entities not associated with a catalog, or null
to return information from all catalogs.schemaPattern
- The schema to retrieve information from, or the
empty string to return entities not associated with a schema.typePattern
- The type name pattern to match.types
- The type identifier patterns (from Types
) to
match.ResultSet
with the requested type informationSQLException
- If an error occurs.java.sql.SQLException
public Connection getConnection() throws java.sql.SQLException
DatabaseMetaData
Connection
object that was used
to generate the metadata in this object.getConnection
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsSavepoints() throws java.sql.SQLException
DatabaseMetaData
supportsSavepoints
in interface DatabaseMetaData
true
if the database supports savepoints,
false
if it does not.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsNamedParameters() throws java.sql.SQLException
DatabaseMetaData
supportsNamedParameters
in interface DatabaseMetaData
true
if the database supports named parameters,
false
if it does not.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsMultipleOpenResults() throws java.sql.SQLException
DatabaseMetaData
ResultSet
S from a CallableStatement
at once.supportsMultipleOpenResults
in interface DatabaseMetaData
true
if the database supports returnig multiple
results at once, false
if it does not.SQLException
- If an error occurs.java.sql.SQLException
public boolean supportsGetGeneratedKeys() throws java.sql.SQLException
supportsGetGeneratedKeys
in interface DatabaseMetaData
java.sql.SQLException
public ResultSet getSuperTypes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typePattern) throws java.sql.SQLException
getSuperTypes
in interface DatabaseMetaData
java.sql.SQLException
public ResultSet getSuperTables(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tablePattern) throws java.sql.SQLException
getSuperTables
in interface DatabaseMetaData
java.sql.SQLException
public ResultSet getAttributes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typePattern, java.lang.String attributePattern) throws java.sql.SQLException
getAttributes
in interface DatabaseMetaData
java.sql.SQLException
public boolean supportsResultSetHoldability(int holdability) throws java.sql.SQLException
DatabaseMetaData
ResultSet
class.supportsResultSetHoldability
in interface DatabaseMetaData
holdability
- The holdability type to test.true
if the database supports the holdability type,
false
if it does not.SQLException
- If an error occurs.java.sql.SQLException
ResultSet
public int getResultSetHoldability() throws java.sql.SQLException
DatabaseMetaData
ResultSet
S
retrieved from this database. The possible values are specified in the
ResultSet
class.getResultSetHoldability
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public int getDatabaseMajorVersion() throws java.sql.SQLException
DatabaseMetaData
getDatabaseMajorVersion
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public int getDatabaseMinorVersion() throws java.sql.SQLException
DatabaseMetaData
getDatabaseMinorVersion
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public int getJDBCMajorVersion() throws java.sql.SQLException
DatabaseMetaData
getJDBCMajorVersion
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public int getJDBCMinorVersion() throws java.sql.SQLException
DatabaseMetaData
getJDBCMinorVersion
in interface DatabaseMetaData
SQLException
- If an error occurs.java.sql.SQLException
public int getSQLStateType() throws java.sql.SQLException
getSQLStateType
in interface DatabaseMetaData
java.sql.SQLException
public boolean locatorsUpdateCopy() throws java.sql.SQLException
locatorsUpdateCopy
in interface DatabaseMetaData
java.sql.SQLException
public boolean supportsStatementPooling() throws java.sql.SQLException
supportsStatementPooling
in interface DatabaseMetaData
java.sql.SQLException