MockDatabaseMetaData

Overview

Package

Class

Use

Deprecated

Index

Home >> All >> com >> mockobjects >> [ sql overview ]

PREV CLASS NEXT CLASS

SUMMARY:

JAVADOC |

Sourc code of com.mockobjects.sql.MockDatabaseMetaData

SOURCE |

Download com.mockobjects.sql.MockDatabaseMetaData

DOWNLOAD | NESTED | FIELD | CONSTR | METHOD

DETAIL: FIELD | CONSTR | METHOD

com.mockobjects.sql
Class MockDatabaseMetaData

java.lang.Object
  com.mockobjects.MockObject
      com.mockobjects.sql.MockDatabaseMetaData

All Implemented Interfaces:: java.sql.DatabaseMetaData, com.mockobjects.Verifiable

public class MockDatabaseMetaData
extends com.mockobjects.MockObject
implements java.sql.DatabaseMetaData

Field Summary

private java.lang.String myDriverName


Fields inherited from interface java.sql.DatabaseMetaData

attributeNoNulls, attributeNullable, attributeNullableUnknown, bestRowNotPseudo, bestRowPseudo, bestRowSession, bestRowTemporary, bestRowTransaction, bestRowUnknown, columnNoNulls, columnNullable, columnNullableUnknown, importedKeyCascade, importedKeyInitiallyDeferred, importedKeyInitiallyImmediate, importedKeyNoAction, importedKeyNotDeferrable, importedKeyRestrict, importedKeySetDefault, importedKeySetNull, procedureColumnIn, procedureColumnInOut, procedureColumnOut, procedureColumnResult, procedureColumnReturn, procedureColumnUnknown, procedureNoNulls, procedureNoResult, procedureNullable, procedureNullableUnknown, procedureResultUnknown, procedureReturnsResult, sqlStateSQL99, sqlStateXOpen, tableIndexClustered, tableIndexHashed, tableIndexOther, tableIndexStatistic, typeNoNulls, typeNullable, typeNullableUnknown, typePredBasic, typePredChar, typePredNone, typeSearchable, versionColumnNotPseudo, versionColumnPseudo, versionColumnUnknown

Constructor Summary

MockDatabaseMetaData()


Method Summary

boolean allProceduresAreCallable()
          This method tests whether or not all the procedures returned by the getProcedures method can be called by this user.

boolean allTablesAreSelectable()
          This method tests whether or not all the table returned by the getTables method can be selected by this user.

boolean dataDefinitionCausesTransactionCommit()
          This method tests whether or not a DDL statement will cause the current transaction to be automatically committed.

boolean dataDefinitionIgnoredInTransactions()
          This method tests whether or not DDL statements are ignored in transactions.

boolean deletesAreDetected(int a0)
          This method tests whether or not the specified result set type can detect a visible delete by calling the rowUpdated method.

boolean doesMaxRowSizeIncludeBlobs()
          This method tests whether or not the maximum row size includes BLOB's

java.sql.ResultSet getAttributes(java.lang.String a0, java.lang.String a1, java.lang.String a2, java.lang.String a3)


java.sql.ResultSet getBestRowIdentifier(java.lang.String a0, java.lang.String a1, java.lang.String a2, int a3, boolean a4)
          This method returns the best set of columns for uniquely identifying a row.

java.sql.ResultSet getCatalogs()
          This method returns the list of database catalogs as a ResultSet with one column - TABLE_CAT - that is the name of the catalog.

java.lang.String getCatalogSeparator()
          This method returns the separator between the catalog name and the table name.

java.lang.String getCatalogTerm()
          This method returns the vendor's term for "catalog".

java.sql.ResultSet getColumnPrivileges(java.lang.String a0, java.lang.String a1, java.lang.String a2, java.lang.String a3)
          This method returns the access rights that have been granted to the requested columns.

java.sql.ResultSet getColumns(java.lang.String a0, java.lang.String a1, java.lang.String a2, java.lang.String a3)
          This method returns a list of the tables columns for the requested tables.

java.sql.Connection getConnection()
          This method returns the Connection object that was used to generate the metadata in this object.

java.sql.ResultSet getCrossReference(java.lang.String a0, java.lang.String a1, java.lang.String a2, java.lang.String a3, java.lang.String a4, java.lang.String a5)
          This method returns a description of how one table imports another table's primary key as a foreign key.

int getDatabaseMajorVersion()
          This method returns the major version number of the database.

int getDatabaseMinorVersion()
          This method returns the minor version number of the database.

java.lang.String getDatabaseProductName()
          This method returns the name of the database product.

java.lang.String getDatabaseProductVersion()
          This method returns the version of the database product.

int getDefaultTransactionIsolation()
          This method returns the default transaction isolation level of the database.

int getDriverMajorVersion()
          This method returns the major version number of the JDBC driver.

int getDriverMinorVersion()
          This method returns the minor version number of the JDBC driver.

java.lang.String getDriverName()
          This method returns the name of the JDBC driver.

java.lang.String getDriverVersion()
          This method returns the version of the JDBC driver.

java.sql.ResultSet getExportedKeys(java.lang.String a0, java.lang.String a1, java.lang.String a2)
          This method returns a list of the table's which use this table's primary key as a foreign key.

java.lang.String getExtraNameCharacters()
          This methods returns non-standard characters that can appear in unquoted identifiers.

java.lang.String getIdentifierQuoteString()
          This metohd returns the quote string for SQL identifiers.

java.sql.ResultSet getImportedKeys(java.lang.String a0, java.lang.String a1, java.lang.String a2)
          This method returns a list of the table's foreign keys.

java.sql.ResultSet getIndexInfo(java.lang.String a0, java.lang.String a1, java.lang.String a2, boolean a3, boolean a4)
          This method returns information about a tables indices and statistics.

int getJDBCMajorVersion()
          This method returns the major version number of the JDBC driver.

int getJDBCMinorVersion()
          This method returns the minor version number of the JDBC driver.

int getMaxBinaryLiteralLength()
          This method returns the number of hex characters allowed in an inline binary literal.

int getMaxCatalogNameLength()
          This method returns the maximum length of a catalog name.

int getMaxCharLiteralLength()
          This method returns the maximum length of a character literal.

int getMaxColumnNameLength()
          This method returns the maximum length of a column name.

int getMaxColumnsInGroupBy()
          This method returns the maximum number of columns in a GROUP BY statement.

int getMaxColumnsInIndex()
          This method returns the maximum number of columns in an index.

int getMaxColumnsInOrderBy()
          This method returns the maximum number of columns in an ORDER BY statement.

int getMaxColumnsInSelect()
          This method returns the maximum number of columns in a SELECT statement.

int getMaxColumnsInTable()
          This method returns the maximum number of columns in a table.

int getMaxConnections()
          This method returns the maximum number of connections this client can have to the database.

int getMaxCursorNameLength()
          This method returns the maximum length of a cursor name.

int getMaxIndexLength()
          This method returns the maximum length of an index.

int getMaxProcedureNameLength()
          This method returns the maximum length of a procedure name.

int getMaxRowSize()
          This method returns the maximum size of a row in bytes.

int getMaxSchemaNameLength()
          This method returns the maximum length of a schema name.

int getMaxStatementLength()
          This method includes the maximum length of a SQL statement.

int getMaxStatements()
          This method returns the maximum number of statements that can be active at any time.

int getMaxTableNameLength()
          This method returns the maximum length of a table name.

int getMaxTablesInSelect()
          This method returns the maximum number of tables that may be referenced in a SELECT statement.

int getMaxUserNameLength()
          This method returns the maximum length of a user name.

java.lang.String getNumericFunctions()
          This method returns a comma separated list of math functions.

java.sql.ResultSet getPrimaryKeys(java.lang.String a0, java.lang.String a1, java.lang.String a2)
          This method returns a list of a table's primary key columns.

java.sql.ResultSet getProcedureColumns(java.lang.String a0, java.lang.String a1, java.lang.String a2, java.lang.String a3)
          This method returns a list of the parameter and result columns for the requested stored procedures.

java.sql.ResultSet getProcedures(java.lang.String a0, java.lang.String a1, java.lang.String a2)
          This method returns a list of all the stored procedures matching the specified pattern in the given schema and catalog.

java.lang.String getProcedureTerm()
          This method returns the vendor's term for "procedure".

int getResultSetHoldability()
          This method returns the default holdability type of ResultSetS retrieved from this database.

java.sql.ResultSet getSchemas()
          This method returns the list of database schemas as a ResultSet, with one column - TABLE_SCHEM - that is the name of the schema.

java.lang.String getSchemaTerm()
          This method returns the vendor's term for "schema".

java.lang.String getSearchStringEscape()
          This method returns the string used to escape wildcards in search strings.

java.lang.String getSQLKeywords()
          This method returns a comma separated list of all the SQL keywords in the database that are not in SQL92.

int getSQLStateType()


java.lang.String getStringFunctions()
          This method returns a comma separated list of string functions.

java.sql.ResultSet getSuperTables(java.lang.String a0, java.lang.String a1, java.lang.String a2)


java.sql.ResultSet getSuperTypes(java.lang.String a0, java.lang.String a1, java.lang.String a2)


java.lang.String getSystemFunctions()
          This method returns a comma separated list of of system functions.

java.sql.ResultSet getTablePrivileges(java.lang.String a0, java.lang.String a1, java.lang.String a2)
          This method returns the access rights that have been granted to the requested tables.

java.sql.ResultSet getTables(java.lang.String a0, java.lang.String a1, java.lang.String a2, java.lang.String[] a3)
          This method returns a list of the requested table as a ResultSet with the following columns: TABLE_CAT - The catalog the table is in, which may be null. TABLE_SCHEM - The schema the table is in, which may be null. TABLE_NAME - The name of the table. TABLE_TYPE - A string describing the table type.

java.sql.ResultSet getTableTypes()
          This method returns the list of database table types as a ResultSet with one column - TABLE_TYPE - that is the name of the table type.

java.lang.String getTimeDateFunctions()
          This method returns comma separated list of time/date functions.

java.sql.ResultSet getTypeInfo()
          This method returns a list of the SQL types supported by this database.

java.sql.ResultSet getUDTs(java.lang.String a0, java.lang.String a1, java.lang.String a2, int[] a3)
          This method returns the list of user defined data types in use.

java.lang.String getURL()
          This method returns the URL for this database.

java.lang.String getUserName()
          This method returns the database username for this connection.

java.sql.ResultSet getVersionColumns(java.lang.String a0, java.lang.String a1, java.lang.String a2)
          This method returns the set of columns that are automatically updated when the row is update.

boolean insertsAreDetected(int a0)
          This method tests whether or not the specified result set type can detect a visible insert by calling the rowUpdated method.

boolean isCatalogAtStart()
          This method tests whether a catalog name appears at the beginning of a fully qualified table name.

boolean isReadOnly()
          This method tests whether or not the database is in read only mode.

boolean locatorsUpdateCopy()


boolean nullPlusNonNullIsNull()
          This method tests whether the concatenation of a NULL and non-NULL value results in a NULL.

boolean nullsAreSortedAtEnd()
          This method test whether or not NULL's are sorted to the end of the list regardless of ascending or descending sort order.

boolean nullsAreSortedAtStart()
          This method tests whether or not NULL's sort as high values.

boolean nullsAreSortedHigh()
          This method tests whether or not NULL's sort as high values.

boolean nullsAreSortedLow()
          This method tests whether or not NULL's sort as low values.

boolean othersDeletesAreVisible(int a0)
          This method tests whether or not the specified result set type sees deletes committed by others.

boolean othersInsertsAreVisible(int a0)
          This method tests whether or not the specified result set type sees inserts committed by others.

boolean othersUpdatesAreVisible(int a0)
          This method tests whether or not the specified result set type sees updates committed by others.

boolean ownDeletesAreVisible(int a0)
          This method tests whether or not the specified result set type sees its own deletes.

boolean ownInsertsAreVisible(int a0)
          This method tests whether or not the specified result set type sees its own inserts.

boolean ownUpdatesAreVisible(int a0)
          This method tests whether or not the specified result set type sees its own updates.

void setupDriverName(java.lang.String driverName)


boolean storesLowerCaseIdentifiers()
          This method tests whether or not the database treats mixed case identifiers as all lower case.

boolean storesLowerCaseQuotedIdentifiers()
          This method tests whether or not the database treats mixed case quoted identifiers as all lower case.

boolean storesMixedCaseIdentifiers()
          This method tests whether or not the database stores mixed case identifers even if it treats them as case insensitive.

boolean storesMixedCaseQuotedIdentifiers()
          This method tests whether or not the database stores mixed case quoted identifers even if it treats them as case insensitive.

boolean storesUpperCaseIdentifiers()
          This method tests whether or not the database treats mixed case identifiers as all upper case.

boolean storesUpperCaseQuotedIdentifiers()
          This method tests whether or not the database treats mixed case quoted identifiers as all upper case.

boolean supportsAlterTableWithAddColumn()
          This method tests whether or not the database supports "ALTER TABLE ADD COLUMN"

boolean supportsAlterTableWithDropColumn()
          This method tests whether or not the database supports "ALTER TABLE DROP COLUMN"

boolean supportsANSI92EntryLevelSQL()
          This method tests whether or not the ANSI92 entry level SQL grammar is supported.

boolean supportsANSI92FullSQL()
          This method tests whether or not the ANSI92 full SQL grammar is supported.

boolean supportsANSI92IntermediateSQL()
          This method tests whether or not the ANSI92 intermediate SQL grammar is supported.

boolean supportsBatchUpdates()
          This method tests whether or not the database supports batch updates.

boolean supportsCatalogsInDataManipulation()
          This method tests whether a catalog name can appear in a data manipulation statement.

boolean supportsCatalogsInIndexDefinitions()
          This method tests whether a catalog name can appear in an index definition.

boolean supportsCatalogsInPrivilegeDefinitions()
          This method tests whether a catalog name can appear in privilege definitions.

boolean supportsCatalogsInProcedureCalls()
          This method tests whether a catalog name can appear in a procedure call

boolean supportsCatalogsInTableDefinitions()
          This method tests whether a catalog name can appear in a table definition.

boolean supportsColumnAliasing()
          This method tests whether or not column aliasing is supported.

boolean supportsConvert()
          Tests whether or not CONVERT is supported.

boolean supportsConvert(int a0, int a1)
          This method tests whether or not CONVERT can be performed between the specified types.

boolean supportsCoreSQLGrammar()
          This method tests whether or not the core grammer for ODBC is supported.

boolean supportsCorrelatedSubqueries()
          This method test whether or not correlated subqueries are allowed.

boolean supportsDataDefinitionAndDataManipulationTransactions()
          This method tests whether or not DDL and DML statements allowed within the same transaction.

boolean supportsDataManipulationTransactionsOnly()
          This method tests whether or not only DML statement are allowed inside a transaction.

boolean supportsDifferentTableCorrelationNames()
          This method tests whether correlation names must be different from the name of the table.

boolean supportsExpressionsInOrderBy()
          This method tests whether or not expressions are allowed in an ORDER BY lists.

boolean supportsExtendedSQLGrammar()
          This method tests whether or not the extended grammer for ODBC is supported.

boolean supportsFullOuterJoins()
          This method tests whether or not the database supports full outer joins.

boolean supportsGetGeneratedKeys()


boolean supportsGroupBy()
          This method tests whether or not GROUP BY is supported.

boolean supportsGroupByBeyondSelect()
          This method tests whether or not a GROUP BY can add columns not in the select if it includes all the columns in the select.

boolean supportsGroupByUnrelated()
          This method tests whether GROUP BY on a non-selected column is allowed.

boolean supportsIntegrityEnhancementFacility()
          This method tests whether or not the SQL integrity enhancement facility is supported.

boolean supportsLikeEscapeClause()
          This method tests whether or not the escape character is supported in LIKE expressions.

boolean supportsLimitedOuterJoins()
          This method tests whether or not the database supports limited outer joins.

boolean supportsMinimumSQLGrammar()
          This method tests whether or not the minimum grammer for ODBC is supported.

boolean supportsMixedCaseIdentifiers()
          This method tests whether or not the database supports identifiers with mixed case.

boolean supportsMixedCaseQuotedIdentifiers()
          This method tests whether or not the database supports quoted identifiers with mixed case.

boolean supportsMultipleOpenResults()
          This method tests whether the database supports returning multiple ResultSetS from a CallableStatement at once.

boolean supportsMultipleResultSets()
          This method tests whether multiple result sets for a single statement are supported.

boolean supportsMultipleTransactions()
          This method test whether or not multiple transactions may be open at once, as long as they are on different connections.

boolean supportsNamedParameters()
          This method tests whether the database supports named parameters.

boolean supportsNonNullableColumns()
          This method tests whether or not columns can be defined as NOT NULL.

boolean supportsOpenCursorsAcrossCommit()
          This method tests whether or not the database supports cursors remaining open across commits.

boolean supportsOpenCursorsAcrossRollback()
          This method tests whether or not the database supports cursors remaining open across rollbacks.

boolean supportsOpenStatementsAcrossCommit()
          This method tests whether or not the database supports statements remaining open across commits.

boolean supportsOpenStatementsAcrossRollback()
          This method tests whether or not the database supports statements remaining open across rollbacks.

boolean supportsOrderByUnrelated()
          This method tests whether or ORDER BY on a non-selected column is allowed.

boolean supportsOuterJoins()
          This method tests whether or not the database supports outer joins.

boolean supportsPositionedDelete()
          This method tests whether or not that database supports positioned deletes.

boolean supportsPositionedUpdate()
          This method tests whether or not that database supports positioned updates.

boolean supportsResultSetConcurrency(int a0, int a1)
          This method tests whether the specified result set type and result set concurrency type are supported by the database.

boolean supportsResultSetHoldability(int a0)
          This method tests if the database supports the specified holdability type.

boolean supportsResultSetType(int a0)
          This method tests whether or not the datbase supports the specified result type.

boolean supportsSavepoints()
          This method tests whether the databse supports savepoints.

boolean supportsSchemasInDataManipulation()
          This method tests whether a catalog name can appear in a data manipulation statement.

boolean supportsSchemasInIndexDefinitions()
          This method tests whether a catalog name can appear in an index definition.

boolean supportsSchemasInPrivilegeDefinitions()
          This method tests whether a catalog name can appear in privilege definitions.

boolean supportsSchemasInProcedureCalls()
          This method tests whether a catalog name can appear in a procedure call

boolean supportsSchemasInTableDefinitions()
          This method tests whether a catalog name can appear in a table definition.

boolean supportsSelectForUpdate()
          This method tests whether or not SELECT FOR UPDATE is supported by the database.

boolean supportsStatementPooling()


boolean supportsStoredProcedures()
          This method tests whether or not stored procedures are supported on this database.

boolean supportsSubqueriesInComparisons()
          This method tests whether or not subqueries are allowed in comparisons.

boolean supportsSubqueriesInExists()
          This method tests whether or not subqueries are allowed in exists expressions.

boolean supportsSubqueriesInIns()
          This method tests whether subqueries are allowed in IN statements.

boolean supportsSubqueriesInQuantifieds()
          This method tests whether or not subqueries are allowed in quantified expressions.

boolean supportsTableCorrelationNames()
          This method tests whether or not table correlation names are supported.

boolean supportsTransactionIsolationLevel(int a0)
          This method tests whether or not the database supports the specified transaction isolation level.

boolean supportsTransactions()
          This method tests whether or not the database supports transactions.

boolean supportsUnion()
          This method tests whether or not the UNION statement is supported.

boolean supportsUnionAll()
          This method tests whether or not the UNION ALL statement is supported.

boolean updatesAreDetected(int a0)
          This method tests whether or not the specified result set type can detect a visible update by calling the rowUpdated method.

boolean usesLocalFilePerTable()
          This method tests whether or not the database uses a separate file for each table.

boolean usesLocalFiles()
          This method tests whether or not the database uses local files to store tables.

Methods inherited from class com.mockobjects.MockObject

assertEquals, assertEquals, assertTrue, fail, notImplemented, notYetImplemented, notYetImplemented, verify

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

myDriverName

private java.lang.String myDriverName

Constructor Detail

MockDatabaseMetaData

public MockDatabaseMetaData()

Method Detail

setupDriverName

public void setupDriverName(java.lang.String driverName)

supportsANSI92FullSQL

public boolean supportsANSI92FullSQL()
                              throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method tests whether or not the ANSI92 full SQL grammar is supported.

Specified by:: supportsANSI92FullSQL in interface java.sql.DatabaseMetaData

supportsANSI92EntryLevelSQL

public boolean supportsANSI92EntryLevelSQL()
                                    throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method tests whether or not the ANSI92 entry level SQL grammar is supported. A fully JDBC compliant drivers must return true.

Specified by:: supportsANSI92EntryLevelSQL in interface java.sql.DatabaseMetaData

supportsStatementPooling

public boolean supportsStatementPooling()
                                 throws java.sql.SQLException

Specified by:: supportsStatementPooling in interface java.sql.DatabaseMetaData

supportsMixedCaseQuotedIdentifiers

public boolean supportsMixedCaseQuotedIdentifiers()
                                           throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method tests whether or not the database supports quoted identifiers with mixed case.

Specified by:: supportsMixedCaseQuotedIdentifiers in interface java.sql.DatabaseMetaData

supportsSubqueriesInComparisons

public boolean supportsSubqueriesInComparisons()
                                        throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method tests whether or not subqueries are allowed in comparisons. A fully JDBC compliant driver will always return true.

Specified by:: supportsSubqueriesInComparisons in interface java.sql.DatabaseMetaData

supportsMultipleOpenResults

public boolean supportsMultipleOpenResults()
                                    throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method tests whether the database supports returning multiple ResultSetS from a CallableStatement at once.

Specified by:: supportsMultipleOpenResults in interface java.sql.DatabaseMetaData

getProcedures

public java.sql.ResultSet getProcedures(java.lang.String a0,
                                        java.lang.String a1,
                                        java.lang.String a2)
                                 throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method returns a list of all the stored procedures matching the specified pattern in the given schema and catalog. This is returned a ResultSet with 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, or procedureReturnsResult).

Specified by:: getProcedures in interface java.sql.DatabaseMetaData

getSystemFunctions

public java.lang.String getSystemFunctions()
                                    throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method returns a comma separated list of of system functions.

Specified by:: getSystemFunctions in interface java.sql.DatabaseMetaData

supportsUnionAll

public boolean supportsUnionAll()
                         throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method tests whether or not the UNION ALL statement is supported.

Specified by:: supportsUnionAll in interface java.sql.DatabaseMetaData

getDatabaseMinorVersion

public int getDatabaseMinorVersion()
                            throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method returns the minor version number of the database.

Specified by:: getDatabaseMinorVersion in interface java.sql.DatabaseMetaData

supportsResultSetConcurrency

public boolean supportsResultSetConcurrency(int a0,
                                            int a1)
                                     throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method tests whether the specified result set type and result set concurrency type are supported by the database.

Specified by:: supportsResultSetConcurrency in interface java.sql.DatabaseMetaData

getCatalogs

public java.sql.ResultSet getCatalogs()
                               throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method returns the list of database catalogs as a ResultSet with one column - TABLE_CAT - that is the name of the catalog.

Specified by:: getCatalogs in interface java.sql.DatabaseMetaData

usesLocalFilePerTable

public boolean usesLocalFilePerTable()
                              throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method tests whether or not the database uses a separate file for each table.

Specified by:: usesLocalFilePerTable in interface java.sql.DatabaseMetaData

supportsResultSetHoldability

public boolean supportsResultSetHoldability(int a0)
                                     throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method tests if the database supports the specified holdability type. Valid values for this parameter are specified in the ResultSet class.

Specified by:: supportsResultSetHoldability in interface java.sql.DatabaseMetaData

getIndexInfo

public java.sql.ResultSet getIndexInfo(java.lang.String a0,
                                       java.lang.String a1,
                                       java.lang.String a2,
                                       boolean a3,
                                       boolean a4)
                                throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method returns information about a tables indices and statistics. It is returned as a ResultSet with 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, or tableIndexOther).
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 null if 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:: getIndexInfo in interface java.sql.DatabaseMetaData

supportsExpressionsInOrderBy

public boolean supportsExpressionsInOrderBy()
                                     throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method tests whether or not expressions are allowed in an ORDER BY lists.

Specified by:: supportsExpressionsInOrderBy in interface java.sql.DatabaseMetaData

getDatabaseProductName

public java.lang.String getDatabaseProductName()
                                        throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method returns the name of the database product.

Specified by:: getDatabaseProductName in interface java.sql.DatabaseMetaData

supportsIntegrityEnhancementFacility

public boolean supportsIntegrityEnhancementFacility()
                                             throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method tests whether or not the SQL integrity enhancement facility is supported.

Specified by:: supportsIntegrityEnhancementFacility in interface java.sql.DatabaseMetaData

getMaxBinaryLiteralLength

public int getMaxBinaryLiteralLength()
                              throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method returns the number of hex characters allowed in an inline binary literal.

Specified by:: getMaxBinaryLiteralLength in interface java.sql.DatabaseMetaData

supportsLimitedOuterJoins

public boolean supportsLimitedOuterJoins()
                                  throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method tests whether or not the database supports limited outer joins.

Specified by:: supportsLimitedOuterJoins in interface java.sql.DatabaseMetaData

storesUpperCaseQuotedIdentifiers

public boolean storesUpperCaseQuotedIdentifiers()
                                         throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method tests whether or not the database treats mixed case quoted identifiers as all upper case.

Specified by:: storesUpperCaseQuotedIdentifiers in interface java.sql.DatabaseMetaData

supportsMultipleResultSets

public boolean supportsMultipleResultSets()
                                   throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method tests whether multiple result sets for a single statement are supported.

Specified by:: supportsMultipleResultSets in interface java.sql.DatabaseMetaData

supportsFullOuterJoins

public boolean supportsFullOuterJoins()
                               throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method tests whether or not the database supports full outer joins.

Specified by:: supportsFullOuterJoins in interface java.sql.DatabaseMetaData

ownDeletesAreVisible

public boolean ownDeletesAreVisible(int a0)
                             throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method tests whether or not the specified result set type sees its own deletes.

Specified by:: ownDeletesAreVisible in interface java.sql.DatabaseMetaData

getPrimaryKeys

public java.sql.ResultSet getPrimaryKeys(java.lang.String a0,
                                         java.lang.String a1,
                                         java.lang.String a2)
                                  throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method returns a list of a table's primary key columns. These are returned as a ResultSet with 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:: getPrimaryKeys in interface java.sql.DatabaseMetaData

getMaxColumnsInIndex

public int getMaxColumnsInIndex()
                         throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method returns the maximum number of columns in an index.

Specified by:: getMaxColumnsInIndex in interface java.sql.DatabaseMetaData

getExportedKeys

public java.sql.ResultSet getExportedKeys(java.lang.String a0,
                                          java.lang.String a1,
                                          java.lang.String a2)
                                   throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method returns a list of the table's which use this table's primary key as a foreign key. The information is returned as a ResultSet with 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, or importedKeyRestrict).
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, or importedKeySetDefault)
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, or importedKeyNotDeferrable).

Specified by:: getExportedKeys in interface java.sql.DatabaseMetaData

locatorsUpdateCopy

public boolean locatorsUpdateCopy()
                           throws java.sql.SQLException

Specified by:: locatorsUpdateCopy in interface java.sql.DatabaseMetaData

getTables

public java.sql.ResultSet getTables(java.lang.String a0,
                                    java.lang.String a1,
                                    java.lang.String a2,
                                    java.lang.String[] a3)
                             throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method returns a list of the requested table as a ResultSet with the following columns:

TABLE_CAT - The catalog the table is in, which may be null.
TABLE_SCHEM - The schema the table is in, which may be null.
TABLE_NAME - The name of the table.
TABLE_TYPE - A string describing the table type. This will be one of the values returned by the getTableTypes() method.
REMARKS - Comments about the table.

Specified by:: getTables in interface java.sql.DatabaseMetaData

getMaxColumnsInTable

public int getMaxColumnsInTable()
                         throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method returns the maximum number of columns in a table.

Specified by:: getMaxColumnsInTable in interface java.sql.DatabaseMetaData

getDriverVersion

public java.lang.String getDriverVersion()
                                  throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method returns the version of the JDBC driver.

Specified by:: getDriverVersion in interface java.sql.DatabaseMetaData

supportsBatchUpdates

public boolean supportsBatchUpdates()
                             throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method tests whether or not the database supports batch updates.

Specified by:: supportsBatchUpdates in interface java.sql.DatabaseMetaData

getMaxTablesInSelect

public int getMaxTablesInSelect()
                         throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method returns the maximum number of tables that may be referenced in a SELECT statement.

Specified by:: getMaxTablesInSelect in interface java.sql.DatabaseMetaData

getConnection

public java.sql.Connection getConnection()
                                  throws java.sql.SQLException

Description copied from interface: java.sql.DatabaseMetaData

This method returns the Connection object that was used to generate the metadata in this object.

Specified by:

com.mockobjects.sql Class MockDatabaseMetaData

myDriverName

MockDatabaseMetaData

setupDriverName

supportsANSI92FullSQL

supportsANSI92EntryLevelSQL

supportsStatementPooling

supportsMixedCaseQuotedIdentifiers

supportsSubqueriesInComparisons

supportsMultipleOpenResults

getProcedures

getSystemFunctions

supportsUnionAll

getDatabaseMinorVersion

supportsResultSetConcurrency

getCatalogs

usesLocalFilePerTable

supportsResultSetHoldability

getIndexInfo

supportsExpressionsInOrderBy

getDatabaseProductName

supportsIntegrityEnhancementFacility

getMaxBinaryLiteralLength

supportsLimitedOuterJoins

storesUpperCaseQuotedIdentifiers

supportsMultipleResultSets

supportsFullOuterJoins

ownDeletesAreVisible

getPrimaryKeys

getMaxColumnsInIndex

getExportedKeys

locatorsUpdateCopy

getTables

getMaxColumnsInTable

getDriverVersion

supportsBatchUpdates

getMaxTablesInSelect

getConnection

com.mockobjects.sql
Class MockDatabaseMetaData