Package totalcross.sql.sqlite4j
Class SQLite4JDatabaseMetaData
- java.lang.Object
-
- totalcross.sql.sqlite4j.SQLite4JDatabaseMetaData
-
- All Implemented Interfaces:
DatabaseMetaData
public class SQLite4JDatabaseMetaData extends java.lang.Object implements DatabaseMetaData
-
-
Field Summary
-
Fields inherited from interface totalcross.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
-
-
Constructor Summary
Constructors Constructor Description SQLite4JDatabaseMetaData(SQLite4JConnection con, java.sql.DatabaseMetaData metadata)
-
Method Summary
All Methods Instance Methods Concrete Methods Modifier and Type Method Description booleanallProceduresAreCallable()This method tests whether or not all the procedures returned by thegetProceduresmethod can be called by this user.booleanallTablesAreSelectable()This method tests whether or not all the table returned by thegetTablesmethod can be selected by this user.booleandataDefinitionCausesTransactionCommit()This method tests whether or not a DDL statement will cause the current transaction to be automatically committed.booleandataDefinitionIgnoredInTransactions()This method tests whether or not DDL statements are ignored in transactions.booleandeletesAreDetected(int type)This method tests whether or not the specified result set type can detect a visible delete by calling therowUpdatedmethod.booleandoesMaxRowSizeIncludeBlobs()This method tests whether or not the maximum row size includes BLOB'sResultSetgetAttributes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typePattern, java.lang.String attributePattern)ResultSetgetBestRowIdentifier(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.ResultSetgetCatalogs()This method returns the list of database catalogs as aResultSetwith one column - TABLE_CAT - that is the name of the catalog.java.lang.StringgetCatalogSeparator()This method returns the separator between the catalog name and the table name.java.lang.StringgetCatalogTerm()This method returns the vendor's term for "catalog".ResultSetgetColumnPrivileges(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.ResultSetgetColumns(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.ConnectiongetConnection()This method returns theConnectionobject that was used to generate the metadata in this object.ResultSetgetCrossReference(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.intgetDatabaseMajorVersion()This method returns the major version number of the database.intgetDatabaseMinorVersion()This method returns the minor version number of the database.java.lang.StringgetDatabaseProductName()This method returns the name of the database product.java.lang.StringgetDatabaseProductVersion()This method returns the version of the database product.intgetDefaultTransactionIsolation()This method returns the default transaction isolation level of the database.intgetDriverMajorVersion()This method returns the major version number of the JDBC driver.intgetDriverMinorVersion()This method returns the minor version number of the JDBC driver.java.lang.StringgetDriverName()This method returns the name of the JDBC driver.java.lang.StringgetDriverVersion()This method returns the version of the JDBC driver.ResultSetgetExportedKeys(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.StringgetExtraNameCharacters()This methods returns non-standard characters that can appear in unquoted identifiers.java.lang.StringgetIdentifierQuoteString()This metohd returns the quote string for SQL identifiers.ResultSetgetImportedKeys(java.lang.String catalog, java.lang.String schema, java.lang.String tableName)This method returns a list of the table's foreign keys.ResultSetgetIndexInfo(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.intgetJDBCMajorVersion()This method returns the major version number of the JDBC driver.intgetJDBCMinorVersion()This method returns the minor version number of the JDBC driver.intgetMaxBinaryLiteralLength()This method returns the number of hex characters allowed in an inline binary literal.intgetMaxCatalogNameLength()This method returns the maximum length of a catalog name.intgetMaxCharLiteralLength()This method returns the maximum length of a character literal.intgetMaxColumnNameLength()This method returns the maximum length of a column name.intgetMaxColumnsInGroupBy()This method returns the maximum number of columns in a GROUP BY statement.intgetMaxColumnsInIndex()This method returns the maximum number of columns in an index.intgetMaxColumnsInOrderBy()This method returns the maximum number of columns in an ORDER BY statement.intgetMaxColumnsInSelect()This method returns the maximum number of columns in a SELECT statement.intgetMaxColumnsInTable()This method returns the maximum number of columns in a table.intgetMaxConnections()This method returns the maximum number of connections this client can have to the database.intgetMaxCursorNameLength()This method returns the maximum length of a cursor name.intgetMaxIndexLength()This method returns the maximum length of an index.intgetMaxProcedureNameLength()This method returns the maximum length of a procedure name.intgetMaxRowSize()This method returns the maximum size of a row in bytes.intgetMaxSchemaNameLength()This method returns the maximum length of a schema name.intgetMaxStatementLength()This method includes the maximum length of a SQL statement.intgetMaxStatements()This method returns the maximum number of statements that can be active at any time.intgetMaxTableNameLength()This method returns the maximum length of a table name.intgetMaxTablesInSelect()This method returns the maximum number of tables that may be referenced in a SELECT statement.intgetMaxUserNameLength()This method returns the maximum length of a user name.java.lang.StringgetNumericFunctions()This method returns a comma separated list of math functions.ResultSetgetPrimaryKeys(java.lang.String catalog, java.lang.String schema, java.lang.String tableName)This method returns a list of a table's primary key columns.ResultSetgetProcedureColumns(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.ResultSetgetProcedures(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.StringgetProcedureTerm()This method returns the vendor's term for "procedure".intgetResultSetHoldability()This method returns the default holdability type ofResultSetS retrieved from this database.ResultSetgetSchemas()This method returns the list of database schemas as aResultSet, with one column - TABLE_SCHEM - that is the name of the schema.java.lang.StringgetSchemaTerm()This method returns the vendor's term for "schema".java.lang.StringgetSearchStringEscape()This method returns the string used to escape wildcards in search strings.java.lang.StringgetSQLKeywords()This method returns a comma separated list of all the SQL keywords in the database that are not in SQL92.intgetSQLStateType()java.lang.StringgetStringFunctions()This method returns a comma separated list of string functions.ResultSetgetSuperTables(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tablePattern)ResultSetgetSuperTypes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typePattern)java.lang.StringgetSystemFunctions()This method returns a comma separated list of of system functions.ResultSetgetTablePrivileges(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.ResultSetgetTables(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 aResultSetwith the following columns: TABLE_CAT - The catalog the table is in, which may benull. TABLE_SCHEM - The schema the table is in, which may benull. TABLE_NAME - The name of the table. TABLE_TYPE - A string describing the table type.ResultSetgetTableTypes()This method returns the list of database table types as aResultSetwith one column - TABLE_TYPE - that is the name of the table type.java.lang.StringgetTimeDateFunctions()This method returns comma separated list of time/date functions.ResultSetgetTypeInfo()This method returns a list of the SQL types supported by this database.ResultSetgetUDTs(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.StringgetURL()This method returns the URL for this database.java.lang.StringgetUserName()This method returns the database username for this connection.ResultSetgetVersionColumns(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.booleaninsertsAreDetected(int type)This method tests whether or not the specified result set type can detect a visible insert by calling therowUpdatedmethod.booleanisCatalogAtStart()This method tests whether a catalog name appears at the beginning of a fully qualified table name.booleanisReadOnly()This method tests whether or not the database is in read only mode.booleanlocatorsUpdateCopy()booleannullPlusNonNullIsNull()This method tests whether the concatenation of a NULL and non-NULL value results in a NULL.booleannullsAreSortedAtEnd()This method test whether or not NULL's are sorted to the end of the list regardless of ascending or descending sort order.booleannullsAreSortedAtStart()This method tests whether or not NULL's sort as high values.booleannullsAreSortedHigh()This method tests whether or not NULL's sort as high values.booleannullsAreSortedLow()This method tests whether or not NULL's sort as low values.booleanothersDeletesAreVisible(int type)This method tests whether or not the specified result set type sees deletes committed by others.booleanothersInsertsAreVisible(int type)This method tests whether or not the specified result set type sees inserts committed by others.booleanothersUpdatesAreVisible(int type)This method tests whether or not the specified result set type sees updates committed by others.booleanownDeletesAreVisible(int type)This method tests whether or not the specified result set type sees its own deletes.booleanownInsertsAreVisible(int type)This method tests whether or not the specified result set type sees its own inserts.booleanownUpdatesAreVisible(int type)This method tests whether or not the specified result set type sees its own updates.booleanstoresLowerCaseIdentifiers()This method tests whether or not the database treats mixed case identifiers as all lower case.booleanstoresLowerCaseQuotedIdentifiers()This method tests whether or not the database treats mixed case quoted identifiers as all lower case.booleanstoresMixedCaseIdentifiers()This method tests whether or not the database stores mixed case identifers even if it treats them as case insensitive.booleanstoresMixedCaseQuotedIdentifiers()This method tests whether or not the database stores mixed case quoted identifers even if it treats them as case insensitive.booleanstoresUpperCaseIdentifiers()This method tests whether or not the database treats mixed case identifiers as all upper case.booleanstoresUpperCaseQuotedIdentifiers()This method tests whether or not the database treats mixed case quoted identifiers as all upper case.booleansupportsAlterTableWithAddColumn()This method tests whether or not the database supports "ALTER TABLE ADD COLUMN"booleansupportsAlterTableWithDropColumn()This method tests whether or not the database supports "ALTER TABLE DROP COLUMN"booleansupportsANSI92EntryLevelSQL()This method tests whether or not the ANSI92 entry level SQL grammar is supported.booleansupportsANSI92FullSQL()This method tests whether or not the ANSI92 full SQL grammar is supported.booleansupportsANSI92IntermediateSQL()This method tests whether or not the ANSI92 intermediate SQL grammar is supported.booleansupportsBatchUpdates()This method tests whether or not the database supports batch updates.booleansupportsCatalogsInDataManipulation()This method tests whether a catalog name can appear in a data manipulation statement.booleansupportsCatalogsInIndexDefinitions()This method tests whether a catalog name can appear in an index definition.booleansupportsCatalogsInPrivilegeDefinitions()This method tests whether a catalog name can appear in privilege definitions.booleansupportsCatalogsInProcedureCalls()This method tests whether a catalog name can appear in a procedure callbooleansupportsCatalogsInTableDefinitions()This method tests whether a catalog name can appear in a table definition.booleansupportsColumnAliasing()This method tests whether or not column aliasing is supported.booleansupportsConvert()Tests whether or not CONVERT is supported.booleansupportsConvert(int fromType, int toType)This method tests whether or not CONVERT can be performed between the specified types.booleansupportsCoreSQLGrammar()This method tests whether or not the core grammer for ODBC is supported.booleansupportsCorrelatedSubqueries()This method test whether or not correlated subqueries are allowed.booleansupportsDataDefinitionAndDataManipulationTransactions()This method tests whether or not DDL and DML statements allowed within the same transaction.booleansupportsDataManipulationTransactionsOnly()This method tests whether or not only DML statement are allowed inside a transaction.booleansupportsDifferentTableCorrelationNames()This method tests whether correlation names must be different from the name of the table.booleansupportsExpressionsInOrderBy()This method tests whether or not expressions are allowed in an ORDER BY lists.booleansupportsExtendedSQLGrammar()This method tests whether or not the extended grammer for ODBC is supported.booleansupportsFullOuterJoins()This method tests whether or not the database supports full outer joins.booleansupportsGetGeneratedKeys()booleansupportsGroupBy()This method tests whether or not GROUP BY is supported.booleansupportsGroupByBeyondSelect()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.booleansupportsGroupByUnrelated()This method tests whether GROUP BY on a non-selected column is allowed.booleansupportsIntegrityEnhancementFacility()This method tests whether or not the SQL integrity enhancement facility is supported.booleansupportsLikeEscapeClause()This method tests whether or not the escape character is supported in LIKE expressions.booleansupportsLimitedOuterJoins()This method tests whether or not the database supports limited outer joins.booleansupportsMinimumSQLGrammar()This method tests whether or not the minimum grammer for ODBC is supported.booleansupportsMixedCaseIdentifiers()This method tests whether or not the database supports identifiers with mixed case.booleansupportsMixedCaseQuotedIdentifiers()This method tests whether or not the database supports quoted identifiers with mixed case.booleansupportsMultipleOpenResults()This method tests whether the database supports returning multipleResultSetS from aCallableStatementat once.booleansupportsMultipleResultSets()This method tests whether multiple result sets for a single statement are supported.booleansupportsMultipleTransactions()This method test whether or not multiple transactions may be open at once, as long as they are on different connections.booleansupportsNamedParameters()This method tests whether the database supports named parameters.booleansupportsNonNullableColumns()This method tests whether or not columns can be defined as NOT NULL.booleansupportsOpenCursorsAcrossCommit()This method tests whether or not the database supports cursors remaining open across commits.booleansupportsOpenCursorsAcrossRollback()This method tests whether or not the database supports cursors remaining open across rollbacks.booleansupportsOpenStatementsAcrossCommit()This method tests whether or not the database supports statements remaining open across commits.booleansupportsOpenStatementsAcrossRollback()This method tests whether or not the database supports statements remaining open across rollbacks.booleansupportsOrderByUnrelated()This method tests whether or ORDER BY on a non-selected column is allowed.booleansupportsOuterJoins()This method tests whether or not the database supports outer joins.booleansupportsPositionedDelete()This method tests whether or not that database supports positioned deletes.booleansupportsPositionedUpdate()This method tests whether or not that database supports positioned updates.booleansupportsResultSetConcurrency(int type, int concurrency)This method tests whether the specified result set type and result set concurrency type are supported by the database.booleansupportsResultSetHoldability(int holdability)This method tests if the database supports the specified holdability type.booleansupportsResultSetType(int type)This method tests whether or not the datbase supports the specified result type.booleansupportsSavepoints()This method tests whether the databse supports savepoints.booleansupportsSchemasInDataManipulation()This method tests whether a catalog name can appear in a data manipulation statement.booleansupportsSchemasInIndexDefinitions()This method tests whether a catalog name can appear in an index definition.booleansupportsSchemasInPrivilegeDefinitions()This method tests whether a catalog name can appear in privilege definitions.booleansupportsSchemasInProcedureCalls()This method tests whether a catalog name can appear in a procedure callbooleansupportsSchemasInTableDefinitions()This method tests whether a catalog name can appear in a table definition.booleansupportsSelectForUpdate()This method tests whether or not SELECT FOR UPDATE is supported by the database.booleansupportsStatementPooling()booleansupportsStoredProcedures()This method tests whether or not stored procedures are supported on this database.booleansupportsSubqueriesInComparisons()This method tests whether or not subqueries are allowed in comparisons.booleansupportsSubqueriesInExists()This method tests whether or not subqueries are allowed in exists expressions.booleansupportsSubqueriesInIns()This method tests whether subqueries are allowed in IN statements.booleansupportsSubqueriesInQuantifieds()This method tests whether or not subqueries are allowed in quantified expressions.booleansupportsTableCorrelationNames()This method tests whether or not table correlation names are supported.booleansupportsTransactionIsolationLevel(int level)This method tests whether or not the database supports the specified transaction isolation level.booleansupportsTransactions()This method tests whether or not the database supports transactions.booleansupportsUnion()This method tests whether or not the UNION statement is supported.booleansupportsUnionAll()This method tests whether or not the UNION ALL statement is supported.booleanupdatesAreDetected(int type)This method tests whether or not the specified result set type can detect a visible update by calling therowUpdatedmethod.booleanusesLocalFilePerTable()This method tests whether or not the database uses a separate file for each table.booleanusesLocalFiles()This method tests whether or not the database uses local files to store tables.
-
-
-
Constructor Detail
-
SQLite4JDatabaseMetaData
public SQLite4JDatabaseMetaData(SQLite4JConnection con, java.sql.DatabaseMetaData metadata)
-
-
Method Detail
-
allProceduresAreCallable
public boolean allProceduresAreCallable() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not all the procedures returned by thegetProceduresmethod can be called by this user.- Specified by:
allProceduresAreCallablein interfaceDatabaseMetaData- Returns:
trueif all the procedures can be called,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
allTablesAreSelectable
public boolean allTablesAreSelectable() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not all the table returned by thegetTablesmethod can be selected by this user.- Specified by:
allTablesAreSelectablein interfaceDatabaseMetaData- Returns:
trueif all the procedures can be called,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
getURL
public java.lang.String getURL() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the URL for this database.- Specified by:
getURLin interfaceDatabaseMetaData- Returns:
- The URL string for this database, or
nullif it is not known. - Throws:
java.sql.SQLException- If an error occurs.
-
getUserName
public java.lang.String getUserName() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the database username for this connection.- Specified by:
getUserNamein interfaceDatabaseMetaData- Returns:
- The database username.
- Throws:
java.sql.SQLException- If an error occurs.
-
isReadOnly
public boolean isReadOnly() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the database is in read only mode.- Specified by:
isReadOnlyin interfaceDatabaseMetaData- Returns:
trueif the database is in read only mode,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
nullsAreSortedHigh
public boolean nullsAreSortedHigh() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not NULL's sort as high values.- Specified by:
nullsAreSortedHighin interfaceDatabaseMetaData- Returns:
trueif NULL's sort as high values,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
nullsAreSortedLow
public boolean nullsAreSortedLow() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not NULL's sort as low values.- Specified by:
nullsAreSortedLowin interfaceDatabaseMetaData- Returns:
trueif NULL's sort as low values,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
nullsAreSortedAtStart
public boolean nullsAreSortedAtStart() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not NULL's sort as high values.- Specified by:
nullsAreSortedAtStartin interfaceDatabaseMetaData- Returns:
trueif NULL's sort as high values,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
nullsAreSortedAtEnd
public boolean nullsAreSortedAtEnd() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method test whether or not NULL's are sorted to the end of the list regardless of ascending or descending sort order.- Specified by:
nullsAreSortedAtEndin interfaceDatabaseMetaData- Returns:
trueif NULL's always sort to the end,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
getDatabaseProductName
public java.lang.String getDatabaseProductName() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the name of the database product.- Specified by:
getDatabaseProductNamein interfaceDatabaseMetaData- Returns:
- The database product.
- Throws:
java.sql.SQLException- If an error occurs.
-
getDatabaseProductVersion
public java.lang.String getDatabaseProductVersion() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the version of the database product.- Specified by:
getDatabaseProductVersionin interfaceDatabaseMetaData- Returns:
- The version of the database product.
- Throws:
java.sql.SQLException- If an error occurs.
-
getDriverName
public java.lang.String getDriverName() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the name of the JDBC driver.- Specified by:
getDriverNamein interfaceDatabaseMetaData- Returns:
- The name of the JDBC driver.
- Throws:
java.sql.SQLException- If an error occurs.
-
getDriverVersion
public java.lang.String getDriverVersion() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the version of the JDBC driver.- Specified by:
getDriverVersionin interfaceDatabaseMetaData- Returns:
- The version of the JDBC driver.
- Throws:
java.sql.SQLException- If an error occurs.
-
getDriverMajorVersion
public int getDriverMajorVersion()
Description copied from interface:DatabaseMetaDataThis method returns the major version number of the JDBC driver.- Specified by:
getDriverMajorVersionin interfaceDatabaseMetaData- Returns:
- The major version number of the JDBC driver.
-
getDriverMinorVersion
public int getDriverMinorVersion()
Description copied from interface:DatabaseMetaDataThis method returns the minor version number of the JDBC driver.- Specified by:
getDriverMinorVersionin interfaceDatabaseMetaData- Returns:
- The minor version number of the JDBC driver.
-
usesLocalFiles
public boolean usesLocalFiles() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the database uses local files to store tables.- Specified by:
usesLocalFilesin interfaceDatabaseMetaData- Returns:
trueif the database uses local files,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
usesLocalFilePerTable
public boolean usesLocalFilePerTable() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the database uses a separate file for each table.- Specified by:
usesLocalFilePerTablein interfaceDatabaseMetaData- Returns:
trueif the database uses a separate file for each tablefalseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsMixedCaseIdentifiers
public boolean supportsMixedCaseIdentifiers() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the database supports identifiers with mixed case.- Specified by:
supportsMixedCaseIdentifiersin interfaceDatabaseMetaData- Returns:
trueif the database supports mixed case identifiers,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
storesUpperCaseIdentifiers
public boolean storesUpperCaseIdentifiers() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the database treats mixed case identifiers as all upper case.- Specified by:
storesUpperCaseIdentifiersin interfaceDatabaseMetaData- Returns:
trueif the database treats all identifiers as upper case,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
storesLowerCaseIdentifiers
public boolean storesLowerCaseIdentifiers() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the database treats mixed case identifiers as all lower case.- Specified by:
storesLowerCaseIdentifiersin interfaceDatabaseMetaData- Returns:
trueif the database treats all identifiers as lower case,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
storesMixedCaseIdentifiers
public boolean storesMixedCaseIdentifiers() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the database stores mixed case identifers even if it treats them as case insensitive.- Specified by:
storesMixedCaseIdentifiersin interfaceDatabaseMetaData- Returns:
trueif the database stores mixed case identifiers,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsMixedCaseQuotedIdentifiers
public boolean supportsMixedCaseQuotedIdentifiers() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the database supports quoted identifiers with mixed case.- Specified by:
supportsMixedCaseQuotedIdentifiersin interfaceDatabaseMetaData- Returns:
trueif the database supports mixed case quoted identifiers,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
storesUpperCaseQuotedIdentifiers
public boolean storesUpperCaseQuotedIdentifiers() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the database treats mixed case quoted identifiers as all upper case.- Specified by:
storesUpperCaseQuotedIdentifiersin interfaceDatabaseMetaData- Returns:
trueif the database treats all quoted identifiers as upper case,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
storesLowerCaseQuotedIdentifiers
public boolean storesLowerCaseQuotedIdentifiers() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the database treats mixed case quoted identifiers as all lower case.- Specified by:
storesLowerCaseQuotedIdentifiersin interfaceDatabaseMetaData- Returns:
trueif the database treats all quoted identifiers as lower case,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
storesMixedCaseQuotedIdentifiers
public boolean storesMixedCaseQuotedIdentifiers() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the database stores mixed case quoted identifers even if it treats them as case insensitive.- Specified by:
storesMixedCaseQuotedIdentifiersin interfaceDatabaseMetaData- Returns:
trueif the database stores mixed case quoted identifiers,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
getIdentifierQuoteString
public java.lang.String getIdentifierQuoteString() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis metohd returns the quote string for SQL identifiers.- Specified by:
getIdentifierQuoteStringin interfaceDatabaseMetaData- Returns:
- The quote string for SQL identifers, or a space if quoting is not supported.
- Throws:
java.sql.SQLException- If an error occurs.
-
getSQLKeywords
public java.lang.String getSQLKeywords() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns a comma separated list of all the SQL keywords in the database that are not in SQL92.- Specified by:
getSQLKeywordsin interfaceDatabaseMetaData- Returns:
- The list of SQL keywords not in SQL92.
- Throws:
java.sql.SQLException- If an error occurs.
-
getNumericFunctions
public java.lang.String getNumericFunctions() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns a comma separated list of math functions.- Specified by:
getNumericFunctionsin interfaceDatabaseMetaData- Returns:
- The list of math functions.
- Throws:
java.sql.SQLException- If an error occurs.
-
getStringFunctions
public java.lang.String getStringFunctions() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns a comma separated list of string functions.- Specified by:
getStringFunctionsin interfaceDatabaseMetaData- Returns:
- The list of string functions.
- Throws:
java.sql.SQLException- If an error occurs.
-
getSystemFunctions
public java.lang.String getSystemFunctions() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns a comma separated list of of system functions.- Specified by:
getSystemFunctionsin interfaceDatabaseMetaData- Returns:
- A comma separated list of system functions.
- Throws:
java.sql.SQLException- If an error occurs.
-
getTimeDateFunctions
public java.lang.String getTimeDateFunctions() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns comma separated list of time/date functions.- Specified by:
getTimeDateFunctionsin interfaceDatabaseMetaData- Returns:
- The list of time/date functions.
- Throws:
java.sql.SQLException- If an error occurs.
-
getSearchStringEscape
public java.lang.String getSearchStringEscape() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the string used to escape wildcards in search strings.- Specified by:
getSearchStringEscapein interfaceDatabaseMetaData- Returns:
- The string used to escape wildcards in search strings.
- Throws:
java.sql.SQLException- If an error occurs.
-
getExtraNameCharacters
public java.lang.String getExtraNameCharacters() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis methods returns non-standard characters that can appear in unquoted identifiers.- Specified by:
getExtraNameCharactersin interfaceDatabaseMetaData- Returns:
- Non-standard characters that can appear in unquoted identifiers.
- Throws:
java.sql.SQLException- If an error occurs.
-
supportsAlterTableWithAddColumn
public boolean supportsAlterTableWithAddColumn() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the database supports "ALTER TABLE ADD COLUMN"- Specified by:
supportsAlterTableWithAddColumnin interfaceDatabaseMetaData- Returns:
trueif column add supported,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsAlterTableWithDropColumn
public boolean supportsAlterTableWithDropColumn() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the database supports "ALTER TABLE DROP COLUMN"- Specified by:
supportsAlterTableWithDropColumnin interfaceDatabaseMetaData- Returns:
trueif column drop supported,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsColumnAliasing
public boolean supportsColumnAliasing() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not column aliasing is supported.- Specified by:
supportsColumnAliasingin interfaceDatabaseMetaData- Returns:
trueif column aliasing is supported,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
nullPlusNonNullIsNull
public boolean nullPlusNonNullIsNull() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether the concatenation of a NULL and non-NULL value results in a NULL. This will always be true in fully JDBC compliant drivers.- Specified by:
nullPlusNonNullIsNullin interfaceDatabaseMetaData- Returns:
trueif concatenating NULL and a non-NULL value returns a NULL,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsConvert
public boolean supportsConvert() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataTests whether or not CONVERT is supported.- Specified by:
supportsConvertin interfaceDatabaseMetaData- Returns:
trueif CONVERT is supported,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsConvert
public boolean supportsConvert(int fromType, int toType) throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not CONVERT can be performed between the specified types. The types are contants fromTypes.- Specified by:
supportsConvertin interfaceDatabaseMetaData- Parameters:
fromType- The SQL type to convert from.toType- The SQL type to convert to.- Returns:
trueif the conversion can be performed,falseotherwise.- Throws:
java.sql.SQLException- See Also:
Types
-
supportsTableCorrelationNames
public boolean supportsTableCorrelationNames() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not table correlation names are supported. This will be always betruein a fully JDBC compliant driver.- Specified by:
supportsTableCorrelationNamesin interfaceDatabaseMetaData- Returns:
trueif table correlation names are supported,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsDifferentTableCorrelationNames
public boolean supportsDifferentTableCorrelationNames() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether correlation names must be different from the name of the table.- Specified by:
supportsDifferentTableCorrelationNamesin interfaceDatabaseMetaData- Returns:
trueif the correlation name must be different from the table name,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsExpressionsInOrderBy
public boolean supportsExpressionsInOrderBy() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not expressions are allowed in an ORDER BY lists.- Specified by:
supportsExpressionsInOrderByin interfaceDatabaseMetaData- Returns:
trueif expressions are allowed in ORDER BY lists,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsOrderByUnrelated
public boolean supportsOrderByUnrelated() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or ORDER BY on a non-selected column is allowed.- Specified by:
supportsOrderByUnrelatedin interfaceDatabaseMetaData- Returns:
trueif a non-selected column can be used in an ORDER BY,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsGroupBy
public boolean supportsGroupBy() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not GROUP BY is supported.- Specified by:
supportsGroupByin interfaceDatabaseMetaData- Returns:
trueif GROUP BY is supported,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsGroupByUnrelated
public boolean supportsGroupByUnrelated() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether GROUP BY on a non-selected column is allowed.- Specified by:
supportsGroupByUnrelatedin interfaceDatabaseMetaData- Returns:
trueif a non-selected column can be used in a GROUP BY,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsGroupByBeyondSelect
public boolean supportsGroupByBeyondSelect() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not a GROUP BY can add columns not in the select if it includes all the columns in the select.- Specified by:
supportsGroupByBeyondSelectin interfaceDatabaseMetaData- Returns:
trueif GROUP BY an add columns provided it includes all columns in the select,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsLikeEscapeClause
public boolean supportsLikeEscapeClause() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the escape character is supported in LIKE expressions. A fully JDBC compliant driver will always returntrue.- Specified by:
supportsLikeEscapeClausein interfaceDatabaseMetaData- Returns:
trueif escapes are supported in LIKE expressions,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsMultipleResultSets
public boolean supportsMultipleResultSets() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether multiple result sets for a single statement are supported.- Specified by:
supportsMultipleResultSetsin interfaceDatabaseMetaData- Returns:
trueif multiple result sets are supported for a single statement,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsMultipleTransactions
public boolean supportsMultipleTransactions() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method test whether or not multiple transactions may be open at once, as long as they are on different connections.- Specified by:
supportsMultipleTransactionsin interfaceDatabaseMetaData- Returns:
trueif multiple transactions on different connections are supported,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsNonNullableColumns
public boolean supportsNonNullableColumns() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not columns can be defined as NOT NULL. A fully JDBC compliant driver always returnstrue.- Specified by:
supportsNonNullableColumnsin interfaceDatabaseMetaData- Returns:
trueif NOT NULL columns are supported,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsMinimumSQLGrammar
public boolean supportsMinimumSQLGrammar() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the minimum grammer for ODBC is supported. A fully JDBC compliant driver will always returntrue.- Specified by:
supportsMinimumSQLGrammarin interfaceDatabaseMetaData- Returns:
trueif the ODBC minimum grammar is supported,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsCoreSQLGrammar
public boolean supportsCoreSQLGrammar() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the core grammer for ODBC is supported.- Specified by:
supportsCoreSQLGrammarin interfaceDatabaseMetaData- Returns:
trueif the ODBC core grammar is supported,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsExtendedSQLGrammar
public boolean supportsExtendedSQLGrammar() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the extended grammer for ODBC is supported.- Specified by:
supportsExtendedSQLGrammarin interfaceDatabaseMetaData- Returns:
trueif the ODBC extended grammar is supported,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsANSI92EntryLevelSQL
public boolean supportsANSI92EntryLevelSQL() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the ANSI92 entry level SQL grammar is supported. A fully JDBC compliant drivers must returntrue.- Specified by:
supportsANSI92EntryLevelSQLin interfaceDatabaseMetaData- Returns:
trueif the ANSI92 entry level SQL grammar is supported,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsANSI92IntermediateSQL
public boolean supportsANSI92IntermediateSQL() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the ANSI92 intermediate SQL grammar is supported.- Specified by:
supportsANSI92IntermediateSQLin interfaceDatabaseMetaData- Returns:
trueif the ANSI92 intermediate SQL grammar is supported,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsANSI92FullSQL
public boolean supportsANSI92FullSQL() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the ANSI92 full SQL grammar is supported.- Specified by:
supportsANSI92FullSQLin interfaceDatabaseMetaData- Returns:
trueif the ANSI92 full SQL grammar is supported,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsIntegrityEnhancementFacility
public boolean supportsIntegrityEnhancementFacility() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the SQL integrity enhancement facility is supported.- Specified by:
supportsIntegrityEnhancementFacilityin interfaceDatabaseMetaData- Returns:
trueif the integrity enhancement facility is supported,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsOuterJoins
public boolean supportsOuterJoins() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the database supports outer joins.- Specified by:
supportsOuterJoinsin interfaceDatabaseMetaData- Returns:
trueif outer joins are supported,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsFullOuterJoins
public boolean supportsFullOuterJoins() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the database supports full outer joins.- Specified by:
supportsFullOuterJoinsin interfaceDatabaseMetaData- Returns:
trueif full outer joins are supported,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsLimitedOuterJoins
public boolean supportsLimitedOuterJoins() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the database supports limited outer joins.- Specified by:
supportsLimitedOuterJoinsin interfaceDatabaseMetaData- Returns:
trueif limited outer joins are supported,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
getSchemaTerm
public java.lang.String getSchemaTerm() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the vendor's term for "schema".- Specified by:
getSchemaTermin interfaceDatabaseMetaData- Returns:
- The vendor's term for schema.
- Throws:
java.sql.SQLException- if an error occurs.
-
getProcedureTerm
public java.lang.String getProcedureTerm() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the vendor's term for "procedure".- Specified by:
getProcedureTermin interfaceDatabaseMetaData- Returns:
- The vendor's term for procedure.
- Throws:
java.sql.SQLException- if an error occurs.
-
getCatalogTerm
public java.lang.String getCatalogTerm() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the vendor's term for "catalog".- Specified by:
getCatalogTermin interfaceDatabaseMetaData- Returns:
- The vendor's term for catalog.
- Throws:
java.sql.SQLException- if an error occurs.
-
isCatalogAtStart
public boolean isCatalogAtStart() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether a catalog name appears at the beginning of a fully qualified table name.- Specified by:
isCatalogAtStartin interfaceDatabaseMetaData- Returns:
trueif the catalog name appears at the beginning,falseif it appears at the end.- Throws:
java.sql.SQLException- If an error occurs.
-
getCatalogSeparator
public java.lang.String getCatalogSeparator() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the separator between the catalog name and the table name.- Specified by:
getCatalogSeparatorin interfaceDatabaseMetaData- Returns:
- The separator between the catalog name and the table name.
- Throws:
java.sql.SQLException- If an error occurs.
-
supportsSchemasInDataManipulation
public boolean supportsSchemasInDataManipulation() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether a catalog name can appear in a data manipulation statement.- Specified by:
supportsSchemasInDataManipulationin interfaceDatabaseMetaData- Returns:
trueif a catalog name can appear in a data manipulation statement,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsSchemasInProcedureCalls
public boolean supportsSchemasInProcedureCalls() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether a catalog name can appear in a procedure call- Specified by:
supportsSchemasInProcedureCallsin interfaceDatabaseMetaData- Returns:
trueif a catalog name can appear in a procedure call,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsSchemasInTableDefinitions
public boolean supportsSchemasInTableDefinitions() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether a catalog name can appear in a table definition.- Specified by:
supportsSchemasInTableDefinitionsin interfaceDatabaseMetaData- Returns:
trueif a catalog name can appear in a table definition,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsSchemasInIndexDefinitions
public boolean supportsSchemasInIndexDefinitions() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether a catalog name can appear in an index definition.- Specified by:
supportsSchemasInIndexDefinitionsin interfaceDatabaseMetaData- Returns:
trueif a catalog name can appear in an index definition,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsSchemasInPrivilegeDefinitions
public boolean supportsSchemasInPrivilegeDefinitions() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether a catalog name can appear in privilege definitions.- Specified by:
supportsSchemasInPrivilegeDefinitionsin interfaceDatabaseMetaData- Returns:
trueif a catalog name can appear in privilege definition,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsCatalogsInDataManipulation
public boolean supportsCatalogsInDataManipulation() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether a catalog name can appear in a data manipulation statement.- Specified by:
supportsCatalogsInDataManipulationin interfaceDatabaseMetaData- Returns:
trueif a catalog name can appear in a data manipulation statement,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsCatalogsInProcedureCalls
public boolean supportsCatalogsInProcedureCalls() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether a catalog name can appear in a procedure call- Specified by:
supportsCatalogsInProcedureCallsin interfaceDatabaseMetaData- Returns:
trueif a catalog name can appear in a procedure call,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsCatalogsInTableDefinitions
public boolean supportsCatalogsInTableDefinitions() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether a catalog name can appear in a table definition.- Specified by:
supportsCatalogsInTableDefinitionsin interfaceDatabaseMetaData- Returns:
trueif a catalog name can appear in a table definition,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsCatalogsInIndexDefinitions
public boolean supportsCatalogsInIndexDefinitions() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether a catalog name can appear in an index definition.- Specified by:
supportsCatalogsInIndexDefinitionsin interfaceDatabaseMetaData- Returns:
trueif a catalog name can appear in an index definition,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsCatalogsInPrivilegeDefinitions
public boolean supportsCatalogsInPrivilegeDefinitions() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether a catalog name can appear in privilege definitions.- Specified by:
supportsCatalogsInPrivilegeDefinitionsin interfaceDatabaseMetaData- Returns:
trueif a catalog name can appear in privilege definition,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsPositionedDelete
public boolean supportsPositionedDelete() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not that database supports positioned deletes.- Specified by:
supportsPositionedDeletein interfaceDatabaseMetaData- Returns:
trueif positioned deletes are supported,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsPositionedUpdate
public boolean supportsPositionedUpdate() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not that database supports positioned updates.- Specified by:
supportsPositionedUpdatein interfaceDatabaseMetaData- Returns:
trueif positioned updates are supported,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsSelectForUpdate
public boolean supportsSelectForUpdate() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not SELECT FOR UPDATE is supported by the database.- Specified by:
supportsSelectForUpdatein interfaceDatabaseMetaData- Returns:
trueif SELECT FOR UPDATE is supportedfalseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsStoredProcedures
public boolean supportsStoredProcedures() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not stored procedures are supported on this database.- Specified by:
supportsStoredProceduresin interfaceDatabaseMetaData- Returns:
trueif stored procedures are supported,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsSubqueriesInComparisons
public boolean supportsSubqueriesInComparisons() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not subqueries are allowed in comparisons. A fully JDBC compliant driver will always returntrue.- Specified by:
supportsSubqueriesInComparisonsin interfaceDatabaseMetaData- Returns:
trueif subqueries are allowed in comparisons,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsSubqueriesInExists
public boolean supportsSubqueriesInExists() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not subqueries are allowed in exists expressions. A fully JDBC compliant driver will always returntrue.- Specified by:
supportsSubqueriesInExistsin interfaceDatabaseMetaData- Returns:
trueif subqueries are allowed in exists expressions,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsSubqueriesInIns
public boolean supportsSubqueriesInIns() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether subqueries are allowed in IN statements. A fully JDBC compliant driver will always returntrue.- Specified by:
supportsSubqueriesInInsin interfaceDatabaseMetaData- Returns:
trueif the driver supports subqueries in IN statements,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsSubqueriesInQuantifieds
public boolean supportsSubqueriesInQuantifieds() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not subqueries are allowed in quantified expressions. A fully JDBC compliant driver will always returntrue.- Specified by:
supportsSubqueriesInQuantifiedsin interfaceDatabaseMetaData- Returns:
trueif subqueries are allowed in quantified expressions,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsCorrelatedSubqueries
public boolean supportsCorrelatedSubqueries() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method test whether or not correlated subqueries are allowed. A fully JDBC compliant driver will always returntrue.- Specified by:
supportsCorrelatedSubqueriesin interfaceDatabaseMetaData- Returns:
trueif correlated subqueries are allowed,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsUnion
public boolean supportsUnion() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the UNION statement is supported.- Specified by:
supportsUnionin interfaceDatabaseMetaData- Returns:
trueif UNION is supported,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsUnionAll
public boolean supportsUnionAll() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the UNION ALL statement is supported.- Specified by:
supportsUnionAllin interfaceDatabaseMetaData- Returns:
trueif UNION ALL is supported,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsOpenCursorsAcrossCommit
public boolean supportsOpenCursorsAcrossCommit() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the database supports cursors remaining open across commits.- Specified by:
supportsOpenCursorsAcrossCommitin interfaceDatabaseMetaData- Returns:
trueif cursors can remain open across commits,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsOpenCursorsAcrossRollback
public boolean supportsOpenCursorsAcrossRollback() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the database supports cursors remaining open across rollbacks.- Specified by:
supportsOpenCursorsAcrossRollbackin interfaceDatabaseMetaData- Returns:
trueif cursors can remain open across rollbacks,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsOpenStatementsAcrossCommit
public boolean supportsOpenStatementsAcrossCommit() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the database supports statements remaining open across commits.- Specified by:
supportsOpenStatementsAcrossCommitin interfaceDatabaseMetaData- Returns:
trueif statements can remain open across commits,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsOpenStatementsAcrossRollback
public boolean supportsOpenStatementsAcrossRollback() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the database supports statements remaining open across rollbacks.- Specified by:
supportsOpenStatementsAcrossRollbackin interfaceDatabaseMetaData- Returns:
trueif statements can remain open across rollbacks,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
getMaxBinaryLiteralLength
public int getMaxBinaryLiteralLength() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the number of hex characters allowed in an inline binary literal.- Specified by:
getMaxBinaryLiteralLengthin interfaceDatabaseMetaData- Returns:
- The number of hex characters allowed in a binary literal, 0 meaning either an unknown or unlimited number.
- Throws:
java.sql.SQLException- If an error occurs.
-
getMaxCharLiteralLength
public int getMaxCharLiteralLength() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the maximum length of a character literal.- Specified by:
getMaxCharLiteralLengthin interfaceDatabaseMetaData- Returns:
- The maximum length of a character literal.
- Throws:
java.sql.SQLException- If an error occurs.
-
getMaxColumnNameLength
public int getMaxColumnNameLength() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the maximum length of a column name.- Specified by:
getMaxColumnNameLengthin interfaceDatabaseMetaData- Returns:
- The maximum length of a column name.
- Throws:
java.sql.SQLException- If an error occurs.
-
getMaxColumnsInGroupBy
public int getMaxColumnsInGroupBy() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the maximum number of columns in a GROUP BY statement.- Specified by:
getMaxColumnsInGroupByin interfaceDatabaseMetaData- Returns:
- The maximum number of columns in a GROUP BY statement.
- Throws:
java.sql.SQLException- If an error occurs.
-
getMaxColumnsInIndex
public int getMaxColumnsInIndex() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the maximum number of columns in an index.- Specified by:
getMaxColumnsInIndexin interfaceDatabaseMetaData- Returns:
- The maximum number of columns in an index.
- Throws:
java.sql.SQLException- If an error occurs.
-
getMaxColumnsInOrderBy
public int getMaxColumnsInOrderBy() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the maximum number of columns in an ORDER BY statement.- Specified by:
getMaxColumnsInOrderByin interfaceDatabaseMetaData- Returns:
- The maximum number of columns in an ORDER BY statement.
- Throws:
java.sql.SQLException- If an error occurs.
-
getMaxColumnsInSelect
public int getMaxColumnsInSelect() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the maximum number of columns in a SELECT statement.- Specified by:
getMaxColumnsInSelectin interfaceDatabaseMetaData- Returns:
- The maximum number of columns in a SELECT statement.
- Throws:
java.sql.SQLException- If an error occurs.
-
getMaxColumnsInTable
public int getMaxColumnsInTable() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the maximum number of columns in a table.- Specified by:
getMaxColumnsInTablein interfaceDatabaseMetaData- Returns:
- The maximum number of columns in a table.
- Throws:
java.sql.SQLException- If an error occurs.
-
getMaxConnections
public int getMaxConnections() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the maximum number of connections this client can have to the database.- Specified by:
getMaxConnectionsin interfaceDatabaseMetaData- Returns:
- The maximum number of database connections.
- Throws:
java.sql.SQLException
-
getMaxCursorNameLength
public int getMaxCursorNameLength() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the maximum length of a cursor name.- Specified by:
getMaxCursorNameLengthin interfaceDatabaseMetaData- Returns:
- The maximum length of a cursor name.
- Throws:
java.sql.SQLException- If an error occurs.
-
getMaxIndexLength
public int getMaxIndexLength() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the maximum length of an index.- Specified by:
getMaxIndexLengthin interfaceDatabaseMetaData- Returns:
- The maximum length of an index.
- Throws:
java.sql.SQLException- If an error occurs.
-
getMaxSchemaNameLength
public int getMaxSchemaNameLength() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the maximum length of a schema name.- Specified by:
getMaxSchemaNameLengthin interfaceDatabaseMetaData- Returns:
- The maximum length of a schema name.
- Throws:
java.sql.SQLException- If an error occurs.
-
getMaxProcedureNameLength
public int getMaxProcedureNameLength() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the maximum length of a procedure name.- Specified by:
getMaxProcedureNameLengthin interfaceDatabaseMetaData- Returns:
- The maximum length of a procedure name.
- Throws:
java.sql.SQLException- If an error occurs.
-
getMaxCatalogNameLength
public int getMaxCatalogNameLength() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the maximum length of a catalog name.- Specified by:
getMaxCatalogNameLengthin interfaceDatabaseMetaData- Returns:
- The maximum length of a catalog name.
- Throws:
java.sql.SQLException- If an error occurs.
-
getMaxRowSize
public int getMaxRowSize() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the maximum size of a row in bytes.- Specified by:
getMaxRowSizein interfaceDatabaseMetaData- Returns:
- The maximum size of a row.
- Throws:
java.sql.SQLException- If an error occurs.
-
doesMaxRowSizeIncludeBlobs
public boolean doesMaxRowSizeIncludeBlobs() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the maximum row size includes BLOB's- Specified by:
doesMaxRowSizeIncludeBlobsin interfaceDatabaseMetaData- Returns:
trueif the maximum row size includes BLOB's,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
getMaxStatementLength
public int getMaxStatementLength() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method includes the maximum length of a SQL statement.- Specified by:
getMaxStatementLengthin interfaceDatabaseMetaData- Returns:
- The maximum length of a SQL statement.
- Throws:
java.sql.SQLException- If an error occurs.
-
getMaxStatements
public int getMaxStatements() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the maximum number of statements that can be active at any time.- Specified by:
getMaxStatementsin interfaceDatabaseMetaData- Returns:
- The maximum number of statements that can be active at any time.
- Throws:
java.sql.SQLException- If an error occurs.
-
getMaxTableNameLength
public int getMaxTableNameLength() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the maximum length of a table name.- Specified by:
getMaxTableNameLengthin interfaceDatabaseMetaData- Returns:
- The maximum length of a table name.
- Throws:
java.sql.SQLException- If an error occurs.
-
getMaxTablesInSelect
public int getMaxTablesInSelect() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the maximum number of tables that may be referenced in a SELECT statement.- Specified by:
getMaxTablesInSelectin interfaceDatabaseMetaData- Returns:
- The maximum number of tables allowed in a SELECT statement.
- Throws:
java.sql.SQLException- If an error occurs.
-
getMaxUserNameLength
public int getMaxUserNameLength() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the maximum length of a user name.- Specified by:
getMaxUserNameLengthin interfaceDatabaseMetaData- Returns:
- The maximum length of a user name.
- Throws:
java.sql.SQLException- If an error occurs.
-
getDefaultTransactionIsolation
public int getDefaultTransactionIsolation() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the default transaction isolation level of the database.- Specified by:
getDefaultTransactionIsolationin interfaceDatabaseMetaData- Returns:
- The default transaction isolation level of the database.
- Throws:
java.sql.SQLException- If an error occurs.- See Also:
Connection
-
supportsTransactions
public boolean supportsTransactions() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the database supports transactions.- Specified by:
supportsTransactionsin interfaceDatabaseMetaData- Returns:
trueif the database supports transactions,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsTransactionIsolationLevel
public boolean supportsTransactionIsolationLevel(int level) throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the database supports the specified transaction isolation level.- Specified by:
supportsTransactionIsolationLevelin interfaceDatabaseMetaData- Parameters:
level- The transaction isolation level.- Returns:
trueif the specified transaction isolation level is supported,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsDataDefinitionAndDataManipulationTransactions
public boolean supportsDataDefinitionAndDataManipulationTransactions() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not DDL and DML statements allowed within the same transaction.- Specified by:
supportsDataDefinitionAndDataManipulationTransactionsin interfaceDatabaseMetaData- Returns:
trueif DDL and DML statements are allowed in the same transaction,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsDataManipulationTransactionsOnly
public boolean supportsDataManipulationTransactionsOnly() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not only DML statement are allowed inside a transaction.- Specified by:
supportsDataManipulationTransactionsOnlyin interfaceDatabaseMetaData- Returns:
trueif only DML statements are allowed in transactions,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
dataDefinitionCausesTransactionCommit
public boolean dataDefinitionCausesTransactionCommit() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not a DDL statement will cause the current transaction to be automatically committed.- Specified by:
dataDefinitionCausesTransactionCommitin interfaceDatabaseMetaData- Returns:
trueif DDL causes an immediate transaction commit,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
dataDefinitionIgnoredInTransactions
public boolean dataDefinitionIgnoredInTransactions() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not DDL statements are ignored in transactions.- Specified by:
dataDefinitionIgnoredInTransactionsin interfaceDatabaseMetaData- Returns:
trueif DDL statements are ignored in transactions,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
getProcedures
public ResultSet getProcedures(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String procedurePattern) throws java.sql.SQLException
Description copied from interface:DatabaseMetaDataThis method returns a list of all the stored procedures matching the specified pattern in the given schema and catalog. This is returned aResultSetwith the following columns:- PROCEDURE_CAT - The catalog the procedure is in, which may be
null. - PROCEDURE_SCHEM - The schema the procedures is in, which may be
null. - PROCEDURE_NAME - The name of the procedure.
- Unused
- Unused
- Unused
- REMARKS - A description of the procedure
- PROCEDURE_TYPE - Indicates the return type of the procedure, which
is one of the contstants defined in this class
(
procedureResultUnknown,procedureNoResult, orprocedureReturnsResult).
- Specified by:
getProceduresin interfaceDatabaseMetaData- Parameters:
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.- Throws:
java.sql.SQLException- If an error occurs.
- PROCEDURE_CAT - The catalog the procedure is in, which may be
-
getProcedureColumns
public ResultSet getProcedureColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String procedurePattern, java.lang.String columnPattern) throws java.sql.SQLException
Description copied from interface:DatabaseMetaDataThis method returns a list of the parameter and result columns for the requested stored procedures. This is returned in the form of aResultSetwith the following columns:- PROCEDURE_CAT - The catalog the procedure is in, which may be
null. - PROCEDURE_SCHEM - The schema the procedures is in, which may be
null. - PROCEDURE_NAME - The name of the procedure.
- COLUMN_NAME - The name of the column
- COLUMN_TYPE - The type of the column, which will be one of the
contants defined in this class (
procedureColumnUnknown,procedureColumnIn,procedureColumnInOut,procedureColumnOut,procedureColumnReturn, orprocedureColumnResult). - DATA_TYPE - The SQL type of the column. This is one of the constants
defined in
Types. - TYPE_NAME - The string name of the data type for this column.
- PRECISION - The precision of the column.
- LENGTH - The length of the column in bytes
- SCALE - The scale of the column.
- RADIX - The radix of the column.
- NULLABLE - Whether or not the column is NULLABLE. This is one of
the constants defined in this class (
procedureNoNulls,procedureNullable, orprocedureNullableUnknown) - REMARKS - A description of the column.
- Specified by:
getProcedureColumnsin interfaceDatabaseMetaData- Parameters:
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.- Throws:
java.sql.SQLException- If an error occurs.
- PROCEDURE_CAT - The catalog the procedure is in, which may be
-
getTables
public ResultSet getTables(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tablePattern, java.lang.String[] types) throws java.sql.SQLException
Description copied from interface:DatabaseMetaDataThis method returns a list of the requested table as aResultSetwith 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. This will be one
of the values returned by the
getTableTypes()method. - REMARKS - Comments about the table.
- Specified by:
getTablesin interfaceDatabaseMetaData- Parameters:
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.- Throws:
java.sql.SQLException- If an error occurs.
- TABLE_CAT - The catalog the table is in, which may be
-
getSchemas
public ResultSet getSchemas() throws java.sql.SQLException
Description copied from interface:DatabaseMetaDataThis method returns the list of database schemas as aResultSet, with one column - TABLE_SCHEM - that is the name of the schema.- Specified by:
getSchemasin interfaceDatabaseMetaData- Returns:
- A
ResultSetwith all the requested schemas. - Throws:
java.sql.SQLException- If an error occurs.
-
getCatalogs
public ResultSet getCatalogs() throws java.sql.SQLException
Description copied from interface:DatabaseMetaDataThis method returns the list of database catalogs as aResultSetwith one column - TABLE_CAT - that is the name of the catalog.- Specified by:
getCatalogsin interfaceDatabaseMetaData- Returns:
- A
ResultSetwith all the requested catalogs. - Throws:
java.sql.SQLException- If an error occurs.
-
getTableTypes
public ResultSet getTableTypes() throws java.sql.SQLException
Description copied from interface:DatabaseMetaDataThis method returns the list of database table types as aResultSetwith one column - TABLE_TYPE - that is the name of the table type.- Specified by:
getTableTypesin interfaceDatabaseMetaData- Returns:
- A
ResultSetwith all the requested table types. - Throws:
java.sql.SQLException- If an error occurs.
-
getColumns
public ResultSet getColumns(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tablePattern, java.lang.String columnPattern) throws java.sql.SQLException
Description copied from interface:DatabaseMetaDataThis method returns a list of the tables columns for the requested tables. This is returned in the form of aResultSetwith the following columns:- TABLE_CAT - The catalog the table is in, which may be
null. - TABLE_SCHEM - The schema the tables is in, which may be
null. - TABLE_NAME - The name of the table.
- COLUMN_NAME - The name of the column
- DATA_TYPE - The SQL type of the column. This is one of the constants
defined in
Types. - TYPE_NAME - The string name of the data type for this column.
- COLUMN_SIZE - The size of the column.
- Unused
- NUM_PREC_RADIX - The radix of the column.
- NULLABLE - Whether or not the column is NULLABLE. This is one of
the constants defined in this class (
tableNoNulls,tableNullable, ortableNullableUnknown) - REMARKS - A description of the column.
- COLUMN_DEF - The default value for the column, may be
null. - SQL_DATA_TYPE - Unused
- SQL_DATETIME_SUB - Unused
- CHAR_OCTET_LENGTH - For character columns, the maximum number of bytes in the column.
- ORDINAL_POSITION - The index of the column in the table.
- IS_NULLABLE - "NO" means no, "YES" means maybe, and an empty string means unknown.
- Specified by:
getColumnsin interfaceDatabaseMetaData- Parameters:
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.- Throws:
java.sql.SQLException- If an error occurs.
- TABLE_CAT - The catalog the table is in, which may be
-
getColumnPrivileges
public ResultSet getColumnPrivileges(java.lang.String catalog, java.lang.String schema, java.lang.String tableName, java.lang.String columnPattern) throws java.sql.SQLException
Description copied from interface:DatabaseMetaDataThis method returns the access rights that have been granted to the requested columns. This information is returned as aResultSetwith the following columns:- TABLE_CAT - The catalog the table is in, which may be
null. - TABLE_SCHEM - The schema the tables is in, which may be
null. - TABLE_NAME - The name of the table.
- COLUMN_NAME - The name of the column.
- GRANTOR - The entity that granted the access.
- GRANTEE - The entity granted the access.
- PRIVILEGE - The name of the privilege granted.
- IS_GRANTABLE - "YES" if the grantee can grant the privilege to
others, "NO" if not, and
nullif unknown.
- Specified by:
getColumnPrivilegesin interfaceDatabaseMetaData- Parameters:
catalog- The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, ornullto 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.- Returns:
- A
ResultSetwith all the requested privileges. - Throws:
java.sql.SQLException- If an error occurs.
- TABLE_CAT - The catalog the table is in, which may be
-
getTablePrivileges
public ResultSet getTablePrivileges(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tablePattern) throws java.sql.SQLException
Description copied from interface:DatabaseMetaDataThis method returns the access rights that have been granted to the requested tables. This information is returned as aResultSetwith the following columns:- TABLE_CAT - The catalog the table is in, which may be
null. - TABLE_SCHEM - The schema the tables is in, which may be
null. - TABLE_NAME - The name of the table.
- GRANTOR - The entity that granted the access.
- GRANTEE - The entity granted the access.
- PRIVILEGE - The name of the privilege granted.
- IS_GRANTABLE - "YES" if the grantee can grant the privilege to
others, "NO" if not, and
nullif unknown.
- Specified by:
getTablePrivilegesin interfaceDatabaseMetaData- Parameters:
catalog- The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, ornullto 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.- Returns:
- A
ResultSetwith all the requested privileges. - Throws:
java.sql.SQLException- If an error occurs.
- TABLE_CAT - The catalog the table is in, which may be
-
getBestRowIdentifier
public ResultSet getBestRowIdentifier(java.lang.String catalog, java.lang.String schema, java.lang.String tableName, int scope, boolean nullable) throws java.sql.SQLException
Description copied from interface:DatabaseMetaDataThis method returns the best set of columns for uniquely identifying a row. It returns this information as aResultSetwith the following columns:- SCOPE - The scope of the results returned. This is one of the
constants defined in this class (
bestRowTemporary,bestRowTransaction, orbestRowSession). - COLUMN_NAME - The name of the column.
- DATA_TYPE - The SQL type of the column. This is one of the constants
defined in
Types. - TYPE_NAME - The string name of the data type for this column.
- COLUMN_SIZE - The precision of the columns
- BUFFER_LENGTH - Unused
- DECIMAL_DIGITS - The scale of the column.
- PSEUDO_COLUMN - Whether or not the best row identifier is a
pseudo_column. This is one of the constants defined in this class
(
bestRowUnknown,bestRowNotPseudo, orbestRowPseudo).
- Specified by:
getBestRowIdentifierin interfaceDatabaseMetaData- Parameters:
catalog- The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, ornullto 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-trueto include columns that are nullable,falseotherwise.- Returns:
- A
ResultSetwith the best row identifier. - Throws:
java.sql.SQLException- If an error occurs.
- SCOPE - The scope of the results returned. This is one of the
constants defined in this class (
-
getVersionColumns
public ResultSet getVersionColumns(java.lang.String catalog, java.lang.String schema, java.lang.String tableName) throws java.sql.SQLException
Description copied from interface:DatabaseMetaDataThis method returns the set of columns that are automatically updated when the row is update. It returns this information as aResultSetwith the following columns:- SCOPE - Unused
- COLUMN_NAME - The name of the column.
- DATA_TYPE - The SQL type of the column. This is one of the constants
defined in
Types. - TYPE_NAME - The string name of the data type for this column.
- COLUMN_SIZE - The precision of the columns
- BUFFER_LENGTH - Unused
- DECIMAL_DIGITS - The scale of the column.
- PSEUDO_COLUMN - Whether or not the best row identifier is a
pseudo_column. This is one of the constants defined in this class
(
versionRowUnknown,versionRowNotPseudo, orversionRowPseudo).
- Specified by:
getVersionColumnsin interfaceDatabaseMetaData- Parameters:
catalog- The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, ornullto 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- Returns:
- A
ResultSetwith the version columns. - Throws:
java.sql.SQLException- If an error occurs.
-
getPrimaryKeys
public ResultSet getPrimaryKeys(java.lang.String catalog, java.lang.String schema, java.lang.String tableName) throws java.sql.SQLException
Description copied from interface:DatabaseMetaDataThis method returns a list of a table's primary key columns. These are returned as aResultSetwith the following columns.- TABLE_CAT - The catalog of the table, which may be
null. - TABLE_SCHEM - The schema of the table, which may be
null. - TABLE_NAME - The name of the table.
- COLUMN_NAME - The name of the column.
- KEY_SEQ - The sequence number of the column within the primary key.
- PK_NAME - The name of the primary key, which may be
null.
- Specified by:
getPrimaryKeysin interfaceDatabaseMetaData- Parameters:
catalog- The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, ornullto 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.- Returns:
- A
ResultSetwith the primary key columns. - Throws:
java.sql.SQLException- If an error occurs.
- TABLE_CAT - The catalog of the table, which may be
-
getImportedKeys
public ResultSet getImportedKeys(java.lang.String catalog, java.lang.String schema, java.lang.String tableName) throws java.sql.SQLException
Description copied from interface:DatabaseMetaDataThis method returns a list of the table's foreign keys. These are returned as aResultSetwith the following columns:- PKTABLE_CAT - The catalog of the table the key was imported from.
- PKTABLE_SCHEM - The schema of the table the key was imported from.
- PKTABLE_NAME - The name of the table the key was imported from.
- PKCOLUMN_NAME - The name of the column that was imported.
- FKTABLE_CAT - The foreign key catalog name.
- FKTABLE_SCHEM - The foreign key schema name.
- FKTABLE_NAME - The foreign key table name.
- FKCOLUMN_NAME - The foreign key column name.
- KEY_SEQ - The sequence number of the column within the foreign key.
- UPDATE_RULE - How the foreign key behaves when the primary key is
updated. This is one of the constants defined in this class
(
importedNoAction,importedKeyCascade,importedKeySetNull,importedKeySetDefault, orimportedKeyRestrict). - DELETE_RULE - How the foreign key behaves when the primary key is
deleted. This is one of the constants defined in this class
(
importedNoAction,importedKeyCascade,importedKeySetNull, orimportedKeySetDefault) - FK_NAME - The name of the foreign key.
- PK_NAME - The name of the primary key.
- DEFERRABILITY - The deferrability value. This is one of the
constants defined in this table (
importedKeyInitiallyDeferred,importedKeyInitiallyImmediate, orimportedKeyNotDeferrable).
- Specified by:
getImportedKeysin interfaceDatabaseMetaData- Parameters:
catalog- The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, ornullto 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.- Returns:
- A
ResultSetwith the foreign key columns. - Throws:
java.sql.SQLException- If an error occurs.
-
getExportedKeys
public ResultSet getExportedKeys(java.lang.String catalog, java.lang.String schema, java.lang.String tableName) throws java.sql.SQLException
Description copied from interface:DatabaseMetaDataThis method returns a list of the table's which use this table's primary key as a foreign key. The information is returned as aResultSetwith the following columns:- PKTABLE_CAT - The catalog of the table the key was imported from.
- PKTABLE_SCHEM - The schema of the table the key was imported from.
- PKTABLE_NAME - The name of the table the key was imported from.
- PKCOLUMN_NAME - The name of the column that was imported.
- FKTABLE_CAT - The foreign key catalog name.
- FKTABLE_SCHEM - The foreign key schema name.
- FKTABLE_NAME - The foreign key table name.
- FKCOLUMN_NAME - The foreign key column name.
- KEY_SEQ - The sequence number of the column within the foreign key.
- UPDATE_RULE - How the foreign key behaves when the primary key is
updated. This is one of the constants defined in this class
(
importedNoAction,importedKeyCascade,importedKeySetNull,importedKeySetDefault, orimportedKeyRestrict). - DELETE_RULE - How the foreign key behaves when the primary key is
deleted. This is one of the constants defined in this class
(
importedNoAction,importedKeyCascade,importedKeySetNull, orimportedKeySetDefault) - FK_NAME - The name of the foreign key.
- PK_NAME - The name of the primary key.
- DEFERRABILITY - The deferrability value. This is one of the
constants defined in this table (
importedKeyInitiallyDeferred,importedKeyInitiallyImmediate, orimportedKeyNotDeferrable).
- Specified by:
getExportedKeysin interfaceDatabaseMetaData- Parameters:
catalog- The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, ornullto 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.- Returns:
- A
ResultSetwith the requested information - Throws:
java.sql.SQLException- If an error occurs.
-
getCrossReference
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
Description copied from interface:DatabaseMetaDataThis method returns a description of how one table imports another table's primary key as a foreign key. The information is returned as aResultSetwith the following columns:- PKTABLE_CAT - The catalog of the table the key was imported from.
- PKTABLE_SCHEM - The schema of the table the key was imported from.
- PKTABLE_NAME - The name of the table the key was imported from.
- PKCOLUMN_NAME - The name of the column that was imported.
- FKTABLE_CAT - The foreign key catalog name.
- FKTABLE_SCHEM - The foreign key schema name.
- FKTABLE_NAME - The foreign key table name.
- FKCOLUMN_NAME - The foreign key column name.
- KEY_SEQ - The sequence number of the column within the foreign key.
- UPDATE_RULE - How the foreign key behaves when the primary key is
updated. This is one of the constants defined in this class
(
importedNoAction,importedKeyCascade,importedKeySetNull,importedKeySetDefault, orimportedKeyRestrict). - DELETE_RULE - How the foreign key behaves when the primary key is
deleted. This is one of the constants defined in this class
(
importedNoAction,importedKeyCascade,importedKeySetNull, orimportedKeySetDefault) - FK_NAME - The name of the foreign key.
- PK_NAME - The name of the primary key.
- DEFERRABILITY - The deferrability value. This is one of the
constants defined in this table (
importedKeyInitiallyDeferred,importedKeyInitiallyImmediate, orimportedKeyNotDeferrable).
- Specified by:
getCrossReferencein interfaceDatabaseMetaData- Parameters:
primaryCatalog- The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, ornullto 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, ornullto 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.- Returns:
- A
ResultSetwith the requested information - Throws:
java.sql.SQLException- If an error occurs.
-
getTypeInfo
public ResultSet getTypeInfo() throws java.sql.SQLException
Description copied from interface:DatabaseMetaDataThis method returns a list of the SQL types supported by this database. The information is returned as aResultSetwith the following columns:- TYPE_NAME - The name of the data type.
- DATA_TYPE - A data type constant from
Typesfor this type. - PRECISION - The maximum precision of this type.
- LITERAL_PREFIX - Prefix value used to quote a literal, which may be
null. - LITERAL_SUFFIX - Suffix value used to quote a literal, which may be
null. - CREATE_PARAMS - The parameters used to create the type, which may be
null. - NULLABLE - Whether or not this type supports NULL values. This will
be one of the constants defined in this interface
(
typeNoNulls,typeNullable, ortypeNullableUnknown). - CASE_SENSITIVE - Whether or not the value is case sensitive.
- SEARCHABLE - Whether or not "LIKE" expressions are supported in
WHERE clauses for this type. This will be one of the constants defined
in this interface (
typePredNone,typePredChar,typePredBasic, ortypeSearchable). - UNSIGNED_ATTRIBUTE - Is the value of this type unsigned.
- FIXED_PREC_SCALE - Whether or not this type can be used for money.
- AUTO_INCREMENT - Whether or not this type supports auto-incrementing.
- LOCAL_TYPE_NAME - A localized name for this data type.
- MINIMUM_SCALE - The minimum scale supported by this type.
- MAXIMUM_SCALE - The maximum scale supported by this type.
- SQL_DATA_TYPE - Unused.
- SQL_DATETIME_SUB - Unused.
- NUM_PREC_RADIX - The radix of this data type.
- Specified by:
getTypeInfoin interfaceDatabaseMetaData- Returns:
- A
ResultSetwith the list of available data types. - Throws:
java.sql.SQLException- If an error occurs.
-
getIndexInfo
public ResultSet getIndexInfo(java.lang.String catalog, java.lang.String schema, java.lang.String tableName, boolean unique, boolean approximate) throws java.sql.SQLException
Description copied from interface:DatabaseMetaDataThis method returns information about a tables indices and statistics. It is returned as aResultSetwith the following columns:- TABLE_CAT - The catalog of the table, which may be
null. - TABLE_SCHEM - The schema of the table, which may be
null. - TABLE_NAME - The name of the table.
- NON_UNIQUE - Are index values non-unique?
- INDEX_QUALIFIER The index catalog, which may be
null - INDEX_NAME - The name of the index.
- TYPE - The type of index, which will be one of the constants defined
in this interface (
tableIndexStatistic,tableIndexClustered,tableIndexHashed, ortableIndexOther). - ORDINAL_POSITION - The sequence number of this column in the index.
This will be 0 when the index type is
tableIndexStatistic. - COLUMN_NAME - The name of this column in the index.
- ASC_OR_DESC - "A" for an ascending sort sequence, "D" for a
descending sort sequence or
nullif a sort sequence is not supported. - CARDINALITY - The number of unique rows in the index, or the number
of rows in the table if the index type is
tableIndexStatistic. - PAGES - The number of pages used for the index, or the number of pages
in the table if the index type is
tableIndexStatistic. - FILTER_CONDITION - The filter condition for this index, which may be
null.
- Specified by:
getIndexInfoin interfaceDatabaseMetaData- Parameters:
catalog- The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, ornullto 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-trueto return only unique indexes,falseotherwise.approximate-trueif data values can be approximations,falseotherwise.- Returns:
- A
ResultSetwith the requested index information - Throws:
java.sql.SQLException- If an error occurs.
- TABLE_CAT - The catalog of the table, which may be
-
supportsResultSetType
public boolean supportsResultSetType(int type) throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the datbase supports the specified result type.- Specified by:
supportsResultSetTypein interfaceDatabaseMetaData- Parameters:
type- The desired result type, which is one of the constants defined inResultSet.- Returns:
trueif the result set type is supported,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.- See Also:
ResultSet
-
supportsResultSetConcurrency
public boolean supportsResultSetConcurrency(int type, int concurrency) throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether the specified result set type and result set concurrency type are supported by the database.- Specified by:
supportsResultSetConcurrencyin interfaceDatabaseMetaData- Parameters:
type- The desired result type, which is one of the constants defined inResultSet.concurrency- The desired concurrency type, which is one of the constants defined inResultSet.- Returns:
trueif the result set type is supported,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.- See Also:
ResultSet
-
ownUpdatesAreVisible
public boolean ownUpdatesAreVisible(int type) throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the specified result set type sees its own updates.- Specified by:
ownUpdatesAreVisiblein interfaceDatabaseMetaData- Parameters:
type- The desired result type, which is one of the constants defined inResultSet.- Returns:
trueif the result set type sees its own updates,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.- See Also:
ResultSet
-
ownDeletesAreVisible
public boolean ownDeletesAreVisible(int type) throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the specified result set type sees its own deletes.- Specified by:
ownDeletesAreVisiblein interfaceDatabaseMetaData- Parameters:
type- The desired result type, which is one of the constants defined inResultSet.- Returns:
trueif the result set type sees its own deletes,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.- See Also:
ResultSet
-
ownInsertsAreVisible
public boolean ownInsertsAreVisible(int type) throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the specified result set type sees its own inserts.- Specified by:
ownInsertsAreVisiblein interfaceDatabaseMetaData- Parameters:
type- The desired result type, which is one of the constants defined inResultSet.- Returns:
trueif the result set type sees its own inserts,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.- See Also:
ResultSet
-
othersUpdatesAreVisible
public boolean othersUpdatesAreVisible(int type) throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the specified result set type sees updates committed by others.- Specified by:
othersUpdatesAreVisiblein interfaceDatabaseMetaData- Parameters:
type- The desired result type, which is one of the constants defined inResultSet.- Returns:
trueif the result set type sees other updates,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.- See Also:
ResultSet
-
othersDeletesAreVisible
public boolean othersDeletesAreVisible(int type) throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the specified result set type sees deletes committed by others.- Specified by:
othersDeletesAreVisiblein interfaceDatabaseMetaData- Parameters:
type- The desired result type, which is one of the constants defined inResultSet.- Returns:
trueif the result set type sees other deletes,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.- See Also:
ResultSet
-
othersInsertsAreVisible
public boolean othersInsertsAreVisible(int type) throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the specified result set type sees inserts committed by others.- Specified by:
othersInsertsAreVisiblein interfaceDatabaseMetaData- Parameters:
type- The desired result type, which is one of the constants defined inResultSet.- Returns:
trueif the result set type sees other inserts,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.- See Also:
ResultSet
-
updatesAreDetected
public boolean updatesAreDetected(int type) throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the specified result set type can detect a visible update by calling therowUpdatedmethod.- Specified by:
updatesAreDetectedin interfaceDatabaseMetaData- Parameters:
type- The desired result type, which is one of the constants defined inResultSet.- Returns:
trueif the result set type can detect visible updates usingrowUpdated,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.- See Also:
ResultSet
-
deletesAreDetected
public boolean deletesAreDetected(int type) throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the specified result set type can detect a visible delete by calling therowUpdatedmethod.- Specified by:
deletesAreDetectedin interfaceDatabaseMetaData- Parameters:
type- The desired result type, which is one of the constants defined inResultSet.- Returns:
trueif the result set type can detect visible deletes usingrowUpdated,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.- See Also:
ResultSet
-
insertsAreDetected
public boolean insertsAreDetected(int type) throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the specified result set type can detect a visible insert by calling therowUpdatedmethod.- Specified by:
insertsAreDetectedin interfaceDatabaseMetaData- Parameters:
type- The desired result type, which is one of the constants defined inResultSet.- Returns:
trueif the result set type can detect visible inserts usingrowUpdated,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.- See Also:
ResultSet
-
supportsBatchUpdates
public boolean supportsBatchUpdates() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether or not the database supports batch updates.- Specified by:
supportsBatchUpdatesin interfaceDatabaseMetaData- Returns:
trueif batch updates are supported,falseotherwise.- Throws:
java.sql.SQLException- If an error occurs.
-
getUDTs
public ResultSet getUDTs(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typePattern, int[] types) throws java.sql.SQLException
Description copied from interface:DatabaseMetaDataThis method returns the list of user defined data types in use. These are returned as aResultSetwith the following columns:- TYPE_CAT - The catalog name, which may be
null. - TYPE_SCEHM - The schema name, which may be
null. - TYPE_NAME - The user defined data type name.
- CLASS_NAME - The Java class name this type maps to.
- DATA_TYPE - A type identifier from
Typesfor this type. This will be one ofJAVA_OBJECT,STRUCT, orDISTINCT. - REMARKS - Comments about this data type.
- Specified by:
getUDTsin interfaceDatabaseMetaData- Parameters:
catalog- The catalog to retrieve information from, or the empty string to return entities not associated with a catalog, ornullto 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 (fromTypes) to match.- Returns:
- A
ResultSetwith the requested type information - Throws:
java.sql.SQLException- If an error occurs.
- TYPE_CAT - The catalog name, which may be
-
getConnection
public Connection getConnection() throws java.sql.SQLException
Description copied from interface:DatabaseMetaDataThis method returns theConnectionobject that was used to generate the metadata in this object.- Specified by:
getConnectionin interfaceDatabaseMetaData- Returns:
- The connection for this object.
- Throws:
java.sql.SQLException- If an error occurs.
-
supportsSavepoints
public boolean supportsSavepoints() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether the databse supports savepoints.- Specified by:
supportsSavepointsin interfaceDatabaseMetaData- Returns:
trueif the database supports savepoints,falseif it does not.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsNamedParameters
public boolean supportsNamedParameters() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether the database supports named parameters.- Specified by:
supportsNamedParametersin interfaceDatabaseMetaData- Returns:
trueif the database supports named parameters,falseif it does not.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsMultipleOpenResults
public boolean supportsMultipleOpenResults() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests whether the database supports returning multipleResultSetS from aCallableStatementat once.- Specified by:
supportsMultipleOpenResultsin interfaceDatabaseMetaData- Returns:
trueif the database supports returnig multiple results at once,falseif it does not.- Throws:
java.sql.SQLException- If an error occurs.
-
supportsGetGeneratedKeys
public boolean supportsGetGeneratedKeys() throws java.sql.SQLException- Specified by:
supportsGetGeneratedKeysin interfaceDatabaseMetaData- Throws:
java.sql.SQLException
-
getSuperTypes
public ResultSet getSuperTypes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typePattern) throws java.sql.SQLException
- Specified by:
getSuperTypesin interfaceDatabaseMetaData- Throws:
java.sql.SQLException
-
getSuperTables
public ResultSet getSuperTables(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String tablePattern) throws java.sql.SQLException
- Specified by:
getSuperTablesin interfaceDatabaseMetaData- Throws:
java.sql.SQLException
-
getAttributes
public ResultSet getAttributes(java.lang.String catalog, java.lang.String schemaPattern, java.lang.String typePattern, java.lang.String attributePattern) throws java.sql.SQLException
- Specified by:
getAttributesin interfaceDatabaseMetaData- Throws:
java.sql.SQLException
-
supportsResultSetHoldability
public boolean supportsResultSetHoldability(int holdability) throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method tests if the database supports the specified holdability type. Valid values for this parameter are specified in theResultSetclass.- Specified by:
supportsResultSetHoldabilityin interfaceDatabaseMetaData- Parameters:
holdability- The holdability type to test.- Returns:
trueif the database supports the holdability type,falseif it does not.- Throws:
java.sql.SQLException- If an error occurs.- See Also:
ResultSet
-
getResultSetHoldability
public int getResultSetHoldability() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the default holdability type ofResultSetS retrieved from this database. The possible values are specified in theResultSetclass.- Specified by:
getResultSetHoldabilityin interfaceDatabaseMetaData- Returns:
- The default holdability type.
- Throws:
java.sql.SQLException- If an error occurs.
-
getDatabaseMajorVersion
public int getDatabaseMajorVersion() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the major version number of the database.- Specified by:
getDatabaseMajorVersionin interfaceDatabaseMetaData- Returns:
- The major version number of the database.
- Throws:
java.sql.SQLException- If an error occurs.
-
getDatabaseMinorVersion
public int getDatabaseMinorVersion() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the minor version number of the database.- Specified by:
getDatabaseMinorVersionin interfaceDatabaseMetaData- Returns:
- The minor version number of the database.
- Throws:
java.sql.SQLException- If an error occurs.
-
getJDBCMajorVersion
public int getJDBCMajorVersion() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the major version number of the JDBC driver.- Specified by:
getJDBCMajorVersionin interfaceDatabaseMetaData- Returns:
- The major version number of the JDBC driver.
- Throws:
java.sql.SQLException- If an error occurs.
-
getJDBCMinorVersion
public int getJDBCMinorVersion() throws java.sql.SQLExceptionDescription copied from interface:DatabaseMetaDataThis method returns the minor version number of the JDBC driver.- Specified by:
getJDBCMinorVersionin interfaceDatabaseMetaData- Returns:
- The minor version number of the database.
- Throws:
java.sql.SQLException- If an error occurs.
-
getSQLStateType
public int getSQLStateType() throws java.sql.SQLException- Specified by:
getSQLStateTypein interfaceDatabaseMetaData- Throws:
java.sql.SQLException
-
locatorsUpdateCopy
public boolean locatorsUpdateCopy() throws java.sql.SQLException- Specified by:
locatorsUpdateCopyin interfaceDatabaseMetaData- Throws:
java.sql.SQLException
-
supportsStatementPooling
public boolean supportsStatementPooling() throws java.sql.SQLException- Specified by:
supportsStatementPoolingin interfaceDatabaseMetaData- Throws:
java.sql.SQLException
-
-