org.apache.derbyTesting.functionTests.tests.largedata

Class LobLimitsTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.functionTests.tests.largedata.LobLimitsTest

All Implemented Interfaces:

junit.framework.Test

Direct Known Subclasses:

LobLimitsClientTest, LobLimitsLiteTest

public class LobLimitsTest
extends BaseJDBCTestCase

This test is part of the "largedata" suite because this test tests data for lobs to the limits ( ie blob and clob can be 2G-1 maximum) and so this test may take considerable disk space as well as time to run. Hence it is not part of the derbyall suite but should ideally be run at some intervals to test if no regression has occurred.

Field Summary

Fields

Modifier and Type	Field and Description
(package private) static int	_100MB
(package private) static int	_2GB
(package private) static long	_4GB
(package private) static int	BIG_LOB_SZ
(package private) static int	BIGGEST_LOB_SZ
(package private) static java.lang.String	CHARDATAFILE
(package private) static java.lang.String	DATAFILE
(package private) static int	MORE_DATA_THAN_COL_WIDTH
(package private) static int	NUM_TRAILING_SPACES
(package private) static boolean	trace

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
(package private) static junit.framework.Test	baseSuite(int biggestSize, int bigSize) Create an instance of the LobLimitsTest suite.
private static void	compareBlobToFile(java.io.InputStream lobstream, java.lang.String filename)
private static void	compareClobToFile(java.io.Reader lobstream, java.lang.String filename, int length)
private void	deleteAndTruncateTable(java.lang.String table, int expectedRows)
private void	insertBlob_SetBinaryStream(java.lang.String testId, java.sql.PreparedStatement ps, int bloblen, int start, int rows, int streamLength) insert blob
private void	insertBlob_SetBlob(java.lang.String testId, java.sql.PreparedStatement ps, java.sql.Blob blob, long bloblen, int start, int rows, int expectedRows) insert blob, using a setBlob api.
private void	insertBlob2(java.lang.String testId, java.sql.PreparedStatement ps, int bloblen, int start, int rows, int streamLength, java.lang.String file) insert blob into BLOBTBL2
private void	insertClob_SetCharacterStream(java.lang.String testId, java.sql.PreparedStatement ps, int cloblen, int start, int rows, int streamLength) insert clob
private void	insertClob_SetClob(java.lang.String testId, java.sql.PreparedStatement ps, java.sql.Clob clob, long cloblen, int start, int rows, int expectedRows) insert clob, using a setClob api.
private void	insertClob2(java.lang.String testId, java.sql.PreparedStatement ps, int cloblen, int start, int rows, int streamLength, java.lang.String file) insert clob into CLOBTBL2
private void	negativeSpaceTruncationTest(java.lang.String msg)
private void	selectBlob(java.lang.String testId, java.sql.PreparedStatement ps, int bloblen, int id, int expectedRows) select from blob table (BLOBTBL)
private void	selectBlob2(java.lang.String testId, java.sql.PreparedStatement ps, int bloblen, int id, int expectedRows, java.lang.String file) select from blob table (BLOBTBL2)
private void	selectClob(java.lang.String testId, java.sql.PreparedStatement ps, int cloblen, int id, int expectedRows) select from clob table
private void	selectClob2(java.lang.String testId, java.sql.PreparedStatement ps, int cloblen, int id, int expectedRows, java.lang.String file) select from clob table (CLOBTBL2)
private void	selectInsertBlob(java.lang.String testId, java.sql.PreparedStatement ps, java.sql.PreparedStatement ins, int bloblen, int id, int insertId) Basically this test will do an insert using setBlob api - select row from blobtbl and then insert a row in blobtbl and verify updated data in blobtbl
private void	selectUpdateBlob(java.lang.String testId, java.sql.PreparedStatement ps, int bloblen, int id, int updateId) Basically this test will do an update using setBlob api - select row from blobtbl and then update a row in blobtbl and verify updated data in blobtbl
private void	selectUpdateBlob2(java.lang.String testId, java.sql.PreparedStatement ps, java.sql.PreparedStatement sel, int bloblen, int id, int updateId, java.lang.String file) Basically this test will do an update using setBinaryStream api and verifies the updated data. select row from blobtbl2 and then update a row in blobtbl and verify updated data in blobtbl
private void	selectUpdateClob(java.lang.String testId, java.sql.PreparedStatement ps, int cloblen, int id, int updateId)
private void	selectUpdateClob2(java.lang.String testId, java.sql.PreparedStatement ps, java.sql.PreparedStatement sel, int cloblen, int id, int updateId, java.lang.String file)
static void	setBIG_LOB_SZ(int bIGLOBSZ)
static void	setBIGGEST_LOB_SZ(int bIGGESTLOBSZ)
static void	setMORE_DATA_THAN_COL_WIDTH(int mOREDATATHANCOLWIDTH)
(package private) static void	setupTables(java.sql.Statement s, int biggestlobsz, int biglobsz) Setup the schema and the blob sizes for the test.
static junit.framework.Test	suite()
void	test_01_Blob() tests specific for blobs
void	test_02_BlobNegative()
void	test_03_Clob1() tests using clobs
void	test_04_Clob2()
void	test_05_ClobNegative()
void	test_06_shutdownDB()
private void	updateClob2(java.lang.String testId, java.sql.PreparedStatement sel, int cloblen, int id, int updateRowId, int updateIdVal, java.lang.String file)
private static void	verifyTest(int affectedRows, int expectedRows, java.lang.String test)
private static void	writeToFile(java.lang.String file, java.io.Reader r)

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

trace

static boolean trace

_2GB

static final int _2GB

See Also:

Constant Field Values

_100MB

static final int _100MB

See Also:

Constant Field Values

_4GB

static final long _4GB

See Also:

Constant Field Values

NUM_TRAILING_SPACES

static final int NUM_TRAILING_SPACES

See Also:

Constant Field Values

BIGGEST_LOB_SZ

static int BIGGEST_LOB_SZ

BIG_LOB_SZ

static int BIG_LOB_SZ

MORE_DATA_THAN_COL_WIDTH

static int MORE_DATA_THAN_COL_WIDTH

DATAFILE

static final java.lang.String DATAFILE

See Also:

Constant Field Values

CHARDATAFILE

static final java.lang.String CHARDATAFILE

See Also:

Constant Field Values

Constructor Detail

LobLimitsTest

public LobLimitsTest(java.lang.String name)

Method Detail

setBIGGEST_LOB_SZ

public static void setBIGGEST_LOB_SZ(int bIGGESTLOBSZ)

setBIG_LOB_SZ

public static void setBIG_LOB_SZ(int bIGLOBSZ)

setMORE_DATA_THAN_COL_WIDTH

public static void setMORE_DATA_THAN_COL_WIDTH(int mOREDATATHANCOLWIDTH)

setupTables

static void setupTables(java.sql.Statement s,
                        int biggestlobsz,
                        int biglobsz)
                 throws java.sql.SQLException

Setup the schema and the blob sizes for the test.

Parameters:

s -

biggestlobsz -

biglobsz -

Throws:

java.sql.SQLException

suite

public static junit.framework.Test suite()

baseSuite

static junit.framework.Test baseSuite(int biggestSize,
                                      int bigSize)

Create an instance of the LobLimitsTest suite.

Parameters:

biggestSize - the size of the biggest LOB to test

bigSize - the size of a typical big LOB to test

Returns:

a test suite

test_01_Blob

public void test_01_Blob()
                  throws java.lang.Exception

tests specific for blobs

Throws:

java.lang.Exception

test_02_BlobNegative

public void test_02_BlobNegative()
                          throws java.sql.SQLException

Throws:

java.sql.SQLException

test_03_Clob1

public void test_03_Clob1()
                   throws java.lang.Exception

tests using clobs

Throws:

java.lang.Exception

test_04_Clob2

public void test_04_Clob2()
                   throws java.lang.Exception

Throws:

java.lang.Exception

test_05_ClobNegative

public void test_05_ClobNegative()
                          throws java.lang.Exception

Throws:

java.lang.Exception

test_06_shutdownDB

public void test_06_shutdownDB()
                        throws java.lang.Exception

Throws:

java.lang.Exception

negativeSpaceTruncationTest

private void negativeSpaceTruncationTest(java.lang.String msg)
                                  throws java.lang.Exception

Throws:

java.lang.Exception

insertBlob_SetBinaryStream

private void insertBlob_SetBinaryStream(java.lang.String testId,
                                        java.sql.PreparedStatement ps,
                                        int bloblen,
                                        int start,
                                        int rows,
                                        int streamLength)
                                 throws java.sql.SQLException

insert blob

Parameters:

bloblen - length of blob to insert

start - start id value for insert

rows - insert rows number of rows

streamLength - stream length passed to setBinaryStream(,,length)

Throws:

java.sql.SQLException

insertBlob_SetBlob

private void insertBlob_SetBlob(java.lang.String testId,
                                java.sql.PreparedStatement ps,
                                java.sql.Blob blob,
                                long bloblen,
                                int start,
                                int rows,
                                int expectedRows)
                         throws java.sql.SQLException

insert blob, using a setBlob api.

Parameters:

bloblen - length of blob to insert

blob - blob to insert

start - start id value for insert

rows - insert rows number of rows

expectedRows - rows expected to be inserted

Throws:

java.sql.SQLException

selectBlob

private void selectBlob(java.lang.String testId,
                        java.sql.PreparedStatement ps,
                        int bloblen,
                        int id,
                        int expectedRows)
                 throws java.sql.SQLException

select from blob table (BLOBTBL)

Parameters:

bloblen - select expects to retrieve a blob of this length

id - id of the row to retrieve

expectedRows - number of rows expected to match id

Throws:

java.sql.SQLException

insertBlob2

private void insertBlob2(java.lang.String testId,
                         java.sql.PreparedStatement ps,
                         int bloblen,
                         int start,
                         int rows,
                         int streamLength,
                         java.lang.String file)
                  throws java.lang.Exception

insert blob into BLOBTBL2

Parameters:

bloblen - length of blob to insert

start - id value for insert

rows - insert rows number of rows

streamLength - stream length passed to setBinaryStream(,,length)

file - filename to match retrieved data against

Throws:

java.lang.Exception

selectBlob2

private void selectBlob2(java.lang.String testId,
                         java.sql.PreparedStatement ps,
                         int bloblen,
                         int id,
                         int expectedRows,
                         java.lang.String file)
                  throws java.lang.Exception

select from blob table (BLOBTBL2)

Parameters:

bloblen - select expects to retrieve a blob of this length

id - id of the row to retrieve

expectedRows - number of rows expected to match id

file - name of the file,against which the retrieved data is compared

Throws:

java.lang.Exception

selectUpdateBlob

private void selectUpdateBlob(java.lang.String testId,
                              java.sql.PreparedStatement ps,
                              int bloblen,
                              int id,
                              int updateId)
                       throws java.lang.Exception

Basically this test will do an update using setBlob api - select row from blobtbl and then update a row in blobtbl and verify updated data in blobtbl

Parameters:

ps - select statement from which blob is retrieved

bloblen - updating value is of length bloblen

id - id of the row retrieved, for the update

updateId - id of the row that is updated

Throws:

java.lang.Exception

selectInsertBlob

private void selectInsertBlob(java.lang.String testId,
                              java.sql.PreparedStatement ps,
                              java.sql.PreparedStatement ins,
                              int bloblen,
                              int id,
                              int insertId)
                       throws java.lang.Exception

Basically this test will do an insert using setBlob api - select row from blobtbl and then insert a row in blobtbl and verify updated data in blobtbl

Parameters:

ps - select statement from which blob is retrieved

bloblen - updating value is of length bloblen

id - id of the row retrieved, for the update

insertId - id of the row that is inserted

Throws:

java.lang.Exception

selectUpdateBlob2

private void selectUpdateBlob2(java.lang.String testId,
                               java.sql.PreparedStatement ps,
                               java.sql.PreparedStatement sel,
                               int bloblen,
                               int id,
                               int updateId,
                               java.lang.String file)
                        throws java.lang.Exception

Basically this test will do an update using setBinaryStream api and verifies the updated data. select row from blobtbl2 and then update a row in blobtbl and verify updated data in blobtbl

Parameters:

bloblen - updating value is of length bloblen

id - id of the row retrieved, for the update

updateId - id of the row that is updated

file - name of the file,against which the updated data is compared

Throws:

java.lang.Exception

compareBlobToFile

private static void compareBlobToFile(java.io.InputStream lobstream,
                                      java.lang.String filename)
                               throws java.lang.Exception

Throws:

java.lang.Exception

deleteAndTruncateTable

private void deleteAndTruncateTable(java.lang.String table,
                                    int expectedRows)
                             throws java.sql.SQLException

Throws:

java.sql.SQLException

insertClob_SetCharacterStream

private void insertClob_SetCharacterStream(java.lang.String testId,
                                           java.sql.PreparedStatement ps,
                                           int cloblen,
                                           int start,
                                           int rows,
                                           int streamLength)
                                    throws java.sql.SQLException

insert clob

Parameters:

cloblen - length of clob to insert

start - id value for insert

rows - insert rows number of rows

streamLength - stream length passed to setCharacterStream(...,length)

Throws:

java.sql.SQLException

insertClob_SetClob

private void insertClob_SetClob(java.lang.String testId,
                                java.sql.PreparedStatement ps,
                                java.sql.Clob clob,
                                long cloblen,
                                int start,
                                int rows,
                                int expectedRows)
                         throws java.sql.SQLException

insert clob, using a setClob api.

Parameters:

cloblen - length of clob to insert

clob - clob to insert

start - start id value for insert

rows - insert rows number of rows

expectedRows - rows expected to be inserted

Throws:

java.sql.SQLException

selectClob

private void selectClob(java.lang.String testId,
                        java.sql.PreparedStatement ps,
                        int cloblen,
                        int id,
                        int expectedRows)
                 throws java.sql.SQLException

select from clob table

Parameters:

cloblen - select expects to retrieve a clob of this length

id - id of the row to retrieve

expectedRows - number of rows expected to match id

Throws:

java.sql.SQLException

insertClob2

private void insertClob2(java.lang.String testId,
                         java.sql.PreparedStatement ps,
                         int cloblen,
                         int start,
                         int rows,
                         int streamLength,
                         java.lang.String file)
                  throws java.lang.Exception

insert clob into CLOBTBL2

Parameters:

cloblen - length of clob to insert

start - id value for insert

rows - insert rows number of rows

streamLength - stream length passed to setCharacterStream(pos,reader,streamLength)

file - name of the file that has data to be inserted

Throws:

java.lang.Exception

selectClob2

private void selectClob2(java.lang.String testId,
                         java.sql.PreparedStatement ps,
                         int cloblen,
                         int id,
                         int expectedRows,
                         java.lang.String file)
                  throws java.lang.Exception

select from clob table (CLOBTBL2)

Parameters:

cloblen - select expects to retrieve a clob of this length

id - id of the row to retrieve

expectedRows - number of rows expected to match id

file - filename to compare the retrieved data against

Throws:

java.lang.Exception

selectUpdateClob

private void selectUpdateClob(java.lang.String testId,
                              java.sql.PreparedStatement ps,
                              int cloblen,
                              int id,
                              int updateId)
                       throws java.lang.Exception

Throws:

java.lang.Exception

selectUpdateClob2

private void selectUpdateClob2(java.lang.String testId,
                               java.sql.PreparedStatement ps,
                               java.sql.PreparedStatement sel,
                               int cloblen,
                               int id,
                               int updateId,
                               java.lang.String file)
                        throws java.lang.Exception

Throws:

java.lang.Exception

updateClob2

private void updateClob2(java.lang.String testId,
                         java.sql.PreparedStatement sel,
                         int cloblen,
                         int id,
                         int updateRowId,
                         int updateIdVal,
                         java.lang.String file)
                  throws java.lang.Exception

Throws:

java.lang.Exception

compareClobToFile

private static void compareClobToFile(java.io.Reader lobstream,
                                      java.lang.String filename,
                                      int length)
                               throws java.lang.Exception

Throws:

java.lang.Exception

verifyTest

private static void verifyTest(int affectedRows,
                               int expectedRows,
                               java.lang.String test)

writeToFile

private static void writeToFile(java.lang.String file,
                                java.io.Reader r)
                         throws java.io.IOException

Throws:

java.io.IOException