org.apache.derbyTesting.functionTests.tests.jdbc4

Class StatementEventsTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.functionTests.tests.jdbc4.StatementEventsTest

All Implemented Interfaces:

junit.framework.Test

public class StatementEventsTest
extends BaseJDBCTestCase

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
private static class	StatementEventsTest.SimpleListener A simple StatementEventListener that counts the number of times it has been triggered.
private static class	StatementEventsTest.Suite Test suite class which contains all test cases in StatementEventsTest for a given configuration.

Field Summary

Fields

Modifier and Type	Field and Description
private boolean	callable Type of statement to use.
private int	closedCount Number of times statementClosed events have been raised.
private java.sql.Statement	closedStatement The statement that caused the last statementClosed event.
private java.sql.Connection	connection The connection object to use in the test.
private int	errorCount Number of times statementError events have been raised.
private java.sql.Statement	errorStatement The statement that caused the last statementError event.
private javax.sql.PooledConnection	pooledConnection The pooled connection to use in the test (could also be an XA connection).
private boolean	xa Type of data source to use.

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
StatementEventsTest(java.lang.String name) Create a test with the given name.

Method Summary

Methods

Modifier and Type	Method and Description
private static junit.framework.Test	baseSuite(java.lang.String name) Return suite with all tests of the class for all combinations of pooled/xa connection and prepared/callable statement.
java.lang.String	getName() Return the name of the test.
private java.sql.PreparedStatement	prepare(java.lang.String sql) Prepare a statement.
private void	setCallable(boolean callable) Set whether the test should use CallableStatement or PreparedStatement.
void	setUp() Set up the connection to the database and register a statement event listener.
private void	setXA(boolean xa) Set whether the test should use XADataSource or ConnectionPoolDataSource.
static junit.framework.Test	suite() Create a test suite with all tests in the class.
protected void	tearDown() Free resources used in the test.
void	testAddListenerFromListener() Test that adding a listener from a listener works.
void	testAddNullListener() Test that you don't get a NullPointerException when the listeners are triggered and one of them is null.
void	testAddRemoveListenerOnClosedObject() Test how addStatementEventListener() and removeStatementEventListener() behave when they are called on a closed PooledConnection or XAConnection.
void	testCloseEvent() Test that a close event is raised when a statement is closed.
void	testCloseEventOnClosedConnection() Test whether a close event is raised when a connection is closed.
void	testDoubleAddListener() Test how the listener behaves if it is added twice.
void	testErrorEventOnClosedConnection() Test that an error event is raised when execute() fails because the connection is closed.
void	testRemoveListenerFromListener() Test that removing a listener from a listener works.
void	testRemoveListenerNotAddedFirst() Test that removing a listener that hasn't been added first, doesn't cause any errors.
void	testRemoveNullListener() Test that you can call removeStatementEventListener() with a null argument.

Methods inherited from class org.apache.derbyTesting.junit.BaseJDBCTestCase

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

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

alarm, assertDirectoryDeleted, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertEquals, assertExecJavaCmdAsExpected, assertLaunchedJUnitTestMethod, assertLaunchedJUnitTestMethod, assertSameNullness, assertSecurityManager, assertThrowableEquals, currentDirectory, 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

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, run, run, runTest, setName, toString

Methods inherited from class java.lang.Object

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

Field Detail

xa

private boolean xa

Type of data source to use. If true, use XADataSource; otherwise, use ConnectionPoolDataSource.

callable

private boolean callable

Type of statement to use. If true, use CallableStatement; otherwise, use PreparedStatement.

closedStatement

private java.sql.Statement closedStatement

The statement that caused the last statementClosed event.

closedCount

private int closedCount

Number of times statementClosed events have been raised.

errorStatement

private java.sql.Statement errorStatement

The statement that caused the last statementError event.

errorCount

private int errorCount

Number of times statementError events have been raised.

pooledConnection

private javax.sql.PooledConnection pooledConnection

The pooled connection to use in the test (could also be an XA connection).

connection

private java.sql.Connection connection

The connection object to use in the test.

Constructor Detail

StatementEventsTest

public StatementEventsTest(java.lang.String name)

Create a test with the given name.

Parameters:

name - name of the test.

Method Detail

setXA

private void setXA(boolean xa)

Set whether the test should use XADataSource or ConnectionPoolDataSource.

Parameters:

xa - if true, use XA

setCallable

private void setCallable(boolean callable)

Set whether the test should use CallableStatement or PreparedStatement.

Parameters:

callable - if true, use callable statement; otherwise, use prepared statement

getName

public java.lang.String getName()

Return the name of the test.

Overrides:

getName in class junit.framework.TestCase

Returns:

name of the test

setUp

public void setUp()
           throws java.sql.SQLException

Set up the connection to the database and register a statement event listener.

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.sql.SQLException - if a database error occurs

tearDown

protected void tearDown()
                 throws java.lang.Exception

Free resources used in the test.

Overrides:

tearDown in class BaseJDBCTestCase

Throws:

java.lang.Exception - if an error occurs

baseSuite

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

Return suite with all tests of the class for all combinations of pooled/xa connection and prepared/callable statement.

Parameters:

name - name of the test suite

Returns:

a test suite

suite

public static junit.framework.Test suite()

Create a test suite with all tests in the class.

prepare

private java.sql.PreparedStatement prepare(java.lang.String sql)
                                    throws java.sql.SQLException

Prepare a statement.

Parameters:

sql - SQL text

Returns:

a PreparedStatement or CallableStatement object

Throws:

java.sql.SQLException - if a database error occurs

testCloseEvent

public void testCloseEvent()
                    throws java.sql.SQLException

Test that a close event is raised when a statement is closed.

Throws:

java.sql.SQLException - if a database error occurs

testAddNullListener

public void testAddNullListener()
                         throws java.sql.SQLException

Test that you don't get a NullPointerException when the listeners are triggered and one of them is null. DERBY-3695

Throws:

java.sql.SQLException

testRemoveNullListener

public void testRemoveNullListener()
                            throws java.sql.SQLException

Test that you can call removeStatementEventListener() with a null argument.

Throws:

java.sql.SQLException

testDoubleAddListener

public void testDoubleAddListener()
                           throws java.sql.SQLException

Test how the listener behaves if it is added twice.

Throws:

java.sql.SQLException

testCloseEventOnClosedConnection

public void testCloseEventOnClosedConnection()
                                      throws java.sql.SQLException

Test whether a close event is raised when a connection is closed. (Client should raise a close event since the connection calls close() on its statements. Embedded should not raise a close event since the connection does not call close() on its statements.)

Throws:

java.sql.SQLException - if a database error occurs

testErrorEventOnClosedConnection

public void testErrorEventOnClosedConnection()
                                      throws java.sql.SQLException

Test that an error event is raised when execute() fails because the connection is closed.

Throws:

java.sql.SQLException - if a database error occurs

testRemoveListenerFromListener

public void testRemoveListenerFromListener()
                                    throws java.sql.SQLException

Test that removing a listener from a listener works. (DERBY-3401)

Throws:

java.sql.SQLException

testAddListenerFromListener

public void testAddListenerFromListener()
                                 throws java.sql.SQLException

Test that adding a listener from a listener works. (DERBY-3401)

Throws:

java.sql.SQLException

testAddRemoveListenerOnClosedObject

public void testAddRemoveListenerOnClosedObject()
                                         throws java.sql.SQLException

Test how addStatementEventListener() and removeStatementEventListener() behave when they are called on a closed PooledConnection or XAConnection.

Throws:

java.sql.SQLException

testRemoveListenerNotAddedFirst

public void testRemoveListenerNotAddedFirst()
                                     throws java.sql.SQLException

Test that removing a listener that hasn't been added first, doesn't cause any errors.

Throws:

java.sql.SQLException