org.apache.derby.client.am

Class LogicalStatementEntityTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derby.client.am.LogicalStatementEntityTest

All Implemented Interfaces:

junit.framework.Test

public class LogicalStatementEntityTest
extends BaseJDBCTestCase

Tests for the handling of logical statements.

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
private org.apache.derby.client.am.LogicalStatementEntity	createLogicalStatementEntity(java.lang.String sql, boolean isCallable, org.apache.derby.client.am.stmtcache.JDBCStatementCache cache) Creates a logical statement entity.
private org.apache.derby.client.am.stmtcache.StatementKey	insertStatementIntoCache(org.apache.derby.client.am.stmtcache.JDBCStatementCache cache, java.sql.PreparedStatement ps, java.lang.String sql) Insers the statement into the cache.
static junit.framework.Test	suite() Returns a suite of tests running in a client-server environment.
void	testCloseBehaviorExternalCs() Verifies that the logical statement representing a callable statement behaves correctly when it has been closed.
void	testCloseBehaviorExternalPs() Verifies that the logical statement representing a prepared statement behaves correctly when it has been closed.
void	testClosedUnderlyingStatement() Tries to execute a method on a logical statement when the underlying physical statement has been closed without the logical connection knowing.
void	testCloseOnDuplicateStatement() Tests that a statement equal to one in the cache is not cached when closing the logical statement, and that the physical statement is closed.
void	testCloseWhenStatementShallBeCached() Asserts that closing the logical statement and caching the physical one does close the logical one but not the physical one.
void	testEvictionFromCache() Tests that the cache throws out the least frequently used statement when it reaches its maximum capacity, and that the thrown out statement is closed in the process.

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

LogicalStatementEntityTest

public LogicalStatementEntityTest(java.lang.String name)

Method Detail

testCloseBehaviorExternalPs

public void testCloseBehaviorExternalPs()
                                 throws java.sql.SQLException

Verifies that the logical statement representing a prepared statement behaves correctly when it has been closed.

Throws:

java.sql.SQLException - if a JDBC operation fails

testCloseBehaviorExternalCs

public void testCloseBehaviorExternalCs()
                                 throws java.sql.SQLException

Verifies that the logical statement representing a callable statement behaves correctly when it has been closed.

Throws:

java.sql.SQLException - if a JDBC operation fails

testCloseOnDuplicateStatement

public void testCloseOnDuplicateStatement()
                                   throws java.sql.SQLException

Tests that a statement equal to one in the cache is not cached when closing the logical statement, and that the physical statement is closed.

Throws:

java.sql.SQLException - if a JDBC operation fails

testCloseWhenStatementShallBeCached

public void testCloseWhenStatementShallBeCached()
                                         throws java.sql.SQLException

Asserts that closing the logical statement and caching the physical one does close the logical one but not the physical one.

Throws:

java.sql.SQLException - if a JDBC operation fails

testClosedUnderlyingStatement

public void testClosedUnderlyingStatement()
                                   throws java.sql.SQLException

Tries to execute a method on a logical statement when the underlying physical statement has been closed without the logical connection knowing.

Throws:

java.sql.SQLException - if something goes wrong...

testEvictionFromCache

public void testEvictionFromCache()
                           throws java.sql.SQLException

Tests that the cache throws out the least frequently used statement when it reaches its maximum capacity, and that the thrown out statement is closed in the process.

Note: This test assumes things about the replacement policy.

Throws:

java.sql.SQLException - if a JDBC operation fails

suite

public static junit.framework.Test suite()

Returns a suite of tests running in a client-server environment.

Returns:

A test suite.

createLogicalStatementEntity

private org.apache.derby.client.am.LogicalStatementEntity createLogicalStatementEntity(java.lang.String sql,
                                                                                       boolean isCallable,
                                                                                       org.apache.derby.client.am.stmtcache.JDBCStatementCache cache)
                                                                                throws java.sql.SQLException

Creates a logical statement entity.

The entity represents a prepared statement.

Parameters:

sql - the SQL text

isCallable - whether the entity is a callable statement or not

cache - the statement cache to interact with.

Returns:

A logical statement entity.

Throws:

java.sql.SQLException - if creating the entity fails

insertStatementIntoCache

private org.apache.derby.client.am.stmtcache.StatementKey insertStatementIntoCache(org.apache.derby.client.am.stmtcache.JDBCStatementCache cache,
                                                                                   java.sql.PreparedStatement ps,
                                                                                   java.lang.String sql)
                                                                            throws java.sql.SQLException

Insers the statement into the cache.

Parameters:

cache - the to insert into

ps - the statement to insert

sql - the SQL text of the statement

Returns:

The key the statement was inserted with.

Throws:

java.sql.SQLException - if getting the connection holdability fails