|
||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||
java.lang.Objectorg.h2.message.TraceObject
org.h2.jdbc.JdbcDatabaseMetaData
public class JdbcDatabaseMetaData
Represents the meta data for a database.
| Field Summary |
|---|
| Fields inherited from class org.h2.message.TraceObject |
|---|
ARRAY, BLOB, CALLABLE_STATEMENT, CLOB, CONNECTION, DATA_SOURCE, DATABASE_META_DATA, PARAMETER_META_DATA, PREPARED_STATEMENT, RESULT_SET, RESULT_SET_META_DATA, SAVEPOINT, SQL_EXCEPTION, STATEMENT, trace, XA_DATA_SOURCE, XA_RESOURCE, XID |
| Fields inherited from interface java.sql.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 |
| Method Summary | |
|---|---|
boolean |
allProceduresAreCallable()
Checks if all procedures callable. |
boolean |
allTablesAreSelectable()
Checks if it possible to query all tables returned by getTables. |
boolean |
autoCommitFailureClosesAllResultSets()
Returns whether an exception while auto commit is on closes all result sets. |
boolean |
dataDefinitionCausesTransactionCommit()
Returns whether CREATE/DROP commit an open transaction. |
boolean |
dataDefinitionIgnoredInTransactions()
Returns whether CREATE/DROP do not affect transactions. |
boolean |
deletesAreDetected(int type)
Returns whether deletes are detected. |
boolean |
doesMaxRowSizeIncludeBlobs()
Returns whether the maximum row size includes blobs. |
java.sql.ResultSet |
getAttributes(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern,
java.lang.String attributeNamePattern)
[Not supported] |
java.sql.ResultSet |
getBestRowIdentifier(java.lang.String catalogPattern,
java.lang.String schemaPattern,
java.lang.String tableName,
int scope,
boolean nullable)
Gets the list of columns that best identifier a row in a table. |
java.sql.ResultSet |
getCatalogs()
Gets the list of catalogs. |
java.lang.String |
getCatalogSeparator()
Returns the catalog separator. |
java.lang.String |
getCatalogTerm()
Returns the term for "catalog". |
java.sql.ResultSet |
getClientInfoProperties()
[Not supported] Returns the client info properties. |
java.sql.ResultSet |
getColumnPrivileges(java.lang.String catalogPattern,
java.lang.String schemaPattern,
java.lang.String table,
java.lang.String columnNamePattern)
Gets the list of column privileges. |
java.sql.ResultSet |
getColumns(java.lang.String catalogPattern,
java.lang.String schemaPattern,
java.lang.String tableNamePattern,
java.lang.String columnNamePattern)
Gets the list of columns. |
java.sql.Connection |
getConnection()
Returns the connection that created this object. |
java.sql.ResultSet |
getCrossReference(java.lang.String primaryCatalogPattern,
java.lang.String primarySchemaPattern,
java.lang.String primaryTable,
java.lang.String foreignCatalogPattern,
java.lang.String foreignSchemaPattern,
java.lang.String foreignTable)
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. |
int |
getDatabaseMajorVersion()
Gets the major version of the database. |
int |
getDatabaseMinorVersion()
Gets the minor version of the database. |
java.lang.String |
getDatabaseProductName()
Gets the database product name. |
java.lang.String |
getDatabaseProductVersion()
Gets the product version of the database. |
int |
getDefaultTransactionIsolation()
Returns the default transaction isolation level. |
int |
getDriverMajorVersion()
Returns the major version of this driver. |
int |
getDriverMinorVersion()
Returns the minor version of this driver. |
java.lang.String |
getDriverName()
Gets the name of the JDBC driver. |
java.lang.String |
getDriverVersion()
Gets the version number of the driver. |
java.sql.ResultSet |
getExportedKeys(java.lang.String catalogPattern,
java.lang.String schemaPattern,
java.lang.String tableName)
Gets the list of foreign key columns that reference a table. |
java.lang.String |
getExtraNameCharacters()
Returns the characters that are allowed for identifiers in addiction to A-Z, a-z, 0-9 and '_'. |
java.lang.String |
getIdentifierQuoteString()
Returns the string used to quote identifiers. |
java.sql.ResultSet |
getImportedKeys(java.lang.String catalogPattern,
java.lang.String schemaPattern,
java.lang.String tableName)
Gets the list of primary key columns that are referenced by a table. |
java.sql.ResultSet |
getIndexInfo(java.lang.String catalogPattern,
java.lang.String schemaPattern,
java.lang.String tableName,
boolean unique,
boolean approximate)
Gets the list of indexes for this database. |
int |
getJDBCMajorVersion()
Gets the major version of the supported JDBC API. |
int |
getJDBCMinorVersion()
Gets the minor version of the supported JDBC API. |
int |
getMaxBinaryLiteralLength()
Returns the maximum length for hex values (characters). |
int |
getMaxCatalogNameLength()
Returns the maximum length for a catalog name. |
int |
getMaxCharLiteralLength()
Returns the maximum length for literals. |
int |
getMaxColumnNameLength()
Returns the maximum length for column names. |
int |
getMaxColumnsInGroupBy()
Returns the maximum number of columns in GROUP BY. |
int |
getMaxColumnsInIndex()
Returns the maximum number of columns in CREATE INDEX. |
int |
getMaxColumnsInOrderBy()
Returns the maximum number of columns in ORDER BY. |
int |
getMaxColumnsInSelect()
Returns the maximum number of columns in SELECT. |
int |
getMaxColumnsInTable()
Returns the maximum number of columns in CREATE TABLE. |
int |
getMaxConnections()
Returns the maximum number of open connection. |
int |
getMaxCursorNameLength()
Returns the maximum length for a cursor name. |
int |
getMaxIndexLength()
Returns the maximum length for an index (in bytes). |
int |
getMaxProcedureNameLength()
Returns the maximum length for a procedure name. |
int |
getMaxRowSize()
Returns the maximum size of a row (in bytes). |
int |
getMaxSchemaNameLength()
Returns the maximum length for a schema name. |
int |
getMaxStatementLength()
Returns the maximum length of a statement. |
int |
getMaxStatements()
Returns the maximum number of open statements. |
int |
getMaxTableNameLength()
Returns the maximum length for a table name. |
int |
getMaxTablesInSelect()
Returns the maximum number of tables in a SELECT. |
int |
getMaxUserNameLength()
Returns the maximum length for a user name. |
java.lang.String |
getNumericFunctions()
Returns the list of numeric functions supported by this database. |
java.sql.ResultSet |
getPrimaryKeys(java.lang.String catalogPattern,
java.lang.String schemaPattern,
java.lang.String tableName)
Gets the primary key columns for a table. |
java.sql.ResultSet |
getProcedureColumns(java.lang.String catalogPattern,
java.lang.String schemaPattern,
java.lang.String procedureNamePattern,
java.lang.String columnNamePattern)
Gets the list of procedure columns. |
java.sql.ResultSet |
getProcedures(java.lang.String catalogPattern,
java.lang.String schemaPattern,
java.lang.String procedureNamePattern)
Gets the list of procedures. |
java.lang.String |
getProcedureTerm()
Returns the term for "procedure". |
int |
getResultSetHoldability()
Gets the result set holdability. |
java.sql.ResultSet |
getSchemas()
Gets the list of schemas. |
java.lang.String |
getSchemaTerm()
Returns the term for "schema". |
java.lang.String |
getSearchStringEscape()
Returns the default escape character for DatabaseMetaData search patterns. |
java.lang.String |
getSQLKeywords()
Gets the comma-separated list of all SQL keywords that are not supported as table/column/index name, in addition to the SQL-92 keywords. |
int |
getSQLStateType()
Gets the SQL State type. |
java.lang.String |
getStringFunctions()
Returns the list of string functions supported by this database. |
java.sql.ResultSet |
getSuperTables(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern)
Get the list of super tables of a table. |
java.sql.ResultSet |
getSuperTypes(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern)
[Not supported] |
java.lang.String |
getSystemFunctions()
Returns the list of system functions supported by this database. |
java.sql.ResultSet |
getTablePrivileges(java.lang.String catalogPattern,
java.lang.String schemaPattern,
java.lang.String tableNamePattern)
Gets the list of table privileges. |
java.sql.ResultSet |
getTables(java.lang.String catalogPattern,
java.lang.String schemaPattern,
java.lang.String tableNamePattern,
java.lang.String[] types)
Gets the list of tables in the database. |
java.sql.ResultSet |
getTableTypes()
Gets the list of table types. |
java.lang.String |
getTimeDateFunctions()
Returns the list of date and time functions supported by this database. |
java.sql.ResultSet |
getTypeInfo()
Gets the list of data types. |
java.sql.ResultSet |
getUDTs(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern,
int[] types)
Gets the list of user-defined data types. |
java.lang.String |
getURL()
Returns the database URL for this connection. |
java.lang.String |
getUserName()
Returns the user name as passed to DriverManager.getConnection(url, user, password). |
java.sql.ResultSet |
getVersionColumns(java.lang.String catalog,
java.lang.String schema,
java.lang.String tableName)
Get the list of columns that are update when any value is updated. |
boolean |
insertsAreDetected(int type)
Returns whether inserts are detected. |
boolean |
isCatalogAtStart()
Returns whether the catalog is at the beginning. |
boolean |
isReadOnly()
Returns the same as Connection.isReadOnly(). |
boolean |
locatorsUpdateCopy()
Does the database make a copy before updating. |
boolean |
nullPlusNonNullIsNull()
Returns whether NULL+1 is NULL or not. |
boolean |
nullsAreSortedAtEnd()
Checks if NULL is sorted at the end (no matter if ASC or DESC is used). |
boolean |
nullsAreSortedAtStart()
Checks if NULL is sorted at the beginning (no matter if ASC or DESC is used). |
boolean |
nullsAreSortedHigh()
Checks if NULL is sorted high (bigger than anything that is not null). |
boolean |
nullsAreSortedLow()
Checks if NULL is sorted low (smaller than anything that is not null). |
boolean |
othersDeletesAreVisible(int type)
Returns whether other deletes are visible. |
boolean |
othersInsertsAreVisible(int type)
Returns whether other inserts are visible. |
boolean |
othersUpdatesAreVisible(int type)
Returns whether other updates are visible. |
boolean |
ownDeletesAreVisible(int type)
Returns whether own deletes are visible. |
boolean |
ownInsertsAreVisible(int type)
Returns whether own inserts are visible. |
boolean |
ownUpdatesAreVisible(int type)
Returns whether own updates are visible. |
boolean |
storesLowerCaseIdentifiers()
Checks if for CREATE TABLE Test(ID INT), getTables returns test as the table name. |
boolean |
storesLowerCaseQuotedIdentifiers()
Checks if for CREATE TABLE "Test"(ID INT), getTables returns test as the table name. |
boolean |
storesMixedCaseIdentifiers()
Checks if for CREATE TABLE Test(ID INT), getTables returns Test as the table name. |
boolean |
storesMixedCaseQuotedIdentifiers()
Checks if for CREATE TABLE "Test"(ID INT), getTables returns Test as the table name. |
boolean |
storesUpperCaseIdentifiers()
Checks if for CREATE TABLE Test(ID INT), getTables returns TEST as the table name. |
boolean |
storesUpperCaseQuotedIdentifiers()
Checks if for CREATE TABLE "Test"(ID INT), getTables returns TEST as the table name. |
boolean |
supportsAlterTableWithAddColumn()
Returns whether alter table with add column is supported. |
boolean |
supportsAlterTableWithDropColumn()
Returns whether alter table with drop column is supported. |
boolean |
supportsANSI92EntryLevelSQL()
Returns whether SQL-92 entry level grammar is supported. |
boolean |
supportsANSI92FullSQL()
Returns whether SQL-92 full level grammar is supported. |
boolean |
supportsANSI92IntermediateSQL()
Returns whether SQL-92 intermediate level grammar is supported. |
boolean |
supportsBatchUpdates()
Returns whether batch updates are supported. |
boolean |
supportsCatalogsInDataManipulation()
Returns whether the catalog name in INSERT, UPDATE, DELETE is supported. |
boolean |
supportsCatalogsInIndexDefinitions()
Returns whether the catalog name in CREATE INDEX is supported. |
boolean |
supportsCatalogsInPrivilegeDefinitions()
Returns whether the catalog name in GRANT is supported. |
boolean |
supportsCatalogsInProcedureCalls()
Returns whether the catalog name in procedure calls is supported. |
boolean |
supportsCatalogsInTableDefinitions()
Returns whether the catalog name in CREATE TABLE is supported. |
boolean |
supportsColumnAliasing()
Returns whether column aliasing is supported. |
boolean |
supportsConvert()
Returns whether CONVERT is supported. |
boolean |
supportsConvert(int fromType,
int toType)
Returns whether CONVERT is supported for one datatype to another. |
boolean |
supportsCoreSQLGrammar()
Returns whether ODBC Core SQL grammar is supported. |
boolean |
supportsCorrelatedSubqueries()
Returns whether correlated subqueries are supported. |
boolean |
supportsDataDefinitionAndDataManipulationTransactions()
Returns whether data manipulation and CREATE/DROP is supported in transactions. |
boolean |
supportsDataManipulationTransactionsOnly()
Returns whether only data manipulations are supported in transactions. |
boolean |
supportsDifferentTableCorrelationNames()
Returns whether table correlation names (table alias) are restricted to be different than table names. |
boolean |
supportsExpressionsInOrderBy()
Returns whether expression in ORDER BY are supported. |
boolean |
supportsExtendedSQLGrammar()
Returns whether ODBC Extended SQL grammar is supported. |
boolean |
supportsFullOuterJoins()
Returns whether full outer joins are supported. |
boolean |
supportsGetGeneratedKeys()
Does the database support getGeneratedKeys. |
boolean |
supportsGroupBy()
Returns whether GROUP BY is supported. |
boolean |
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. |
boolean |
supportsGroupByUnrelated()
Returns whether GROUP BY is supported if the column is not in the SELECT list. |
boolean |
supportsIntegrityEnhancementFacility()
Returns whether referential integrity is supported. |
boolean |
supportsLikeEscapeClause()
Returns whether LIKE... |
boolean |
supportsLimitedOuterJoins()
Returns whether limited outer joins are supported. |
boolean |
supportsMinimumSQLGrammar()
Returns whether ODBC Minimum SQL grammar is supported. |
boolean |
supportsMixedCaseIdentifiers()
Checks if for CREATE TABLE Test(ID INT), getTables returns Test as the table name. |
boolean |
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). |
boolean |
supportsMultipleOpenResults()
Does the database support multiple open result sets. |
boolean |
supportsMultipleResultSets()
Returns whether multiple result sets are supported. |
boolean |
supportsMultipleTransactions()
Returns whether multiple transactions (on different connections) are supported. |
boolean |
supportsNamedParameters()
Does the database support named parameters. |
boolean |
supportsNonNullableColumns()
Returns whether columns with NOT NULL are supported. |
boolean |
supportsOpenCursorsAcrossCommit()
Returns whether open result sets across commits are supported. |
boolean |
supportsOpenCursorsAcrossRollback()
Returns whether open result sets across rollback are supported. |
boolean |
supportsOpenStatementsAcrossCommit()
Returns whether open statements across commit are supported. |
boolean |
supportsOpenStatementsAcrossRollback()
Returns whether open statements across rollback are supported. |
boolean |
supportsOrderByUnrelated()
Returns whether ORDER BY is supported if the column is not in the SELECT list. |
boolean |
supportsOuterJoins()
Returns whether outer joins are supported. |
boolean |
supportsPositionedDelete()
Returns whether positioned deletes are supported. |
boolean |
supportsPositionedUpdate()
Returns whether positioned updates are supported. |
boolean |
supportsResultSetConcurrency(int type,
int concurrency)
Returns whether a specific result set concurrency is supported. |
boolean |
supportsResultSetHoldability(int holdability)
Does this database supports a result set holdability. |
boolean |
supportsResultSetType(int type)
Returns whether a specific result set type is supported. |
boolean |
supportsSavepoints()
Does the database support savepoints. |
boolean |
supportsSchemasInDataManipulation()
Returns whether the schema name in INSERT, UPDATE, DELETE is supported. |
boolean |
supportsSchemasInIndexDefinitions()
Returns whether the schema name in CREATE INDEX is supported. |
boolean |
supportsSchemasInPrivilegeDefinitions()
Returns whether the schema name in GRANT is supported. |
boolean |
supportsSchemasInProcedureCalls()
Returns whether the schema name in procedure calls is supported. |
boolean |
supportsSchemasInTableDefinitions()
Returns whether the schema name in CREATE TABLE is supported. |
boolean |
supportsSelectForUpdate()
Returns whether SELECT ... |
boolean |
supportsStatementPooling()
Does the database support statement pooling. |
boolean |
supportsStoredFunctionsUsingCallSyntax()
Returns whether the database supports calling functions using the call syntax. |
boolean |
supportsStoredProcedures()
Returns whether stored procedures are supported. |
boolean |
supportsSubqueriesInComparisons()
Returns whether subqueries (SELECT) in comparisons are supported. |
boolean |
supportsSubqueriesInExists()
Returns whether SELECT in EXISTS is supported. |
boolean |
supportsSubqueriesInIns()
Returns whether IN(SELECT...) is supported. |
boolean |
supportsSubqueriesInQuantifieds()
Returns whether subqueries in quantified expression are supported. |
boolean |
supportsTableCorrelationNames()
Returns whether table correlation names (table alias) are supported. |
boolean |
supportsTransactionIsolationLevel(int level)
Returns whether a specific transaction isolation level is supported. |
boolean |
supportsTransactions()
Returns whether transactions are supported. |
boolean |
supportsUnion()
Returns whether UNION SELECT is supported. |
boolean |
supportsUnionAll()
Returns whether UNION ALL SELECT is supported. |
java.lang.String |
toString()
INTERNAL |
boolean |
updatesAreDetected(int type)
Returns whether updates are detected. |
boolean |
usesLocalFilePerTable()
Checks if this database use one file per table. |
boolean |
usesLocalFiles()
Checks if this database store data in local files. |
| Methods inherited from class org.h2.message.TraceObject |
|---|
debugCode, debugCodeAssign, debugCodeCall, debugCodeCall, debugCodeCall, getNextId, getTrace, getTraceId, getTraceObjectName, isDebugEnabled, isInfoEnabled, logAndConvert, quote, quoteArray, quoteBigDecimal, quoteBytes, quoteDate, quoteIntArray, quoteMap, quoteTime, quoteTimestamp, setTrace, unsupported |
| Methods inherited from class java.lang.Object |
|---|
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait |
| Method Detail |
|---|
public int getDriverMajorVersion()
getDriverMajorVersion in interface java.sql.DatabaseMetaDatapublic int getDriverMinorVersion()
getDriverMinorVersion in interface java.sql.DatabaseMetaDatapublic java.lang.String getDatabaseProductName()
getDatabaseProductName in interface java.sql.DatabaseMetaDatapublic java.lang.String getDatabaseProductVersion()
getDatabaseProductVersion in interface java.sql.DatabaseMetaDatapublic java.lang.String getDriverName()
getDriverName in interface java.sql.DatabaseMetaDatapublic java.lang.String getDriverVersion()
getDriverVersion in interface java.sql.DatabaseMetaData
public java.sql.ResultSet getTables(java.lang.String catalogPattern,
java.lang.String schemaPattern,
java.lang.String tableNamePattern,
java.lang.String[] types)
throws java.sql.SQLException
getTables in interface java.sql.DatabaseMetaDatacatalogPattern - null (to get all objects) or the catalog nameschemaPattern - null (to get all objects) or a schema name
(uppercase for unquoted names)tableNamePattern - null (to get all objects) or a table name
(uppercase for unquoted names)types - null or a list of table types
java.sql.SQLException - if the connection is closed
public java.sql.ResultSet getColumns(java.lang.String catalogPattern,
java.lang.String schemaPattern,
java.lang.String tableNamePattern,
java.lang.String columnNamePattern)
throws java.sql.SQLException
getColumns in interface java.sql.DatabaseMetaDatacatalogPattern - null (to get all objects) or the catalog nameschemaPattern - null (to get all objects) or a schema name
(uppercase for unquoted names)tableNamePattern - null (to get all objects) or a table name
(uppercase for unquoted names)columnNamePattern - null (to get all objects) or a column name
(uppercase for unquoted names)
java.sql.SQLException - if the connection is closed
public java.sql.ResultSet getIndexInfo(java.lang.String catalogPattern,
java.lang.String schemaPattern,
java.lang.String tableName,
boolean unique,
boolean approximate)
throws java.sql.SQLException
getIndexInfo in interface java.sql.DatabaseMetaDatacatalogPattern - null or the catalog nameschemaPattern - null (to get all objects) or a schema name
(uppercase for unquoted names)tableName - table name (must be specified)unique - only unique indexesapproximate - is ignored
java.sql.SQLException - if the connection is closed
public java.sql.ResultSet getPrimaryKeys(java.lang.String catalogPattern,
java.lang.String schemaPattern,
java.lang.String tableName)
throws java.sql.SQLException
getPrimaryKeys in interface java.sql.DatabaseMetaDatacatalogPattern - null or the catalog nameschemaPattern - null (to get all objects) or a schema name
(uppercase for unquoted names)tableName - table name (must be specified)
java.sql.SQLException - if the connection is closedpublic boolean allProceduresAreCallable()
allProceduresAreCallable in interface java.sql.DatabaseMetaDatapublic boolean allTablesAreSelectable()
allTablesAreSelectable in interface java.sql.DatabaseMetaData
public java.lang.String getURL()
throws java.sql.SQLException
getURL in interface java.sql.DatabaseMetaDatajava.sql.SQLException
public java.lang.String getUserName()
throws java.sql.SQLException
getUserName in interface java.sql.DatabaseMetaDatajava.sql.SQLException
public boolean isReadOnly()
throws java.sql.SQLException
isReadOnly in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean nullsAreSortedHigh()
nullsAreSortedHigh in interface java.sql.DatabaseMetaDatapublic boolean nullsAreSortedLow()
nullsAreSortedLow in interface java.sql.DatabaseMetaDatapublic boolean nullsAreSortedAtStart()
nullsAreSortedAtStart in interface java.sql.DatabaseMetaDatapublic boolean nullsAreSortedAtEnd()
nullsAreSortedAtEnd in interface java.sql.DatabaseMetaDatapublic java.sql.Connection getConnection()
getConnection in interface java.sql.DatabaseMetaData
public java.sql.ResultSet getProcedures(java.lang.String catalogPattern,
java.lang.String schemaPattern,
java.lang.String procedureNamePattern)
throws java.sql.SQLException
getProcedures in interface java.sql.DatabaseMetaDatacatalogPattern - null or the catalog nameschemaPattern - null (to get all objects) or a schema name
(uppercase for unquoted names)procedureNamePattern - the procedure name pattern
java.sql.SQLException - if the connection is closed
public java.sql.ResultSet getProcedureColumns(java.lang.String catalogPattern,
java.lang.String schemaPattern,
java.lang.String procedureNamePattern,
java.lang.String columnNamePattern)
throws java.sql.SQLException
getProcedureColumns in interface java.sql.DatabaseMetaDatacatalogPattern - null or the catalog nameschemaPattern - null (to get all objects) or a schema name
(uppercase for unquoted names)procedureNamePattern - the procedure name patterncolumnNamePattern - the procedure name pattern
java.sql.SQLException - if the connection is closed
public java.sql.ResultSet getSchemas()
throws java.sql.SQLException
getSchemas in interface java.sql.DatabaseMetaDatajava.sql.SQLException - if the connection is closed
public java.sql.ResultSet getCatalogs()
throws java.sql.SQLException
getCatalogs in interface java.sql.DatabaseMetaDatajava.sql.SQLException - if the connection is closed
public java.sql.ResultSet getTableTypes()
throws java.sql.SQLException
getTableTypes in interface java.sql.DatabaseMetaDatajava.sql.SQLException - if the connection is closed
public java.sql.ResultSet getColumnPrivileges(java.lang.String catalogPattern,
java.lang.String schemaPattern,
java.lang.String table,
java.lang.String columnNamePattern)
throws java.sql.SQLException
getColumnPrivileges in interface java.sql.DatabaseMetaDatacatalogPattern - null (to get all objects) or the catalog nameschemaPattern - null (to get all objects) or a schema name (uppercase for
unquoted names)table - a table name (uppercase for unquoted names)columnNamePattern - null (to get all objects) or a column name
(uppercase for unquoted names)
java.sql.SQLException - if the connection is closed
public java.sql.ResultSet getTablePrivileges(java.lang.String catalogPattern,
java.lang.String schemaPattern,
java.lang.String tableNamePattern)
throws java.sql.SQLException
getTablePrivileges in interface java.sql.DatabaseMetaDatacatalogPattern - null (to get all objects) or the catalog nameschemaPattern - null (to get all objects) or a schema name
(uppercase for unquoted names)tableNamePattern - null (to get all objects) or a table name
(uppercase for unquoted names)
java.sql.SQLException - if the connection is closed
public java.sql.ResultSet getBestRowIdentifier(java.lang.String catalogPattern,
java.lang.String schemaPattern,
java.lang.String tableName,
int scope,
boolean nullable)
throws java.sql.SQLException
getBestRowIdentifier in interface java.sql.DatabaseMetaDatacatalogPattern - null (to get all objects) or the catalog nameschemaPattern - null (to get all objects) or a schema name
(uppercase for unquoted names)tableName - table name (must be specified)scope - ignorednullable - ignored
java.sql.SQLException - if the connection is closed
public java.sql.ResultSet getVersionColumns(java.lang.String catalog,
java.lang.String schema,
java.lang.String tableName)
throws java.sql.SQLException
getVersionColumns in interface java.sql.DatabaseMetaDatacatalog - null (to get all objects) or the catalog nameschema - null (to get all objects) or a schema nametableName - table name (must be specified)
java.sql.SQLException - if the connection is closed
public java.sql.ResultSet getImportedKeys(java.lang.String catalogPattern,
java.lang.String schemaPattern,
java.lang.String tableName)
throws java.sql.SQLException
getImportedKeys in interface java.sql.DatabaseMetaDatacatalogPattern - null (to get all objects) or the catalog nameschemaPattern - the schema name of the foreign tabletableName - the name of the foreign table
java.sql.SQLException - if the connection is closed
public java.sql.ResultSet getExportedKeys(java.lang.String catalogPattern,
java.lang.String schemaPattern,
java.lang.String tableName)
throws java.sql.SQLException
getExportedKeys in interface java.sql.DatabaseMetaDatacatalogPattern - null or the catalog nameschemaPattern - the schema name of the primary tabletableName - the name of the primary table
java.sql.SQLException - if the connection is closed
public java.sql.ResultSet getCrossReference(java.lang.String primaryCatalogPattern,
java.lang.String primarySchemaPattern,
java.lang.String primaryTable,
java.lang.String foreignCatalogPattern,
java.lang.String foreignSchemaPattern,
java.lang.String foreignTable)
throws java.sql.SQLException
getCrossReference in interface java.sql.DatabaseMetaDataprimaryCatalogPattern - null or the catalog nameprimarySchemaPattern - the schema name of the primary table
(optional)primaryTable - the name of the primary table (must be specified)foreignCatalogPattern - null or the catalog nameforeignSchemaPattern - the schema name of the foreign table
(optional)foreignTable - the name of the foreign table (must be specified)
java.sql.SQLException - if the connection is closed
public java.sql.ResultSet getUDTs(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern,
int[] types)
throws java.sql.SQLException
getUDTs in interface java.sql.DatabaseMetaDatacatalog - ignoredschemaPattern - ignoredtypeNamePattern - ignoredtypes - ignored
java.sql.SQLException - if the connection is closed
public java.sql.ResultSet getTypeInfo()
throws java.sql.SQLException
getTypeInfo in interface java.sql.DatabaseMetaDatajava.sql.SQLException - if the connection is closedpublic boolean usesLocalFiles()
usesLocalFiles in interface java.sql.DatabaseMetaDatapublic boolean usesLocalFilePerTable()
usesLocalFilePerTable in interface java.sql.DatabaseMetaDatapublic java.lang.String getIdentifierQuoteString()
getIdentifierQuoteString in interface java.sql.DatabaseMetaDatapublic java.lang.String getSQLKeywords()
LIMIT,MINUS,ROWNUM,SYSDATE,SYSTIME,SYSTIMESTAMP,TODAYThe complete list of keywords (including SQL-92 keywords) is:
CROSS, CURRENT_DATE, CURRENT_TIME, CURRENT_TIMESTAMP, DISTINCT, EXCEPT, EXISTS, FALSE, FOR, FROM, FULL, GROUP, HAVING, INNER, INTERSECT, IS, JOIN, LIKE, LIMIT, MINUS, NATURAL, NOT, NULL, ON, ORDER, PRIMARY, ROWNUM, SELECT, SYSDATE, SYSTIME, SYSTIMESTAMP, TODAY, TRUE, UNION, UNIQUE, WHERE
getSQLKeywords in interface java.sql.DatabaseMetaData
public java.lang.String getNumericFunctions()
throws java.sql.SQLException
getNumericFunctions in interface java.sql.DatabaseMetaDatajava.sql.SQLException
public java.lang.String getStringFunctions()
throws java.sql.SQLException
getStringFunctions in interface java.sql.DatabaseMetaDatajava.sql.SQLException
public java.lang.String getSystemFunctions()
throws java.sql.SQLException
getSystemFunctions in interface java.sql.DatabaseMetaDatajava.sql.SQLException
public java.lang.String getTimeDateFunctions()
throws java.sql.SQLException
getTimeDateFunctions in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic java.lang.String getSearchStringEscape()
getSearchStringEscape in interface java.sql.DatabaseMetaDatapublic java.lang.String getExtraNameCharacters()
getExtraNameCharacters in interface java.sql.DatabaseMetaDatapublic boolean supportsAlterTableWithAddColumn()
supportsAlterTableWithAddColumn in interface java.sql.DatabaseMetaDatapublic boolean supportsAlterTableWithDropColumn()
supportsAlterTableWithDropColumn in interface java.sql.DatabaseMetaDatapublic boolean supportsColumnAliasing()
supportsColumnAliasing in interface java.sql.DatabaseMetaDatapublic boolean nullPlusNonNullIsNull()
nullPlusNonNullIsNull in interface java.sql.DatabaseMetaDatapublic boolean supportsConvert()
supportsConvert in interface java.sql.DatabaseMetaData
public boolean supportsConvert(int fromType,
int toType)
supportsConvert in interface java.sql.DatabaseMetaDatafromType - the source SQL typetoType - the target SQL type
public boolean supportsTableCorrelationNames()
supportsTableCorrelationNames in interface java.sql.DatabaseMetaDatapublic boolean supportsDifferentTableCorrelationNames()
supportsDifferentTableCorrelationNames in interface java.sql.DatabaseMetaDatapublic boolean supportsExpressionsInOrderBy()
supportsExpressionsInOrderBy in interface java.sql.DatabaseMetaDatapublic boolean supportsOrderByUnrelated()
supportsOrderByUnrelated in interface java.sql.DatabaseMetaDatapublic boolean supportsGroupBy()
supportsGroupBy in interface java.sql.DatabaseMetaDatapublic boolean supportsGroupByUnrelated()
supportsGroupByUnrelated in interface java.sql.DatabaseMetaDatapublic boolean supportsGroupByBeyondSelect()
supportsGroupByBeyondSelect in interface java.sql.DatabaseMetaDatapublic boolean supportsLikeEscapeClause()
supportsLikeEscapeClause in interface java.sql.DatabaseMetaDatapublic boolean supportsMultipleResultSets()
supportsMultipleResultSets in interface java.sql.DatabaseMetaDatapublic boolean supportsMultipleTransactions()
supportsMultipleTransactions in interface java.sql.DatabaseMetaDatapublic boolean supportsNonNullableColumns()
supportsNonNullableColumns in interface java.sql.DatabaseMetaDatapublic boolean supportsMinimumSQLGrammar()
supportsMinimumSQLGrammar in interface java.sql.DatabaseMetaDatapublic boolean supportsCoreSQLGrammar()
supportsCoreSQLGrammar in interface java.sql.DatabaseMetaDatapublic boolean supportsExtendedSQLGrammar()
supportsExtendedSQLGrammar in interface java.sql.DatabaseMetaDatapublic boolean supportsANSI92EntryLevelSQL()
supportsANSI92EntryLevelSQL in interface java.sql.DatabaseMetaDatapublic boolean supportsANSI92IntermediateSQL()
supportsANSI92IntermediateSQL in interface java.sql.DatabaseMetaDatapublic boolean supportsANSI92FullSQL()
supportsANSI92FullSQL in interface java.sql.DatabaseMetaDatapublic boolean supportsIntegrityEnhancementFacility()
supportsIntegrityEnhancementFacility in interface java.sql.DatabaseMetaDatapublic boolean supportsOuterJoins()
supportsOuterJoins in interface java.sql.DatabaseMetaDatapublic boolean supportsFullOuterJoins()
supportsFullOuterJoins in interface java.sql.DatabaseMetaDatapublic boolean supportsLimitedOuterJoins()
supportsLimitedOuterJoins in interface java.sql.DatabaseMetaDatapublic java.lang.String getSchemaTerm()
getSchemaTerm in interface java.sql.DatabaseMetaDatapublic java.lang.String getProcedureTerm()
getProcedureTerm in interface java.sql.DatabaseMetaDatapublic java.lang.String getCatalogTerm()
getCatalogTerm in interface java.sql.DatabaseMetaDatapublic boolean isCatalogAtStart()
isCatalogAtStart in interface java.sql.DatabaseMetaDatapublic java.lang.String getCatalogSeparator()
getCatalogSeparator in interface java.sql.DatabaseMetaDatapublic boolean supportsSchemasInDataManipulation()
supportsSchemasInDataManipulation in interface java.sql.DatabaseMetaDatapublic boolean supportsSchemasInProcedureCalls()
supportsSchemasInProcedureCalls in interface java.sql.DatabaseMetaDatapublic boolean supportsSchemasInTableDefinitions()
supportsSchemasInTableDefinitions in interface java.sql.DatabaseMetaDatapublic boolean supportsSchemasInIndexDefinitions()
supportsSchemasInIndexDefinitions in interface java.sql.DatabaseMetaDatapublic boolean supportsSchemasInPrivilegeDefinitions()
supportsSchemasInPrivilegeDefinitions in interface java.sql.DatabaseMetaDatapublic boolean supportsCatalogsInDataManipulation()
supportsCatalogsInDataManipulation in interface java.sql.DatabaseMetaDatapublic boolean supportsCatalogsInProcedureCalls()
supportsCatalogsInProcedureCalls in interface java.sql.DatabaseMetaDatapublic boolean supportsCatalogsInTableDefinitions()
supportsCatalogsInTableDefinitions in interface java.sql.DatabaseMetaDatapublic boolean supportsCatalogsInIndexDefinitions()
supportsCatalogsInIndexDefinitions in interface java.sql.DatabaseMetaDatapublic boolean supportsCatalogsInPrivilegeDefinitions()
supportsCatalogsInPrivilegeDefinitions in interface java.sql.DatabaseMetaDatapublic boolean supportsPositionedDelete()
supportsPositionedDelete in interface java.sql.DatabaseMetaDatapublic boolean supportsPositionedUpdate()
supportsPositionedUpdate in interface java.sql.DatabaseMetaDatapublic boolean supportsSelectForUpdate()
supportsSelectForUpdate in interface java.sql.DatabaseMetaDatapublic boolean supportsStoredProcedures()
supportsStoredProcedures in interface java.sql.DatabaseMetaDatapublic boolean supportsSubqueriesInComparisons()
supportsSubqueriesInComparisons in interface java.sql.DatabaseMetaDatapublic boolean supportsSubqueriesInExists()
supportsSubqueriesInExists in interface java.sql.DatabaseMetaDatapublic boolean supportsSubqueriesInIns()
supportsSubqueriesInIns in interface java.sql.DatabaseMetaDatapublic boolean supportsSubqueriesInQuantifieds()
supportsSubqueriesInQuantifieds in interface java.sql.DatabaseMetaDatapublic boolean supportsCorrelatedSubqueries()
supportsCorrelatedSubqueries in interface java.sql.DatabaseMetaDatapublic boolean supportsUnion()
supportsUnion in interface java.sql.DatabaseMetaDatapublic boolean supportsUnionAll()
supportsUnionAll in interface java.sql.DatabaseMetaDatapublic boolean supportsOpenCursorsAcrossCommit()
supportsOpenCursorsAcrossCommit in interface java.sql.DatabaseMetaDatapublic boolean supportsOpenCursorsAcrossRollback()
supportsOpenCursorsAcrossRollback in interface java.sql.DatabaseMetaDatapublic boolean supportsOpenStatementsAcrossCommit()
supportsOpenStatementsAcrossCommit in interface java.sql.DatabaseMetaDatapublic boolean supportsOpenStatementsAcrossRollback()
supportsOpenStatementsAcrossRollback in interface java.sql.DatabaseMetaDatapublic boolean supportsTransactions()
supportsTransactions in interface java.sql.DatabaseMetaDatapublic boolean supportsTransactionIsolationLevel(int level)
supportsTransactionIsolationLevel in interface java.sql.DatabaseMetaDatalevel - the transaction isolation level (Connection.TRANSACTION_*)
public boolean supportsDataDefinitionAndDataManipulationTransactions()
supportsDataDefinitionAndDataManipulationTransactions in interface java.sql.DatabaseMetaDatapublic boolean supportsDataManipulationTransactionsOnly()
supportsDataManipulationTransactionsOnly in interface java.sql.DatabaseMetaDatapublic boolean dataDefinitionCausesTransactionCommit()
dataDefinitionCausesTransactionCommit in interface java.sql.DatabaseMetaDatapublic boolean dataDefinitionIgnoredInTransactions()
dataDefinitionIgnoredInTransactions in interface java.sql.DatabaseMetaDatapublic boolean supportsResultSetType(int type)
supportsResultSetType in interface java.sql.DatabaseMetaDatatype - the result set type
public boolean supportsResultSetConcurrency(int type,
int concurrency)
supportsResultSetConcurrency in interface java.sql.DatabaseMetaDatatype - the result set typeconcurrency - the result set concurrency
public boolean ownUpdatesAreVisible(int type)
ownUpdatesAreVisible in interface java.sql.DatabaseMetaDatatype - the result set type
public boolean ownDeletesAreVisible(int type)
ownDeletesAreVisible in interface java.sql.DatabaseMetaDatatype - the result set type
public boolean ownInsertsAreVisible(int type)
ownInsertsAreVisible in interface java.sql.DatabaseMetaDatatype - the result set type
public boolean othersUpdatesAreVisible(int type)
othersUpdatesAreVisible in interface java.sql.DatabaseMetaDatatype - the result set type
public boolean othersDeletesAreVisible(int type)
othersDeletesAreVisible in interface java.sql.DatabaseMetaDatatype - the result set type
public boolean othersInsertsAreVisible(int type)
othersInsertsAreVisible in interface java.sql.DatabaseMetaDatatype - the result set type
public boolean updatesAreDetected(int type)
updatesAreDetected in interface java.sql.DatabaseMetaDatatype - the result set type
public boolean deletesAreDetected(int type)
deletesAreDetected in interface java.sql.DatabaseMetaDatatype - the result set type
public boolean insertsAreDetected(int type)
insertsAreDetected in interface java.sql.DatabaseMetaDatatype - the result set type
public boolean supportsBatchUpdates()
supportsBatchUpdates in interface java.sql.DatabaseMetaDatapublic boolean doesMaxRowSizeIncludeBlobs()
doesMaxRowSizeIncludeBlobs in interface java.sql.DatabaseMetaDatapublic int getDefaultTransactionIsolation()
getDefaultTransactionIsolation in interface java.sql.DatabaseMetaDatapublic boolean supportsMixedCaseIdentifiers()
supportsMixedCaseIdentifiers in interface java.sql.DatabaseMetaDatapublic boolean supportsMixedCaseQuotedIdentifiers()
supportsMixedCaseQuotedIdentifiers in interface java.sql.DatabaseMetaDatapublic boolean storesUpperCaseIdentifiers()
storesUpperCaseIdentifiers in interface java.sql.DatabaseMetaDatapublic boolean storesLowerCaseIdentifiers()
storesLowerCaseIdentifiers in interface java.sql.DatabaseMetaDatapublic boolean storesMixedCaseIdentifiers()
storesMixedCaseIdentifiers in interface java.sql.DatabaseMetaDatapublic boolean storesUpperCaseQuotedIdentifiers()
storesUpperCaseQuotedIdentifiers in interface java.sql.DatabaseMetaDatapublic boolean storesLowerCaseQuotedIdentifiers()
storesLowerCaseQuotedIdentifiers in interface java.sql.DatabaseMetaDatapublic boolean storesMixedCaseQuotedIdentifiers()
storesMixedCaseQuotedIdentifiers in interface java.sql.DatabaseMetaDatapublic int getMaxBinaryLiteralLength()
getMaxBinaryLiteralLength in interface java.sql.DatabaseMetaDatapublic int getMaxCharLiteralLength()
getMaxCharLiteralLength in interface java.sql.DatabaseMetaDatapublic int getMaxColumnNameLength()
getMaxColumnNameLength in interface java.sql.DatabaseMetaDatapublic int getMaxColumnsInGroupBy()
getMaxColumnsInGroupBy in interface java.sql.DatabaseMetaDatapublic int getMaxColumnsInIndex()
getMaxColumnsInIndex in interface java.sql.DatabaseMetaDatapublic int getMaxColumnsInOrderBy()
getMaxColumnsInOrderBy in interface java.sql.DatabaseMetaDatapublic int getMaxColumnsInSelect()
getMaxColumnsInSelect in interface java.sql.DatabaseMetaDatapublic int getMaxColumnsInTable()
getMaxColumnsInTable in interface java.sql.DatabaseMetaDatapublic int getMaxConnections()
getMaxConnections in interface java.sql.DatabaseMetaDatapublic int getMaxCursorNameLength()
getMaxCursorNameLength in interface java.sql.DatabaseMetaDatapublic int getMaxIndexLength()
getMaxIndexLength in interface java.sql.DatabaseMetaDatapublic int getMaxSchemaNameLength()
getMaxSchemaNameLength in interface java.sql.DatabaseMetaDatapublic int getMaxProcedureNameLength()
getMaxProcedureNameLength in interface java.sql.DatabaseMetaDatapublic int getMaxCatalogNameLength()
getMaxCatalogNameLength in interface java.sql.DatabaseMetaDatapublic int getMaxRowSize()
getMaxRowSize in interface java.sql.DatabaseMetaDatapublic int getMaxStatementLength()
getMaxStatementLength in interface java.sql.DatabaseMetaDatapublic int getMaxStatements()
getMaxStatements in interface java.sql.DatabaseMetaDatapublic int getMaxTableNameLength()
getMaxTableNameLength in interface java.sql.DatabaseMetaDatapublic int getMaxTablesInSelect()
getMaxTablesInSelect in interface java.sql.DatabaseMetaDatapublic int getMaxUserNameLength()
getMaxUserNameLength in interface java.sql.DatabaseMetaDatapublic boolean supportsSavepoints()
supportsSavepoints in interface java.sql.DatabaseMetaDatapublic boolean supportsNamedParameters()
supportsNamedParameters in interface java.sql.DatabaseMetaDatapublic boolean supportsMultipleOpenResults()
supportsMultipleOpenResults in interface java.sql.DatabaseMetaDatapublic boolean supportsGetGeneratedKeys()
supportsGetGeneratedKeys in interface java.sql.DatabaseMetaData
public java.sql.ResultSet getSuperTypes(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern)
throws java.sql.SQLException
getSuperTypes in interface java.sql.DatabaseMetaDatajava.sql.SQLException
public java.sql.ResultSet getSuperTables(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String tableNamePattern)
throws java.sql.SQLException
getSuperTables in interface java.sql.DatabaseMetaDatacatalog - null (to get all objects) or the catalog nameschemaPattern - null (to get all objects) or a schema name (uppercase for
unquoted names)tableNamePattern - null (to get all objects) or a table name pattern
(uppercase for unquoted names)
java.sql.SQLException
public java.sql.ResultSet getAttributes(java.lang.String catalog,
java.lang.String schemaPattern,
java.lang.String typeNamePattern,
java.lang.String attributeNamePattern)
throws java.sql.SQLException
getAttributes in interface java.sql.DatabaseMetaDatajava.sql.SQLExceptionpublic boolean supportsResultSetHoldability(int holdability)
supportsResultSetHoldability in interface java.sql.DatabaseMetaDataholdability - ResultSet.HOLD_CURSORS_OVER_COMMIT or
CLOSE_CURSORS_AT_COMMIT
public int getResultSetHoldability()
getResultSetHoldability in interface java.sql.DatabaseMetaDatapublic int getDatabaseMajorVersion()
getDatabaseMajorVersion in interface java.sql.DatabaseMetaDatapublic int getDatabaseMinorVersion()
getDatabaseMinorVersion in interface java.sql.DatabaseMetaDatapublic int getJDBCMajorVersion()
getJDBCMajorVersion in interface java.sql.DatabaseMetaDatapublic int getJDBCMinorVersion()
getJDBCMinorVersion in interface java.sql.DatabaseMetaDatapublic int getSQLStateType()
getSQLStateType in interface java.sql.DatabaseMetaDatapublic boolean locatorsUpdateCopy()
locatorsUpdateCopy in interface java.sql.DatabaseMetaDatapublic boolean supportsStatementPooling()
supportsStatementPooling in interface java.sql.DatabaseMetaDatapublic boolean supportsStoredFunctionsUsingCallSyntax()
public boolean autoCommitFailureClosesAllResultSets()
public java.sql.ResultSet getClientInfoProperties()
throws java.sql.SQLException
java.sql.SQLExceptionpublic java.lang.String toString()
toString in class java.lang.Object
|
||||||||
| PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||
| SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD | |||||||