org.apache.derbyTesting.functionTests.tests.lang

Class UpdateCursorTest

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

All Implemented Interfaces:

junit.framework.Test

public class UpdateCursorTest
extends BaseJDBCTestCase

This tests updateable cursor using index, Beetle entry 3865. Not done in ij since we need to do many "next" and "update" to be able to excercise the code of creating temp conglomerate for virtual memory heap. We need at minimum 200 rows in table, if "maxMemoryPerTable" property is set to 1 (KB). This includes 100 rows to fill the in-memory portion of the hash table, and another 100 rows to fill an in-memory heap that was used until DERBY-5425 removed it.

Field Summary

Fields

Modifier and Type	Field and Description
private static java.lang.String	EXPECTED_SQL_CODE
private static int	SIZE_OF_T1

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
UpdateCursorTest(java.lang.String name) Basic constructor.

Method Summary

Modifier and Type	Method and Description
protected void	initializeConnection(java.sql.Connection conn) Sets the auto commit to false.
static junit.framework.Test	suite() Returns the implemented tests.
void	testDerby5425HoldOverCommit() Regression test case for DERBY-5425.
void	testDescendingIndex() Tests descending index.
void	testNonCoveringIndex() Tests non covering index.
void	testUpdateDeleteWarning() Test if the correct warnings are raised.
void	testVirtualMemoryHeap() Test the virtual memory heap.

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

SIZE_OF_T1

private static final int SIZE_OF_T1

See Also:

Constant Field Values

EXPECTED_SQL_CODE

private static final java.lang.String EXPECTED_SQL_CODE

See Also:

Constant Field Values

Constructor Detail

UpdateCursorTest

public UpdateCursorTest(java.lang.String name)

Basic constructor.

Method Detail

initializeConnection

protected void initializeConnection(java.sql.Connection conn)
                             throws java.sql.SQLException

Sets the auto commit to false.

Overrides:

initializeConnection in class BaseJDBCTestCase

Parameters:

conn - Connection to be intialized

Throws:

java.sql.SQLException - Error setting the initial state.

suite

public static junit.framework.Test suite()

Returns the implemented tests.

Returns:

An instance of Test with the implemented tests to run.

testVirtualMemoryHeap

public void testVirtualMemoryHeap()
                           throws java.sql.SQLException

Test the virtual memory heap.

Throws:

java.sql.SQLException

testNonCoveringIndex

public void testNonCoveringIndex()
                          throws java.sql.SQLException

Tests non covering index.

Throws:

java.sql.SQLException

testDescendingIndex

public void testDescendingIndex()
                         throws java.sql.SQLException

Tests descending index.

Throws:

java.sql.SQLException

testUpdateDeleteWarning

public void testUpdateDeleteWarning()
                             throws java.sql.SQLException

Test if the correct warnings are raised.

Throws:

java.sql.SQLException

testDerby5425HoldOverCommit

public void testDerby5425HoldOverCommit()
                                 throws java.sql.SQLException

Regression test case for DERBY-5425. The scan used to lose rows that had spilt to disk from the data structure that keeps track of already seen rows, if the transaction was committed in the middle of the scan.

Throws:

java.sql.SQLException