public class DeclareGlobalTempTableJavaJDBC30Test extends BaseJDBCTestCase
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
DeclareGlobalTempTableJavaJDBC30Test(java.lang.String name) |
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.
|
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
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
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
public DeclareGlobalTempTableJavaJDBC30Test(java.lang.String name)
public static junit.framework.Test suite()
private static junit.framework.Test getClientSuite()
protected void setUp() throws java.lang.Exception
setUp
in class junit.framework.TestCase
java.lang.Exception
protected void tearDown() throws java.lang.Exception
BaseJDBCTestCase
tearDown
in class BaseJDBCTestCase
java.lang.Exception
public void testOnCommitDeleteRowsWithHoldableOpenCursor() throws java.sql.SQLException
java.sql.SQLException
public void testOnCommitDeleteRowsHoldabilityWithPreparedStatements() throws java.sql.SQLException
java.sql.SQLException
public void testOnCommitPreserveRowsWithHoldability() throws java.sql.SQLException
java.sql.SQLException
public void testSavepointRollbackbehaviour1() throws java.sql.SQLException
java.sql.SQLException
public void testSavepointRollbackbehaviour2() throws java.sql.SQLException
java.sql.SQLException
public void testSavepointRollbackbehaviour3() throws java.sql.SQLException
java.sql.SQLException
public void testSavepointRollbackbehaviour4() throws java.sql.SQLException
java.sql.SQLException
public void testSavepointRollbackbehaviour5() throws java.sql.SQLException
java.sql.SQLException
public void testSavepointRollbackbehaviour6() throws java.sql.SQLException
java.sql.SQLException
public void testSavepointRollbackbehaviour7() throws java.sql.SQLException
java.sql.SQLException
public void testSavepointRollbackbehaviour8() throws java.sql.SQLException
java.sql.SQLException
public void testSavepointRollbackbehaviour9() throws java.sql.SQLException
java.sql.SQLException
public void testSavepointRollbackbehaviour10() throws java.sql.SQLException
java.sql.SQLException
public void testSavepointRollbackbehaviour11() throws java.sql.SQLException
java.sql.SQLException
public void testSavepointRollbackbehaviour12() throws java.sql.SQLException
java.sql.SQLException
public void testSavepointRollbackbehaviour13() throws java.sql.SQLException
java.sql.SQLException
public void testTest4() throws java.sql.SQLException
java.sql.SQLException
public void testPooledConnectionClosed() throws java.sql.SQLException
java.sql.SQLException
public void test_derby_6189() throws java.lang.Exception
java.lang.Exception
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.