org.apache.derbyTesting.functionTests.tests.store

Class Derby5234Test

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

All Implemented Interfaces:

junit.framework.Test

public class Derby5234Test
extends BaseJDBCTestCase

Regression test for DERBY-5234.

Field Summary

Fields

Modifier and Type	Field and Description
private static long	ITERATIONS
private static long	MAX_KEY_PER_FIRST_EXTENT
private static java.lang.String	SEED
private static int	VARCHAR_LENGTH

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
private java.sql.PreparedStatement	chattyPrepare(java.sql.Connection conn, java.lang.String text) Prepare a statement and report its sql text.
private void	compressTable(java.sql.Connection conn)
private void	deleteRows(java.sql.Connection conn)
private void	goodStatement(java.sql.Connection conn, java.lang.String command) Run a successful statement.
private void	insertRows(java.sql.Connection conn, long iterations) Fill the table with enough rows to force Derby to grab a second allocation page
private java.lang.String	makeVarcharValue()
protected void	setUp()
static junit.framework.Test	suite() Create a suite of tests.
protected void	tearDown() Tear down this fixture, sub-classes should call super.tearDown().
void	test_01_basic() Basic test case for DERBY-5234.
void	test_02_maxOK() Test with the highest row count which did NOT trip the bug.
void	test_03_triggeringEdge() Test with one more than the highest good value.
private void	vetBasic(long rowCount)

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

Field Detail

ITERATIONS

private static final long ITERATIONS

See Also:

Constant Field Values

MAX_KEY_PER_FIRST_EXTENT

private static final long MAX_KEY_PER_FIRST_EXTENT

See Also:

Constant Field Values

VARCHAR_LENGTH

private static final int VARCHAR_LENGTH

See Also:

Constant Field Values

SEED

private static final java.lang.String SEED

See Also:

Constant Field Values

Constructor Detail

Derby5234Test

public Derby5234Test(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

Create a suite of tests.

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

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

test_01_basic

public void test_01_basic()
                   throws java.lang.Exception

Basic test case for DERBY-5234. Test that the last allocation page remembers which pages have been released to the operating system.

Throws:

java.lang.Exception

vetBasic

private void vetBasic(long rowCount)
               throws java.lang.Exception

Throws:

java.lang.Exception

insertRows

private void insertRows(java.sql.Connection conn,
                        long iterations)
                 throws java.lang.Exception

Fill the table with enough rows to force Derby to grab a second allocation page

Throws:

java.lang.Exception

makeVarcharValue

private java.lang.String makeVarcharValue()

deleteRows

private void deleteRows(java.sql.Connection conn)
                 throws java.lang.Exception

Throws:

java.lang.Exception

compressTable

private void compressTable(java.sql.Connection conn)
                    throws java.lang.Exception

Throws:

java.lang.Exception

test_02_maxOK

public void test_02_maxOK()
                   throws java.lang.Exception

Test with the highest row count which did NOT trip the bug.

Throws:

java.lang.Exception

test_03_triggeringEdge

public void test_03_triggeringEdge()
                            throws java.lang.Exception

Test with one more than the highest good value.

Throws:

java.lang.Exception

goodStatement

private void goodStatement(java.sql.Connection conn,
                           java.lang.String command)
                    throws java.sql.SQLException

Run a successful statement.

Throws:

java.sql.SQLException

chattyPrepare

private java.sql.PreparedStatement chattyPrepare(java.sql.Connection conn,
                                                 java.lang.String text)
                                          throws java.sql.SQLException

Prepare a statement and report its sql text.

Throws:

java.sql.SQLException