org.apache.derbyTesting.functionTests.tests.lang

Class IdentitySequenceTest

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.IdentitySequenceTest

All Implemented Interfaces:

junit.framework.Test

public class IdentitySequenceTest
extends GeneratedColumnsHelper

Test for identity columns backed by sequence generators.

Field Summary

Fields

Modifier and Type	Field and Description
private static java.lang.String	BAD_NEXT_VALUE
private static java.lang.String	TABLE_DOESNT_HAVE_IDENTITY

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

BAD_BEFORE_TRIGGER, BAD_CAST, BAD_FOREIGN_KEY_ACTION, 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, LEXICAL_ERROR, LOCK_TIMEOUT, MISSING_OBJECT, NEED_EXPLICIT_DATATYPE, NO_GENERIC_PERMISSION, NO_SELECT_OR_UPDATE_PERMISSION, NO_TABLE_PERMISSION, NON_EMPTY_SCHEMA, NONEXISTENT_OBJECT, NOT_IMPLEMENTED, 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
IdentitySequenceTest(java.lang.String name) Create a new instance.

Method Summary

Modifier and Type	Method and Description
static java.lang.String	getIdentitySequenceName(java.sql.Connection conn, java.lang.String tableName)
private int	getScalarInteger(java.sql.PreparedStatement ps) Get a scalar integer result from a query
static junit.framework.Test	suite() Construct top level suite in this JUnit test
void	test_001_catalog() Test catalog changes.
void	test_002_alterTable() Test ALTER TABLE behavior.
void	test_003_identityTimeout() Test that too much contention on an identity column raises a LOCK_TIMEOUT.
void	testcycleOption() Tests for newly added cycle option in DERBY-6852.
static java.lang.String	uuidToSequenceName(java.lang.String uuidString)

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

assertColumnTypes, assertDeterministic, expectExecutionWarning, expectExecutionWarnings, expectInsertRowError, expectNoWarning, expectUpdateRowError, fill, verifyRestrictedDrop, verifyRevokePrivilege

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

assertCallError, assertCheckTable, assertCommitError, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertErrorCode, assertGetIntError, assertNextError, assertPreparedStatementError, assertResults, assertResults, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertStatementErrorUnordered, assertTableRowCount, assertUpdateCount, assertUpdateCount, assertWarning, chattyPrepare, chattyPrepareCall, checkAllConsistency, checkEstimatedRowCount, closeStatement, commit, createStatement, createStatement, createStatement, dropTable, dropTable, dropView, dropView, dumpRs, dumpRs, emptyStatementCache, executeQuery, expectCompilationError, expectCompilationError, expectExecutionError, getClientTransactionID, getConnection, getDatabaseProperty, getLastSQLException, goodStatement, goodUpdate, 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, assertEquals, assertExecJavaCmdAsExpected, assertLaunchedJUnitTestMethod, assertLaunchedJUnitTestMethod, assertSameNullness, assertSecurityManager, assertThrowableEquals, currentDirectory, execJavaCmd, execJavaCmd, execJavaCmd, fail, getClassVersionMajor, getEmmaJar, getFailureFolder, getFilesWith, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, hasInterruptibleIO, isCVM, isIBMJVM, isJ9Platform, isJava5, isJava7, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, newAssertionFailedError, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemErr, setSystemOut, setSystemProperty, sleep, sleepAtLeastOneTick, traceit, vmAtLeast

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

BAD_NEXT_VALUE

private static final java.lang.String BAD_NEXT_VALUE

See Also:

Constant Field Values

TABLE_DOESNT_HAVE_IDENTITY

private static final java.lang.String TABLE_DOESNT_HAVE_IDENTITY

See Also:

Constant Field Values

Constructor Detail

IdentitySequenceTest

public IdentitySequenceTest(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_001_catalog

public void test_001_catalog()
                      throws java.lang.Exception

Test catalog changes.

Throws:

java.lang.Exception

test_002_alterTable

public void test_002_alterTable()
                         throws java.lang.Exception

Test ALTER TABLE behavior.

Throws:

java.lang.Exception

test_003_identityTimeout

public void test_003_identityTimeout()
                              throws java.lang.Exception

Test that too much contention on an identity column raises a LOCK_TIMEOUT.

Throws:

java.lang.Exception

testcycleOption

public void testcycleOption()
                     throws java.lang.Exception

Tests for newly added cycle option in DERBY-6852.

Throws:

java.lang.Exception

getScalarInteger

private int getScalarInteger(java.sql.PreparedStatement ps)
                      throws java.lang.Exception

Get a scalar integer result from a query

Throws:

java.lang.Exception

getIdentitySequenceName

public static java.lang.String getIdentitySequenceName(java.sql.Connection conn,
                                                       java.lang.String tableName)
                                                throws java.lang.Exception

Throws:

java.lang.Exception

uuidToSequenceName

public static java.lang.String uuidToSequenceName(java.lang.String uuidString)