org.apache.derbyTesting.unitTests.junit

Class JDBCStatementCacheTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.unitTests.junit.JDBCStatementCacheTest

All Implemented Interfaces:

junit.framework.Test

public class JDBCStatementCacheTest
extends BaseJDBCTestCase

Tests basic operation of the JDBC prepared statement object cache and the keys used to operate on it.

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
static junit.framework.Test	suite() Returns the appropriate tests.
void	testBasicCallableVsPrepared() Make sure requesting a cached callable statement does not return a PreparedStatement object.
void	testBasicDuplicateKeyInsertion() Test insertion of a duplicate key.
void	testBasicInsertion() Test basic insertion into the cache.
void	testCreateCacheWithZeroOrNegativeMaxSize() Make sure a negative or zero max size is not allowed, as this will in effect be no caching but with an overhead.

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

JDBCStatementCacheTest

public JDBCStatementCacheTest(java.lang.String name)

Method Detail

testCreateCacheWithZeroOrNegativeMaxSize

public void testCreateCacheWithZeroOrNegativeMaxSize()

Make sure a negative or zero max size is not allowed, as this will in effect be no caching but with an overhead.

The overhead would come from always throwing out the newly inserted element.

testBasicInsertion

public void testBasicInsertion()
                        throws java.sql.SQLException

Test basic insertion into the cache.

Throws:

java.sql.SQLException - if obtaining a PreparedStatement fails

testBasicDuplicateKeyInsertion

public void testBasicDuplicateKeyInsertion()
                                    throws java.sql.SQLException

Test insertion of a duplicate key.

Throws:

java.sql.SQLException - if obtaining a PreparedStatement fails

testBasicCallableVsPrepared

public void testBasicCallableVsPrepared()
                                 throws java.sql.SQLException

Make sure requesting a cached callable statement does not return a PreparedStatement object.

Throws:

java.sql.SQLException - if creating database resources fail

suite

public static junit.framework.Test suite()

Returns the appropriate tests.

Run only client/server, because the code being tested does not live in the embedded driver (yet).

Returns:

A suite of tests (may be empty).