org.apache.derbyTesting.functionTests.tests.lang

Class LockTableTest

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

All Implemented Interfaces:

junit.framework.Test

public class LockTableTest
extends BaseJDBCTestCase

Tests the LOCK TABLE in various modes.

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
LockTableTest(java.lang.String name)

Method Summary

Modifier and Type	Method and Description
static java.lang.String	getSelectLocksString()
private java.sql.Connection	setConnection(java.lang.String userString) sets up the connection for a user
protected void	setUp()
private void	setupTable(java.sql.Statement s)
static junit.framework.Test	suite() Construct top level suite in this JUnit test The suite is wrapped in a DatabasePropertyTestSetup to lower the locking times.
protected void	tearDown() Tear-down the fixture by removing the tables and schemas
void	testSystemTable() Tests that LOCK TABLE is not allowed on system tables.
void	testTSvsTSLocks() Tests LOCK TABLE command - shared vs shared mode
void	testTSvsTXLocks() Tests LOCK TABLE command - shared vs exclusive mode
void	testTXvsTSLocks() Tests LOCK TABLE command - exclusive vs shared mode
void	testTXvsTXLocks() Tests LOCK TABLE command - exclusive vs exclusive mode
void	testWithRolledBack() test with rollback.

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, 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, toString

Methods inherited from class java.lang.Object

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

Constructor Detail

LockTableTest

public LockTableTest(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

Construct top level suite in this JUnit test The suite is wrapped in a DatabasePropertyTestSetup to lower the locking times.

Returns:

A suite containing embedded fixtures

setUp

protected void setUp()
              throws java.lang.Exception

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.lang.Exception

tearDown

protected void tearDown()
                 throws java.lang.Exception

Tear-down the fixture by removing the tables and schemas

Overrides:

tearDown in class BaseJDBCTestCase

Throws:

java.lang.Exception

setConnection

private java.sql.Connection setConnection(java.lang.String userString)
                                   throws java.sql.SQLException

sets up the connection for a user

Returns:

A connection with autocommit set to false

Throws:

java.sql.SQLException

setupTable

private void setupTable(java.sql.Statement s)
                 throws java.sql.SQLException

Throws:

java.sql.SQLException

getSelectLocksString

public static java.lang.String getSelectLocksString()

testSystemTable

public void testSystemTable()
                     throws java.sql.SQLException

Tests that LOCK TABLE is not allowed on system tables.

Throws:

java.sql.SQLException

testTXvsTXLocks

public void testTXvsTXLocks()
                     throws java.sql.SQLException

Tests LOCK TABLE command - exclusive vs exclusive mode

Throws:

java.sql.SQLException

testTXvsTSLocks

public void testTXvsTSLocks()
                     throws java.sql.SQLException

Tests LOCK TABLE command - exclusive vs shared mode

Throws:

java.sql.SQLException

testTSvsTXLocks

public void testTSvsTXLocks()
                     throws java.sql.SQLException

Tests LOCK TABLE command - shared vs exclusive mode

Throws:

java.sql.SQLException

testTSvsTSLocks

public void testTSvsTSLocks()
                     throws java.sql.SQLException

Tests LOCK TABLE command - shared vs shared mode

Throws:

java.sql.SQLException

testWithRolledBack

public void testWithRolledBack()
                        throws java.sql.SQLException

test with rollback.

Throws:

java.sql.SQLException