org.apache.derbyTesting.functionTests.tests.store

Class TableLockBasicTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.functionTests.tests.store.TableLockBasicTest

All Implemented Interfaces:

junit.framework.Test

public class TableLockBasicTest
extends BaseJDBCTestCase

Very basic single user testing of table locking, verify that the right locks are obtained for simple operations. This test only looks at table and row logical locks, it does not verify physical latches or lock ordering. -- The basic methodology is: start transaction simple operation print lock table which should match the master end transation

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
private void	constructHeap(java.sql.Statement st)
private void	constructIndexedHeap(java.sql.Statement st)
private void	createLockTableQueryEntries(java.sql.Statement s)
protected void	setUp()
static junit.framework.Test	suite()
void	tearDown() Tear down this fixture, sub-classes should call super.tearDown().
void	testCreateIndex()
void	testDDLTableLockMode()
void	testDelectFromHeap() Test delete from a heap, should get exclusive table lock.
void	testDeleteFromIndexedHeap() Test delete from a indexed heap, should get exclusive table lock.
void	testDropHeap() Test drop of heap, should get exclusive table lock.
void	testDropIndexedHeap() Test drop of indexed heap, should get exclusive table lock.
void	testInsertIntoEmtpyIndexedHeaP()
void	testInsertIntoHeap()
void	testLockTableInSysSchema() verify that lock table not allowed in sys schema
void	testLockTableStatement() Test LOCK TABLE statement
void	testRTSOutput() Test RTS output when table locking configured
void	testSelectFromHeap() Test select from a heap, should get shared table lock.
void	testSelectFromIndexedHeap() Test select from a indexed heap, should get shared table lock.
void	testUpdateToHeap() Test update to heap, should get exclusive table lock.
void	testUpdateToIndexedHeap() Test update to indexed heap, should get exclusive table lock.

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

Methods inherited from class java.lang.Object

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

Constructor Detail

TableLockBasicTest

public TableLockBasicTest(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

setUp

protected void setUp()
              throws java.sql.SQLException

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.sql.SQLException

createLockTableQueryEntries

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

Throws:

java.sql.SQLException

tearDown

public void tearDown()
              throws java.lang.Exception

Description copied from class: BaseJDBCTestCase

Tear down this fixture, sub-classes should call super.tearDown(). This cleanups & closes the connection if it is open and any statement objects returned through the utility methods.

Overrides:

tearDown in class BaseJDBCTestCase

Throws:

java.lang.Exception

testInsertIntoHeap

public void testInsertIntoHeap()
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

testSelectFromHeap

public void testSelectFromHeap()
                        throws java.sql.SQLException

Test select from a heap, should get shared table lock.

Throws:

java.sql.SQLException

constructHeap

private void constructHeap(java.sql.Statement st)
                    throws java.sql.SQLException

Throws:

java.sql.SQLException

testDelectFromHeap

public void testDelectFromHeap()
                        throws java.sql.SQLException

Test delete from a heap, should get exclusive table lock.

Throws:

java.sql.SQLException

testUpdateToHeap

public void testUpdateToHeap()
                      throws java.sql.SQLException

Test update to heap, should get exclusive table lock.

Throws:

java.sql.SQLException

testDropHeap

public void testDropHeap()
                  throws java.sql.SQLException

Test drop of heap, should get exclusive table lock.

Throws:

java.sql.SQLException

testCreateIndex

public void testCreateIndex()
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

testInsertIntoEmtpyIndexedHeaP

public void testInsertIntoEmtpyIndexedHeaP()
                                    throws java.sql.SQLException

Throws:

java.sql.SQLException

testSelectFromIndexedHeap

public void testSelectFromIndexedHeap()
                               throws java.sql.SQLException

Test select from a indexed heap, should get shared table lock.

Throws:

java.sql.SQLException

constructIndexedHeap

private void constructIndexedHeap(java.sql.Statement st)
                           throws java.sql.SQLException

Throws:

java.sql.SQLException

testDeleteFromIndexedHeap

public void testDeleteFromIndexedHeap()
                               throws java.sql.SQLException

Test delete from a indexed heap, should get exclusive table lock.

Throws:

java.sql.SQLException

testUpdateToIndexedHeap

public void testUpdateToIndexedHeap()
                             throws java.sql.SQLException

Test update to indexed heap, should get exclusive table lock.

Throws:

java.sql.SQLException

testDropIndexedHeap

public void testDropIndexedHeap()
                         throws java.sql.SQLException

Test drop of indexed heap, should get exclusive table lock.

Throws:

java.sql.SQLException

testLockTableStatement

public void testLockTableStatement()
                            throws java.sql.SQLException

Test LOCK TABLE statement

Throws:

java.sql.SQLException

testLockTableInSysSchema

public void testLockTableInSysSchema()
                              throws java.sql.SQLException

verify that lock table not allowed in sys schema

Throws:

java.sql.SQLException

testRTSOutput

public void testRTSOutput()
                   throws java.sql.SQLException

Test RTS output when table locking configured

Throws:

java.sql.SQLException

testDDLTableLockMode

public void testDDLTableLockMode()
                          throws java.sql.SQLException

Throws:

java.sql.SQLException