org.apache.derbyTesting.functionTests.tests.jdbcapi

Class ResultSetMiscTest

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

All Implemented Interfaces:

junit.framework.Test

public class ResultSetMiscTest
extends BaseJDBCTestCase

Field Summary

Fields

Modifier and Type	Field and Description
private java.lang.Object	nogc Hang onto the SecurityCheck class while running the tests so that it is not garbage collected during the test and lose the information it has collected.

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
static junit.framework.Test	baseSuite(java.lang.String name)
private void	checkLocksForAutoCommitSelect(java.sql.Connection conn, java.sql.Statement stmt, int action) Check locks with various commit sequences.
private void	checkSingleRSAutoCommit(java.sql.Connection conn) Tests for two things: 1) The ResultSet does not close implicitly when the ResultSet completes and holdability == HOLD_CURSORS_OVER_COMMIT 2) The ResultSet auto-commits when it completes and auto-commit is on.
private void	checkSingleRSCloseCursorsAtCommit(java.sql.Connection conn) Check to see that ResultSet closes implicitly when holdability is set to CLOSE_CURORS_AT_COMMIT.
private boolean	locksHeld() Check if locks are held.
static junit.framework.Test	suite() Runs the test fixtures in embedded and client.
void	testAutoCommit() Setup up and run the auto-commit tests.
void	testBug4810() Test fix for Bug4810 -Connection.commit() and rollback() do not commit/rollback in auto-commit mode.
void	testCorrelationNamesAndMetaDataCalls()
void	testDerby853() Test fix for DERBY-853 ResultSetMetaData.getScale returns inconsistent values for DOUBLE type.
void	testFloatMAX_VALUE(java.sql.Connection conn)
void	testResultSetMetaData() Test resultset metadata on columns of various types

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

nogc

private final java.lang.Object nogc

Hang onto the SecurityCheck class while running the tests so that it is not garbage collected during the test and lose the information it has collected.

Constructor Detail

ResultSetMiscTest

public ResultSetMiscTest(java.lang.String name)

Method Detail

testResultSetMetaData

public void testResultSetMetaData()
                           throws java.sql.SQLException

Test resultset metadata on columns of various types

Throws:

java.sql.SQLException

testBug4810

public void testBug4810()
                 throws java.sql.SQLException

Test fix for Bug4810 -Connection.commit() and rollback() do not commit/rollback in auto-commit mode.

Throws:

java.sql.SQLException

testDerby853

public void testDerby853()
                  throws java.sql.SQLException

Test fix for DERBY-853 ResultSetMetaData.getScale returns inconsistent values for DOUBLE type.

Throws:

java.sql.SQLException

testAutoCommit

public void testAutoCommit()
                    throws java.sql.SQLException

Setup up and run the auto-commit tests.

Throws:

java.sql.SQLException

testCorrelationNamesAndMetaDataCalls

public void testCorrelationNamesAndMetaDataCalls()
                                          throws java.sql.SQLException

Throws:

java.sql.SQLException

testFloatMAX_VALUE

public void testFloatMAX_VALUE(java.sql.Connection conn)
                        throws java.sql.SQLException

Throws:

java.sql.SQLException

checkSingleRSAutoCommit

private void checkSingleRSAutoCommit(java.sql.Connection conn)
                              throws java.sql.SQLException

Tests for two things: 1) The ResultSet does not close implicitly when the ResultSet completes and holdability == HOLD_CURSORS_OVER_COMMIT 2) The ResultSet auto-commits when it completes and auto-commit is on.

Parameters:

conn - The Connection

Throws:

java.sql.SQLException

checkSingleRSCloseCursorsAtCommit

private void checkSingleRSCloseCursorsAtCommit(java.sql.Connection conn)
                                        throws java.sql.SQLException

Check to see that ResultSet closes implicitly when holdability is set to CLOSE_CURORS_AT_COMMIT.

Parameters:

conn - The Connection

Throws:

java.sql.SQLException

checkLocksForAutoCommitSelect

private void checkLocksForAutoCommitSelect(java.sql.Connection conn,
                                           java.sql.Statement stmt,
                                           int action)
                                    throws java.sql.SQLException

Check locks with various commit sequences.

Parameters:

conn - Initialized connection

stmt - stmt to use for select from table

action - 0 = autocommit only 1 = commit with ResultSet open 2 = rollback with ResultSet open

Throws:

java.sql.SQLException

locksHeld

private boolean locksHeld()
                   throws java.sql.SQLException

Check if locks are held.

Returns:

true if locks are held.

Throws:

java.sql.SQLException

suite

public static junit.framework.Test suite()

Runs the test fixtures in embedded and client.

Returns:

test suite

baseSuite

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