org.apache.derbyTesting.functionTests.tests.jdbc4

Class StatementTest

java.lang.Object

junit.framework.Assert

junit.framework.TestCase

org.apache.derbyTesting.junit.BaseTestCase

org.apache.derbyTesting.junit.BaseJDBCTestCase

org.apache.derbyTesting.functionTests.tests.jdbc4.StatementTest

All Implemented Interfaces:

junit.framework.Test

public class StatementTest
extends BaseJDBCTestCase

Tests for new methods added for Statement in JDBC4.

Nested Class Summary

Nested Classes

Modifier and Type	Class and Description
static class	StatementTest.StatementWrapper This wrapper is used to expose JDBC 4.2 methods which can run on VM rev levels lower than Java 8.

Field Summary

Fields

Modifier and Type	Field and Description
private java.sql.Statement	stmt Default statement used by the tests.

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

DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors

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

Method Summary

Modifier and Type	Method and Description
private static void	createBatch(StatementTest.StatementWrapper sw)
private static void	largeBatchTest(StatementTest.StatementWrapper sw, long rowCountBase)
private static void	largeBatchUpdateExceptionTest(StatementTest.StatementWrapper sw, long rowCountBase)
private static void	largeMaxRowsTest(StatementTest.StatementWrapper sw, long maxRows)
static void	largeUpdate_jdbc4_2(java.sql.Connection conn)
private static void	largeUpdateTest(StatementTest.StatementWrapper sw, long rowCountBase)
private static void	largeUpdateTest(StatementTest.StatementWrapper sw, long rowCountBase, long rowCount)
static void	setRowCountBase(long newBase) Set the base which is used for returned row counts and fetched row counters
static void	setRowCountBase(java.sql.Statement stmt, boolean onClient, long rowCountBase)
protected void	setUp() Create default connection and statement.
private static int[]	squashLongs(long[] longs)
static junit.framework.Test	suite() Create test suite for StatementTest.
protected void	tearDown() Close default connection and statement if necessary.
void	test_jdbc4_1_queryTimeoutException() Test that Statement.setQueryTimeout() causes statements to raise SQLTimeoutException per the JDBC 4.1 spec clarification.
void	testCompletionClosure_jdbc4_1_implicitRSClosure() Test the closeOnCompletion() and isCloseOnCompletion() methods when using ResultSets which close implicitly.
void	testIsClosedBasic() Check that isClosed returns true after the statement has been explicitly closed.
void	testIsClosedWhenClosingConnection() Test that the two statements created on the connection are closed when the connection itself is closed.
void	testIsClosedWhenClosingConnectionInInvalidState() Check the state of the statement when the connection is first attempted closed when in an invalid transaction state, then closed after a commit.
void	testIsClosedWithTwoStatementsOnSameConnection() Test that creating two statements on the same connection does not cause side effects on the statements.
void	testIsNotWrapperForCallableStatement()
void	testIsNotWrapperForPreparedStatement()
void	testIsNotWrapperForResultSet()
void	testIsWrapperForStatement()
void	testLargeUpdate_jdbc4_2() Test the large update methods added by JDBC 4.2.
void	testPoolable() Tests isPoolable, setPoolable, and the default poolability.
void	testStatementExecuteAfterConnectionClose() Execute a query on a statement after the parent connection has been closed.
void	testUnwrapCallableStatement()
void	testUnwrapPreparedStatement()
void	testUnwrapResultSet()
void	testUnwrapStatement()
private static void	truncate(StatementTest.StatementWrapper sw)
private static void	vetUpdateSize(StatementTest.StatementWrapper sw, int expected, int actual, long longAnswer)
private static void	vetUpdateSize(StatementTest.StatementWrapper sw, long expected, long actual, long longAnswer)

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

Methods inherited from class java.lang.Object

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

Field Detail

stmt

private java.sql.Statement stmt

Default statement used by the tests.

Constructor Detail

StatementTest

public StatementTest(java.lang.String name)

Create a new test with the given name.

Parameters:

name - name of the test.

Method Detail

setUp

protected void setUp()
              throws java.sql.SQLException

Create default connection and statement.

Overrides:

setUp in class junit.framework.TestCase

Throws:

java.sql.SQLException - if setAutoCommit, createStatement or BaseJDBCTestCase.getConnection fails.

tearDown

protected void tearDown()
                 throws java.lang.Exception

Close default connection and statement if necessary.

Overrides:

tearDown in class BaseJDBCTestCase

Throws:

java.sql.SQLException - if a database access exception occurs.

java.lang.Exception

testIsClosedBasic

public void testIsClosedBasic()
                       throws java.sql.SQLException

Check that isClosed returns true after the statement has been explicitly closed.

Throws:

java.sql.SQLException

testIsClosedWithTwoStatementsOnSameConnection

public void testIsClosedWithTwoStatementsOnSameConnection()
                                                   throws java.sql.SQLException

Test that creating two statements on the same connection does not cause side effects on the statements.

Throws:

java.sql.SQLException

testIsClosedWhenClosingConnection

public void testIsClosedWhenClosingConnection()
                                       throws java.sql.SQLException

Test that the two statements created on the connection are closed when the connection itself is closed.

Throws:

java.sql.SQLException

testIsClosedWhenClosingConnectionInInvalidState

public void testIsClosedWhenClosingConnectionInInvalidState()
                                                     throws java.sql.SQLException

Check the state of the statement when the connection is first attempted closed when in an invalid transaction state, then closed after a commit. According to the JDBC 4 API documentation: "It is strongly recommended that an application explictly commits or rolls back an active transaction prior to calling the close method. If the close method is called and there is an active transaction, the results are implementation-defined." Derby throws an exception and keeps the connection open.

Throws:

java.sql.SQLException

testStatementExecuteAfterConnectionClose

public void testStatementExecuteAfterConnectionClose()
                                              throws java.sql.SQLException

Execute a query on a statement after the parent connection has been closed.

Throws:

java.sql.SQLException

testIsWrapperForStatement

public void testIsWrapperForStatement()
                               throws java.sql.SQLException

Throws:

java.sql.SQLException

testIsNotWrapperForPreparedStatement

public void testIsNotWrapperForPreparedStatement()
                                          throws java.sql.SQLException

Throws:

java.sql.SQLException

testIsNotWrapperForCallableStatement

public void testIsNotWrapperForCallableStatement()
                                          throws java.sql.SQLException

Throws:

java.sql.SQLException

testIsNotWrapperForResultSet

public void testIsNotWrapperForResultSet()
                                  throws java.sql.SQLException

Throws:

java.sql.SQLException

testUnwrapStatement

public void testUnwrapStatement()
                         throws java.sql.SQLException

Throws:

java.sql.SQLException

testUnwrapPreparedStatement

public void testUnwrapPreparedStatement()

testUnwrapCallableStatement

public void testUnwrapCallableStatement()

testUnwrapResultSet

public void testUnwrapResultSet()
                         throws java.sql.SQLException

Throws:

java.sql.SQLException

testPoolable

public void testPoolable()
                  throws java.sql.SQLException

Tests isPoolable, setPoolable, and the default poolability.

Throws:

java.sql.SQLException

test_jdbc4_1_queryTimeoutException

public void test_jdbc4_1_queryTimeoutException()
                                        throws java.lang.Exception

Test that Statement.setQueryTimeout() causes statements to raise SQLTimeoutException per the JDBC 4.1 spec clarification.

Throws:

java.lang.Exception

testCompletionClosure_jdbc4_1_implicitRSClosure

public void testCompletionClosure_jdbc4_1_implicitRSClosure()
                                                     throws java.lang.Exception

Test the closeOnCompletion() and isCloseOnCompletion() methods when using ResultSets which close implicitly.

Throws:

java.lang.Exception

testLargeUpdate_jdbc4_2

public void testLargeUpdate_jdbc4_2()
                             throws java.lang.Exception

Test the large update methods added by JDBC 4.2.

Throws:

java.lang.Exception

largeUpdate_jdbc4_2

public static void largeUpdate_jdbc4_2(java.sql.Connection conn)
                                throws java.lang.Exception

Throws:

java.lang.Exception

largeUpdateTest

private static void largeUpdateTest(StatementTest.StatementWrapper sw,
                                    long rowCountBase)
                             throws java.lang.Exception

Throws:

java.lang.Exception

largeUpdateTest

private static void largeUpdateTest(StatementTest.StatementWrapper sw,
                                    long rowCountBase,
                                    long rowCount)
                             throws java.lang.Exception

Throws:

java.lang.Exception

vetUpdateSize

private static void vetUpdateSize(StatementTest.StatementWrapper sw,
                                  int expected,
                                  int actual,
                                  long longAnswer)
                           throws java.lang.Exception

Throws:

java.lang.Exception

vetUpdateSize

private static void vetUpdateSize(StatementTest.StatementWrapper sw,
                                  long expected,
                                  long actual,
                                  long longAnswer)
                           throws java.lang.Exception

Throws:

java.lang.Exception

largeBatchTest

private static void largeBatchTest(StatementTest.StatementWrapper sw,
                                   long rowCountBase)
                            throws java.lang.Exception

Throws:

java.lang.Exception

createBatch

private static void createBatch(StatementTest.StatementWrapper sw)
                         throws java.lang.Exception

Throws:

java.lang.Exception

largeMaxRowsTest

private static void largeMaxRowsTest(StatementTest.StatementWrapper sw,
                                     long maxRows)
                              throws java.lang.Exception

Throws:

java.lang.Exception

largeBatchUpdateExceptionTest

private static void largeBatchUpdateExceptionTest(StatementTest.StatementWrapper sw,
                                                  long rowCountBase)
                                           throws java.lang.Exception

Throws:

java.lang.Exception

setRowCountBase

public static void setRowCountBase(java.sql.Statement stmt,
                                   boolean onClient,
                                   long rowCountBase)
                            throws java.lang.Exception

Throws:

java.lang.Exception

truncate

private static void truncate(StatementTest.StatementWrapper sw)
                      throws java.lang.Exception

Throws:

java.lang.Exception

squashLongs

private static int[] squashLongs(long[] longs)

suite

public static junit.framework.Test suite()

Create test suite for StatementTest.

setRowCountBase

public static void setRowCountBase(long newBase)

Set the base which is used for returned row counts and fetched row counters