org.apache.derbyTesting.functionTests.tests.lang

Class OptionalToolsTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.functionTests.tests.lang.GeneratedColumnsHelper

org.apache.derbyTesting.functionTests.tests.lang.OptionalToolsTest

All Implemented Interfaces:

junit.framework.Test

public class OptionalToolsTest
extends GeneratedColumnsHelper

Test optional tools. See DERBY-6022.

Field Summary

Fields

Modifier and Type	Field and Description
private static java.lang.String	ALICE
private static java.lang.String	FOREIGN_DB
private static java.lang.String	FRANK
private static java.lang.String[]	LEGAL_USERS
protected static java.lang.String	MISSING_SCHEMA
protected static java.lang.String	NO_SUCH_TABLE_FUNCTION
private static java.lang.String	RUTH
private static java.lang.String	TEST_DBO
protected static java.lang.String	UNEXPECTED_USER_EXCEPTION
protected static java.lang.String	UNKNOWN_ROUTINE
protected static java.lang.String	UNKNOWN_TOOL

Fields inherited from class org.apache.derbyTesting.functionTests.tests.lang.GeneratedColumnsHelper

BAD_BEFORE_TRIGGER, BAD_CAST, BAD_FOREIGN_KEY_ACTION, CANT_ADD_IDENTITY, CANT_CONTAIN_NULLS, CANT_MODIFY_IDENTITY, CANT_OVERRIDE_GENERATION_CLAUSE, CANT_REFERENCE_GENERATED_COLUMN, CASCADED_COLUMN_DROP_WARNING, COLUMN_OUT_OF_SCOPE, CONSTRAINT_DROPPED_WARNING, CONSTRAINT_VIOLATION, DUPLICATE_CLAUSE, FORBIDDEN_DROP_TRIGGER, FORBIDDEN_ORDERING_OPERATION, FOREIGN_KEY_VIOLATION, GRANT_REVOKE_NOT_ALLOWED, ILLEGAL_ADD_DEFAULT, ILLEGAL_AGG, ILLEGAL_AGGREGATE, ILLEGAL_COMPARISON, ILLEGAL_DUPLICATE, ILLEGAL_RENAME, ILLEGAL_STORAGE, ILLEGAL_UDT_CLASS, JAVA_EXCEPTION, LACK_COLUMN_PRIV, LACK_EXECUTE_PRIV, LACK_TABLE_PRIV, LACK_USAGE_PRIV, LANG_INVALID_USE_OF_DEFAULT, LOCK_TIMEOUT, MISSING_OBJECT, NEED_EXPLICIT_DATATYPE, NON_EMPTY_SCHEMA, NONEXISTENT_OBJECT, NOT_NULL_NEEDS_DATATYPE, NOT_NULL_VIOLATION, OBJECT_DOES_NOT_EXIST, OPERATION_FORBIDDEN, REDUNDANT_CLAUSE, ROUTINE_CANT_ISSUE_SQL, ROUTINE_DEPENDS_ON_TYPE, STRING_TRUNCATION, SYNTAX_ERROR, TABLE_DEPENDS_ON_TYPE, TOO_MUCH_CONTENTION, TRIGGER_DROPPED_WARNING, UNSTABLE_RESULTS, VIEW_DEPENDENCY

Fields inherited from class org.apache.derbyTesting.junit.BaseTestCase

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
OptionalToolsTest(java.lang.String name) Create a new instance.

Method Summary

Modifier and Type	Method and Description
static junit.framework.Test	suite() Construct top level suite in this JUnit test
void	test_01_dbmdWrapper() Test the optional package of routines which wrap the DatabaseMetaData methods.
void	test_02_foreignDBViews() Test the optional package of views on an external database.
void	test_03_customTool() Test loading custom, user-supplied tools.

Methods inherited from class org.apache.derbyTesting.functionTests.tests.lang.GeneratedColumnsHelper

assertColumnTypes, assertDeterministic, assertResults, assertResults, chattyPrepare, chattyPrepareCall, executeQuery, expectCompilationError, expectCompilationError, expectExecutionError, expectExecutionWarning, expectExecutionWarnings, expectInsertRowError, expectUpdateRowError, fill, goodStatement, verifyRestrictedDrop, verifyRevokePrivilege

Methods inherited from class org.apache.derbyTesting.junit.BaseJDBCTestCase

assertCallError, assertCheckTable, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertErrorCode, assertGetIntError, assertNextError, assertPreparedStatementError, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertStatementErrorUnordered, assertTableRowCount, assertUpdateCount, assertUpdateCount, assertWarning, checkAllConsistency, checkEstimatedRowCount, closeStatement, commit, createStatement, createStatement, createStatement, dropTable, dropTable, dropView, dropView, emptyStatementCache, getClientTransactionID, getConnection, getDatabaseProperty, getLastSQLException, initializeConnection, openConnection, openDefaultConnection, openDefaultConnection, openDefaultConnection, openUserConnection, prepareCall, prepareCall, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, rollback, runBare, runBareOverridable, runScript, runScript, runSQLCommands, setAutoCommit, tearDown, usingDB2Client, usingDerbyNetClient, usingEmbedded

Methods inherited from class org.apache.derbyTesting.junit.BaseTestCase

alarm, assertDirectoryDeleted, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertExecJavaCmdAsExpected, assertLaunchedJUnitTestMethod, assertLaunchedJUnitTestMethod, assertSecurityManager, assertThrowableEquals, currentDirectory, execJavaCmd, execJavaCmd, fail, getClassVersionMajor, getEmmaJar, getFailureFolder, getFilesWith, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, hasInterruptibleIO, isCVM, isIBMJVM, isJ9Platform, isJava5, isJava7, isJava8, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemProperty, sleep, sleepAtLeastOneTick, traceit

Methods inherited from class junit.framework.TestCase

assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertFalse, assertFalse, assertNotNull, assertNotNull, assertNotSame, assertNotSame, assertNull, assertNull, assertSame, assertSame, assertTrue, assertTrue, countTestCases, createResult, fail, fail, failNotEquals, failNotSame, failSame, format, getName, run, run, runTest, setName, setUp, toString

Methods inherited from class java.lang.Object

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

Field Detail

NO_SUCH_TABLE_FUNCTION

protected static final java.lang.String NO_SUCH_TABLE_FUNCTION

See Also:

Constant Field Values

UNEXPECTED_USER_EXCEPTION

protected static final java.lang.String UNEXPECTED_USER_EXCEPTION

See Also:

Constant Field Values

MISSING_SCHEMA

protected static final java.lang.String MISSING_SCHEMA

See Also:

Constant Field Values

UNKNOWN_TOOL

protected static final java.lang.String UNKNOWN_TOOL

See Also:

Constant Field Values

UNKNOWN_ROUTINE

protected static final java.lang.String UNKNOWN_ROUTINE

See Also:

Constant Field Values

TEST_DBO

private static final java.lang.String TEST_DBO

See Also:

Constant Field Values

RUTH

private static final java.lang.String RUTH

See Also:

Constant Field Values

ALICE

private static final java.lang.String ALICE

See Also:

Constant Field Values

FRANK

private static final java.lang.String FRANK

See Also:

Constant Field Values

LEGAL_USERS

private static final java.lang.String[] LEGAL_USERS

FOREIGN_DB

private static final java.lang.String FOREIGN_DB

See Also:

Constant Field Values

Constructor Detail

OptionalToolsTest

public OptionalToolsTest(java.lang.String name)

Create a new instance.

Method Detail

suite

public static junit.framework.Test suite()

Construct top level suite in this JUnit test

test_01_dbmdWrapper

public void test_01_dbmdWrapper()
                         throws java.lang.Exception

Test the optional package of routines which wrap the DatabaseMetaData methods.

Throws:

java.lang.Exception

test_02_foreignDBViews

public void test_02_foreignDBViews()
                            throws java.lang.Exception

Test the optional package of views on an external database.

Throws:

java.lang.Exception

test_03_customTool

public void test_03_customTool()
                        throws java.lang.Exception

Test loading custom, user-supplied tools.

Throws:

java.lang.Exception