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 retrieved 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) - testDerby6737: tests that a LOB can be accessed after using an absolute positioning method to move the position to the row on which the result set is currently positioned. (DERBY-6737)

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
void	setUp() Set up the connection to the database.
static junit.framework.Test	suite()
void	tearDown() Drop the table
void	testDerby6737() Test that it is possible to access LOBs after moving the position of a scrollable result set from one row to the same row.
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, assertCommitError, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertErrorCode, assertGetIntError, assertNextError, assertPreparedStatementError, assertResults, assertResults, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertStatementErrorUnordered, assertTableRowCount, assertUpdateCount, assertUpdateCount, assertWarning, chattyPrepare, chattyPrepareCall, checkAllConsistency, checkEstimatedRowCount, closeStatement, commit, createStatement, createStatement, createStatement, dropTable, dropTable, dropView, dropView, dumpRs, dumpRs, emptyStatementCache, executeQuery, expectCompilationError, expectCompilationError, expectExecutionError, getClientTransactionID, getConnection, getDatabaseProperty, getLastSQLException, goodStatement, goodUpdate, 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, assertEquals, assertExecJavaCmdAsExpected, assertLaunchedJUnitTestMethod, assertLaunchedJUnitTestMethod, assertSameNullness, assertSecurityManager, assertThrowableEquals, currentDirectory, execJavaCmd, execJavaCmd, execJavaCmd, fail, getClassVersionMajor, getEmmaJar, getFailureFolder, getFilesWith, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, hasInterruptibleIO, isCVM, isIBMJVM, isJ9Platform, isJava5, isJava7, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, newAssertionFailedError, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemErr, setSystemOut, setSystemProperty, sleep, sleepAtLeastOneTick, traceit, vmAtLeast

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

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

testDerby6737

public void testDerby6737()
                   throws java.sql.SQLException

Test that it is possible to access LOBs after moving the position of a scrollable result set from one row to the same row. Before DERBY-6737 the following sequence of calls

 rs.last();
 rs.first();
 rs.getClob(1).length();
 

would fail with 'invalid locator' on the client, if the result set contained only one row.

Throws:

java.sql.SQLException