org.apache.derbyTesting.functionTests.tests.lang

Class LazyDefaultSchemaCreationTest

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

All Implemented Interfaces:

junit.framework.Test

public class LazyDefaultSchemaCreationTest
extends BaseJDBCTestCase

Tests the lazy creation functionality of default schema: the schema is only first created when the first database object is created in the schema.

Field Summary

Fields

Modifier and Type	Field and Description
private static java.lang.String	LOCK_TIMEOUT

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
LazyDefaultSchemaCreationTest(java.lang.String name) Creates a new LazyDefaultSchemaCreationTest instance.

Method Summary

Modifier and Type	Method and Description
static junit.framework.Test	suite()
protected void	tearDown() Tear down this fixture, sub-classes should call super.tearDown().
void	testDerby3043CheckConstraint()
void	testDerby3678() Test that the timeout lock diagnostics do not create an infinite recursion as in DERBY-3678 (although that particular use case will not cause an infinite recursion after the fix to DERBY-48).
void	testDerby48SelfLockingRecovery() Test that we recover from self locking in the auto-create nested transaction (cf solution for DERBY-48).
void	testDerby48SelfLockingRecoveryDeadlockDetectionOn() Test that we do get to see the self locking in the auto-create nested transaction (cf solution for DERBY-48) when deadlock detection is on, i.e. 40XL2 (LOCK_TIMEOUT_LOG) rather than 40XL1 (LOCK_TIMEOUT) happens.
void	testDerby48testNewSchemaHang() Reproduces hang seen in DERBY-48
void	testOtherImplicitSchemaCreation() Test that implicit schema creation of other schemas besides the initial default schema is still transactional.

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

Methods inherited from class java.lang.Object

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

Field Detail

LOCK_TIMEOUT

private static final java.lang.String LOCK_TIMEOUT

See Also:

Constant Field Values

Constructor Detail

LazyDefaultSchemaCreationTest

public LazyDefaultSchemaCreationTest(java.lang.String name)

Creates a new LazyDefaultSchemaCreationTest instance.

Parameters:

name - the name of the test

Method Detail

testDerby48testNewSchemaHang

public void testDerby48testNewSchemaHang()
                                  throws java.sql.SQLException

Reproduces hang seen in DERBY-48

Throws:

java.sql.SQLException

testDerby48SelfLockingRecovery

public void testDerby48SelfLockingRecovery()
                                    throws java.sql.SQLException

Test that we recover from self locking in the auto-create nested transaction (cf solution for DERBY-48).

Throws:

java.sql.SQLException

testDerby48SelfLockingRecoveryDeadlockDetectionOn

public void testDerby48SelfLockingRecoveryDeadlockDetectionOn()
                                                       throws java.sql.SQLException

Test that we do get to see the self locking in the auto-create nested transaction (cf solution for DERBY-48) when deadlock detection is on, i.e. 40XL2 (LOCK_TIMEOUT_LOG) rather than 40XL1 (LOCK_TIMEOUT) happens. After fix for DERBY-5564 LOCK_TIMEOUT will be returned whether diagnostics are on or not.

Throws:

java.sql.SQLException

testDerby3678

public void testDerby3678()
                   throws java.sql.SQLException

Test that the timeout lock diagnostics do not create an infinite recursion as in DERBY-3678 (although that particular use case will not cause an infinite recursion after the fix to DERBY-48). The scenario in this test case does create the infinite recursion prior to the fix of DERBY-3678, however. After fix for DERBY-5564 LOCK_TIMEOUT SQL state should be returned for a lock timeout whether diagnostics are on or not.

Throws:

java.sql.SQLException

testOtherImplicitSchemaCreation

public void testOtherImplicitSchemaCreation()
                                     throws java.sql.SQLException

Test that implicit schema creation of other schemas besides the initial default schema is still transactional.

Throws:

java.sql.SQLException

testDerby3043CheckConstraint

public void testDerby3043CheckConstraint()
                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

tearDown

protected 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

suite

public static junit.framework.Test suite()