org.apache.derbyTesting.functionTests.tests.derbynet

Class SqlExceptionTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.functionTests.tests.derbynet.SqlExceptionTest

All Implemented Interfaces:

junit.framework.Test

public class SqlExceptionTest
extends BaseJDBCTestCase

This is used for testing the SqlException class. This test can be added to. My itch right now is to verify that exception chaining is working correctly. This test also verifies that a SQLException object generated out of the derby network client driver can be serialized (DERBY-790).

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
static int	badFunction1()
static int	badFunction2()
static int	badFunction3()
private java.sql.SQLException	recreateSQLException(java.sql.SQLException se) Recreate a SQLException by serializing the passed-in one and deserializing it into a new one that we're returning.
void	setUp() Set up the connection to the database.
static junit.framework.Test	suite()
void	tearDown() Drop the table
void	testChainedException() Makes sure exception chaining works correctly (DERBY-1117)
void	testDerby3390() Verify that an SQLException thrown by a function can be returned (DERBY-790).
void	testNextException() Make sure a SQLException is chained as a nextSQLException() and as a chained exception.
void	testSerializedException() Verify that a SQLException generated by the derby network client driver can be serialized (DERBY-790).

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

Constructor Detail

SqlExceptionTest

public SqlExceptionTest(java.lang.String name)

Method Detail

testChainedException

public void testChainedException()

Makes sure exception chaining works correctly (DERBY-1117)

testNextException

public void testNextException()

Make sure a SQLException is chained as a nextSQLException() and as a chained exception.

testSerializedException

public void testSerializedException()
                             throws java.lang.Exception

Verify that a SQLException generated by the derby network client driver can be serialized (DERBY-790).

Throws:

java.lang.Exception

testDerby3390

public void testDerby3390()
                   throws java.lang.Exception

Verify that an SQLException thrown by a function can be returned (DERBY-790).

Throws:

java.lang.Exception

setUp

public void setUp()
           throws java.lang.Exception

Set up the connection to the database.

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.lang.Exception

tearDown

public void tearDown()
              throws java.lang.Exception

Drop the table

Overrides:

tearDown in class BaseJDBCTestCase

Throws:

java.lang.Exception

recreateSQLException

private java.sql.SQLException recreateSQLException(java.sql.SQLException se)
                                            throws java.lang.Exception

Recreate a SQLException by serializing the passed-in one and deserializing it into a new one that we're returning.

Throws:

java.lang.Exception

suite

public static junit.framework.Test suite()

badFunction1

public static int badFunction1()
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

badFunction2

public static int badFunction2()
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

badFunction3

public static int badFunction3()
                        throws java.lang.Exception

Throws:

java.lang.Exception