org.apache.derbyTesting.functionTests.tests.jdbcapi
Class ScrollResultSetTest

java.lang.Object
  junit.framework.Assert
      junit.framework.TestCase
          org.apache.derbyTesting.junit.BaseTestCase
              org.apache.derbyTesting.junit.BaseJDBCTestCase
                  org.apache.derbyTesting.functionTests.tests.jdbcapi.ScrollResultSetTest

All Implemented Interfaces:

junit.framework.Test

public class ScrollResultSetTest
extends BaseJDBCTestCase

Tests scrollable result sets Tests: - testNextOnLastRowForwardOnly: tests that the result set is closed when all rows have been retreived and next has been called from the last row, autocommit = true, the result set is not holdable and type forward only. (DERBY-1295) - testNextOnLastRowScrollable: tests that the result set is not closed when next is called while the result set is positioned in the last row, autocommit = true, the result set is not holdable type scrollable insensitive. (DERBY-1295)

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

ScrollResultSetTest(java.lang.String name)
Creates a new instance of ScrollResultSetTest

Method Summary

void	setUp() Set up the connection to the database.
static junit.framework.Test	suite()
void	tearDown() Drop the table
void	testNextOnLastRowForwardOnly() Test that moving to next row after positioned at the last row on a forward only result set will close the result set
void	testNextOnLastRowScrollable() Test that moving to next row after positioned at the last row on a scrollable result set will not close the result set

Methods inherited from class org.apache.derbyTesting.junit.BaseJDBCTestCase

assertCallError, assertCheckTable, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertGetIntError, assertNextError, assertPreparedStatementError, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertTableRowCount, assertUpdateCount, assertUpdateCount, checkAllConsistency, checkEstimatedRowCount, commit, createStatement, createStatement, createStatement, dropTable, dropTable, getConnection, getDatabaseProperty, getLastSQLException, initializeConnection, openConnection, openDefaultConnection, openDefaultConnection, openUserConnection, prepareCall, prepareCall, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, rollback, runScript, runScript, runSQLCommands, setAutoCommit, usingDB2Client, usingDerbyNetClient, usingEmbedded

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

alarm, assertEquals, assertEquals, assertEquals, assertExecJavaCmdAsExpected, assertSecurityManager, assertThrowableEquals, execJavaCmd, fail, getFailureFolder, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeSystemProperty, runBare, setSystemProperty, traceit

Methods inherited from class junit.framework.TestCase

countTestCases, createResult, getName, run, run, runTest, setName, toString

Methods inherited from class junit.framework.Assert

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

Methods inherited from class java.lang.Object

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

Constructor Detail

ScrollResultSetTest

public ScrollResultSetTest(java.lang.String name)

Creates a new instance of ScrollResultSetTest

Method Detail

suite

public static junit.framework.Test suite()

setUp

public void setUp()
           throws java.lang.Exception

Set up the connection to the database.

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.lang.Exception

tearDown

public void tearDown()
              throws java.lang.Exception

Drop the table

Overrides:

tearDown in class BaseJDBCTestCase

Throws:

java.lang.Exception

testNextOnLastRowForwardOnly

public void testNextOnLastRowForwardOnly()
                                  throws java.sql.SQLException

Test that moving to next row after positioned at the last row on a forward only result set will close the result set

Throws:

java.sql.SQLException

testNextOnLastRowScrollable

public void testNextOnLastRowScrollable()
                                 throws java.sql.SQLException

Test that moving to next row after positioned at the last row on a scrollable result set will not close the result set

Throws:

java.sql.SQLException