Logo Search packages:      
Sourcecode: mysql-connector-java version File versions

com::mysql::jdbc::DatabaseMetaData Class Reference

List of all members.


Detailed Description

JDBC Interface to Mysql functions

This class provides information about the database as a whole.

Many of the methods here return lists of information in ResultSets. You can use the normal ResultSet methods such as getString and getInt to retrieve the data from these ResultSets. If a given form of metadata is not available, these methods show throw a SQLException.

Some of these methods take arguments that are String patterns. These methods all have names such as fooPattern. Within a pattern String "%" means match any substring of 0 or more characters and "_" means match any one character.

Author:
Mark Matthews
Version:
Id
DatabaseMetaData.java,v 1.27.4.54 2005/01/25 19:11:41 mmatthew Exp

Definition at line 69 of file DatabaseMetaData.java.


Public Member Functions

boolean allProceduresAreCallable () throws SQLException
boolean allTablesAreSelectable () throws SQLException
 DatabaseMetaData (Connection connToSet, String databaseToSet)
boolean dataDefinitionCausesTransactionCommit () throws SQLException
boolean dataDefinitionIgnoredInTransactions () throws SQLException
boolean deletesAreDetected (int type) throws SQLException
boolean doesMaxRowSizeIncludeBlobs () throws SQLException
List extractForeignKeyForTable (ArrayList rows, java.sql.ResultSet rs, String catalog) throws SQLException
ResultSet extractForeignKeyFromCreateTable (java.sql.Connection connToUse, java.sql.DatabaseMetaData metadata, String catalog, String tableName) throws SQLException
java.sql.ResultSet getAttributes (String arg0, String arg1, String arg2, String arg3) throws SQLException
java.sql.ResultSet getBestRowIdentifier (String catalog, String schema, String table, int scope, boolean nullable) throws SQLException
java.sql.ResultSet getCatalogs () throws SQLException
String getCatalogSeparator () throws SQLException
String getCatalogTerm () throws SQLException
java.sql.ResultSet getColumnPrivileges (String catalog, String schema, String table, String columnNamePattern) throws SQLException
java.sql.ResultSet getColumns (String catalog, String schemaPattern, String tableName, String columnNamePattern) throws SQLException
java.sql.Connection getConnection () throws SQLException
java.sql.ResultSet getCrossReference (String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable) throws SQLException
int getDatabaseMajorVersion () throws SQLException
int getDatabaseMinorVersion () throws SQLException
String getDatabaseProductName () throws SQLException
String getDatabaseProductVersion () throws SQLException
int getDefaultTransactionIsolation () throws SQLException
int getDriverMajorVersion ()
int getDriverMinorVersion ()
String getDriverName () throws SQLException
String getDriverVersion () throws java.sql.SQLException
java.sql.ResultSet getExportedKeys (String catalog, String schema, String table) throws SQLException
String getExtraNameCharacters () throws SQLException
String getIdentifierQuoteString () throws SQLException
java.sql.ResultSet getImportedKeys (String catalog, String schema, String table) throws SQLException
java.sql.ResultSet getIndexInfo (String catalog, String schema, String table, boolean unique, boolean approximate) throws SQLException
int getJDBCMajorVersion () throws SQLException
int getJDBCMinorVersion () throws SQLException
int getMaxBinaryLiteralLength () throws SQLException
int getMaxCatalogNameLength () throws SQLException
int getMaxCharLiteralLength () throws SQLException
int getMaxColumnNameLength () throws SQLException
int getMaxColumnsInGroupBy () throws SQLException
int getMaxColumnsInIndex () throws SQLException
int getMaxColumnsInOrderBy () throws SQLException
int getMaxColumnsInSelect () throws SQLException
int getMaxColumnsInTable () throws SQLException
int getMaxConnections () throws SQLException
int getMaxCursorNameLength () throws SQLException
int getMaxIndexLength () throws SQLException
int getMaxProcedureNameLength () throws SQLException
int getMaxRowSize () throws SQLException
int getMaxSchemaNameLength () throws SQLException
int getMaxStatementLength () throws SQLException
int getMaxStatements () throws SQLException
int getMaxTableNameLength () throws SQLException
int getMaxTablesInSelect () throws SQLException
int getMaxUserNameLength () throws SQLException
String getNumericFunctions () throws SQLException
java.sql.ResultSet getPrimaryKeys (String catalog, String schema, String table) throws SQLException
java.sql.ResultSet getProcedureColumns (String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) throws SQLException
java.sql.ResultSet getProcedures (String catalog, String schemaPattern, String procedureNamePattern) throws SQLException
String getProcedureTerm () throws SQLException
int getResultSetHoldability () throws SQLException
java.sql.ResultSet getSchemas () throws SQLException
String getSchemaTerm () throws SQLException
String getSearchStringEscape () throws SQLException
String getSQLKeywords () throws SQLException
int getSQLStateType () throws SQLException
String getStringFunctions () throws SQLException
java.sql.ResultSet getSuperTables (String arg0, String arg1, String arg2) throws SQLException
java.sql.ResultSet getSuperTypes (String arg0, String arg1, String arg2) throws SQLException
String getSystemFunctions () throws SQLException
java.sql.ResultSet getTablePrivileges (String catalog, String schemaPattern, String tableNamePattern) throws SQLException
java.sql.ResultSet getTables (String catalog, String schemaPattern, String tableNamePattern, String[] types) throws SQLException
java.sql.ResultSet getTableTypes () throws SQLException
String getTimeDateFunctions () throws SQLException
java.sql.ResultSet getTypeInfo () throws SQLException
java.sql.ResultSet getUDTs (String catalog, String schemaPattern, String typeNamePattern, int[] types) throws SQLException
String getURL () throws SQLException
String getUserName () throws SQLException
java.sql.ResultSet getVersionColumns (String catalog, String schema, String table) throws SQLException
boolean insertsAreDetected (int type) throws SQLException
boolean isCatalogAtStart () throws SQLException
boolean isReadOnly () throws SQLException
boolean locatorsUpdateCopy () throws SQLException
boolean nullPlusNonNullIsNull () throws SQLException
boolean nullsAreSortedAtEnd () throws SQLException
boolean nullsAreSortedAtStart () throws SQLException
boolean nullsAreSortedHigh () throws SQLException
boolean nullsAreSortedLow () throws SQLException
boolean othersDeletesAreVisible (int type) throws SQLException
boolean othersInsertsAreVisible (int type) throws SQLException
boolean othersUpdatesAreVisible (int type) throws SQLException
boolean ownDeletesAreVisible (int type) throws SQLException
boolean ownInsertsAreVisible (int type) throws SQLException
boolean ownUpdatesAreVisible (int type) throws SQLException
boolean storesLowerCaseIdentifiers () throws SQLException
boolean storesLowerCaseQuotedIdentifiers () throws SQLException
boolean storesMixedCaseIdentifiers () throws SQLException
boolean storesMixedCaseQuotedIdentifiers () throws SQLException
boolean storesUpperCaseIdentifiers () throws SQLException
boolean storesUpperCaseQuotedIdentifiers () throws SQLException
boolean supportsAlterTableWithAddColumn () throws SQLException
boolean supportsAlterTableWithDropColumn () throws SQLException
boolean supportsANSI92EntryLevelSQL () throws SQLException
boolean supportsANSI92FullSQL () throws SQLException
boolean supportsANSI92IntermediateSQL () throws SQLException
boolean supportsBatchUpdates () throws SQLException
boolean supportsCatalogsInDataManipulation () throws SQLException
boolean supportsCatalogsInIndexDefinitions () throws SQLException
boolean supportsCatalogsInPrivilegeDefinitions () throws SQLException
boolean supportsCatalogsInProcedureCalls () throws SQLException
boolean supportsCatalogsInTableDefinitions () throws SQLException
boolean supportsColumnAliasing () throws SQLException
boolean supportsConvert (int fromType, int toType) throws SQLException
boolean supportsConvert () throws SQLException
boolean supportsCoreSQLGrammar () throws SQLException
boolean supportsCorrelatedSubqueries () throws SQLException
boolean supportsDataDefinitionAndDataManipulationTransactions () throws SQLException
boolean supportsDataManipulationTransactionsOnly () throws SQLException
boolean supportsDifferentTableCorrelationNames () throws SQLException
boolean supportsExpressionsInOrderBy () throws SQLException
boolean supportsExtendedSQLGrammar () throws SQLException
boolean supportsFullOuterJoins () throws SQLException
boolean supportsGetGeneratedKeys ()
boolean supportsGroupBy () throws SQLException
boolean supportsGroupByBeyondSelect () throws SQLException
boolean supportsGroupByUnrelated () throws SQLException
boolean supportsIntegrityEnhancementFacility () throws SQLException
boolean supportsLikeEscapeClause () throws SQLException
boolean supportsLimitedOuterJoins () throws SQLException
boolean supportsMinimumSQLGrammar () throws SQLException
boolean supportsMixedCaseIdentifiers () throws SQLException
boolean supportsMixedCaseQuotedIdentifiers () throws SQLException
boolean supportsMultipleOpenResults () throws SQLException
boolean supportsMultipleResultSets () throws SQLException
boolean supportsMultipleTransactions () throws SQLException
boolean supportsNamedParameters () throws SQLException
boolean supportsNonNullableColumns () throws SQLException
boolean supportsOpenCursorsAcrossCommit () throws SQLException
boolean supportsOpenCursorsAcrossRollback () throws SQLException
boolean supportsOpenStatementsAcrossCommit () throws SQLException
boolean supportsOpenStatementsAcrossRollback () throws SQLException
boolean supportsOrderByUnrelated () throws SQLException
boolean supportsOuterJoins () throws SQLException
boolean supportsPositionedDelete () throws SQLException
boolean supportsPositionedUpdate () throws SQLException
boolean supportsResultSetConcurrency (int type, int concurrency) throws SQLException
boolean supportsResultSetHoldability (int holdability) throws SQLException
boolean supportsResultSetType (int type) throws SQLException
boolean supportsSavepoints () throws SQLException
boolean supportsSchemasInDataManipulation () throws SQLException
boolean supportsSchemasInIndexDefinitions () throws SQLException
boolean supportsSchemasInPrivilegeDefinitions () throws SQLException
boolean supportsSchemasInProcedureCalls () throws SQLException
boolean supportsSchemasInTableDefinitions () throws SQLException
boolean supportsSelectForUpdate () throws SQLException
boolean supportsStatementPooling () throws SQLException
boolean supportsStoredProcedures () throws SQLException
boolean supportsSubqueriesInComparisons () throws SQLException
boolean supportsSubqueriesInExists () throws SQLException
boolean supportsSubqueriesInIns () throws SQLException
boolean supportsSubqueriesInQuantifieds () throws SQLException
boolean supportsTableCorrelationNames () throws SQLException
boolean supportsTransactionIsolationLevel (int level) throws SQLException
boolean supportsTransactions () throws SQLException
boolean supportsUnion () throws SQLException
boolean supportsUnionAll () throws SQLException
boolean updatesAreDetected (int type) throws SQLException
boolean usesLocalFilePerTable () throws SQLException
boolean usesLocalFiles () throws SQLException

Protected Attributes

Connection conn

Private Member Functions

java.sql.ResultSet buildResultSet (com.mysql.jdbc.Field[] fields, java.util.ArrayList rows) throws SQLException
void getCallStmtParameterTypes (String procName, String parameterNamePattern, List resultRows) throws SQLException
int getCascadeDeleteOption (String cascadeOptions)
int getCascadeUpdateOption (String cascadeOptions)
void getExportKeyResults (String catalog, String exportingTable, String keysComment, List tuples, String fkTableName) throws SQLException
int[] getForeignKeyActions (String commentString)
void getImportKeyResults (String catalog, String importingTable, String keysComment, List tuples) throws SQLException
void getResultsImpl (String catalog, String table, String keysComment, List tuples, String fkTableName, boolean isExport) throws SQLException
String getTableNameWithCase (String table)
byte[] s2b (String s)

Private Attributes

String database = null
String quotedId = null

Static Private Attributes

static final int DEFERRABILITY = 13
static final int DELETE_RULE = 10
static final int FK_NAME = 11
static final int FKCOLUMN_NAME = 7
static final int FKTABLE_CAT = 4
static final int FKTABLE_NAME = 6
static final int FKTABLE_SCHEM = 5
static final int KEY_SEQ = 8
static final int PK_NAME = 12
static final int PKCOLUMN_NAME = 3
static final int PKTABLE_CAT = 0
static final int PKTABLE_NAME = 2
static final int PKTABLE_SCHEM = 1
static final String SUPPORTS_FK = "SUPPORTS_FK"
static final byte[] TABLE_AS_BYTES = "TABLE".getBytes()
static final int UPDATE_RULE = 9
static final byte[] VIEW_AS_BYTES = "VIEW".getBytes()

Classes

class  TypeDescriptor

The documentation for this class was generated from the following file:

Generated by  Doxygen 1.6.0   Back to index