org.apache.derbyTesting.functionTests.tests.jdbcapi
Class PrepStmtNullTest

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

All Implemented Interfaces:

junit.framework.Test

public class PrepStmtNullTest
extends BaseJDBCTestCase

Tests setting parameters to SQL NULL This test converts the old jdbcapi/prepStmtNull.java test to JUnit.

Field Summary

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

PrepStmtNullTest(java.lang.String name)
Create a test with the given name.

Method Summary

private static junit.framework.Test	baseSuite(java.lang.String name)
private java.lang.String	bytesToString(byte[] ba) Helper method to convert byte array to String
static junit.framework.Test	suite() Create suite containing client and embedded tests and to run all tests in this class
void	testNullBlob() Testing a Null Blob
void	testNullClobBlob() Test setNull() on Clob/Blob using Varchar/binary types
void	testNullTimeStamp() Testing a Null Timestamp

Methods inherited from class org.apache.derbyTesting.junit.BaseJDBCTestCase

assertCallError, assertCheckTable, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertGetIntError, assertNextError, assertPreparedStatementError, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertTableRowCount, assertUpdateCount, assertUpdateCount, checkAllConsistency, checkEstimatedRowCount, commit, createStatement, createStatement, createStatement, dropTable, dropTable, getConnection, getDatabaseProperty, getLastSQLException, initializeConnection, openConnection, openDefaultConnection, openDefaultConnection, openUserConnection, prepareCall, prepareCall, prepareCall, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, prepareStatement, rollback, runScript, runScript, runSQLCommands, setAutoCommit, tearDown, usingDB2Client, usingDerbyNetClient, usingEmbedded

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

alarm, assertEquals, assertEquals, assertEquals, assertExecJavaCmdAsExpected, assertSecurityManager, assertThrowableEquals, execJavaCmd, fail, getFailureFolder, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeSystemProperty, runBare, setSystemProperty, traceit

Methods inherited from class junit.framework.TestCase

countTestCases, createResult, getName, run, run, runTest, setName, setUp, toString

Methods inherited from class junit.framework.Assert

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, fail, fail

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

Constructor Detail

PrepStmtNullTest

public PrepStmtNullTest(java.lang.String name)

Create a test with the given name.

Parameters:

name - name of the test.

Method Detail

suite

public static junit.framework.Test suite()

Create suite containing client and embedded tests and to run all tests in this class

baseSuite

private static junit.framework.Test baseSuite(java.lang.String name)

testNullTimeStamp

public void testNullTimeStamp()
                       throws java.sql.SQLException

Testing a Null Timestamp

Throws:

java.sql.SQLException - if error occurs

testNullBlob

public void testNullBlob()
                  throws java.sql.SQLException

Testing a Null Blob

Throws:

java.sql.SQLException - if error occurs

testNullClobBlob

public void testNullClobBlob()
                      throws java.sql.SQLException

Test setNull() on Clob/Blob using Varchar/binary types

Throws:

java.sql.SQLException - if error occurs

bytesToString

private java.lang.String bytesToString(byte[] ba)

Helper method to convert byte array to String