All Packages  Class Hierarchy  This Package  Previous  Next  Index

Class com.imaginary.sql.msql.MsqlDatabaseMetaData

com.imaginary.sql.msql.MsqlDatabaseMetaData

public class MsqlDatabaseMetaData
This class is not yet done.
Last modified $Date: 1999/07/09 23:16:27 $

Version:
$Revision: 1.1.2.1.2.2 $
Author:
George Reese (borg@imaginary.com)

Method Index

 o allProceduresAreCallable()
 o allTablesAreSelectable()
 o dataDefinitionCausesTransactionCommit()
 o dataDefinitionIgnoredInTransactions()
 o deletesAreDetected(int)
 o doesMaxRowSizeIncludeBlobs()
 o getBestRowIdentifier(String, String, String, int, boolean)
 o getCatalogs()
 o getCatalogSeparator()
 o getCatalogTerm()
 o getColumnPrivileges(String, String, String, String)
 o getColumns(String, String, String, String)
Provides column information for the specified table from the database.
 o getConnection()
 o getCrossReference(String, String, String, String, String, String)
 o getDatabaseProductName()
 o getDatabaseProductVersion()
 o getDefaultTransactionIsolation()
 o getDriverMajorVersion()
 o getDriverMinorVersion()
 o getDriverName()
 o getDriverVersion()
 o getExportedKeys(String, String, String)
 o getExtraNameCharacters()
 o getIdentifierQuoteString()
 o getImportedKeys(String, String, String)
 o getIndexInfo(String, String, String, boolean, boolean)
 o getMaxBinaryLiteralLength()
 o getMaxCatalogNameLength()
 o getMaxCharLiteralLength()
 o getMaxColumnNameLength()
 o getMaxColumnsInGroupBy()
 o getMaxColumnsInIndex()
 o getMaxColumnsInOrderBy()
 o getMaxColumnsInSelect()
 o getMaxColumnsInTable()
 o getMaxConnections()
 o getMaxCursorNameLength()
 o getMaxIndexLength()
 o getMaxProcedureNameLength()
 o getMaxRowSize()
 o getMaxSchemaNameLength()
 o getMaxStatementLength()
 o getMaxStatements()
 o getMaxTableNameLength()
 o getMaxTablesInSelect()
 o getMaxUserNameLength()
 o getNumericFunctions()
 o getPrimaryKeys(String, String, String)
This method is used by MsqlDatabaseMetaData to grab column information from the database.
 o getProcedureColumns(String, String, String, String)
 o getProcedures(String, String, String)
 o getProcedureTerm()
 o getSchemas()
 o getSchemaTerm()
 o getSearchStringEscape()
 o getSQLKeywords()
 o getStringFunctions()
 o getSystemFunctions()
 o getTablePrivileges(String, String, String)
 o getTables(String, String, String, String[])
This method is used by MsqlDatabaseMetaData to grab table information from the database.
 o getTableTypes()
 o getTimeDateFunctions()
 o getTypeInfo()
 o getUDTs(String, String, String, int[])
 o getURL()
 o getUserName()
 o getVersionColumns(String, String, String)
 o insertsAreDetected(int)
 o isCatalogAtStart()
 o isReadOnly()
 o nullPlusNonNullIsNull()
 o nullsAreSortedAtEnd()
 o nullsAreSortedAtStart()
 o nullsAreSortedHigh()
 o nullsAreSortedLow()
 o othersDeletesAreVisible(int)
 o othersInsertsAreVisible(int)
 o othersUpdatesAreVisible(int)
 o ownDeletesAreVisible(int)
 o ownInsertsAreVisible(int)
 o ownUpdatesAreVisible(int)
 o storesLowerCaseIdentifiers()
 o storesLowerCaseQuotedIdentifiers()
 o storesMixedCaseIdentifiers()
 o storesMixedCaseQuotedIdentifiers()
 o storesUpperCaseIdentifiers()
 o storesUpperCaseQuotedIdentifiers()
 o supportsAlterTableWithAddColumn()
 o supportsAlterTableWithDropColumn()
 o supportsANSI92EntryLevelSQL()
 o supportsANSI92FullSQL()
 o supportsANSI92IntermediateSQL()
 o supportsBatchUpdates()
 o supportsCatalogsInDataManipulation()
 o supportsCatalogsInIndexDefinitions()
 o supportsCatalogsInPrivilegeDefinitions()
 o supportsCatalogsInProcedureCalls()
 o supportsCatalogsInTableDefinitions()
 o supportsColumnAliasing()
 o supportsConvert()
 o supportsConvert(int, int)
 o supportsCoreSQLGrammar()
 o supportsCorrelatedSubqueries()
 o supportsDataDefinitionAndDataManipulationTransactions()
 o supportsDataManipulationTransactionsOnly()
 o supportsDifferentTableCorrelationNames()
 o supportsExpressionsInOrderBy()
 o supportsExtendedSQLGrammar()
 o supportsFullOuterJoins()
 o supportsGroupBy()
 o supportsGroupByBeyondSelect()
 o supportsGroupByUnrelated()
 o supportsIntegrityEnhancementFacility()
 o supportsLikeEscapeClause()
 o supportsLimitedOuterJoins()
 o supportsMinimumSQLGrammar()
 o supportsMixedCaseIdentifiers()
 o supportsMixedCaseQuotedIdentifiers()
 o supportsMultipleResultSets()
 o supportsMultipleTransactions()
 o supportsNonNullableColumns()
 o supportsOpenCursorsAcrossCommit()
 o supportsOpenCursorsAcrossRollback()
 o supportsOpenStatementsAcrossCommit()
 o supportsOpenStatementsAcrossRollback()
 o supportsOrderByUnrelated()
 o supportsOuterJoins()
 o supportsPositionedDelete()
 o supportsPositionedUpdate()
 o supportsResultSetConcurrency(int, int)
 o supportsResultSetType(int)
 o supportsSchemasInDataManipulation()
 o supportsSchemasInIndexDefinitions()
 o supportsSchemasInPrivilegeDefinitions()
 o supportsSchemasInProcedureCalls()
 o supportsSchemasInTableDefinitions()
 o supportsSelectForUpdate()
 o supportsStoredProcedures()
 o supportsSubqueriesInComparisons()
 o supportsSubqueriesInExists()
 o supportsSubqueriesInIns()
 o supportsSubqueriesInQuantifieds()
 o supportsTableCorrelationNames()
 o supportsTransactionIsolationLevel(int)
 o supportsTransactions()
 o supportsUnion()
 o supportsUnionAll()
 o updatesAreDetected(int)
 o usesLocalFilePerTable()
 o usesLocalFiles()

Methods

 o allProceduresAreCallable
 public boolean allProceduresAreCallable() throws SQLException
 o allTablesAreSelectable
 public boolean allTablesAreSelectable() throws SQLException
 o deletesAreDetected
 public boolean deletesAreDetected(int type) throws SQLException
 o getURL
 public String getURL() throws SQLException
 o getUserName
 public String getUserName() throws SQLException
 o isReadOnly
 public boolean isReadOnly() throws SQLException
 o nullsAreSortedHigh
 public boolean nullsAreSortedHigh() throws SQLException
 o nullsAreSortedLow
 public boolean nullsAreSortedLow() throws SQLException
 o nullsAreSortedAtStart
 public boolean nullsAreSortedAtStart() throws SQLException
 o nullsAreSortedAtEnd
 public boolean nullsAreSortedAtEnd() throws SQLException
 o getDatabaseProductName
 public String getDatabaseProductName() throws SQLException
 o getDatabaseProductVersion
 public String getDatabaseProductVersion() throws SQLException
 o getDriverName
 public String getDriverName() throws SQLException
 o getDriverVersion
 public String getDriverVersion() throws SQLException
 o getDriverMajorVersion
 public int getDriverMajorVersion()
 o getDriverMinorVersion
 public int getDriverMinorVersion()
 o usesLocalFiles
 public boolean usesLocalFiles() throws SQLException
 o usesLocalFilePerTable
 public boolean usesLocalFilePerTable() throws SQLException
 o supportsMixedCaseIdentifiers
 public boolean supportsMixedCaseIdentifiers() throws SQLException
 o storesUpperCaseIdentifiers
 public boolean storesUpperCaseIdentifiers() throws SQLException
 o storesLowerCaseIdentifiers
 public boolean storesLowerCaseIdentifiers() throws SQLException
 o storesMixedCaseIdentifiers
 public boolean storesMixedCaseIdentifiers() throws SQLException
 o supportsMixedCaseQuotedIdentifiers
 public boolean supportsMixedCaseQuotedIdentifiers() throws SQLException
 o storesUpperCaseQuotedIdentifiers
 public boolean storesUpperCaseQuotedIdentifiers() throws SQLException
 o storesLowerCaseQuotedIdentifiers
 public boolean storesLowerCaseQuotedIdentifiers() throws SQLException
 o storesMixedCaseQuotedIdentifiers
 public boolean storesMixedCaseQuotedIdentifiers() throws SQLException
 o getConnection
 public Connection getConnection() throws SQLException
 o getIdentifierQuoteString
 public String getIdentifierQuoteString() throws SQLException
 o getSQLKeywords
 public String getSQLKeywords() throws SQLException
 o getNumericFunctions
 public String getNumericFunctions() throws SQLException
 o getStringFunctions
 public String getStringFunctions() throws SQLException
 o getSystemFunctions
 public String getSystemFunctions() throws SQLException
 o getTimeDateFunctions
 public String getTimeDateFunctions() throws SQLException
 o getSearchStringEscape
 public String getSearchStringEscape() throws SQLException
 o getExtraNameCharacters
 public String getExtraNameCharacters() throws SQLException
 o supportsAlterTableWithAddColumn
 public boolean supportsAlterTableWithAddColumn() throws SQLException
 o supportsAlterTableWithDropColumn
 public boolean supportsAlterTableWithDropColumn() throws SQLException
 o supportsColumnAliasing
 public boolean supportsColumnAliasing() throws SQLException
 o nullPlusNonNullIsNull
 public boolean nullPlusNonNullIsNull() throws SQLException
 o supportsConvert
 public boolean supportsConvert() throws SQLException
 o supportsConvert
 public boolean supportsConvert(int fromType,
                                int toType) throws SQLException
 o supportsTableCorrelationNames
 public boolean supportsTableCorrelationNames() throws SQLException
 o supportsDifferentTableCorrelationNames
 public boolean supportsDifferentTableCorrelationNames() throws SQLException
 o supportsExpressionsInOrderBy
 public boolean supportsExpressionsInOrderBy() throws SQLException
 o supportsOrderByUnrelated
 public boolean supportsOrderByUnrelated() throws SQLException
 o supportsGroupBy
 public boolean supportsGroupBy() throws SQLException
 o supportsGroupByUnrelated
 public boolean supportsGroupByUnrelated() throws SQLException
 o supportsGroupByBeyondSelect
 public boolean supportsGroupByBeyondSelect() throws SQLException
 o supportsLikeEscapeClause
 public boolean supportsLikeEscapeClause() throws SQLException
 o supportsMultipleResultSets
 public boolean supportsMultipleResultSets() throws SQLException
 o supportsMultipleTransactions
 public boolean supportsMultipleTransactions() throws SQLException
 o supportsNonNullableColumns
 public boolean supportsNonNullableColumns() throws SQLException
 o supportsMinimumSQLGrammar
 public boolean supportsMinimumSQLGrammar() throws SQLException
 o supportsCoreSQLGrammar
 public boolean supportsCoreSQLGrammar() throws SQLException
 o supportsExtendedSQLGrammar
 public boolean supportsExtendedSQLGrammar() throws SQLException
 o supportsANSI92EntryLevelSQL
 public boolean supportsANSI92EntryLevelSQL() throws SQLException
 o supportsANSI92IntermediateSQL
 public boolean supportsANSI92IntermediateSQL() throws SQLException
 o supportsANSI92FullSQL
 public boolean supportsANSI92FullSQL() throws SQLException
 o supportsIntegrityEnhancementFacility
 public boolean supportsIntegrityEnhancementFacility() throws SQLException
 o supportsOuterJoins
 public boolean supportsOuterJoins() throws SQLException
 o supportsFullOuterJoins
 public boolean supportsFullOuterJoins() throws SQLException
 o supportsLimitedOuterJoins
 public boolean supportsLimitedOuterJoins() throws SQLException
 o getSchemaTerm
 public String getSchemaTerm() throws SQLException
 o getProcedureTerm
 public String getProcedureTerm() throws SQLException
 o getCatalogTerm
 public String getCatalogTerm() throws SQLException
 o isCatalogAtStart
 public boolean isCatalogAtStart() throws SQLException
 o getCatalogSeparator
 public String getCatalogSeparator() throws SQLException
 o supportsSchemasInDataManipulation
 public boolean supportsSchemasInDataManipulation() throws SQLException
 o supportsSchemasInProcedureCalls
 public boolean supportsSchemasInProcedureCalls() throws SQLException
 o supportsSchemasInTableDefinitions
 public boolean supportsSchemasInTableDefinitions() throws SQLException
 o supportsSchemasInIndexDefinitions
 public boolean supportsSchemasInIndexDefinitions() throws SQLException
 o supportsSchemasInPrivilegeDefinitions
 public boolean supportsSchemasInPrivilegeDefinitions() throws SQLException
 o supportsCatalogsInDataManipulation
 public boolean supportsCatalogsInDataManipulation() throws SQLException
 o supportsCatalogsInProcedureCalls
 public boolean supportsCatalogsInProcedureCalls() throws SQLException
 o supportsCatalogsInTableDefinitions
 public boolean supportsCatalogsInTableDefinitions() throws SQLException
 o supportsCatalogsInIndexDefinitions
 public boolean supportsCatalogsInIndexDefinitions() throws SQLException
 o supportsCatalogsInPrivilegeDefinitions
 public boolean supportsCatalogsInPrivilegeDefinitions() throws SQLException
 o supportsPositionedDelete
 public boolean supportsPositionedDelete() throws SQLException
 o supportsPositionedUpdate
 public boolean supportsPositionedUpdate() throws SQLException
 o supportsSelectForUpdate
 public boolean supportsSelectForUpdate() throws SQLException
 o supportsStoredProcedures
 public boolean supportsStoredProcedures() throws SQLException
 o supportsSubqueriesInComparisons
 public boolean supportsSubqueriesInComparisons() throws SQLException
 o supportsSubqueriesInExists
 public boolean supportsSubqueriesInExists() throws SQLException
 o supportsSubqueriesInIns
 public boolean supportsSubqueriesInIns() throws SQLException
 o supportsSubqueriesInQuantifieds
 public boolean supportsSubqueriesInQuantifieds() throws SQLException
 o supportsCorrelatedSubqueries
 public boolean supportsCorrelatedSubqueries() throws SQLException
 o supportsUnion
 public boolean supportsUnion() throws SQLException
 o supportsUnionAll
 public boolean supportsUnionAll() throws SQLException
 o supportsOpenCursorsAcrossCommit
 public boolean supportsOpenCursorsAcrossCommit() throws SQLException
 o supportsOpenCursorsAcrossRollback
 public boolean supportsOpenCursorsAcrossRollback() throws SQLException
 o supportsOpenStatementsAcrossCommit
 public boolean supportsOpenStatementsAcrossCommit() throws SQLException
 o supportsOpenStatementsAcrossRollback
 public boolean supportsOpenStatementsAcrossRollback() throws SQLException
 o getMaxBinaryLiteralLength
 public int getMaxBinaryLiteralLength() throws SQLException
 o getMaxCharLiteralLength
 public int getMaxCharLiteralLength() throws SQLException
 o getMaxColumnNameLength
 public int getMaxColumnNameLength() throws SQLException
 o getMaxColumnsInGroupBy
 public int getMaxColumnsInGroupBy() throws SQLException
 o getMaxColumnsInIndex
 public int getMaxColumnsInIndex() throws SQLException
 o getMaxColumnsInOrderBy
 public int getMaxColumnsInOrderBy() throws SQLException
 o getMaxColumnsInSelect
 public int getMaxColumnsInSelect() throws SQLException
 o getMaxColumnsInTable
 public int getMaxColumnsInTable() throws SQLException
 o getMaxConnections
 public int getMaxConnections() throws SQLException
 o getMaxCursorNameLength
 public int getMaxCursorNameLength() throws SQLException
 o getMaxIndexLength
 public int getMaxIndexLength() throws SQLException
 o getMaxSchemaNameLength
 public int getMaxSchemaNameLength() throws SQLException
 o getMaxProcedureNameLength
 public int getMaxProcedureNameLength() throws SQLException
 o getMaxCatalogNameLength
 public int getMaxCatalogNameLength() throws SQLException
 o getMaxRowSize
 public int getMaxRowSize() throws SQLException
 o doesMaxRowSizeIncludeBlobs
 public boolean doesMaxRowSizeIncludeBlobs() throws SQLException
 o getMaxStatementLength
 public int getMaxStatementLength() throws SQLException
 o getMaxStatements
 public int getMaxStatements() throws SQLException
 o getMaxTableNameLength
 public int getMaxTableNameLength() throws SQLException
 o getMaxTablesInSelect
 public int getMaxTablesInSelect() throws SQLException
 o getMaxUserNameLength
 public int getMaxUserNameLength() throws SQLException
 o getDefaultTransactionIsolation
 public int getDefaultTransactionIsolation() throws SQLException
 o supportsTransactions
 public boolean supportsTransactions() throws SQLException
 o supportsTransactionIsolationLevel
 public boolean supportsTransactionIsolationLevel(int level) throws SQLException
 o supportsDataDefinitionAndDataManipulationTransactions
 public boolean supportsDataDefinitionAndDataManipulationTransactions() throws SQLException
 o supportsDataManipulationTransactionsOnly
 public boolean supportsDataManipulationTransactionsOnly() throws SQLException
 o dataDefinitionCausesTransactionCommit
 public boolean dataDefinitionCausesTransactionCommit() throws SQLException
 o dataDefinitionIgnoredInTransactions
 public boolean dataDefinitionIgnoredInTransactions() throws SQLException
 o getProcedures
 public ResultSet getProcedures(String catalog,
                                String schemaPattern,
                                String procedureNamePattern) throws SQLException
 o getProcedureColumns
 public ResultSet getProcedureColumns(String catalog,
                                      String schemaPattern,
                                      String procedureNamePattern,
                                      String columnNamePattern) throws SQLException
 o getTables
 public ResultSet getTables(String ct,
                            String sch,
                            String tn,
                            String typs[]) throws SQLException
This method is used by MsqlDatabaseMetaData to grab table information from the database.

Returns:
the tables in the database in the form of a result set
Throws: SQLException
an error occurred retrieving the tables
 o getSchemas
 public ResultSet getSchemas() throws SQLException
 o getCatalogs
 public ResultSet getCatalogs() throws SQLException
 o getTableTypes
 public ResultSet getTableTypes() throws SQLException
 o getColumns
 public ResultSet getColumns(String ct,
                             String sch,
                             String tn,
                             String col) throws SQLException
Provides column information for the specified table from the database. The implementation for this method was provided by Brian Jepson.

Parameters:
ct - catalog name--not yet supported
sch - schema name, should be null for mSQL
tn - the name of the table whose columns are being sought
col - a search string on the column name, null for all columns
Returns:
the columns for a specific table in the form of a result set
 o getColumnPrivileges
 public ResultSet getColumnPrivileges(String ct,
                                      String sch,
                                      String tn,
                                      String cn) throws SQLException
 o getTablePrivileges
 public ResultSet getTablePrivileges(String ct,
                                     String sch,
                                     String tn) throws SQLException
 o getBestRowIdentifier
 public ResultSet getBestRowIdentifier(String ct,
                                       String sch,
                                       String t,
                                       int scope,
                                       boolean nullable) throws SQLException
 o getVersionColumns
 public ResultSet getVersionColumns(String ct,
                                    String sch,
                                    String t) throws SQLException
 o getPrimaryKeys
 public ResultSet getPrimaryKeys(String ct,
                                 String sch,
                                 String t) throws SQLException
This method is used by MsqlDatabaseMetaData to grab column information from the database. The result set is kind of weird - each row has one column (DATA). The first row is the index type, and the remaining rows correspond to each column in the index expression.

Returns:
the primary key information the form of a result set
 o getImportedKeys
 public ResultSet getImportedKeys(String ct,
                                  String sch,
                                  String t) throws SQLException
 o getExportedKeys
 public ResultSet getExportedKeys(String ct,
                                  String sch,
                                  String t) throws SQLException
 o getCrossReference
 public ResultSet getCrossReference(String pcat,
                                    String pschem,
                                    String ptable,
                                    String fcat,
                                    String fschem,
                                    String ftable) throws SQLException
 o getTypeInfo
 public ResultSet getTypeInfo() throws SQLException
 o getIndexInfo
 public ResultSet getIndexInfo(String catalog,
                               String schema,
                               String table,
                               boolean unique,
                               boolean approximate) throws SQLException
 o getUDTs
 public ResultSet getUDTs(String catalog,
                          String schema,
                          String tn,
                          int types[]) throws SQLException
 o insertsAreDetected
 public boolean insertsAreDetected(int type) throws SQLException
 o othersDeletesAreVisible
 public boolean othersDeletesAreVisible(int type) throws SQLException
 o othersInsertsAreVisible
 public boolean othersInsertsAreVisible(int type) throws SQLException
 o othersUpdatesAreVisible
 public boolean othersUpdatesAreVisible(int type) throws SQLException
 o ownDeletesAreVisible
 public boolean ownDeletesAreVisible(int type) throws SQLException
 o ownInsertsAreVisible
 public boolean ownInsertsAreVisible(int type) throws SQLException
 o ownUpdatesAreVisible
 public boolean ownUpdatesAreVisible(int type) throws SQLException
 o supportsBatchUpdates
 public boolean supportsBatchUpdates() throws SQLException
 o supportsResultSetConcurrency
 public boolean supportsResultSetConcurrency(int type,
                                             int concur) throws SQLException
 o supportsResultSetType
 public boolean supportsResultSetType(int type) throws SQLException
 o updatesAreDetected
 public boolean updatesAreDetected(int type) throws SQLException

All Packages  Class Hierarchy  This Package  Previous  Next  Index