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 inherited from class org.apache.derbyTesting.junit.BaseTestCase

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

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

Method Summary

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

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

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