org.apache.derbyTesting.functionTests.tests.jdbcapi

Class StatementJdbc20Test

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

All Implemented Interfaces:

junit.framework.Test

public class StatementJdbc20Test
extends BaseJDBCTestCase

Test of additional methods in JDBC2.0 methods in statement and resultset classes. This test converts the old jdbcapi/statementJdbc20.java test to JUnit.

Field Summary

Fields

Modifier and Type	Field and Description
private static java.lang.String	CLOSED_STATEMENT
private static java.lang.String	METHOD_NOT_ALLOWED

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

Constructor and Description
StatementJdbc20Test(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 void	dynamicResults(java.sql.ResultSet[] rs1, java.sql.ResultSet[] rs2) Stored procedure which returns 2 ResultSets.
private void	failVNA()
private void	setCloseOnCompletion(Wrapper41Statement wrapper, boolean closeOnCompletion)
static junit.framework.Test	suite() Create suite containing client and embedded tests and to run all tests in this class
void	test_clarification_jdbc4_1() Spec clarifications in JDBC 4.1.
void	testAddBatchClarification_jdbc4_1() Test the following clarification made by JDBC 4.1: You should raise an exception when addBatch(String) is called on a PreparedStatement or a CallableStatement.
void	testCompletionClosure_jdbc4_1() Test the closeOnCompletion() and isCloseOnCompletion() methods added by JDBC 4.1.
void	testCreateTableWithExecuteQuery() Tests creating tables with executeQuery which is not allowed on statements that return a row count
void	testLocalValuesOfResultSet() Tests values local to result set and get them back
void	testReadingData() Tests reading data from database
void	testWrongVaues() Testing wrong values for setFetchSize and setFetchDirection.
private void	vetClosedAutoGen(boolean closeOnCompletion, boolean delayClosureCall)
private void	vetClosedCall(boolean closeOnCompletion, boolean delayClosureCall)
private void	vetClosedPS(boolean closeOnCompletion, boolean delayClosureCall)
private void	vetClosedSelect(boolean closeOnCompletion, boolean delayClosureCall)
private void	vetClosure(boolean closeOnCompletion, boolean delayClosureCall)
private void	vetNotAllowed(java.sql.Statement stmt)
private void	vetSuccessfulClosure(Wrapper41Statement wrapper, boolean closeOnCompletion)

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

METHOD_NOT_ALLOWED

private static final java.lang.String METHOD_NOT_ALLOWED

See Also:

Constant Field Values

CLOSED_STATEMENT

private static final java.lang.String CLOSED_STATEMENT

See Also:

Constant Field Values

Constructor Detail

StatementJdbc20Test

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

testWrongVaues

public void testWrongVaues()
                    throws java.sql.SQLException

Testing wrong values for setFetchSize and setFetchDirection.

Throws:

java.sql.SQLException - if error occurs

testReadingData

public void testReadingData()
                     throws java.sql.SQLException

Tests reading data from database

Throws:

java.sql.SQLException - if error occurs

testLocalValuesOfResultSet

public void testLocalValuesOfResultSet()
                                throws java.sql.SQLException

Tests values local to result set and get them back

Throws:

java.sql.SQLException - if error occurs

testCreateTableWithExecuteQuery

public void testCreateTableWithExecuteQuery()
                                     throws java.sql.SQLException

Tests creating tables with executeQuery which is not allowed on statements that return a row count

Throws:

java.sql.SQLException - if error occurs

testAddBatchClarification_jdbc4_1

public void testAddBatchClarification_jdbc4_1()
                                       throws java.sql.SQLException

Test the following clarification made by JDBC 4.1: You should raise an exception when addBatch(String) is called on a PreparedStatement or a CallableStatement.

Throws:

java.sql.SQLException

testCompletionClosure_jdbc4_1

public void testCompletionClosure_jdbc4_1()
                                   throws java.lang.Exception

Test the closeOnCompletion() and isCloseOnCompletion() methods added by JDBC 4.1.

Throws:

java.lang.Exception

vetClosure

private void vetClosure(boolean closeOnCompletion,
                        boolean delayClosureCall)
                 throws java.lang.Exception

Throws:

java.lang.Exception

vetClosedSelect

private void vetClosedSelect(boolean closeOnCompletion,
                             boolean delayClosureCall)
                      throws java.lang.Exception

Throws:

java.lang.Exception

vetClosedCall

private void vetClosedCall(boolean closeOnCompletion,
                           boolean delayClosureCall)
                    throws java.lang.Exception

Throws:

java.lang.Exception

vetClosedPS

private void vetClosedPS(boolean closeOnCompletion,
                         boolean delayClosureCall)
                  throws java.lang.Exception

Throws:

java.lang.Exception

vetClosedAutoGen

private void vetClosedAutoGen(boolean closeOnCompletion,
                              boolean delayClosureCall)
                       throws java.lang.Exception

Throws:

java.lang.Exception

setCloseOnCompletion

private void setCloseOnCompletion(Wrapper41Statement wrapper,
                                  boolean closeOnCompletion)
                           throws java.lang.Exception

Throws:

java.lang.Exception

vetSuccessfulClosure

private void vetSuccessfulClosure(Wrapper41Statement wrapper,
                                  boolean closeOnCompletion)
                           throws java.lang.Exception

Throws:

java.lang.Exception

test_clarification_jdbc4_1

public void test_clarification_jdbc4_1()
                                throws java.lang.Exception

Spec clarifications in JDBC 4.1. Verify that an exception is raised if a PreparedStatement or CallableStatement tries to execute one of the methods which compiles SQL text.

Throws:

java.lang.Exception

vetNotAllowed

private void vetNotAllowed(java.sql.Statement stmt)
                    throws java.lang.Exception

Throws:

java.lang.Exception

failVNA

private void failVNA()
              throws java.lang.Exception

Throws:

java.lang.Exception

dynamicResults

public static void dynamicResults(java.sql.ResultSet[] rs1,
                                  java.sql.ResultSet[] rs2)
                           throws java.sql.SQLException

Stored procedure which returns 2 ResultSets.

Throws:

java.sql.SQLException