SQLSessionContextTest (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.lang.SQLSessionContextTest

All Implemented Interfaces:

junit.framework.Test
```
public class SQLSessionContextTest
extends BaseJDBCTestCase
```
SQLSessionContextTest tests the SQL session context stacking, cf. SQL 4.37.3. The testing of one of the SQL session state variable, the current role, relies on sqlAuthorization being set, so use sqlAuthorization=true. State variables tested: current role (SET ROLE , CURRENT_ROLE) current default schema (SET SCHEMA , CURRENT SCHEMA) SET SCHEMA and SET ROLE are SQL SESSION statements and are not transaction-initiating, cf. SQL section 4.33. The tests are run in the cross product: {client/server, embedded} x {data base owner} See also RoutinesDefinersRightsTest, which tests the current user part of the SQLSessionContext.

Field Summary

Fields
Modifier and Type	Field and Description
`private java.sql.Connection`	`_conn`
`private java.sql.Statement`	`_stm`
`private static java.lang.String[]`	`currentPrefix` SQL prefix used to retrieve current value of a session context state variable.
`private static java.lang.String`	`pwSuffix`
`private static java.lang.String`	`userException` SQL states used by test
`private static java.lang.String[]`	`users` The TestConfiguration.sqlAuthorizationDecorator decorator presumes TEST_DBO as dbo, so add it to set of valid users.
`private static java.lang.String[]`	`variableKeywords` SQL keywords for session context state variables

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

Constructor Summary

Constructors
Constructor and Description

SQLSessionContextTest(java.lang.String name)
Create a new instance of SQLSessionContextTest.

Constructors
Constructor and Description
`SQLSessionContextTest(java.lang.String name)` Create a new instance of SQLSessionContextTest.

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`private static void`	`assertCurrent(java.lang.String sessionVar, java.sql.ResultSet rs, java.lang.String expected)`
`static void`	`calledNestedFromP2(java.lang.String stateString)` Called from p2 so we get to test with a call stack 3 levels deep.
`static void`	`dropper()` Test that when a nested routine drops a role/schema, the current value is correctly reset.
`static int`	`f2()` Utility function used to test that state variables are stacked correctly in a nested SQL session context.
`static int`	`f22()` Used to test that a parallel (subsequent) function call in the same statement (called after f2 which changes state) is not affected by the preceding function (f2) call's changes.
`static int`	`f3()` Utility function used to test that current state is stacked correctly in a nested SQL session context.
`static void`	`p2(java.sql.ResultSet[] rs1, java.sql.ResultSet[] rs2)` Utility procedure used to test that current session state is stacked correctly in a nested SQL session context.
`private static junit.framework.Test`	`positiveSuite(java.lang.String framework)` Construct suite of positive tests
`protected void`	`setUp()`
`static junit.framework.Test`	`suite()` Construct top level suite in this JUnit test
`protected void`	`tearDown()` Tear down this fixture, sub-classes should call super.tearDown().
`void`	`testPositive()` Positive tests for SQL session state.

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

- Field Detail
  - _conn
```
private java.sql.Connection _conn
```
  - _stm
```
private java.sql.Statement _stm
```
  - pwSuffix
```
private static final java.lang.String pwSuffix
```
    See Also:
    
    Constant Field Values
  - userException
```
private static final java.lang.String userException
```
    SQL states used by test
    
    See Also:
    
    Constant Field Values
  - users
```
private static final java.lang.String[] users
```
    The TestConfiguration.sqlAuthorizationDecorator decorator presumes TEST_DBO as dbo, so add it to set of valid users. It uses a fresh db 'dbsqlauth', not 'wombat'.
  - variableKeywords
```
private static final java.lang.String[] variableKeywords
```
    SQL keywords for session context state variables
  - currentPrefix
```
private static final java.lang.String[] currentPrefix
```
    SQL prefix used to retrieve current value of a session context state variable. Cf. variableKeywords.
- Constructor Detail
  - SQLSessionContextTest
```
public SQLSessionContextTest(java.lang.String name)
```
    Create a new instance of SQLSessionContextTest.
    
    Parameters:
    
    name - Fixture name
- Method Detail
  - suite
```
public static junit.framework.Test suite()
```
    Construct top level suite in this JUnit test
    
    Returns:
    
    A suite containing embedded and client suites. Client/server suite commented out to speed up this test as it does not add much value given the nature of the changes (SQL language only).
  - positiveSuite
```
private static junit.framework.Test positiveSuite(java.lang.String framework)
```
    Construct suite of positive tests
    
    Parameters:
    
    framework - Derby framework indication
    
    Returns:
    
    A suite containing the positive test cases incarnated only for security level sqlAuthorization.
  - testPositive
```
public void testPositive()
                  throws java.sql.SQLException
```
    Positive tests for SQL session state.
    
    Throws:
    
    java.sql.SQLException
  - 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
  - assertCurrent
```
private static void assertCurrent(java.lang.String sessionVar,
                                  java.sql.ResultSet rs,
                                  java.lang.String expected)
                           throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - p2
```
public static void p2(java.sql.ResultSet[] rs1,
                      java.sql.ResultSet[] rs2)
               throws java.lang.Throwable
```
    Utility procedure used to test that current session state is stacked correctly in a nested SQL session context.
    
    Throws:
    
    java.lang.Throwable
  - calledNestedFromP2
```
public static void calledNestedFromP2(java.lang.String stateString)
                               throws java.sql.SQLException
```
    Called from p2 so we get to test with a call stack 3 levels deep.
    
    Throws:
    
    java.sql.SQLException
  - f2
```
public static int f2()
              throws java.sql.SQLException
```
    Utility function used to test that state variables are stacked correctly in a nested SQL session context.
    
    Throws:
    
    java.sql.SQLException
  - f22
```
public static int f22()
               throws java.sql.SQLException
```
    Used to test that a parallel (subsequent) function call in the same statement (called after f2 which changes state) is not affected by the preceding function (f2) call's changes.
    
    Throws:
    
    java.sql.SQLException
  - f3
```
public static int f3()
              throws java.sql.SQLException
```
    Utility function used to test that current state is stacked correctly in a nested SQL session context. This particular function will throw and exception. This is used to test that the cleaning up pops the SQL session stack also.
    
    Throws:
    
    java.sql.SQLException
  - dropper
```
public static void dropper()
                    throws java.sql.SQLException
```
    Test that when a nested routine drops a role/schema, the current value is correctly reset. For roles, the current role is unchanged, since it is lazily checked (and potentially reset to NONE if it no longer exists or it is no longer granted to session user) only when it is attempted used for anything. For schema, the current schema should revert back to the session's default schema. This holds for all frames on the session context stack (see also caller's check).
    
    Throws:
    
    java.sql.SQLException

Class SQLSessionContextTest

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

Field Detail

_conn

_stm

pwSuffix

userException

users

variableKeywords

currentPrefix

Constructor Detail

SQLSessionContextTest

Method Detail

suite

positiveSuite

testPositive

setUp

tearDown

assertCurrent

p2

calledNestedFromP2

f2

f22

f3

dropper