org.apache.derbyTesting.functionTests.tests.lang

Class DeclareGlobalTempTableJavaJDBC30Test

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

All Implemented Interfaces:

junit.framework.Test

public class DeclareGlobalTempTableJavaJDBC30Test
extends BaseJDBCTestCase

Test for declared global temporary tables (introduced in Cloudscape 5.2) and pooled connection close and jdbc 3.0 specific features The jdbc3.0 specific featuers are holdable cursors, savepoints. The rest of the temp table test are in declareGlobalTempTableJavaTest class. The reason for a different test class is that the holdability and savepoint support is under jdk14 and higher. But we want to be able to run the non-holdable tests under all the jdks we support and hence splitting the tests into two separate tests.

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
DeclareGlobalTempTableJavaJDBC30Test(java.lang.String name)

Method Summary

Modifier and Type	Method and Description
private static junit.framework.Test	getClientSuite() Return a suite of tests that are run with client only
protected void	setUp()
static junit.framework.Test	suite()
protected void	tearDown() Tear down this fixture, sub-classes should call super.tearDown().
void	test_derby_6189() Test that we don't get an NPE when re-using a PreparedStatement on a temp table declared and then rolled back.
void	testOnCommitDeleteRowsHoldabilityWithPreparedStatements() Test declared temporary table with ON COMMIT DELETE ROWS and holdable cursors on prepared statement
void	testOnCommitDeleteRowsWithHoldableOpenCursor() Tests that If a Global Temp table(with on commi delete rows) has open cursors held on it Data should be preserved in at commit time
void	testOnCommitPreserveRowsWithHoldability() Tests a temporary table with ON COMMIT PRESERVE ROWS and various combinations of holdability.
void	testPooledConnectionClosed() Temporary tables declared in a pooled connection should get dropped when that pooled connection is closed.
void	testSavepointRollbackbehaviour1() Savepoint and Rollback behavior - 1 (3A) In the transaction Create savepoint1 and declare temp table t1.
void	testSavepointRollbackbehaviour10() Savepoint and Rollback behavior - 10 - 3N
void	testSavepointRollbackbehaviour11() Savepoint and Rollback behavior - 11 - 3O
void	testSavepointRollbackbehaviour12() Savepoint and Rollback behavior - 12 - 3P
void	testSavepointRollbackbehaviour13() Savepoint and Rollback behavior - 13 - 3Q tests the rollback , savepoint behaviour with prepartedStatement
void	testSavepointRollbackbehaviour2() Savepoint and Rollback behavior - 2 (3B) In the transaction Create savepoint1 and declare temp table t1.
void	testSavepointRollbackbehaviour3() Savepoint and Rollback behavior - 3 (3C) In the transaction Create savepoint1 and declare temp table t1.
void	testSavepointRollbackbehaviour4() Savepoint and Rollback behavior - 4 (3D)
void	testSavepointRollbackbehaviour5() Savepoint and Rollback behavior - 5 - 3E Tests the basic definition of savepoint in combination with Rollback.
void	testSavepointRollbackbehaviour6() Savepoint and Rollback behavior - 6 - 3J In the transaction: declare temp table t1 with 2 columns and commit.
void	testSavepointRollbackbehaviour7() Savepoint and Rollback behavior - 7 - 3K tests the savepoint and rollback behaviour with update command
void	testSavepointRollbackbehaviour8() Savepoint and Rollback behavior - 8 - 3L
void	testSavepointRollbackbehaviour9() Savepoint and Rollback behavior - 9 - 3M
void	testTest4() Test declared temporary table with ON COMMIT DELETE ROWS and holdable cursors and temp table as part of subquery Temp table t1 with no direct held cursor open on it.

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

DeclareGlobalTempTableJavaJDBC30Test

public DeclareGlobalTempTableJavaJDBC30Test(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

getClientSuite

private static junit.framework.Test getClientSuite()

Return a suite of tests that are run with client only

Returns:

A suite of tests being run with client only

setUp

protected void setUp()
              throws java.lang.Exception

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.lang.Exception

tearDown

protected void tearDown()
                 throws java.lang.Exception

Description copied from class: BaseJDBCTestCase

Tear down this fixture, sub-classes should call super.tearDown(). This cleanups & closes the connection if it is open and any statement objects returned through the utility methods.

Overrides:

tearDown in class BaseJDBCTestCase

Throws:

java.lang.Exception

testOnCommitDeleteRowsWithHoldableOpenCursor

public void testOnCommitDeleteRowsWithHoldableOpenCursor()
                                                  throws java.sql.SQLException

Tests that If a Global Temp table(with on commi delete rows) has open cursors held on it Data should be preserved in at commit time

Throws:

java.sql.SQLException

testOnCommitDeleteRowsHoldabilityWithPreparedStatements

public void testOnCommitDeleteRowsHoldabilityWithPreparedStatements()
                                                             throws java.sql.SQLException

Test declared temporary table with ON COMMIT DELETE ROWS and holdable cursors on prepared statement

Throws:

java.sql.SQLException

testOnCommitPreserveRowsWithHoldability

public void testOnCommitPreserveRowsWithHoldability()
                                             throws java.sql.SQLException

Tests a temporary table with ON COMMIT PRESERVE ROWS and various combinations of holdability. Temp table t1 with held open cursors on it. Data should be preserved, holdability shouldn't matter

Throws:

java.sql.SQLException

testSavepointRollbackbehaviour1

public void testSavepointRollbackbehaviour1()
                                     throws java.sql.SQLException

Savepoint and Rollback behavior - 1 (3A) In the transaction Create savepoint1 and declare temp table t1. Create savepoint 2, drop temp table t1, rollback savepoint 2 select should pass, rollback savepoint 1, select should fail.

Throws:

java.sql.SQLException

testSavepointRollbackbehaviour2

public void testSavepointRollbackbehaviour2()
                                     throws java.sql.SQLException

Savepoint and Rollback behavior - 2 (3B) In the transaction Create savepoint1 and declare temp table t1. Create savepoint2 and declare temp table t2 Release savepoint 1 and select from temp table t1 and t2. Drop temp table t2(explicit drop), rollback transaction(implicit drop of t1) Select from temp table t1 and t2 will fail.

Throws:

java.sql.SQLException

testSavepointRollbackbehaviour3

public void testSavepointRollbackbehaviour3()
                                     throws java.sql.SQLException

Savepoint and Rollback behavior - 3 (3C) In the transaction Create savepoint1 and declare temp table t1. Create savepoint2 and declare temp table t2. Release savepoint 1 and select from temp table t1 and t2 should pass. Create savepoint3 and rollback savepoint3(should not touch t1 and t2) select from temp tables t1 and t2 should pass. Rollback transaction and select from temp tables t1 and t2 should fail.

Throws:

java.sql.SQLException

testSavepointRollbackbehaviour4

public void testSavepointRollbackbehaviour4()
                                     throws java.sql.SQLException

Savepoint and Rollback behavior - 4 (3D)

Throws:

java.sql.SQLException

testSavepointRollbackbehaviour5

public void testSavepointRollbackbehaviour5()
                                     throws java.sql.SQLException

Savepoint and Rollback behavior - 5 - 3E Tests the basic definition of savepoint in combination with Rollback.

Throws:

java.sql.SQLException

testSavepointRollbackbehaviour6

public void testSavepointRollbackbehaviour6()
                                     throws java.sql.SQLException

Savepoint and Rollback behavior - 6 - 3J In the transaction: declare temp table t1 with 2 columns and commit. Create savepoint1 and drop temp table t1 with 2 columns, declare temp table t1 but this time with 3 columns. Create savepoint2 and drop temp table t1 with 3 columns, rollback, select from temp table t1 here should have 2 columns

Throws:

java.sql.SQLException

testSavepointRollbackbehaviour7

public void testSavepointRollbackbehaviour7()
                                     throws java.sql.SQLException

Savepoint and Rollback behavior - 7 - 3K tests the savepoint and rollback behaviour with update command

Throws:

java.sql.SQLException

testSavepointRollbackbehaviour8

public void testSavepointRollbackbehaviour8()
                                     throws java.sql.SQLException

Savepoint and Rollback behavior - 8 - 3L

Throws:

java.sql.SQLException

testSavepointRollbackbehaviour9

public void testSavepointRollbackbehaviour9()
                                     throws java.sql.SQLException

Savepoint and Rollback behavior - 9 - 3M

Throws:

java.sql.SQLException

testSavepointRollbackbehaviour10

public void testSavepointRollbackbehaviour10()
                                      throws java.sql.SQLException

Savepoint and Rollback behavior - 10 - 3N

Throws:

java.sql.SQLException

testSavepointRollbackbehaviour11

public void testSavepointRollbackbehaviour11()
                                      throws java.sql.SQLException

Savepoint and Rollback behavior - 11 - 3O

Throws:

java.sql.SQLException

testSavepointRollbackbehaviour12

public void testSavepointRollbackbehaviour12()
                                      throws java.sql.SQLException

Savepoint and Rollback behavior - 12 - 3P

Throws:

java.sql.SQLException

testSavepointRollbackbehaviour13

public void testSavepointRollbackbehaviour13()
                                      throws java.sql.SQLException

Savepoint and Rollback behavior - 13 - 3Q tests the rollback , savepoint behaviour with prepartedStatement

Throws:

java.sql.SQLException

testTest4

public void testTest4()
               throws java.sql.SQLException

Test declared temporary table with ON COMMIT DELETE ROWS and holdable cursors and temp table as part of subquery Temp table t1 with no direct held cursor open on it. Data should be deleted from t1 at commit time

Throws:

java.sql.SQLException

testPooledConnectionClosed

public void testPooledConnectionClosed()
                                throws java.sql.SQLException

Temporary tables declared in a pooled connection should get dropped when that pooled connection is closed.

Throws:

java.sql.SQLException

test_derby_6189

public void test_derby_6189()
                     throws java.lang.Exception

Test that we don't get an NPE when re-using a PreparedStatement on a temp table declared and then rolled back. See DERBY-6189.

Throws:

java.lang.Exception