SavepointJdbc30Test (Apache Derby V10.10 Test Javadoc)

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

All Implemented Interfaces:

junit.framework.Test
```
public class SavepointJdbc30Test
extends BaseJDBCTestCase
```
Test the new class Savepoint in JDBC 30. Also, test some mix and match of defining savepoints through JDBC and SQL testing both callable and prepared statements meta data

Field Summary
- Fields inherited from class org.apache.derbyTesting.junit.BaseTestCase
  DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors
Constructor and Description

SavepointJdbc30Test(java.lang.String name)
Create a test

Constructors
Constructor and Description
`SavepointJdbc30Test(java.lang.String name)` Create a test

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`private static junit.framework.Test`	`getEmbeddedSuite(java.lang.String name)` Create a testsuite containing the tests that can only run in embedded mode.
`protected void`	`setUp()` Set up the test environment.
`static junit.framework.Test`	`suite()` Set up the test suite for embedded mode, client mode, and embedded mode with XADataSources
`void`	`testBug4465()` TEST 5a and 5b for bug 4465 test 5a - create two savepoints in two different transactions and release the first one in the subsequent transaction
`void`	`testBug5817()` Test 23 - bug 5817 - make savepoint and release non-reserved keywords
`void`	`testGrammarCheck()` Test 16 grammar check for savepoint sq1
`void`	`testNameCaseSensitivity()` Test 10 test savepoint name case sensitivity
`void`	`testNameLengthMax128Chars()` Test 24 Savepoint name can't exceed 128 characters
`void`	`testNamesAndIds()` Test4 - Verify names/ids of named/unnamed savepoints named savepoints don't have an id. unnamed savepoints don't have a name (internally, all our savepoints have names, but for unnamed savepoint, that is not exposed through jdbc api)
`void`	`testNoNestedSavepointsInsideJdbcSavepoint()` Test 18
`void`	`testNoNestedSavepointsInsideSqlSavepoint()` Test 19
`void`	`testNoNestedSavepointsWhenUsingSQL()` Test 17
`void`	`testNoSavepointsIfAutoCommit()` Test1.
`void`	`testNoSqlSavepointStartingWithSYS()` Test 22
`void`	`testNoSqlSavepointStartingWithSYSThroughJdbc()` Test 25
`void`	`testNullName()` Test3 - Named savepoints can't pass null for name
`void`	`testQuotes()` Test that savepoint names can have double-quote characters.
`void`	`testReleaseMultipleTimes()` Test 12 releasing a savepoint multiple times - should not work
`void`	`testReleaseNullSavepoint()` Test 26b pass Null value to releaseSavepoint
`void`	`testReleaseReleasedSavepoint()` test 6a - create a savepoint release it and then create another with the same name. and release the first one
`void`	`testReleaseSavepointFromOtherTransaction()` Test 6c: TEST case just for bug 4467 // Test 10 - create a named savepoint with the a generated name savepoint1 = con2.setSavepoint("SAVEPT0"); // what exactly is the correct behaviour here?
`void`	`testReleaseSqlSavepointAndRollback()` Test 21
`void`	`testReusingSavepoints()` Test2 - After releasing a savepoint, should be able to reuse it.
`void`	`testRollbackMultipleTimes()` Test 11 rolling back a savepoint multiple times - should work
`void`	`testRollbackNullSavepoint()` bug 4451 - Test 26a pass Null value to rollback bug 5374 - Passing a null savepoint to rollback or release method used to give a npe in JCC it should give a SQLException aying "Cannot rollback to a null savepoint"
`void`	`testRollbackReleasedSavepoint()` test 6b - create a savepoints release it and then create another with the same name. and rollback the first one
`void`	`testRollbackReleasesSavepointArray()` Test 14 cause a transaction rollback and that should release the internal savepoint array
`void`	`testRollbackSqlSavepointSameAsJdbc()` Test 20
`void`	`testSavepointFromEarlierTransactionAfterToggleAutocommit()` Test 13 shouldn't be able to use a savepoint from earlier transaction after setting autocommit on and off
`void`	`testSavepointName()` Test 9 test savepoint name and verify case sensitivity
`void`	`testSavepointsInBatch()` Test 15 Check savepoints in batch
`void`	`testSwapSavepointsAcrossConnectionAndRelease()` Test 7a: BUG 4468 - should not be able to pass a savepoint from a different transaction for release/rollback
`void`	`testSwapSavepointsAcrossConnectionsAndRollback()` Test 7b - swap savepoints across connections
`void`	`xtestCommitWillReleaseActiveSavepoints()` Test42a - Commit on a connection will release all the savepoints created for that transaction
`void`	`xtestCursorsCloseOnRollback()` Test 46 bug 5145 Cursors declared before and within the savepoint unit will be closed when rolling back the savepoint
`void`	`xtestGetSavepoint()` Test 47 multiple tests for getSavepointId()
`void`	`xtestNestedSavepoints()` Test 48
`void`	`xtestNoConflictWithGeneratedName()` Test40 - We internally generate a unique name for unnamed savepoints.
`void`	`xtestReuseNameAfterRelease()` Test43 - After releasing a savepoint, should be able to reuse it.
`void`	`xtestReuseNameAfterRollback()` Test 45 reuse savepoint name after rollback - should not work
`void`	`xtestRollbackWillReleaseActiveSavepoints()` Test42 - Rollback on a connection will release all the savepoints created for that transaction
`void`	`xtestRollbackWillReleaseLaterSavepoints()` Test41 - Rolling back to a savepoint will release all the savepoints created after that savepoint.

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, tearDown, 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
  - SavepointJdbc30Test
```
public SavepointJdbc30Test(java.lang.String name)
```
    Create a test
    
    Parameters:
    
    name -
- Method Detail
  - suite
```
public static junit.framework.Test suite()
```
    Set up the test suite for embedded mode, client mode, and embedded mode with XADataSources
    
    Returns:
    
    A suite containing embedded, client and embedded with XA suites
  - getEmbeddedSuite
```
private static junit.framework.Test getEmbeddedSuite(java.lang.String name)
```
    Create a testsuite containing the tests that can only run in embedded mode. These tests have names starting with x and are added automatically.
  - setUp
```
protected void setUp()
              throws java.lang.Exception
```
    Set up the test environment.
    
    Overrides:
    
    setUp in class junit.framework.TestCase
    
    Throws:
    
    java.lang.Exception
  - testNoSavepointsIfAutoCommit
```
public void testNoSavepointsIfAutoCommit()
                                  throws java.sql.SQLException
```
    Test1. It should not be possible to set a savepoint if autocommit is on.
    
    Throws:
    
    java.sql.SQLException
  - testReusingSavepoints
```
public void testReusingSavepoints()
                           throws java.sql.SQLException
```
    Test2 - After releasing a savepoint, should be able to reuse it.
    
    Throws:
    
    java.sql.SQLException
  - testNullName
```
public void testNullName()
                  throws java.sql.SQLException
```
    Test3 - Named savepoints can't pass null for name
    
    Throws:
    
    java.sql.SQLException
  - testNamesAndIds
```
public void testNamesAndIds()
                     throws java.sql.SQLException
```
    Test4 - Verify names/ids of named/unnamed savepoints named savepoints don't have an id. unnamed savepoints don't have a name (internally, all our savepoints have names, but for unnamed savepoint, that is not exposed through jdbc api)
    
    Throws:
    
    java.sql.SQLException
  - testBug4465
```
public void testBug4465()
                 throws java.sql.SQLException
```
    TEST 5a and 5b for bug 4465 test 5a - create two savepoints in two different transactions and release the first one in the subsequent transaction
    
    Throws:
    
    java.sql.SQLException
  - testReleaseReleasedSavepoint
```
public void testReleaseReleasedSavepoint()
                                  throws java.sql.SQLException
```
    test 6a - create a savepoint release it and then create another with the same name. and release the first one
    
    Throws:
    
    java.sql.SQLException
  - testRollbackReleasedSavepoint
```
public void testRollbackReleasedSavepoint()
                                   throws java.sql.SQLException
```
    test 6b - create a savepoints release it and then create another with the same name. and rollback the first one
    
    Throws:
    
    java.sql.SQLException
  - testReleaseSavepointFromOtherTransaction
```
public void testReleaseSavepointFromOtherTransaction()
                                              throws java.sql.SQLException
```
    Test 6c: TEST case just for bug 4467 // Test 10 - create a named savepoint with the a generated name savepoint1 = con2.setSavepoint("SAVEPT0"); // what exactly is the correct behaviour here? try { savepoint2 = con2.setSavepoint(); } catch (SQLException se) { System.out.println("Expected Exception is " + se.getMessage()); } con2.commit();
    
    Throws:
    
    java.sql.SQLException
  - testSwapSavepointsAcrossConnectionAndRelease
```
public void testSwapSavepointsAcrossConnectionAndRelease()
                                                  throws java.sql.SQLException
```
    Test 7a: BUG 4468 - should not be able to pass a savepoint from a different transaction for release/rollback
    
    Throws:
    
    java.sql.SQLException
  - testSwapSavepointsAcrossConnectionsAndRollback
```
public void testSwapSavepointsAcrossConnectionsAndRollback()
                                                    throws java.sql.SQLException
```
    Test 7b - swap savepoints across connections
    
    Throws:
    
    java.sql.SQLException
  - testSavepointName
```
public void testSavepointName()
                       throws java.sql.SQLException
```
    Test 9 test savepoint name and verify case sensitivity
    
    Throws:
    
    java.sql.SQLException
  - testNameCaseSensitivity
```
public void testNameCaseSensitivity()
                             throws java.sql.SQLException
```
    Test 10 test savepoint name case sensitivity
    
    Throws:
    
    java.sql.SQLException
  - testRollbackMultipleTimes
```
public void testRollbackMultipleTimes()
                               throws java.sql.SQLException
```
    Test 11 rolling back a savepoint multiple times - should work
    
    Throws:
    
    java.sql.SQLException
  - testReleaseMultipleTimes
```
public void testReleaseMultipleTimes()
                              throws java.sql.SQLException
```
    Test 12 releasing a savepoint multiple times - should not work
    
    Throws:
    
    java.sql.SQLException
  - testSavepointFromEarlierTransactionAfterToggleAutocommit
```
public void testSavepointFromEarlierTransactionAfterToggleAutocommit()
                                                              throws java.sql.SQLException
```
    Test 13 shouldn't be able to use a savepoint from earlier transaction after setting autocommit on and off
    
    Throws:
    
    java.sql.SQLException
  - testRollbackReleasesSavepointArray
```
public void testRollbackReleasesSavepointArray()
                                        throws java.sql.SQLException
```
    Test 14 cause a transaction rollback and that should release the internal savepoint array
    
    Throws:
    
    java.sql.SQLException
  - testSavepointsInBatch
```
public void testSavepointsInBatch()
                           throws java.sql.SQLException
```
    Test 15 Check savepoints in batch
    
    Throws:
    
    java.sql.SQLException
  - testGrammarCheck
```
public void testGrammarCheck()
                      throws java.sql.SQLException
```
    Test 16 grammar check for savepoint sq1
    
    Throws:
    
    java.sql.SQLException
  - testNoNestedSavepointsWhenUsingSQL
```
public void testNoNestedSavepointsWhenUsingSQL()
                                        throws java.sql.SQLException
```
    Test 17
    
    Throws:
    
    java.sql.SQLException
  - testNoNestedSavepointsInsideJdbcSavepoint
```
public void testNoNestedSavepointsInsideJdbcSavepoint()
                                               throws java.sql.SQLException
```
    Test 18
    
    Throws:
    
    java.sql.SQLException
  - testNoNestedSavepointsInsideSqlSavepoint
```
public void testNoNestedSavepointsInsideSqlSavepoint()
                                              throws java.sql.SQLException
```
    Test 19
    
    Throws:
    
    java.sql.SQLException
  - testRollbackSqlSavepointSameAsJdbc
```
public void testRollbackSqlSavepointSameAsJdbc()
                                        throws java.sql.SQLException
```
    Test 20
    
    Throws:
    
    java.sql.SQLException
  - testReleaseSqlSavepointAndRollback
```
public void testReleaseSqlSavepointAndRollback()
                                        throws java.sql.SQLException
```
    Test 21
    
    Throws:
    
    java.sql.SQLException
  - testNoSqlSavepointStartingWithSYS
```
public void testNoSqlSavepointStartingWithSYS()
                                       throws java.sql.SQLException
```
    Test 22
    
    Throws:
    
    java.sql.SQLException
  - testBug5817
```
public void testBug5817()
                 throws java.sql.SQLException
```
    Test 23 - bug 5817 - make savepoint and release non-reserved keywords
    
    Throws:
    
    java.sql.SQLException
  - testNameLengthMax128Chars
```
public void testNameLengthMax128Chars()
                               throws java.sql.SQLException
```
    Test 24 Savepoint name can't exceed 128 characters
    
    Throws:
    
    java.sql.SQLException
  - testNoSqlSavepointStartingWithSYSThroughJdbc
```
public void testNoSqlSavepointStartingWithSYSThroughJdbc()
                                                  throws java.sql.SQLException
```
    Test 25
    
    Throws:
    
    java.sql.SQLException
  - testRollbackNullSavepoint
```
public void testRollbackNullSavepoint()
                               throws java.sql.SQLException
```
    bug 4451 - Test 26a pass Null value to rollback bug 5374 - Passing a null savepoint to rollback or release method used to give a npe in JCC it should give a SQLException aying "Cannot rollback to a null savepoint"
    
    Throws:
    
    java.sql.SQLException
  - testReleaseNullSavepoint
```
public void testReleaseNullSavepoint()
                              throws java.sql.SQLException
```
    Test 26b pass Null value to releaseSavepoint
    
    Throws:
    
    java.sql.SQLException
  - testQuotes
```
public void testQuotes()
                throws java.sql.SQLException
```
    Test that savepoint names can have double-quote characters. The client driver used to fail with a syntax error when the names contained such characters. DERBY-5170.
    
    Throws:
    
    java.sql.SQLException
  - xtestNoConflictWithGeneratedName
```
public void xtestNoConflictWithGeneratedName()
                                      throws java.sql.SQLException
```
    Test40 - We internally generate a unique name for unnamed savepoints. If a named savepoint uses the currently used internal savepoint name, we won't get an exception thrown for it because we prepend external saves with "e." to avoid name conflicts.
    
    Throws:
    
    java.sql.SQLException
  - xtestRollbackWillReleaseLaterSavepoints
```
public void xtestRollbackWillReleaseLaterSavepoints()
                                             throws java.sql.SQLException
```
    Test41 - Rolling back to a savepoint will release all the savepoints created after that savepoint.
    
    Throws:
    
    java.sql.SQLException
  - xtestRollbackWillReleaseActiveSavepoints
```
public void xtestRollbackWillReleaseActiveSavepoints()
                                              throws java.sql.SQLException
```
    Test42 - Rollback on a connection will release all the savepoints created for that transaction
    
    Throws:
    
    java.sql.SQLException
  - xtestCommitWillReleaseActiveSavepoints
```
public void xtestCommitWillReleaseActiveSavepoints()
                                            throws java.sql.SQLException
```
    Test42a - Commit on a connection will release all the savepoints created for that transaction
    
    Throws:
    
    java.sql.SQLException
  - xtestReuseNameAfterRelease
```
public void xtestReuseNameAfterRelease()
                                throws java.sql.SQLException
```
    Test43 - After releasing a savepoint, should be able to reuse it.
    
    Throws:
    
    java.sql.SQLException
  - xtestReuseNameAfterRollback
```
public void xtestReuseNameAfterRollback()
                                 throws java.sql.SQLException
```
    Test 45 reuse savepoint name after rollback - should not work
    
    Throws:
    
    java.sql.SQLException
  - xtestCursorsCloseOnRollback
```
public void xtestCursorsCloseOnRollback()
                                 throws java.sql.SQLException
```
    Test 46 bug 5145 Cursors declared before and within the savepoint unit will be closed when rolling back the savepoint
    
    Throws:
    
    java.sql.SQLException
  - xtestGetSavepoint
```
public void xtestGetSavepoint()
                       throws java.sql.SQLException
```
    Test 47 multiple tests for getSavepointId()
    
    Throws:
    
    java.sql.SQLException
  - xtestNestedSavepoints
```
public void xtestNestedSavepoints()
                           throws java.sql.SQLException
```
    Test 48
    
    Throws:
    
    java.sql.SQLException

Class SavepointJdbc30Test

Field Summary

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

Constructor Summary

Method Summary

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

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

Methods inherited from class junit.framework.TestCase

Methods inherited from class java.lang.Object

Constructor Detail

SavepointJdbc30Test

Method Detail

suite

getEmbeddedSuite

setUp

testNoSavepointsIfAutoCommit

testReusingSavepoints

testNullName

testNamesAndIds

testBug4465

testReleaseReleasedSavepoint

testRollbackReleasedSavepoint

testReleaseSavepointFromOtherTransaction

testSwapSavepointsAcrossConnectionAndRelease

testSwapSavepointsAcrossConnectionsAndRollback

testSavepointName

testNameCaseSensitivity

testRollbackMultipleTimes

testReleaseMultipleTimes

testSavepointFromEarlierTransactionAfterToggleAutocommit

testRollbackReleasesSavepointArray

testSavepointsInBatch

testGrammarCheck

testNoNestedSavepointsWhenUsingSQL

testNoNestedSavepointsInsideJdbcSavepoint

testNoNestedSavepointsInsideSqlSavepoint

testRollbackSqlSavepointSameAsJdbc

testReleaseSqlSavepointAndRollback

testNoSqlSavepointStartingWithSYS

testBug5817

testNameLengthMax128Chars

testNoSqlSavepointStartingWithSYSThroughJdbc

testRollbackNullSavepoint

testReleaseNullSavepoint

testQuotes

xtestNoConflictWithGeneratedName

xtestRollbackWillReleaseLaterSavepoints

xtestRollbackWillReleaseActiveSavepoints

xtestCommitWillReleaseActiveSavepoints

xtestReuseNameAfterRelease

xtestReuseNameAfterRollback

xtestCursorsCloseOnRollback

xtestGetSavepoint

xtestNestedSavepoints