public class ProcedureInTriggerTest extends BaseJDBCTestCase
Modifier and Type | Field and Description |
---|---|
private static int |
getConnectionProcCount |
private static int |
selectRowsCount |
private static int |
zeroArgCount |
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
Constructor and Description |
---|
ProcedureInTriggerTest(java.lang.String name) |
Modifier and Type | Method and Description |
---|---|
static void |
alterTable() |
private static junit.framework.Test |
basesuite() |
private void |
checkAndResetGetConnectionProcCount(int count) |
private void |
checkAndResetSelectRowsCount(int count) |
private void |
checkAndResetZeroArgCount(int count) |
static void |
createIndex() |
static void |
createTrigger() |
static void |
deleteRow(int p1) |
static void |
doConnCommit() |
static int |
doConnCommitInt() |
static void |
doConnectionSetIsolation() |
static void |
doConnRollback() |
static void |
dropIndex() |
static void |
dropTable() |
static void |
dropTrigger() |
static void |
getConnectionProc() |
static void |
insertRow(int p1) |
static void |
insertRow(int p1,
java.lang.String p2) |
static void |
selectRows(int p1,
int p2,
java.sql.ResultSet[] data1,
java.sql.ResultSet[] data2) |
static void |
selectRows(int p1,
java.sql.ResultSet[] data) |
static void |
selectRows(java.lang.String table,
java.sql.ResultSet[] rs) |
static junit.framework.Test |
suite() |
protected void |
tearDown()
Tear down the test environment.
|
void |
testModifiesSql()
Test triggers that MODIFY SQL DATA
|
void |
testTriggerContainsSql()
Test CONTAINS SQL triggers (neither reads no writes data)
procedure does just a getConnection and that's it.
|
void |
testTriggerNegative()
Some misc negative tests for procedures in triggers.
|
void |
testTriggerNoSql()
Test triggers that fire procedures with no sql
|
void |
testTriggerReadsSql()
Test triggers for procedures that READ SQL DATA
|
static void |
updateRow(int p1) |
static void |
zeroArg() |
assertCallError, assertCheckTable, assertCommitError, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertErrorCode, assertGetIntError, assertNextError, assertPreparedStatementError, assertResults, assertResults, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertStatementErrorUnordered, assertTableRowCount, assertUpdateCount, assertUpdateCount, assertWarning, chattyPrepare, chattyPrepareCall, checkAllConsistency, checkEstimatedRowCount, closeStatement, commit, createStatement, createStatement, createStatement, dropTable, dropTable, dropView, dropView, dumpRs, dumpRs, emptyStatementCache, executeQuery, expectCompilationError, expectCompilationError, expectExecutionError, getClientTransactionID, getConnection, getDatabaseProperty, getLastSQLException, goodStatement, goodUpdate, 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
alarm, assertDirectoryDeleted, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertExecJavaCmdAsExpected, assertLaunchedJUnitTestMethod, assertLaunchedJUnitTestMethod, assertSameNullness, assertSecurityManager, assertThrowableEquals, currentDirectory, execJavaCmd, execJavaCmd, execJavaCmd, fail, getClassVersionMajor, getEmmaJar, getFailureFolder, getFilesWith, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, hasInterruptibleIO, isCVM, isIBMJVM, isJ9Platform, isJava5, isJava7, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, newAssertionFailedError, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemErr, setSystemOut, setSystemProperty, sleep, sleepAtLeastOneTick, traceit, vmAtLeast
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
private static int zeroArgCount
private static int getConnectionProcCount
private static int selectRowsCount
public void testTriggerNoSql() throws java.sql.SQLException
java.sql.SQLException
public void testTriggerContainsSql() throws java.sql.SQLException
java.sql.SQLException
public void testTriggerReadsSql() throws java.sql.SQLException
java.sql.SQLException
public void testModifiesSql() throws java.sql.SQLException
java.sql.SQLException
public void testTriggerNegative() throws java.sql.SQLException
java.sql.SQLException
private static junit.framework.Test basesuite()
public static junit.framework.Test suite()
protected void tearDown() throws java.lang.Exception
tearDown
in class BaseJDBCTestCase
java.lang.Exception
private void checkAndResetZeroArgCount(int count)
public static void zeroArg()
private void checkAndResetGetConnectionProcCount(int count)
public static void getConnectionProc() throws java.lang.Throwable
java.lang.Throwable
private void checkAndResetSelectRowsCount(int count)
public static void selectRows(int p1, java.sql.ResultSet[] data) throws java.sql.SQLException
java.sql.SQLException
public static void selectRows(int p1, int p2, java.sql.ResultSet[] data1, java.sql.ResultSet[] data2) throws java.sql.SQLException
java.sql.SQLException
public static void selectRows(java.lang.String table, java.sql.ResultSet[] rs) throws java.sql.SQLException
java.sql.SQLException
public static void insertRow(int p1) throws java.sql.SQLException
java.sql.SQLException
public static void insertRow(int p1, java.lang.String p2) throws java.sql.SQLException
java.sql.SQLException
public static void updateRow(int p1) throws java.sql.SQLException
java.sql.SQLException
public static void deleteRow(int p1) throws java.sql.SQLException
java.sql.SQLException
public static void alterTable() throws java.sql.SQLException
java.sql.SQLException
public static void dropTable() throws java.sql.SQLException
java.sql.SQLException
public static int doConnCommitInt() throws java.lang.Throwable
java.lang.Throwable
public static void doConnCommit() throws java.lang.Throwable
java.lang.Throwable
public static void doConnRollback() throws java.lang.Throwable
java.lang.Throwable
public static void doConnectionSetIsolation() throws java.lang.Throwable
java.lang.Throwable
public static void createIndex() throws java.sql.SQLException
java.sql.SQLException
public static void dropIndex() throws java.sql.SQLException
java.sql.SQLException
public static void createTrigger() throws java.sql.SQLException
java.sql.SQLException
public static void dropTrigger() throws java.sql.SQLException
java.sql.SQLException
Apache Derby V10.13 Internals - Copyright © 2004,2016 The Apache Software Foundation. All Rights Reserved.