org.apache.derbyTesting.functionTests.tests.jdbcapi

Class Derby2017LayerATest

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

All Implemented Interfaces:

junit.framework.Test

public class Derby2017LayerATest
extends BaseJDBCTestCase

Tests that inserts with streams whose lengths differs from the the length specified don't insert data into the database when they shouldn't.

The test uses various combinations of auto-commit and rollback.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	Derby2017LayerATest.FailingReader WARNING: This reader is not a general purpose reader!!!

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	UTF8 The encoding used when generating a byte array from a string.

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
void	cs_FailedStreamInsertCharBufferBoundaries() Runs some failing inserts around buffer boundaries.
void	cs_StreamInsertCharBufferBoundary() Tests inserts around some selected buffer boundaries.
private void	doInsertTest(byte[][] INSERT, java.lang.String[][] MASTER, boolean autoCommit, boolean rollbackOnError) Performs the base test cycle; insert 3 valid rows, try to insert 2 invalid rows, insert 2 valid rows.
private void	doInsertTest(int[] INSERT, boolean autoCommit, boolean rollbackOnError) Performs the base test cycle; insert 3 valid rows, try to insert 2 invalid rows, insert 2 valid rows.
private void	doInsertTest(java.lang.String[] INSERT, java.lang.String[][] MASTER, boolean autoCommit, boolean rollbackOnError) Performs the base test cycle; insert 3 valid rows, try to insert 2 invalid rows, insert 2 valid rows.
static byte[][]	generateDefaultInsert() Helper method returning the default bytes used for testing binary data.
static java.lang.String[][]	generateMaster(byte[][] insert, int[] excludes) Helper method returning a string array with the expected values from the database (based on the values inserted).
static junit.framework.Test	suite() Returns a suite running most of the tests with both the client driver and the embedded driver, and some of the tests only with the client driver.
void	testFailedStreamInsertBinary()
void	testFailedStreamInsertBinaryAutoCommit()
void	testFailedStreamInsertBinaryAutoCommitRollbackOnError()
void	testFailedStreamInsertBinaryRollbackOnError()
void	testFailedStreamInsertChar()
void	testFailedStreamInsertCharAutoCommit()
void	testFailedStreamInsertCharAutoCommitRollbackOnError()
void	testFailedStreamInsertCharIOException() Inserts data by reading from streams, where two of these will thrown an IOException.
void	testFailedStreamInsertCharLong()
void	testFailedStreamInsertCharRollbackOnError()

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

UTF8

public static final java.lang.String UTF8

The encoding used when generating a byte array from a string.

See Also:

Constant Field Values

Constructor Detail

Derby2017LayerATest

public Derby2017LayerATest(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

Returns a suite running most of the tests with both the client driver and the embedded driver, and some of the tests only with the client driver.

Returns:

A suite of tests.

cs_StreamInsertCharBufferBoundary

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

Tests inserts around some selected buffer boundaries. This test verifies that the client and server can sucessfully insert values of various lengths. It will work also before the fix for DERBY-2017, but will fail if an incorrect fix is applied.

Throws:

java.io.IOException

java.sql.SQLException

cs_FailedStreamInsertCharBufferBoundaries

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

Runs some failing inserts around buffer boundaries.

Throws:

java.io.IOException

java.sql.SQLException

testFailedStreamInsertCharLong

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

Throws:

java.io.IOException

java.sql.SQLException

testFailedStreamInsertCharIOException

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

Inserts data by reading from streams, where two of these will thrown an IOException. Data from these streams should not be committed.

Throws:

java.io.IOException

java.sql.SQLException

testFailedStreamInsertChar

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

Throws:

java.io.IOException

java.sql.SQLException

testFailedStreamInsertCharAutoCommit

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

Throws:

java.io.IOException

java.sql.SQLException

testFailedStreamInsertCharRollbackOnError

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

Throws:

java.io.IOException

java.sql.SQLException

testFailedStreamInsertCharAutoCommitRollbackOnError

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

Throws:

java.io.IOException

java.sql.SQLException

testFailedStreamInsertBinary

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

Throws:

java.io.IOException

java.sql.SQLException

testFailedStreamInsertBinaryAutoCommit

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

Throws:

java.io.IOException

java.sql.SQLException

testFailedStreamInsertBinaryRollbackOnError

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

Throws:

java.io.IOException

java.sql.SQLException

testFailedStreamInsertBinaryAutoCommitRollbackOnError

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

Throws:

java.io.IOException

java.sql.SQLException

doInsertTest

private void doInsertTest(java.lang.String[] INSERT,
                          java.lang.String[][] MASTER,
                          boolean autoCommit,
                          boolean rollbackOnError)
                   throws java.io.IOException,
                          java.sql.SQLException

Performs the base test cycle; insert 3 valid rows, try to insert 2 invalid rows, insert 2 valid rows.

The outcome depends on whether auto-commit is on, and whether a rollback is issued when an insert fails.

Parameters:

INSERT - the data to insert

MASTER - the expected outcome

autoCommit - the auto-commit state to use

rollbackOnError - whether or not to issue a rollback if an insert fails

Throws:

java.io.IOException - if something goes wrong

java.sql.SQLException - if something goes wrong

doInsertTest

private void doInsertTest(int[] INSERT,
                          boolean autoCommit,
                          boolean rollbackOnError)
                   throws java.io.IOException,
                          java.sql.SQLException

Performs the base test cycle; insert 3 valid rows, try to insert 2 invalid rows, insert 2 valid rows.

The outcome depends on whether auto-commit is on, and whether a rollback is issued when an insert fails.

Parameters:

INSERT - the data to insert

autoCommit - the auto-commit state to use

rollbackOnError - whether or not to issue a rollback if an insert fails

Throws:

java.io.IOException - if something goes wrong

java.sql.SQLException - if something goes wrong

doInsertTest

private void doInsertTest(byte[][] INSERT,
                          java.lang.String[][] MASTER,
                          boolean autoCommit,
                          boolean rollbackOnError)
                   throws java.io.IOException,
                          java.sql.SQLException

Performs the base test cycle; insert 3 valid rows, try to insert 2 invalid rows, insert 2 valid rows.

The outcome depends on whether auto-commit is on, and whether a rollback is issued when an insert fails.

Parameters:

INSERT - the data to insert

MASTER - the expected outcome

autoCommit - the auto-commit state to use

rollbackOnError - whether or not to issue a rollback if an insert fails

Throws:

java.io.IOException - if something goes wrong

java.sql.SQLException - if something goes wrong

generateDefaultInsert

public static byte[][] generateDefaultInsert()

Helper method returning the default bytes used for testing binary data.

Returns:

A byte array with byte arrays ("rows").

generateMaster

public static java.lang.String[][] generateMaster(byte[][] insert,
                                                  int[] excludes)

Helper method returning a string array with the expected values from the database (based on the values inserted).

The purpose of this method is to convert from byte[] to String (as done by ResultSet.getString() when invoked on a column with binary data).

Parameters:

insert - the data inserted

excludes - the rows that is expected to fail, will be ignored

Returns:

A string array with expected strings.