org.apache.derbyTesting.functionTests.tests.jdbcapi

Class NullSQLTextTest

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

All Implemented Interfaces:

junit.framework.Test

public class NullSQLTextTest
extends BaseJDBCTestCase

This test converts the old jdbcapi/nullSQLText.java test to JUnit.

Field Summary

Fields

Modifier and Type	Field and Description
private static java.lang.String	SQLSTATE_SYNTAX_ERROR

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
NullSQLTextTest(java.lang.String name) Create a test with the given name.

Method Summary

Modifier and Type	Method and Description
private static junit.framework.Test	baseSuite(java.lang.String name)
static junit.framework.Test	suite() Create suite containing client and embedded tests and to run all tests in this class
private static void	testCommentStmt(java.sql.Statement st, java.lang.String sql, boolean expectFailure) Helper method for testDerby522().
void	testDerby522() Testing embedded comments in execute statement.
void	testExecuteEmptyString()
void	testExecuteQueryEmptyString()
void	testExecuteUpdateEmptyString()
void	testNullStringExecuteQueryStatement() Testing null string in executeQuery statement.
void	testNullStringExecuteStatement() Testing null string in execute statement.
void	testNullStringExecuteUpdateStatement() Testing null string in executeUpdate statement.
void	testNullStringPreparedStatement() Testing null string in prepared statement.
void	testPrepareEmptyString()
static void	zeroArg() Java method for procedure za()

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

assertCallError, assertCheckTable, assertCommitError, assertCompileError, assertEquals, assertEquals, assertEquals, assertEquivalentDataType, assertErrorCode, assertGetIntError, assertNextError, assertPreparedStatementError, assertResults, assertResults, assertSQLExceptionEquals, assertSQLState, assertSQLState, assertStatementError, assertStatementError, assertStatementError, assertStatementError, assertStatementErrorUnordered, assertTableRowCount, assertUpdateCount, assertUpdateCount, assertWarning, chattyPrepare, chattyPrepareCall, checkAllConsistency, checkEstimatedRowCount, closeStatement, commit, createStatement, createStatement, createStatement, dropTable, dropTable, dropView, dropView, dumpRs, dumpRs, emptyStatementCache, executeQuery, expectCompilationError, expectCompilationError, expectExecutionError, getClientTransactionID, getConnection, getDatabaseProperty, getLastSQLException, goodStatement, goodUpdate, 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, assertEquals, assertExecJavaCmdAsExpected, assertLaunchedJUnitTestMethod, assertLaunchedJUnitTestMethod, assertSameNullness, assertSecurityManager, assertThrowableEquals, currentDirectory, execJavaCmd, execJavaCmd, execJavaCmd, fail, getClassVersionMajor, getEmmaJar, getFailureFolder, getFilesWith, getJavaExecutableName, getSystemProperty, getTestConfiguration, getTestResource, hasInterruptibleIO, isCVM, isIBMJVM, isJ9Platform, isJava5, isJava7, isJava8, isPhoneME, isPlatform, isSunJVM, isWindowsPlatform, newAssertionFailedError, openTestResource, println, printStackTrace, readProcessOutput, removeDirectory, removeDirectory, removeFiles, removeSystemProperty, runsWithEmma, runsWithJaCoCo, setSystemErr, setSystemOut, setSystemProperty, sleep, sleepAtLeastOneTick, traceit, vmAtLeast

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

SQLSTATE_SYNTAX_ERROR

private static java.lang.String SQLSTATE_SYNTAX_ERROR

Constructor Detail

NullSQLTextTest

public NullSQLTextTest(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)

testNullStringPreparedStatement

public void testNullStringPreparedStatement()
                                     throws java.sql.SQLException

Testing null string in prepared statement.

Throws:

java.sql.SQLException - if database access errors or other errors occur

testNullStringExecuteStatement

public void testNullStringExecuteStatement()
                                    throws java.sql.SQLException

Testing null string in execute statement.

Throws:

java.sql.SQLException - if database access errors or other errors occur

testNullStringExecuteQueryStatement

public void testNullStringExecuteQueryStatement()
                                         throws java.sql.SQLException

Testing null string in executeQuery statement.

Throws:

java.sql.SQLException - if database access errors or other errors occur

testNullStringExecuteUpdateStatement

public void testNullStringExecuteUpdateStatement()
                                          throws java.sql.SQLException

Testing null string in executeUpdate statement.

Throws:

java.sql.SQLException - if database access errors or other errors occur

testDerby522

public void testDerby522()
                  throws java.sql.SQLException

Testing embedded comments in execute statement.

Throws:

java.sql.SQLException - if database access errors or other errors occur

testCommentStmt

private static void testCommentStmt(java.sql.Statement st,
                                    java.lang.String sql,
                                    boolean expectFailure)
                             throws java.sql.SQLException

Helper method for testDerby522(). executes strings containing embedded comments.

Parameters:

sql - sql statement

Throws:

java.sql.SQLException - if database access errors or other errors occur

zeroArg

public static void zeroArg()

Java method for procedure za()

testExecuteEmptyString

public void testExecuteEmptyString()
                            throws java.sql.SQLException

Throws:

java.sql.SQLException

testExecuteUpdateEmptyString

public void testExecuteUpdateEmptyString()

testExecuteQueryEmptyString

public void testExecuteQueryEmptyString()

testPrepareEmptyString

public void testPrepareEmptyString()