org.apache.derbyTesting.functionTests.tests.lang

Class PrepareExecuteDDL

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

All Implemented Interfaces:

junit.framework.Test

public class PrepareExecuteDDL
extends BaseJDBCTestCase

Test the dependency system for active statements when a DDL is executed in a separate connection after the prepare but before the execute.

Field Summary

Fields

Modifier and Type	Field and Description
private java.sql.Connection	connDDL Connection to execute the DDL on.
private java.lang.String	ddl
private static java.lang.String[]	DDL All the DDL commands that will be executed, one per fixture, as the mutation between the prepare and execute.
private static java.lang.String[]	STMTS List of statements that are prepared and then executed.

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Modifier	Constructor and Description
private	PrepareExecuteDDL(java.lang.String name, java.lang.String ddl)

Method Summary

Modifier and Type	Method and Description
private void	checkGrantRevoke(java.sql.PreparedStatement ps, java.lang.String sql)
private void	checkSelect(java.sql.PreparedStatement ps, java.lang.String sql)
protected void	setUp() Set the fixture up with a clean, standard table PED001.
static junit.framework.Test	suite() Create a suite of tests, one per statement in DDL.
private boolean	tableDropped()
protected void	tearDown() Tear-down the fixture by removing the table (if it still exists).
void	testPrepareExcute()

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

connDDL

private java.sql.Connection connDDL

Connection to execute the DDL on. Needs to be different to the single connection provided by the super-class. This connection is used to execute DDL while the other connection has open objcts dependent on the objct changed by the DDL.

STMTS

private static final java.lang.String[] STMTS

List of statements that are prepared and then executed. The testPrepareExecute method prepares each statement in this list, executes one DDL, executes each prepared statement and then checks the result.
The result checking is driven off the initial text of the statement.

DDL

private static final java.lang.String[] DDL

All the DDL commands that will be executed, one per fixture, as the mutation between the prepare and execute.

ddl

private final java.lang.String ddl

Constructor Detail

PrepareExecuteDDL

private PrepareExecuteDDL(java.lang.String name,
                          java.lang.String ddl)

Method Detail

suite

public static junit.framework.Test suite()

Create a suite of tests, one per statement in DDL. This test is for testing the embedded dependency system though possibly it could be used for testing in client as well.

tableDropped

private boolean tableDropped()

testPrepareExcute

public void testPrepareExcute()
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

checkSelect

private void checkSelect(java.sql.PreparedStatement ps,
                         java.lang.String sql)
                  throws java.sql.SQLException

Throws:

java.sql.SQLException

checkGrantRevoke

private void checkGrantRevoke(java.sql.PreparedStatement ps,
                              java.lang.String sql)
                       throws java.sql.SQLException

Throws:

java.sql.SQLException

setUp

protected void setUp()
              throws java.sql.SQLException

Set the fixture up with a clean, standard table PED001.

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.sql.SQLException

tearDown

protected void tearDown()
                 throws java.lang.Exception

Tear-down the fixture by removing the table (if it still exists).

Overrides:

tearDown in class BaseJDBCTestCase

Throws:

java.lang.Exception