org.apache.derbyTesting.functionTests.tests.store

Class HoldCursorJDBC30Test

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

All Implemented Interfaces:

junit.framework.Test

public final class HoldCursorJDBC30Test
extends BaseJDBCTestCase

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
HoldCursorJDBC30Test(java.lang.String name) Public constructor required for running test as standalone JUnit.

Method Summary

Modifier and Type	Method and Description
private static junit.framework.Test	decorateTest(junit.framework.Test test) This will allow us to decorate the test for each driver separately
protected void	setUp() Disabling auto-commit for all tests
static junit.framework.Test	suite()
void	testBasicBtreeScanForZeroRowsReadOnlyNoGroupFetch() The following tests that no matter where commit comes in the state of the scan that the scan will continue after the commit.
void	testBasicBtreeScanForZeroRowsUpdateNonkeyfield() basic btree scan tests (zero rows/update nonkey field) The following tests that no matter where commit comes in the state of the scan that the scan will continue after the commit.
void	testBasicBtreeScanTestsForMultipleRowsOrReadOnly() basic btree scan tests (multiple rows/read only/no group fetch) The following tests that no matter where commit comes in the state of the scan that the scan will continue after the commit.
void	testBasicBtreeScanTestsForMultipleRowsOrUpdateNonkeyField() The following tests that no matter where commit comes in the state of the scan that the scan will continue after the commit.
void	testBasicHeapScanMultiRows() The following tests that no matter where commit comes in the state of the scan that the scan will continue after the commit.
void	testBasicHeapScanZeroRows() The following tests that no matter where commit comes in the state of the scan that the scan will continue after the commit.
void	testBeetle4902() test query plans which use reopenScan() on a btree to do the inner table processing of a join.
void	testBeetle4902WithBulkFetchDefaultSet() test query plans which use reopenScan() on a btree to do the inner table processing of a join.
void	testDistinctScalarAggregateResultSet() test of hold cursor code in DistinctScalarAggregateResultSet.java Directed test of hold cursor as applies to sort scans opened by DistinctScalarAggregateResultSet.java.
void	testDistinctScalarAggregateResultSetGrouped() test of hold cursor code in GroupedAggregateResultSet.java Directed test of hold cursor as applies to sort scans opened by GroupedAggregateResultSet.java.
void	testOrder() basic tests for cursors with order by The following tests that no matter where commit comes in the state of the scan that the scan will continue after the commit.
void	testPositionPurgedPage() test scan positioned on a page which has been purged (should really not be any different than a row being purged).
void	testPositionPurgedRow() test scan positioned on a row which has been purged.

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

Methods inherited from class java.lang.Object

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

Constructor Detail

HoldCursorJDBC30Test

public HoldCursorJDBC30Test(java.lang.String name)

Public constructor required for running test as standalone JUnit.

Method Detail

decorateTest

private static junit.framework.Test decorateTest(junit.framework.Test test)

This will allow us to decorate the test for each driver separately

suite

public static junit.framework.Test suite()

setUp

protected void setUp()
              throws java.sql.SQLException

Disabling auto-commit for all tests

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.sql.SQLException

testBasicHeapScanZeroRows

public void testBasicHeapScanZeroRows()
                               throws java.sql.SQLException

The following tests that no matter where commit comes in the state of the scan that the scan will continue after the commit. Tests various states of scan like: before first next, after first next, before close, after close.

Throws:

java.sql.SQLException

testBasicHeapScanMultiRows

public void testBasicHeapScanMultiRows()
                                throws java.sql.SQLException

The following tests that no matter where commit comes in the state of the scan that the scan will continue after the commit. Tests various states of scan like: before first next, after first next, before close,after close.

Throws:

java.sql.SQLException

testBasicBtreeScanForZeroRowsUpdateNonkeyfield

public void testBasicBtreeScanForZeroRowsUpdateNonkeyfield()
                                                    throws java.sql.SQLException

basic btree scan tests (zero rows/update nonkey field) The following tests that no matter where commit comes in the state of the scan that the scan will continue after the commit. Tests various states of scan like: before first next, after first next, before close, after close.

Throws:

java.sql.SQLException

testBasicBtreeScanTestsForMultipleRowsOrUpdateNonkeyField

public void testBasicBtreeScanTestsForMultipleRowsOrUpdateNonkeyField()
                                                               throws java.sql.SQLException

The following tests that no matter where commit comes in the state of the scan that the scan will continue after the commit. Tests various states of scan like: before first next, after first next, before close, after close.

Throws:

java.sql.SQLException

testBasicBtreeScanForZeroRowsReadOnlyNoGroupFetch

public void testBasicBtreeScanForZeroRowsReadOnlyNoGroupFetch()
                                                       throws java.sql.SQLException

The following tests that no matter where commit comes in the state of the scan that the scan will continue after the commit. Tests various states of scan like: before first next, after first next, before close, after close.

Throws:

java.sql.SQLException

testBasicBtreeScanTestsForMultipleRowsOrReadOnly

public void testBasicBtreeScanTestsForMultipleRowsOrReadOnly()
                                                      throws java.sql.SQLException

basic btree scan tests (multiple rows/read only/no group fetch) The following tests that no matter where commit comes in the state of the scan that the scan will continue after the commit. Tests various states of scan like: before first next, after first next, before close, after close.

Throws:

java.sql.SQLException

testOrder

public void testOrder()
               throws java.sql.SQLException

basic tests for cursors with order by The following tests that no matter where commit comes in the state of the scan that the scan will continue after the commit. Tests various states of scan like: before first next, after first next, before close, after close.

Throws:

java.sql.SQLException

testDistinctScalarAggregateResultSet

public void testDistinctScalarAggregateResultSet()
                                          throws java.sql.SQLException

test of hold cursor code in DistinctScalarAggregateResultSet.java Directed test of hold cursor as applies to sort scans opened by DistinctScalarAggregateResultSet.java.

Throws:

java.sql.SQLException

testDistinctScalarAggregateResultSetGrouped

public void testDistinctScalarAggregateResultSetGrouped()
                                                 throws java.sql.SQLException

test of hold cursor code in GroupedAggregateResultSet.java Directed test of hold cursor as applies to sort scans opened by GroupedAggregateResultSet.java.

Throws:

java.sql.SQLException

testPositionPurgedRow

public void testPositionPurgedRow()
                           throws java.sql.SQLException

test scan positioned on a row which has been purged.

Throws:

java.sql.SQLException

testPositionPurgedPage

public void testPositionPurgedPage()
                            throws java.sql.SQLException

test scan positioned on a page which has been purged (should really not be any different than a row being purged).

Throws:

java.sql.SQLException

testBeetle4902

public void testBeetle4902()
                    throws java.sql.SQLException

test query plans which use reopenScan() on a btree to do the inner table processing of a join. Prior to the fix a null pointer exception would be thrown after the commit, as the code did not handle keeping the resultset used for the inner table open across commits in this case.

Throws:

java.sql.SQLException

testBeetle4902WithBulkFetchDefaultSet

public void testBeetle4902WithBulkFetchDefaultSet()
                                           throws java.sql.SQLException

test query plans which use reopenScan() on a btree to do the inner table processing of a join. Prior to the fix a null pointer exception would be thrown after the commit, as the code did not handle keeping the resultset used for the inner table open across commits in this case.

Throws:

java.sql.SQLException