TestJdbc20.java example

Explorer
open-mika-master
/*
 * Test java.sql.DatabaseMetaData
 *
 * Copyright (c) 1998
 *      Transvirtual Technologies, Inc.  All rights reserved.
 * Copyright (c) 1999 Aaron M. Renn (arenn@urbanophile.com)
 *
 * See the file "COPYING" for information on usage and redistribution
 * of this file.
 */

// Tags: JDK1.2 JDBC2.0

package gnu.testlet.wonka.sql.DatabaseMetaData;

import java.sql.*;
import gnu.testlet.Testlet;
import gnu.testlet.TestHarness;

public class TestJdbc20 implements Testlet, DatabaseMetaData
{

public void
test(TestHarness harness)
{
  harness.check(java.sql.DatabaseMetaData.procedureResultUnknown, 0);
  harness.check(java.sql.DatabaseMetaData.procedureNoResult, 1);
  harness.check(java.sql.DatabaseMetaData.procedureReturnsResult, 2);

  harness.check(java.sql.DatabaseMetaData.procedureColumnUnknown, 0);
  harness.check(java.sql.DatabaseMetaData.procedureColumnIn, 1);
  harness.check(java.sql.DatabaseMetaData.procedureColumnInOut, 2);
  harness.check(java.sql.DatabaseMetaData.procedureColumnOut, 4);
  harness.check(java.sql.DatabaseMetaData.procedureColumnReturn, 5);
  harness.check(java.sql.DatabaseMetaData.procedureColumnResult, 3);

  harness.check(java.sql.DatabaseMetaData.procedureNoNulls, 0);
  harness.check(java.sql.DatabaseMetaData.procedureNullable, 1);
  harness.check(java.sql.DatabaseMetaData.procedureNullableUnknown, 2);

  harness.check(java.sql.DatabaseMetaData.columnNoNulls, 0);
  harness.check(java.sql.DatabaseMetaData.columnNullable, 1);
  harness.check(java.sql.DatabaseMetaData.columnNullableUnknown, 2);

  harness.check(java.sql.DatabaseMetaData.bestRowTemporary, 0);
  harness.check(java.sql.DatabaseMetaData.bestRowTransaction, 1);
  harness.check(java.sql.DatabaseMetaData.bestRowSession, 2);

  harness.check(java.sql.DatabaseMetaData.bestRowUnknown, 0);
  harness.check(java.sql.DatabaseMetaData.bestRowNotPseudo, 1);
  harness.check(java.sql.DatabaseMetaData.bestRowPseudo, 2);

  harness.check(java.sql.DatabaseMetaData.versionColumnUnknown, 0);
  harness.check(java.sql.DatabaseMetaData.versionColumnNotPseudo, 1);
  harness.check(java.sql.DatabaseMetaData.versionColumnPseudo, 2);

  harness.check(java.sql.DatabaseMetaData.importedKeyCascade, 0);
  harness.check(java.sql.DatabaseMetaData.importedKeyRestrict, 1);
  harness.check(java.sql.DatabaseMetaData.importedKeySetNull, 2);
  harness.check(java.sql.DatabaseMetaData.importedKeyNoAction, 3);
  harness.check(java.sql.DatabaseMetaData.importedKeySetDefault, 4);
  harness.check(java.sql.DatabaseMetaData.importedKeyInitiallyDeferred, 5);
  harness.check(java.sql.DatabaseMetaData.importedKeyInitiallyImmediate, 6);
  harness.check(java.sql.DatabaseMetaData.importedKeyNotDeferrable, 7);

  harness.check(java.sql.DatabaseMetaData.typeNoNulls, 0);
  harness.check(java.sql.DatabaseMetaData.typeNullable, 1);
  harness.check(java.sql.DatabaseMetaData.typeNullableUnknown, 2);
  harness.check(java.sql.DatabaseMetaData.typePredNone, 0);
  harness.check(java.sql.DatabaseMetaData.typePredChar, 1);
  harness.check(java.sql.DatabaseMetaData.typePredBasic, 2);
  harness.check(java.sql.DatabaseMetaData.typeSearchable, 3);

  harness.check(java.sql.DatabaseMetaData.tableIndexStatistic, 0);
  harness.check(java.sql.DatabaseMetaData.tableIndexClustered, 1);
  harness.check(java.sql.DatabaseMetaData.tableIndexHashed, 2);
  harness.check(java.sql.DatabaseMetaData.tableIndexOther, 3);
}

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

} // class TestJdbc10