org.apache.derbyTesting.functionTests.tests.memory

Class ClobMemTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.functionTests.tests.memory.ClobMemTest

All Implemented Interfaces:

junit.framework.Test

public class ClobMemTest
extends BaseJDBCTestCase

Field Summary

Fields

Modifier and Type	Field and Description
private static int	LONG_CLOB_LENGTH
private static java.lang.String	LONG_CLOB_LENGTH_STRING
private static char[]	SHORT_CLOB_CHARS

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
static junit.framework.Test	suite()
void	testClobLength() Test the length after inserting with the setCharacterStream api that takes length.
private void	testClobLength(boolean lengthless) Insert a clob and test length.
void	testClobLengthWithLengthlessInsert() Test the length after inserting the clob value with the lengthless setCharacterStream api.
void	testDerby4477_3645_3646_Repro_lowmem_clob() Tests that a clob can be safely occur multiple times in a SQL select and test that large objects streams are not being materialized when cloned.

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

Field Detail

LONG_CLOB_LENGTH

private static final int LONG_CLOB_LENGTH

See Also:

Constant Field Values

LONG_CLOB_LENGTH_STRING

private static final java.lang.String LONG_CLOB_LENGTH_STRING

See Also:

Constant Field Values

SHORT_CLOB_CHARS

private static final char[] SHORT_CLOB_CHARS

Constructor Detail

ClobMemTest

public ClobMemTest(java.lang.String name)

Method Detail

testClobLength

private void testClobLength(boolean lengthless)
                     throws java.sql.SQLException,
                            java.io.IOException,
                            java.lang.IllegalArgumentException,
                            java.lang.IllegalAccessException,
                            java.lang.reflect.InvocationTargetException

Insert a clob and test length.

Parameters:

lengthless - if true use the lengthless setCharacterStream api

Throws:

java.sql.SQLException

java.io.IOException

java.lang.reflect.InvocationTargetException

java.lang.IllegalAccessException

java.lang.IllegalArgumentException

testClobLength

public void testClobLength()
                    throws java.sql.SQLException,
                           java.io.IOException,
                           java.lang.IllegalArgumentException,
                           java.lang.IllegalAccessException,
                           java.lang.reflect.InvocationTargetException

Test the length after inserting with the setCharacterStream api that takes length. In this case the length will be encoded at the begining of the stream and the call should be fairly low overhead.

Throws:

java.sql.SQLException

java.io.IOException

java.lang.reflect.InvocationTargetException

java.lang.IllegalAccessException

java.lang.IllegalArgumentException

testClobLengthWithLengthlessInsert

public void testClobLengthWithLengthlessInsert()
                                        throws java.sql.SQLException,
                                               java.io.IOException,
                                               java.lang.IllegalArgumentException,
                                               java.lang.IllegalAccessException,
                                               java.lang.reflect.InvocationTargetException

Test the length after inserting the clob value with the lengthless setCharacterStream api. In this case we will have to read the whole stream to get the length.

Throws:

java.sql.SQLException

java.io.IOException

java.lang.reflect.InvocationTargetException

java.lang.IllegalAccessException

java.lang.IllegalArgumentException

suite

public static junit.framework.Test suite()

testDerby4477_3645_3646_Repro_lowmem_clob

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

Tests that a clob can be safely occur multiple times in a SQL select and test that large objects streams are not being materialized when cloned. Same as testDerby4477_3645_3646_Repro_lowmem, but now using clob rather than blob.

Throws:

java.sql.SQLException

java.io.IOException

See Also:

BlobMemTest.testDerby4477_3645_3646_Repro_lowmem()