org.apache.derbyTesting.functionTests.tests.jdbcapi

Class StreamTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.functionTests.tests.jdbcapi.StreamTest

All Implemented Interfaces:

junit.framework.Test

public class StreamTest
extends BaseJDBCTestCase

Tests of ResultSet streams

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
private class	StreamTest.MyLoopingAlphabetReader

Field Summary

Fields

Modifier and Type	Field and Description
private boolean	didclose
private static java.lang.String	LANG_STREAM_RETRIEVED_ALREADY

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
StreamTest(java.lang.String name) Creates a new instance of StreamTest

Method Summary

Modifier and Type	Method and Description
private void	insertBlobData(int blobSize)
private void	insertClobData(int clobSize)
void	runGetReaderTwiceTest()
private void	runGetStreamTwiceTest()
protected void	setUp()
static junit.framework.Test	suite()
protected void	tearDown() Tear down this fixture, sub-classes should call super.tearDown().
void	testDerby4531() DERBY-4531: Test that JDBC driver doesn't close a stream handed in to PreparedStatement.setCharacterStream when the prepared statement is garbage collected.
void	testGetReaderTwiceLargeClob() Tests calling ResultSet.getCharacterStream() twice in the same column using a 512K characters clob
void	testGetReaderTwiceSmallClob() Tests calling ResultSet.getCharacterStream() twice in the same column using a 512 characters clob
void	testGetStreamTwiceLargeBlob() Tests calling ResultSet.getBinaryStream() twice in the same column using a 512K bytes blob
void	testGetStreamTwiceSmallBlob() Tests calling ResultSet.getBinaryStream() twice in the same column using a 512 bytes blob

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

Field Detail

LANG_STREAM_RETRIEVED_ALREADY

private static final java.lang.String LANG_STREAM_RETRIEVED_ALREADY

See Also:

Constant Field Values

didclose

private boolean didclose

Constructor Detail

StreamTest

public StreamTest(java.lang.String name)

Creates a new instance of StreamTest

Method Detail

setUp

protected void setUp()
              throws java.lang.Exception

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.lang.Exception

tearDown

protected void tearDown()
                 throws java.lang.Exception

Description copied from class: BaseJDBCTestCase

Tear down this fixture, sub-classes should call super.tearDown(). This cleanups & closes the connection if it is open and any statement objects returned through the utility methods.

Overrides:

tearDown in class BaseJDBCTestCase

Throws:

java.lang.Exception

suite

public static junit.framework.Test suite()

testGetStreamTwiceSmallBlob

public void testGetStreamTwiceSmallBlob()
                                 throws java.sql.SQLException,
                                        java.io.IOException

Tests calling ResultSet.getBinaryStream() twice in the same column using a 512 bytes blob

Throws:

java.sql.SQLException

java.io.IOException

testGetStreamTwiceLargeBlob

public void testGetStreamTwiceLargeBlob()
                                 throws java.sql.SQLException,
                                        java.io.IOException

Tests calling ResultSet.getBinaryStream() twice in the same column using a 512K bytes blob

Throws:

java.sql.SQLException

java.io.IOException

testGetReaderTwiceSmallClob

public void testGetReaderTwiceSmallClob()
                                 throws java.sql.SQLException,
                                        java.io.IOException

Tests calling ResultSet.getCharacterStream() twice in the same column using a 512 characters clob

Throws:

java.sql.SQLException

java.io.IOException

testGetReaderTwiceLargeClob

public void testGetReaderTwiceLargeClob()
                                 throws java.sql.SQLException,
                                        java.io.IOException

Tests calling ResultSet.getCharacterStream() twice in the same column using a 512K characters clob

Throws:

java.sql.SQLException

java.io.IOException

insertBlobData

private void insertBlobData(int blobSize)
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

insertClobData

private void insertClobData(int clobSize)
                     throws java.sql.SQLException

Throws:

java.sql.SQLException

runGetStreamTwiceTest

private void runGetStreamTwiceTest()
                            throws java.sql.SQLException,
                                   java.io.IOException

Throws:

java.sql.SQLException

java.io.IOException

runGetReaderTwiceTest

public void runGetReaderTwiceTest()
                           throws java.sql.SQLException,
                                  java.io.IOException

Throws:

java.sql.SQLException

java.io.IOException

testDerby4531

public void testDerby4531()
                   throws java.sql.SQLException

DERBY-4531: Test that JDBC driver doesn't close a stream handed in to PreparedStatement.setCharacterStream when the prepared statement is garbage collected. Prior to thus fix, the client driver did call close on the stream in its finalizer. After fix to DERBY-4531, both embedded and client driver leaves the stream open after having read the number of characters specified.

Throws:

java.sql.SQLException