org.apache.derbyTesting.functionTests.tests.lang

Class XMLConcurrencyTest

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

All Implemented Interfaces:

junit.framework.Test

public class XMLConcurrencyTest
extends BaseJDBCTestCase

Test that XML operators can be invoked by multiple threads concurrently. Regression test case for DERBY-3870.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
private class	XMLConcurrencyTest.WorkerThread A thread class that does the actual work in the test.

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
XMLConcurrencyTest(java.lang.String name) Create an instance of this test case.

Method Summary

Modifier and Type	Method and Description
private static void	createTestTable(java.sql.Statement s) Create a table with test data.
private static void	runXMLTest(java.sql.Connection conn, int iterations) Do the work for one of the worker threads.
static junit.framework.Test	suite() Create a suite of all test cases in this class.
void	testConcurrency() Start four threads that execute queries that use all the XML operators.

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

Constructor Detail

XMLConcurrencyTest

public XMLConcurrencyTest(java.lang.String name)

Create an instance of this test case.

Method Detail

suite

public static junit.framework.Test suite()

Create a suite of all test cases in this class.

testConcurrency

public void testConcurrency()
                     throws java.lang.Exception

Start four threads that execute queries that use all the XML operators. If each thread manages 100 iterations without failing, running concurrently with the other threads, the test case passes.

Throws:

java.lang.Exception

createTestTable

private static void createTestTable(java.sql.Statement s)
                             throws java.sql.SQLException

Create a table with test data. The table contains three columns:

1. An ID column used to identify the rows and to give a stable ordering.
2. A VARCHAR column holding the string representation of an XML document.
3. An XML column holding the XML representation of the document in the VARCHAR column.

Throws:

java.sql.SQLException

runXMLTest

private static void runXMLTest(java.sql.Connection conn,
                               int iterations)
                        throws java.sql.SQLException

Do the work for one of the worker threads. Perform queries that use all the XML operators. Repeat the queries the specified number of times.

Parameters:

conn - the connection on which to execute the queries

iterations - the number of times each query should be executed

Throws:

java.sql.SQLException