org.apache.derbyTesting.functionTests.tests.lang

Class HoldCursorTest

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

All Implemented Interfaces:

junit.framework.Test

public class HoldCursorTest
extends BaseJDBCTestCase

Test hold cursor after commit

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
static void	assertGetIntEquals(int position, int expected, java.sql.ResultSet rs) Perform getInt(position) with expected error
void	assertIsolationError(java.lang.String sqlState, int level) Assert that the changing isolation throws an SQLException with the expected state.
private static junit.framework.Test	baseSuite(boolean embeddedMode)
java.sql.Statement	createStatement(int resultSetType, int resultSetConcurrency, int resultSetHoldability) Utility method to create a Statement using the connection returned by getConnection.
void	setHoldability(int holdability) Utility method to set Holdability
void	setTransactionIsolation(int level) Utility method to set Transaction Isolation
protected void	setUp() Set the fixture up with tables and insert rows .
void	StatementsInProcedure(int holdability) test holdability of statements in procedures
void	StatementsInProcedureTest()
static junit.framework.Test	suite() Create a suite of tests.
protected void	tearDown() Drop tables for clean up
void	testCloseCursor() Test for drop table after closing the cursor
void	testDropTable() Test that drop table cannot be performed when there is an open cursor on that table.
void	testHoldabilityOverCommit() set connection holdability and test holdability of statements inside and outside procedures test that holdability of statements always overrides holdability of connection
void	testHoldCursorOnMultiTableQuery() test cursor holdability after commit on multi table query
void	testIsolationLevelChange() Test Chaging isolation levels with and without held curosors
static void	testProc(java.sql.ResultSet[] rs1, java.sql.ResultSet[] rs2) Java method for stored procedure
void	testStatements(int holdability) test holdability of statements outside procedures

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

Constructor Detail

HoldCursorTest

public HoldCursorTest(java.lang.String name)

Public constructor required for running test as standalone JUnit.

Method Detail

suite

public static junit.framework.Test suite()

Create a suite of tests.

baseSuite

private static junit.framework.Test baseSuite(boolean embeddedMode)

setUp

protected void setUp()
              throws java.sql.SQLException

Set the fixture up with tables and insert rows .

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.sql.SQLException

tearDown

protected void tearDown()
                 throws java.lang.Exception

Drop tables for clean up

Overrides:

tearDown in class BaseJDBCTestCase

Throws:

java.lang.Exception

testHoldCursorOnMultiTableQuery

public void testHoldCursorOnMultiTableQuery()
                                     throws java.lang.Exception

test cursor holdability after commit on multi table query

Throws:

java.lang.Exception

testIsolationLevelChange

public void testIsolationLevelChange()
                              throws java.lang.Exception

Test Chaging isolation levels with and without held curosors

Throws:

java.lang.Exception

testDropTable

public void testDropTable()
                   throws java.sql.SQLException

Test that drop table cannot be performed when there is an open cursor on that table.

Throws:

java.sql.SQLException

testHoldabilityOverCommit

public void testHoldabilityOverCommit()
                               throws java.sql.SQLException

set connection holdability and test holdability of statements inside and outside procedures test that holdability of statements always overrides holdability of connection

Throws:

java.sql.SQLException

StatementsInProcedureTest

public void StatementsInProcedureTest()
                               throws java.sql.SQLException

Throws:

java.sql.SQLException

testStatements

public void testStatements(int holdability)
                    throws java.sql.SQLException

test holdability of statements outside procedures

Parameters:

holdability -

Throws:

java.sql.SQLException

StatementsInProcedure

public void StatementsInProcedure(int holdability)
                           throws java.sql.SQLException

test holdability of statements in procedures

Parameters:

holdability -

Throws:

java.sql.SQLException

testCloseCursor

public void testCloseCursor()
                     throws java.sql.SQLException

Test for drop table after closing the cursor

Throws:

java.sql.SQLException

assertIsolationError

public void assertIsolationError(java.lang.String sqlState,
                                 int level)

Assert that the changing isolation throws an SQLException with the expected state.

Parameters:

sqlState -

level -

createStatement

public java.sql.Statement createStatement(int resultSetType,
                                          int resultSetConcurrency,
                                          int resultSetHoldability)
                                   throws java.sql.SQLException

Utility method to create a Statement using the connection returned by getConnection.

Overrides:

createStatement in class BaseJDBCTestCase

Parameters:

resultSetType -

resultSetConcurrency -

resultSetHoldability -

Returns:

Statement with desired holdability set

Throws:

java.sql.SQLException

setTransactionIsolation

public void setTransactionIsolation(int level)
                             throws java.sql.SQLException

Utility method to set Transaction Isolation

Parameters:

level -

Throws:

java.sql.SQLException

setHoldability

public void setHoldability(int holdability)
                    throws java.sql.SQLException

Utility method to set Holdability

Parameters:

holdability -

Throws:

java.sql.SQLException

assertGetIntEquals

public static void assertGetIntEquals(int position,
                                      int expected,
                                      java.sql.ResultSet rs)

Perform getInt(position) with expected error

Parameters:

position -

expected -

rs -

testProc

public static void testProc(java.sql.ResultSet[] rs1,
                            java.sql.ResultSet[] rs2)
                     throws java.lang.Exception

Java method for stored procedure

Parameters:

rs1 -

rs2 -

Throws:

java.lang.Exception