org.apache.derbyTesting.functionTests.tests.jdbcapi

Class SetTransactionIsolationTest

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

All Implemented Interfaces:

junit.framework.Test

public class SetTransactionIsolationTest
extends BaseJDBCTestCase

Test setTransactionIsolation

Field Summary

Fields

Modifier and Type	Field and Description
static int[]	isoLevels

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
static junit.framework.Test	baseSuite(java.lang.String name)
private void	checkIsolationLevelNoTimeout(java.sql.Connection conn, int isoLevel) Test setTransactionIsolation and queries with no timeout expected
private void	checkIsolationLevelTimeout(java.sql.Connection conn, int isoLevel) Check setTransactioIsolation and queries with timeout expected in all cases except READ_UNCOMMITTED
static junit.framework.Test	suite()
void	testIsolation() test setting of isolation levels with and without lock timeouts
void	testSetTransactionIsolationCommitRollback() setTransactionIsolation commits?
void	testSetTransactionIsolationInHoldCursor() Call setTransactionIsolation with holdable cursor open?

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

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Field Detail

isoLevels

public static int[] isoLevels

Constructor Detail

SetTransactionIsolationTest

public SetTransactionIsolationTest(java.lang.String name)

Parameters:

name -

Method Detail

testIsolation

public void testIsolation()
                   throws java.sql.SQLException

test setting of isolation levels with and without lock timeouts

Throws:

java.sql.SQLException

checkIsolationLevelTimeout

private void checkIsolationLevelTimeout(java.sql.Connection conn,
                                        int isoLevel)
                                 throws java.sql.SQLException

Check setTransactioIsolation and queries with timeout expected in all cases except READ_UNCOMMITTED

Parameters:

conn - Connection to use

isoLevel - Isolation level to test from Connection.TRANSACTION_*

Throws:

java.sql.SQLException

checkIsolationLevelNoTimeout

private void checkIsolationLevelNoTimeout(java.sql.Connection conn,
                                          int isoLevel)
                                   throws java.sql.SQLException

Test setTransactionIsolation and queries with no timeout expected

Parameters:

conn -

isoLevel -

Throws:

java.sql.SQLException

testSetTransactionIsolationCommitRollback

public void testSetTransactionIsolationCommitRollback()
                                               throws java.sql.SQLException

setTransactionIsolation commits?

Throws:

java.sql.SQLException

testSetTransactionIsolationInHoldCursor

public void testSetTransactionIsolationInHoldCursor()
                                             throws java.sql.SQLException

Call setTransactionIsolation with holdable cursor open?

Throws:

java.sql.SQLException

baseSuite

public static junit.framework.Test baseSuite(java.lang.String name)

suite

public static junit.framework.Test suite()