org.apache.derbyTesting.functionTests.tests.jdbc4

Class Derby2017LayerBTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.functionTests.tests.jdbc4.Derby2017LayerBTest

All Implemented Interfaces:

junit.framework.Test

public class Derby2017LayerBTest
extends BaseJDBCTestCase

Tests that inserts with streams that throws an IOException 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
private static class	Derby2017LayerBTest.FailingInputStream Simple and non-conforming input stream that will fail after a specified number of bytes read.

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
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(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 junit.framework.Test	suite() Returns a suite running the test with both the client driver and the embedded driver.
void	testFailedStreamInsertBinary()
void	testFailedStreamInsertBinaryAutoCommit()
void	testFailedStreamInsertBinaryAutoCommitRollbackOnError()
void	testFailedStreamInsertBinaryRollbackOnError()
void	testFailedStreamInsertChar()
void	testFailedStreamInsertCharAutoCommit()
void	testFailedStreamInsertCharAutoCommitRollbackOnError()
void	testFailedStreamInsertCharBufferBoundariesImpl() Attempt to insert data with failing streams of various lengths.
void	testFailedStreamInsertCharRollbackOnError()
void	testStreamInsertCharBufferBoundary()

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

Constructor Detail

Derby2017LayerBTest

public Derby2017LayerBTest(java.lang.String name)

Method Detail

suite

public static junit.framework.Test suite()

Returns a suite running the test with both the client driver and the embedded driver.

Returns:

A suite of tests.

testStreamInsertCharBufferBoundary

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

Throws:

java.io.IOException

java.sql.SQLException

testFailedStreamInsertCharBufferBoundariesImpl

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

Attempt to insert data with failing streams of various lengths.

None of the inserts should be successful, as an IOException is thrown by all of the streams.

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