org.apache.derbyTesting.functionTests.tests.jdbcapi
Class ProcedureTest

java.lang.Object
  extended by junit.framework.Assert
      extended by junit.framework.TestCase
          extended by org.apache.derbyTesting.junit.BaseTestCase
              extended by org.apache.derbyTesting.junit.BaseJDBCTestCase
                  extended by org.apache.derbyTesting.functionTests.tests.jdbcapi.ProcedureTest
All Implemented Interfaces:
junit.framework.Test

public class ProcedureTest
extends BaseJDBCTestCase

Tests of stored procedures.


Field Summary
private static java.lang.String[] PROCEDURES
          Procedures that should be created before the tests are run and dropped when the tests have finished.
private static java.lang.String[][] TABLES
          Tables that should be created before the tests are run and dropped when the tests have finished.
 
Fields inherited from class org.apache.derbyTesting.junit.BaseTestCase
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE
 
Constructor Summary
ProcedureTest(java.lang.String name)
          Creates a new ProcedureTest instance.
 
Method Summary
private  void assertMultipleResultsFromExecuteQuery(java.sql.SQLException sqle)
          Raises an exception if the exception is not caused by executeQuery() returning multiple result sets.
private  void assertNoResultSetFromExecuteQuery(java.sql.SQLException sqle)
          Raises an exception if the exception is not caused by executeQuery() returning no result set.
private  void assertResultsFromExecuteUpdate(java.sql.SQLException sqle)
          Raises an exception if the exception is not caused by executeUpdate() returning result sets.
private static junit.framework.Test baseSuite(java.lang.String name)
          Creates the test suite and wraps it in a TestSetup instance which sets up and tears down the test environment.
private  void checkCSCloseClosesResults(java.sql.CallableStatement cs, java.sql.ResultSet[] allRS)
          Check that CallableStatement.close() closes results
private  void checkExecuteClosesResults(java.sql.CallableStatement cs, java.sql.ResultSet[] allRS)
          Check that CallableStatement.execute() closes results
private  void closeCurrentGetMoreResults(java.sql.CallableStatement cs, java.sql.ResultSet[] allRS)
           
private  void defaultGetMoreResults(java.sql.CallableStatement cs, java.sql.ResultSet[] allRS)
          Test default getMoreResults() closes result set.
private  void keepCurrentGetMoreResults(java.sql.CallableStatement cs, java.sql.ResultSet[] allRS)
          Check getMoreResults(Statement.KEEP_CURRENT_RESULT)
private  void mixedGetMoreResults(java.sql.CallableStatement cs, java.sql.ResultSet[] allRS)
           
static void nestedDynamicResultSets(java.lang.String procedureText, java.sql.ResultSet[] rs1, java.sql.ResultSet[] rs2, java.sql.ResultSet[] rs3, java.sql.ResultSet[] rs4, java.sql.ResultSet[] rs5, java.sql.ResultSet[] rs6)
          Method for a Java procedure that calls another procedure and just passes on the dynamic results from that call.
static void procWithSideEffects(int returnResults, java.sql.ResultSet[] rs1, java.sql.ResultSet[] rs2)
          Stored procedure which inserts a row into SIMPLE_TABLE and optionally returns result sets.
static void retrieveClosedResult(java.sql.ResultSet[] closed)
          Stored procedure which produces a closed result set.
static void retrieveDynamicResults(int number, java.sql.ResultSet[] rs1, java.sql.ResultSet[] rs2, java.sql.ResultSet[] rs3, java.sql.ResultSet[] rs4)
          Stored procedure which returns 0, 1, 2, 3 or 4 ResultSets.
static void retrieveExternalResult(java.lang.String dbName, java.lang.String user, java.lang.String password, java.sql.ResultSet[] external)
          Stored procedure which produces a result set in another connection.
 void setUp()
          Sets up the connection for a test case and clears all tables used in the test cases.
static junit.framework.Test suite()
          Runs the test fixtures in embedded and client.
 void testClosedDynamicResultSetsFromExecuteQuery()
          Tests that closed result sets are not returned when calling executeQuery().
 void testClosedDynamicResultSetsFromExecuteUpdate()
          Tests that closed result sets are ignored when calling executeUpdate().
 void testDynamicResultSetsFromOtherConnectionWithExecuteQuery()
          Tests that dynamic result sets from other connections are ignored when calling executeQuery.
 void testDynamicResultSetsFromOtherConnectionWithExecuteUpdate()
          Tests that dynamic result sets from other connections are ignored when calling executeUpdate.
 void testExecuteQueryWithMoreThanOneDynamicResultSet_callable()
          Tests that CallableStatement.executeQuery() fails when multiple result sets are returned.
 void testExecuteQueryWithMoreThanOneDynamicResultSet_prepared()
          Tests that PreparedStatement.executeQuery() fails when multiple result sets are returned.
 void testExecuteQueryWithMoreThanOneDynamicResultSet()
          Tests that Statement.executeQuery() fails when multiple result sets are returned.
 void testExecuteQueryWithNoDynamicResultSets_callable()
          Tests that CallableStatement.executeQuery() fails when no result sets are returned.
 void testExecuteQueryWithNoDynamicResultSets_prepared()
          Tests that PreparedStatement.executeQuery() fails when no result sets are returned.
 void testExecuteQueryWithNoDynamicResultSets()
          Tests that Statement.executeQuery() fails when no result sets are returned.
 void testExecuteQueryWithOneDynamicResultSet_callable()
          Tests that CallableStatement.executeQuery() succeeds when one result set is returned from a stored procedure.
 void testExecuteQueryWithOneDynamicResultSet_prepared()
          Tests that PreparedStatement.executeQuery() succeeds when one result set is returned from a stored procedure.
 void testExecuteQueryWithOneDynamicResultSet()
          Tests that Statement.executeQuery() succeeds when one result set is returned from a stored procedure.
 void testExecuteUpdateWithNoDynamicResultSets_callable()
          Tests that CallableStatement.executeUpdate() succeeds when no result sets are returned.
 void testExecuteUpdateWithNoDynamicResultSets_prepared()
          Tests that PreparedStatement.executeUpdate() succeeds when no result sets are returned.
 void testExecuteUpdateWithNoDynamicResultSets()
          Tests that Statement.executeUpdate() succeeds when no result sets are returned.
 void testExecuteUpdateWithOneDynamicResultSet_callable()
          Tests that CallableStatement.executeUpdate() fails when a result set is returned from a stored procedure.
 void testExecuteUpdateWithOneDynamicResultSet_prepared()
          Tests that PreparedStatement.executeUpdate() fails when a result set is returned from a stored procedure.
 void testExecuteUpdateWithOneDynamicResultSet()
          Tests that Statement.executeUpdate() fails when a result set is returned from a stored procedure.
 void testGetMoreResults()
          Test various combinations of getMoreResults
 void testRollbackStoredProcWhenExecuteQueryReturnsNothing_prepared()
          Tests that the effects of executing a stored procedure with executeQuery() are correctly rolled back when the query fails because the number of returned result sets is zero.
 void testRollbackStoredProcWhenExecuteQueryReturnsNothing()
          Tests that the effects of executing a stored procedure with executeQuery() are correctly rolled back when the query fails because the number of returned result sets is zero.
 void testRollbackStoredProcWhenExecuteQueryReturnsTooMuch_prepared()
          Tests that the effects of executing a stored procedure with executeQuery() are correctly rolled back when the query fails because the number of returned result sets is more than one.
 void testRollbackStoredProcWhenExecuteQueryReturnsTooMuch()
          Tests that the effects of executing a stored procedure with executeQuery() are correctly rolled back when the query fails because the number of returned result sets is more than one.
 void testRollbackStoredProcWhenExecuteUpdateReturnsResults_prepared()
          Tests that the effects of executing a stored procedure with executeUpdate() are correctly rolled back when the query fails because the stored procedure returned a result set.
 void testRollbackStoredProcWhenExecuteUpdateReturnsResults()
          Tests that the effects of executing a stored procedure with executeUpdate() are correctly rolled back when the query fails because the stored procedure returned a result set.
 void testRollbackStoredProcWithExecuteQuery()
          Tests that the effects of executing a stored procedure with executeQuery() are correctly rolled back when Connection.rollback() is called.
 void testRollbackStoredProcWithExecuteUpdate()
          Tests that the effects of executing a stored procedure with executeUpdate() are correctly rolled back when Connection.rollback() is called.
 
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, 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
 

Field Detail

PROCEDURES

private static final java.lang.String[] PROCEDURES
Procedures that should be created before the tests are run and dropped when the tests have finished. First element in each row is the name of the procedure, second element is SQL which creates it.


TABLES

private static final java.lang.String[][] TABLES
Tables that should be created before the tests are run and dropped when the tests have finished. The tables will be cleared before each test case is run. First element in each row is the name of the table, second element is the SQL text which creates it.

Constructor Detail

ProcedureTest

public ProcedureTest(java.lang.String name)
Creates a new ProcedureTest instance.

Parameters:
name - name of the test
Method Detail

testExecuteQueryWithNoDynamicResultSets

public void testExecuteQueryWithNoDynamicResultSets()
                                             throws java.sql.SQLException
Tests that Statement.executeQuery() fails when no result sets are returned.

Throws:
java.sql.SQLException - if a database error occurs

testExecuteQueryWithOneDynamicResultSet

public void testExecuteQueryWithOneDynamicResultSet()
                                             throws java.sql.SQLException
Tests that Statement.executeQuery() succeeds when one result set is returned from a stored procedure.

Throws:
java.sql.SQLException - if a database error occurs

testExecuteQueryWithMoreThanOneDynamicResultSet

public void testExecuteQueryWithMoreThanOneDynamicResultSet()
                                                     throws java.sql.SQLException
Tests that Statement.executeQuery() fails when multiple result sets are returned.

Throws:
java.sql.SQLException - if a database error occurs

testExecuteUpdateWithNoDynamicResultSets

public void testExecuteUpdateWithNoDynamicResultSets()
                                              throws java.sql.SQLException
Tests that Statement.executeUpdate() succeeds when no result sets are returned.

Currently, this test fails with JCC.

Throws:
java.sql.SQLException - if a database error occurs

testExecuteUpdateWithOneDynamicResultSet

public void testExecuteUpdateWithOneDynamicResultSet()
                                              throws java.sql.SQLException
Tests that Statement.executeUpdate() fails when a result set is returned from a stored procedure.

Throws:
java.sql.SQLException - if a database error occurs

testExecuteQueryWithNoDynamicResultSets_prepared

public void testExecuteQueryWithNoDynamicResultSets_prepared()
                                                      throws java.sql.SQLException
Tests that PreparedStatement.executeQuery() fails when no result sets are returned.

Throws:
java.sql.SQLException - if a database error occurs

testExecuteQueryWithOneDynamicResultSet_prepared

public void testExecuteQueryWithOneDynamicResultSet_prepared()
                                                      throws java.sql.SQLException
Tests that PreparedStatement.executeQuery() succeeds when one result set is returned from a stored procedure.

Throws:
java.sql.SQLException - if a database error occurs

testExecuteQueryWithMoreThanOneDynamicResultSet_prepared

public void testExecuteQueryWithMoreThanOneDynamicResultSet_prepared()
                                                              throws java.sql.SQLException
Tests that PreparedStatement.executeQuery() fails when multiple result sets are returned.

Throws:
java.sql.SQLException - if a database error occurs

testExecuteUpdateWithNoDynamicResultSets_prepared

public void testExecuteUpdateWithNoDynamicResultSets_prepared()
                                                       throws java.sql.SQLException
Tests that PreparedStatement.executeUpdate() succeeds when no result sets are returned.

Currently, this test fails with JCC.

Throws:
java.sql.SQLException - if a database error occurs

testExecuteUpdateWithOneDynamicResultSet_prepared

public void testExecuteUpdateWithOneDynamicResultSet_prepared()
                                                       throws java.sql.SQLException
Tests that PreparedStatement.executeUpdate() fails when a result set is returned from a stored procedure.

Currently, this test fails with JCC. However, the corresponding tests for Statement and CallableStatement succeed. Strange...

Throws:
java.sql.SQLException - if a database error occurs

testExecuteQueryWithNoDynamicResultSets_callable

public void testExecuteQueryWithNoDynamicResultSets_callable()
                                                      throws java.sql.SQLException
Tests that CallableStatement.executeQuery() fails when no result sets are returned.

Throws:
java.sql.SQLException - if a database error occurs

testExecuteQueryWithOneDynamicResultSet_callable

public void testExecuteQueryWithOneDynamicResultSet_callable()
                                                      throws java.sql.SQLException
Tests that CallableStatement.executeQuery() succeeds when one result set is returned from a stored procedure.

Throws:
java.sql.SQLException - if a database error occurs

testExecuteQueryWithMoreThanOneDynamicResultSet_callable

public void testExecuteQueryWithMoreThanOneDynamicResultSet_callable()
                                                              throws java.sql.SQLException
Tests that CallableStatement.executeQuery() fails when multiple result sets are returned.

Throws:
java.sql.SQLException - if a database error occurs

testExecuteUpdateWithNoDynamicResultSets_callable

public void testExecuteUpdateWithNoDynamicResultSets_callable()
                                                       throws java.sql.SQLException
Tests that CallableStatement.executeUpdate() succeeds when no result sets are returned.

Currently, this test fails with JCC.

Throws:
java.sql.SQLException - if a database error occurs

testExecuteUpdateWithOneDynamicResultSet_callable

public void testExecuteUpdateWithOneDynamicResultSet_callable()
                                                       throws java.sql.SQLException
Tests that CallableStatement.executeUpdate() fails when a result set is returned from a stored procedure.

Throws:
java.sql.SQLException - if a database error occurs

testRollbackStoredProcWithExecuteQuery

public void testRollbackStoredProcWithExecuteQuery()
                                            throws java.sql.SQLException
Tests that the effects of executing a stored procedure with executeQuery() are correctly rolled back when Connection.rollback() is called.

Throws:
java.sql.SQLException - if a database error occurs

testRollbackStoredProcWithExecuteUpdate

public void testRollbackStoredProcWithExecuteUpdate()
                                             throws java.sql.SQLException
Tests that the effects of executing a stored procedure with executeUpdate() are correctly rolled back when Connection.rollback() is called.

Throws:
java.sql.SQLException - if a database error occurs

testRollbackStoredProcWhenExecuteQueryReturnsNothing

public void testRollbackStoredProcWhenExecuteQueryReturnsNothing()
                                                          throws java.sql.SQLException
Tests that the effects of executing a stored procedure with executeQuery() are correctly rolled back when the query fails because the number of returned result sets is zero.

This test case fails with JCC.

Throws:
java.sql.SQLException - if a database error occurs

testRollbackStoredProcWhenExecuteQueryReturnsTooMuch

public void testRollbackStoredProcWhenExecuteQueryReturnsTooMuch()
                                                          throws java.sql.SQLException
Tests that the effects of executing a stored procedure with executeQuery() are correctly rolled back when the query fails because the number of returned result sets is more than one.

This test case fails with JCC.

Throws:
java.sql.SQLException - if a database error occurs

testRollbackStoredProcWhenExecuteUpdateReturnsResults

public void testRollbackStoredProcWhenExecuteUpdateReturnsResults()
                                                           throws java.sql.SQLException
Tests that the effects of executing a stored procedure with executeUpdate() are correctly rolled back when the query fails because the stored procedure returned a result set.

This test case fails with JCC.

Throws:
java.sql.SQLException - if a database error occurs

testRollbackStoredProcWhenExecuteQueryReturnsNothing_prepared

public void testRollbackStoredProcWhenExecuteQueryReturnsNothing_prepared()
                                                                   throws java.sql.SQLException
Tests that the effects of executing a stored procedure with executeQuery() are correctly rolled back when the query fails because the number of returned result sets is zero.

This test case fails with JCC.

Throws:
java.sql.SQLException - if a database error occurs

testRollbackStoredProcWhenExecuteQueryReturnsTooMuch_prepared

public void testRollbackStoredProcWhenExecuteQueryReturnsTooMuch_prepared()
                                                                   throws java.sql.SQLException
Tests that the effects of executing a stored procedure with executeQuery() are correctly rolled back when the query fails because the number of returned result sets is more than one.

This test case fails with JCC.

Throws:
java.sql.SQLException - if a database error occurs

testRollbackStoredProcWhenExecuteUpdateReturnsResults_prepared

public void testRollbackStoredProcWhenExecuteUpdateReturnsResults_prepared()
                                                                    throws java.sql.SQLException
Tests that the effects of executing a stored procedure with executeUpdate() are correctly rolled back when the query fails because the stored procedure returned a result set.

This test case fails with JCC.

Throws:
java.sql.SQLException - if a database error occurs

testClosedDynamicResultSetsFromExecuteQuery

public void testClosedDynamicResultSetsFromExecuteQuery()
                                                 throws java.sql.SQLException
Tests that closed result sets are not returned when calling executeQuery().

Throws:
java.sql.SQLException - if a database error occurs

testClosedDynamicResultSetsFromExecuteUpdate

public void testClosedDynamicResultSetsFromExecuteUpdate()
                                                  throws java.sql.SQLException
Tests that closed result sets are ignored when calling executeUpdate().

Throws:
java.sql.SQLException - if a database error occurs

testDynamicResultSetsFromOtherConnectionWithExecuteQuery

public void testDynamicResultSetsFromOtherConnectionWithExecuteQuery()
                                                              throws java.sql.SQLException
Tests that dynamic result sets from other connections are ignored when calling executeQuery.

Throws:
java.sql.SQLException - if a database error occurs

testDynamicResultSetsFromOtherConnectionWithExecuteUpdate

public void testDynamicResultSetsFromOtherConnectionWithExecuteUpdate()
                                                               throws java.sql.SQLException
Tests that dynamic result sets from other connections are ignored when calling executeUpdate.

Throws:
java.sql.SQLException - if a database error occurs

assertNoResultSetFromExecuteQuery

private void assertNoResultSetFromExecuteQuery(java.sql.SQLException sqle)
Raises an exception if the exception is not caused by executeQuery() returning no result set.

Parameters:
sqle - a SQLException value

assertMultipleResultsFromExecuteQuery

private void assertMultipleResultsFromExecuteQuery(java.sql.SQLException sqle)
Raises an exception if the exception is not caused by executeQuery() returning multiple result sets.

Parameters:
sqle - a SQLException value

assertResultsFromExecuteUpdate

private void assertResultsFromExecuteUpdate(java.sql.SQLException sqle)
Raises an exception if the exception is not caused by executeUpdate() returning result sets.

Parameters:
sqle - a SQLException value

suite

public static junit.framework.Test suite()
Runs the test fixtures in embedded and client.

Returns:
test suite

baseSuite

private static junit.framework.Test baseSuite(java.lang.String name)
Creates the test suite and wraps it in a TestSetup instance which sets up and tears down the test environment.

Returns:
test suite

setUp

public void setUp()
           throws java.sql.SQLException
Sets up the connection for a test case and clears all tables used in the test cases.

Overrides:
setUp in class junit.framework.TestCase
Throws:
java.sql.SQLException - if a database error occurs

retrieveDynamicResults

public static void retrieveDynamicResults(int number,
                                          java.sql.ResultSet[] rs1,
                                          java.sql.ResultSet[] rs2,
                                          java.sql.ResultSet[] rs3,
                                          java.sql.ResultSet[] rs4)
                                   throws java.sql.SQLException
Stored procedure which returns 0, 1, 2, 3 or 4 ResultSets.

Parameters:
number - the number of ResultSets to return
rs1 - first ResultSet
rs2 - second ResultSet
rs3 - third ResultSet
rs4 - fourth ResultSet
Throws:
java.sql.SQLException - if a database error occurs

retrieveClosedResult

public static void retrieveClosedResult(java.sql.ResultSet[] closed)
                                 throws java.sql.SQLException
Stored procedure which produces a closed result set.

Parameters:
closed - holder for the closed result set
Throws:
java.sql.SQLException - if a database error occurs

retrieveExternalResult

public static void retrieveExternalResult(java.lang.String dbName,
                                          java.lang.String user,
                                          java.lang.String password,
                                          java.sql.ResultSet[] external)
                                   throws java.sql.SQLException
Stored procedure which produces a result set in another connection.

Parameters:
external - result set from another connection
Throws:
java.sql.SQLException - if a database error occurs

procWithSideEffects

public static void procWithSideEffects(int returnResults,
                                       java.sql.ResultSet[] rs1,
                                       java.sql.ResultSet[] rs2)
                                throws java.sql.SQLException
Stored procedure which inserts a row into SIMPLE_TABLE and optionally returns result sets.

Parameters:
returnResults - if one, return one result set; if greater than one, return two result sets; otherwise, return no result set
rs1 - first result set to return
rs2 - second result set to return
Throws:
java.sql.SQLException - if a database error occurs

nestedDynamicResultSets

public static void nestedDynamicResultSets(java.lang.String procedureText,
                                           java.sql.ResultSet[] rs1,
                                           java.sql.ResultSet[] rs2,
                                           java.sql.ResultSet[] rs3,
                                           java.sql.ResultSet[] rs4,
                                           java.sql.ResultSet[] rs5,
                                           java.sql.ResultSet[] rs6)
                                    throws java.sql.SQLException
Method for a Java procedure that calls another procedure and just passes on the dynamic results from that call.

Throws:
java.sql.SQLException

testGetMoreResults

public void testGetMoreResults()
                        throws java.sql.SQLException
Test various combinations of getMoreResults

Throws:
java.sql.SQLException

checkExecuteClosesResults

private void checkExecuteClosesResults(java.sql.CallableStatement cs,
                                       java.sql.ResultSet[] allRS)
                                throws java.sql.SQLException
Check that CallableStatement.execute() closes results

Parameters:
cs -
allRS -
Throws:
java.sql.SQLException

checkCSCloseClosesResults

private void checkCSCloseClosesResults(java.sql.CallableStatement cs,
                                       java.sql.ResultSet[] allRS)
                                throws java.sql.SQLException
Check that CallableStatement.close() closes results

Parameters:
cs -
allRS -
Throws:
java.sql.SQLException

mixedGetMoreResults

private void mixedGetMoreResults(java.sql.CallableStatement cs,
                                 java.sql.ResultSet[] allRS)
                          throws java.sql.SQLException
Throws:
java.sql.SQLException

keepCurrentGetMoreResults

private void keepCurrentGetMoreResults(java.sql.CallableStatement cs,
                                       java.sql.ResultSet[] allRS)
                                throws java.sql.SQLException
Check getMoreResults(Statement.KEEP_CURRENT_RESULT)

Parameters:
cs -
allRS -
Throws:
java.sql.SQLException

closeCurrentGetMoreResults

private void closeCurrentGetMoreResults(java.sql.CallableStatement cs,
                                        java.sql.ResultSet[] allRS)
                                 throws java.sql.SQLException
Throws:
java.sql.SQLException

defaultGetMoreResults

private void defaultGetMoreResults(java.sql.CallableStatement cs,
                                   java.sql.ResultSet[] allRS)
                            throws java.sql.SQLException
Test default getMoreResults() closes result set.

Parameters:
cs -
allRS -
Throws:
java.sql.SQLException

Built on Thu 2009-11-26 18:42:53-0800, from revision 884739

Apache Derby V10.6 Internals - Copyright © 2004,2008 The Apache Software Foundation. All Rights Reserved.