org.apache.derbyTesting.functionTests.tests.lang

Class Bug4356Test

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

All Implemented Interfaces:

junit.framework.Test

public class Bug4356Test
extends BaseJDBCTestCase

Demonstrate subselect behavior with prepared statement.

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
Bug4356Test(java.lang.String name) Basic constructor.

Method Summary

Modifier and Type	Method and Description
protected void	initializeConnection(java.sql.Connection conn) Sets the auto commit to false.
protected void	setUp() Bug only happens when autocommit is off.
static junit.framework.Test	suite() Returns the implemented tests.
void	testBug4356() Check fix for Bug4356 - Prepared statement parameter buffers are not cleared between calls to executeUpdate() in the same transaction.

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, 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, toString

Methods inherited from class java.lang.Object

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

Constructor Detail

Bug4356Test

public Bug4356Test(java.lang.String name)

Basic constructor.

Method Detail

initializeConnection

protected void initializeConnection(java.sql.Connection conn)
                             throws java.sql.SQLException

Sets the auto commit to false.

Overrides:

initializeConnection in class BaseJDBCTestCase

Parameters:

conn - Connection to be intialized

Throws:

java.sql.SQLException - Error setting the initial state.

suite

public static junit.framework.Test suite()

Returns the implemented tests.

Returns:

An instance of Test with the implemented tests to run.

setUp

protected void setUp()
              throws java.lang.Exception

Bug only happens when autocommit is off.

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.lang.Exception

testBug4356

public void testBug4356()
                 throws java.sql.SQLException

Check fix for Bug4356 - Prepared statement parameter buffers are not cleared between calls to executeUpdate() in the same transaction. Using a prepared statement to insert data into a table using a sub select to get the data from a second table. The prepared statement doesn't seem to clear it's buffers between execute statements within the same transaction.

Throws:

java.sql.SQLException