org.apache.derbyTesting.functionTests.tests.tools

Class ImportExportBinaryDataTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.functionTests.tests.tools.ImportExportBaseTest

org.apache.derbyTesting.functionTests.tests.tools.ImportExportBinaryDataTest

All Implemented Interfaces:

junit.framework.Test

public class ImportExportBinaryDataTest
extends ImportExportBaseTest

This class tests import/export of a table with simple binary data types CHAR FOR BIT DATA, VARCHAR FOR BIT DATA, LONG VARCHAR FOR BIT DATA.

Field Summary

Fields

Modifier and Type	Field and Description
(package private) java.lang.String	fileName

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
private static void	loadData(java.sql.Statement s)
protected void	setUp() Simple set up, just empty the import table.
static junit.framework.Test	suite() Runs the tests in the default embedded configuration and then the client server configuration.
protected void	tearDown() delete export/import files.
void	testDerby2925ExportQuery()
void	testDerby2925ExportTable()
void	testDerby4677BulkInsertIntoEmptyTable() Bulk insert into a table should recreate the indexes correctly rather than ignoring the unique nullable property of the index.
void	testDerby4677BulkInsertWithReplace() Bulk insert into a table should recreate the indexes correctly rather than ignoring the unique nullable property of the index.
void	testImportDataExportQuery()
void	testImportDataExportQueryWithFewColumns()
void	testImportExportInvalideDelimiters()
void	testImportTableExportTable() Test import/export of a table, using SYSCS_EXPORT_TABLE and SYSCS_IMPORT_TABLE procedures.
void	testImportWitgInvalidHexStrings()
private void	verifyData(java.lang.String cols)

Methods inherited from class org.apache.derbyTesting.functionTests.tests.tools.ImportExportBaseTest

doExportQuery, doExportQueryLobsToExtFile, doExportTable, doExportTableLobsToExtFile, doImportData, doImportDataLobsFromExtFile, doImportTable, doImportTableLobsFromExtFile

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

fileName

java.lang.String fileName

Constructor Detail

ImportExportBinaryDataTest

public ImportExportBinaryDataTest(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

Runs the tests in the default embedded configuration and then the client server configuration.

setUp

protected void setUp()
              throws java.sql.SQLException

Simple set up, just empty the import table.

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.sql.SQLException

tearDown

protected void tearDown()
                 throws java.lang.Exception

delete export/import files.

Overrides:

tearDown in class BaseJDBCTestCase

Throws:

java.lang.Exception

testImportTableExportTable

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

Test import/export of a table, using SYSCS_EXPORT_TABLE and SYSCS_IMPORT_TABLE procedures.

Throws:

java.sql.SQLException

java.io.IOException

testDerby4677BulkInsertIntoEmptyTable

public void testDerby4677BulkInsertIntoEmptyTable()
                                           throws java.sql.SQLException

Bulk insert into a table should recreate the indexes correctly rather than ignoring the unique nullable property of the index. In the following test case, we have an empty table in which we are trying to do an import from a file with one row worth's data. This combination used to cause bulk insert functionality to recreate index incorrectly for unique nullable index. This allowed duplicate rows for unique nullable index. Fix for DERBY-4677 resolves the issue.

Throws:

java.sql.SQLException

testDerby4677BulkInsertWithReplace

public void testDerby4677BulkInsertWithReplace()
                                        throws java.sql.SQLException

Bulk insert into a table should recreate the indexes correctly rather than ignoring the unique nullable property of the index. In the following test case, we have an empty table in which we are trying to do an import from an empty file with the REPLACE option. This combination used to cause bulk insert functionality to recreate index incorrectly for unique nullable index. This allowed duplicate rows for unique nullable index. Fix for DERBY-4677 resolves the issue.

Throws:

java.sql.SQLException

testImportDataExportQuery

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

Throws:

java.sql.SQLException

java.io.IOException

testImportDataExportQueryWithFewColumns

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

Throws:

java.sql.SQLException

java.io.IOException

testImportExportInvalideDelimiters

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

Throws:

java.sql.SQLException

java.io.IOException

testImportWitgInvalidHexStrings

public void testImportWitgInvalidHexStrings()
                                     throws java.sql.SQLException

Throws:

java.sql.SQLException

testDerby2925ExportTable

public void testDerby2925ExportTable()
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

testDerby2925ExportQuery

public void testDerby2925ExportQuery()
                              throws java.sql.SQLException

Throws:

java.sql.SQLException

verifyData

private void verifyData(java.lang.String cols)
                 throws java.sql.SQLException,
                        java.io.IOException

Throws:

java.sql.SQLException

java.io.IOException

loadData

private static void loadData(java.sql.Statement s)
                      throws java.sql.SQLException

Throws:

java.sql.SQLException