ResultSetTest (Apache Derby V10.10 Test Javadoc)

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.Wrapper41Test
        
        org.apache.derbyTesting.functionTests.tests.jdbc4.ResultSetTest

All Implemented Interfaces:

junit.framework.Test
```
public class ResultSetTest
extends Wrapper41Test
```
Tests of JDBC4 and JDBC4.1 features in ResultSet. Some utility methods have been introduced for the updateXXX test-methods. This test also makes use of a TestSetup wrapper to perform one-time setup and teardown for the whole suite.

Field Summary

Fields
Modifier and Type	Field and Description
`private static byte[]`	`BYTES1`
`private static byte[]`	`BYTES2`
`private static int`	`insertKey` Key used to identify inserted rows.
`private int`	`key` Default row identifier used by the tests.
`private java.sql.ResultSet`	`rs` Default resultset used by the tests.
`private java.sql.Statement`	`stmt` Statement used to obtain default resultset.
`private static java.lang.String`	`str1`
`private static java.lang.String`	`str2`

Fields inherited from class org.apache.derbyTesting.functionTests.tests.jdbc4.Wrapper41Test
BINARY_VALUE, TIME_VALUE, TIMESTAMP_VALUE

Fields inherited from class org.apache.derbyTesting.junit.BaseTestCase
DEFAULT_DB_DIR, DERBY_LOG, ERRORSTACKTRACEFILE

Constructor Summary

Constructors
Constructor and Description

ResultSetTest(java.lang.String name)
Create test with given name.

Constructors
Constructor and Description
`ResultSetTest(java.lang.String name)` Create test with given name.

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`private static junit.framework.Test`	`decorateTestSuite(junit.framework.Test rsSuite)`
`private java.sql.ResultSet`	`fetch(java.lang.String colName, int key)` Fetch the specified row.
`private java.sql.ResultSet`	`fetchUpd(java.lang.String colName, int key)` Fetch the specified row for update.
`static void`	`getResultSetWithHoldability(int holdability, java.sql.ResultSet[] rs)` Method invoked by `testGetHoldability()` (as a stored procedure) to retrieve a result set with a given holdability.
`private static java.lang.String`	`holdabilityString(int holdability)` Convert holdability from an integer to a readable string.
`static java.sql.Blob`	`makeBlob()` Function for making a Blob.
`private java.sql.PreparedStatement`	`prep(java.lang.String colName)` Prepare commonly used statement to insert a row.
`private static int`	`requestKey()` Get a key that is used to identify an inserted row.
`protected void`	`setUp()`
`static junit.framework.Test`	`suite()` T E S T S E T U P *
`protected void`	`tearDown()` Tear down this fixture, sub-classes should call super.tearDown().
`void`	`testDerby1368()` EOFException when reading from blob's binary stream and calling length() twice Test with and without lengthless insert.
`void`	`testDerby1368(boolean lengthless)` EOFException when reading from blob's binary stream and calling length() twice
`void`	`testExceptionWhenClosed()` Test that an exception is thrown when methods are called on a closed result set (DERBY-1060).
`void`	`testGetHoldability()` Tests that `ResultSet.getHoldability()` has the correct behaviour.
`void`	`testGetNCharacterStreamIntNotImplemented()`
`void`	`testGetNCharaterStreamStringNotImplemented()`
`void`	`testGetNClobNotIntImplemented()`
`void`	`testGetNClobStringNotImplemented()`
`void`	`testGetNStringIntNotImplemented()`
`void`	`testGetNStringStringNotImplemented()`
`void`	`testGetSQLXMLIntNotImplemented()`
`void`	`testGetSQLXMLStringNotImplemented()`
`void`	`testIsClosed()` Tests that `ResultSet.isClosed()` returns the correct value in different situations.
`void`	`testIsClosedOnNonHoldableResultSet()` Test that a `ResultSet` is marked as closed after commit if its holdability is `CLOSE_CURSORS_AT_COMMIT` (DERBY-3404).
`void`	`testJDBC4_1()` Test the JDBC 4.1 extensions.
`void`	`testUpdateAsciiStream()` This methods tests the ResultSet interface method updateAsciiStream
`void`	`testUpdateAsciiStreamLengthless()`
`void`	`testUpdateAsciiStreamLengthlessParameterName()`
`void`	`testUpdateAsciiStreamStringParameterName()` This methods tests the ResultSet interface method updateAsciiStream
`void`	`testUpdateBinaryStream()` This methods tests the ResultSet interface method updateBinaryStream
`void`	`testUpdateBinaryStreamLengthless()` Test `updateBinaryStream` on a BINARY column, without specifying length of inputstream.
`void`	`testUpdateBinaryStreamLengthlessBlob()` Test `updateBinaryStream` on a BLOB column, without specifying length of inputstream.
`void`	`testUpdateBinaryStreamLengthlessParameterName()`
`void`	`testUpdateBinaryStreamStringParameterName()` This methods tests the ResultSet interface method updateBinaryStream
`void`	`testUpdateBlob()` This methods tests the ResultSet interface method updateBlob
`void`	`testUpdateBlobLengthless()`
`void`	`testUpdateBlobStringParameterName()` This methods tests the ResultSet interface method updateBlob
`void`	`testUpdateBlobStringParameterNameWithLengthofIS()` Tests the updateBlob that accepts a input stream and the length of the IS and the parameter name String.
`void`	`testUpdateBlobWithLengthofIS()` tests the updateBlob that accepts a input stream and the length of the IS.
`void`	`testUpdateBlobWithStreamLengthlessParameterName()`
`void`	`testUpdateCharacterStream()` This methods tests the ResultSet interface method updateCharacterStream
`void`	`testUpdateCharacterStreamLengthless()`
`void`	`testUpdateCharacterStreamLengthlessParameterName()`
`void`	`testUpdateCharacterStreamStringParameterName()` This methods tests the ResultSet interface method updateCharacterStream
`void`	`testUpdateClob()` This methods tests the ResultSet interface method updateClob
`void`	`testUpdateClobLengthless()`
`void`	`testUpdateClobLengthlessParameterName()`
`void`	`testUpdateClobStringParameterName()` This methods tests the ResultSet interface method updateClob
`void`	`testUpdateClobStringParameterNameWithLengthofIS()` Tests the updateClob that accepts a input stream and the length of the IS and the parameter name String.
`void`	`testUpdateClobwithLengthofIS()` Test the Clob method that accepts a Input Stream and its length as input parameter.
`void`	`testUpdateNCharacterStreamIntLengthLessNotImplemented()`
`void`	`testUpdateNCharacterStreamIntNotImplemented()`
`void`	`testUpdateNCharacterStreamStringLengthlessNotImplemented()`
`void`	`testUpdateNCharacterStreamStringNotImplemented()`
`void`	`testUpdateNClobIntLengthlessNotImplemented()`
`void`	`testUpdateNClobIntNotImplemented()`
`void`	`testUpdateNClobStringLengthlessNotImplemented()`
`void`	`testUpdateNClobStringNotImplemented()`
`void`	`testUpdateNStringIntNotImplemented()`
`void`	`testUpdateNStringStringNotImplemented()`
`void`	`testUpdateSQLXMLIntNotImplemented()`
`void`	`testUpdateSQLXMLStringNotImplemented()`
`void`	`testWrapper()` Tests the wrapper methods isWrapperFor and unwrap.
`static void`	`threeResultSets(java.sql.ResultSet[] rs1, java.sql.ResultSet[] rs2, java.sql.ResultSet[] rs3)` Method that is invoked by `testIsClosed()` (as a stored procedure) to retrieve three result sets.
`private void`	`vetDataTypeCount(java.sql.Connection conn)`

Methods inherited from class org.apache.derbyTesting.functionTests.tests.jdbc4.Wrapper41Test
examineJDBC4_1extensions, prepareCall, prepareStatement

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
  - BYTES1
```
private static final byte[] BYTES1
```
  - BYTES2
```
private static final byte[] BYTES2
```
  - str1
```
private static final java.lang.String str1
```
    See Also:
    
    Constant Field Values
  - str2
```
private static final java.lang.String str2
```
    See Also:
    
    Constant Field Values
  - insertKey
```
private static int insertKey
```
    Key used to identify inserted rows. Use method requestKey to obtain it.
  - stmt
```
private java.sql.Statement stmt
```
    Statement used to obtain default resultset.
  - rs
```
private java.sql.ResultSet rs
```
    Default resultset used by the tests.
  - key
```
private int key
```
    Default row identifier used by the tests.
- Constructor Detail
  - ResultSetTest
```
public ResultSetTest(java.lang.String name)
```
    Create test with given name.
    
    Parameters:
    
    name - name of the test.
- Method Detail
  - setUp
```
protected void setUp()
              throws java.sql.SQLException
```
    Overrides:
    
    setUp in class junit.framework.TestCase
    
    Throws:
    
    java.sql.SQLException
  - tearDown
```
protected void tearDown()
                 throws java.lang.Exception
```
    Description copied from class: BaseJDBCTestCase
    
    Tear down this fixture, sub-classes should call super.tearDown(). This cleanups & closes the connection if it is open and any statement objects returned through the utility methods.
    
    Overrides:
    
    tearDown in class BaseJDBCTestCase
    
    Throws:
    
    java.lang.Exception
  - testGetNCharacterStreamIntNotImplemented
```
public void testGetNCharacterStreamIntNotImplemented()
                                              throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testGetNCharaterStreamStringNotImplemented
```
public void testGetNCharaterStreamStringNotImplemented()
                                                throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testGetNClobNotIntImplemented
```
public void testGetNClobNotIntImplemented()
                                   throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testGetNClobStringNotImplemented
```
public void testGetNClobStringNotImplemented()
                                      throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testGetNStringIntNotImplemented
```
public void testGetNStringIntNotImplemented()
                                     throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testGetNStringStringNotImplemented
```
public void testGetNStringStringNotImplemented()
                                        throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testGetSQLXMLIntNotImplemented
```
public void testGetSQLXMLIntNotImplemented()
                                    throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testGetSQLXMLStringNotImplemented
```
public void testGetSQLXMLStringNotImplemented()
                                       throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testUpdateNCharacterStreamIntNotImplemented
```
public void testUpdateNCharacterStreamIntNotImplemented()
                                                 throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testUpdateNCharacterStreamIntLengthLessNotImplemented
```
public void testUpdateNCharacterStreamIntLengthLessNotImplemented()
                                                           throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testUpdateNCharacterStreamStringNotImplemented
```
public void testUpdateNCharacterStreamStringNotImplemented()
                                                    throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testUpdateNCharacterStreamStringLengthlessNotImplemented
```
public void testUpdateNCharacterStreamStringLengthlessNotImplemented()
                                                              throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testUpdateNClobIntNotImplemented
```
public void testUpdateNClobIntNotImplemented()
                                      throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testUpdateNClobIntLengthlessNotImplemented
```
public void testUpdateNClobIntLengthlessNotImplemented()
                                                throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testUpdateNClobStringNotImplemented
```
public void testUpdateNClobStringNotImplemented()
                                         throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testUpdateNClobStringLengthlessNotImplemented
```
public void testUpdateNClobStringLengthlessNotImplemented()
                                                   throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testUpdateNStringIntNotImplemented
```
public void testUpdateNStringIntNotImplemented()
                                        throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testUpdateNStringStringNotImplemented
```
public void testUpdateNStringStringNotImplemented()
                                           throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testUpdateSQLXMLIntNotImplemented
```
public void testUpdateSQLXMLIntNotImplemented()
                                       throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testUpdateSQLXMLStringNotImplemented
```
public void testUpdateSQLXMLStringNotImplemented()
                                          throws java.sql.SQLException
```
    Throws:
    
    java.sql.SQLException
  - testUpdateBinaryStream
```
public void testUpdateBinaryStream()
                            throws java.lang.Exception
```
    This methods tests the ResultSet interface method updateBinaryStream
    
    Throws:
    
    java.sql.SQLException - if some error occurs while calling the method
    
    java.lang.Exception
  - testUpdateAsciiStream
```
public void testUpdateAsciiStream()
                           throws java.lang.Exception
```
    This methods tests the ResultSet interface method updateAsciiStream
    
    Throws:
    
    java.sql.SQLException - if some error occurs while calling the method
    
    java.lang.Exception
  - testUpdateCharacterStream
```
public void testUpdateCharacterStream()
                               throws java.lang.Exception
```
    This methods tests the ResultSet interface method updateCharacterStream
    
    Throws:
    
    java.sql.SQLException - if some error occurs while calling the method
    
    java.lang.Exception
  - testUpdateBinaryStreamStringParameterName
```
public void testUpdateBinaryStreamStringParameterName()
                                               throws java.lang.Exception
```
    This methods tests the ResultSet interface method updateBinaryStream
    
    Throws:
    
    java.sql.SQLException - if some error occurs while calling the method
    
    java.lang.Exception
  - testUpdateBinaryStreamLengthless
```
public void testUpdateBinaryStreamLengthless()
                                      throws java.io.IOException,
                                             java.sql.SQLException
```
    Test updateBinaryStream on a BINARY column, without specifying length of inputstream.
    
    Throws:
    
    java.io.IOException
    
    java.sql.SQLException
  - testUpdateBinaryStreamLengthlessBlob
```
public void testUpdateBinaryStreamLengthlessBlob()
                                          throws java.io.IOException,
                                                 java.sql.SQLException
```
    Test updateBinaryStream on a BLOB column, without specifying length of inputstream.
    
    Throws:
    
    java.io.IOException
    
    java.sql.SQLException
  - testUpdateBinaryStreamLengthlessParameterName
```
public void testUpdateBinaryStreamLengthlessParameterName()
                                                   throws java.io.IOException,
                                                          java.sql.SQLException
```
    Throws:
    
    java.io.IOException
    
    java.sql.SQLException
  - testUpdateAsciiStreamStringParameterName
```
public void testUpdateAsciiStreamStringParameterName()
                                              throws java.lang.Exception
```
    This methods tests the ResultSet interface method updateAsciiStream
    
    Throws:
    
    java.sql.SQLException - if some error occurs while calling the method
    
    java.lang.Exception
  - testUpdateAsciiStreamLengthless
```
public void testUpdateAsciiStreamLengthless()
                                     throws java.io.IOException,
                                            java.sql.SQLException
```
    Throws:
    
    java.io.IOException
    
    java.sql.SQLException
  - testUpdateAsciiStreamLengthlessParameterName
```
public void testUpdateAsciiStreamLengthlessParameterName()
                                                  throws java.io.IOException,
                                                         java.sql.SQLException
```
    Throws:
    
    java.io.IOException
    
    java.sql.SQLException
  - testUpdateCharacterStreamStringParameterName
```
public void testUpdateCharacterStreamStringParameterName()
                                                  throws java.lang.Exception
```
    This methods tests the ResultSet interface method updateCharacterStream
    
    Throws:
    
    java.sql.SQLException - if some error occurs while calling the method
    
    java.lang.Exception
  - testUpdateCharacterStreamLengthless
```
public void testUpdateCharacterStreamLengthless()
                                         throws java.io.IOException,
                                                java.sql.SQLException
```
    Throws:
    
    java.io.IOException
    
    java.sql.SQLException
  - testUpdateCharacterStreamLengthlessParameterName
```
public void testUpdateCharacterStreamLengthlessParameterName()
                                                      throws java.io.IOException,
                                                             java.sql.SQLException
```
    Throws:
    
    java.io.IOException
    
    java.sql.SQLException
  - testUpdateClob
```
public void testUpdateClob()
                    throws java.lang.Exception
```
    This methods tests the ResultSet interface method updateClob
    
    Throws:
    
    java.sql.SQLException - if some error occurs while calling the method
    
    java.lang.Exception
  - testUpdateClobLengthless
```
public void testUpdateClobLengthless()
                              throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testUpdateClobwithLengthofIS
```
public void testUpdateClobwithLengthofIS()
                                  throws java.lang.Exception
```
    Test the Clob method that accepts a Input Stream and its length as input parameter.
    
    Throws:
    
    java.lang.Exception
  - testUpdateBlob
```
public void testUpdateBlob()
                    throws java.lang.Exception
```
    This methods tests the ResultSet interface method updateBlob
    
    Throws:
    
    java.sql.SQLException - if some error occurs while calling the method
    
    java.lang.Exception
  - testUpdateBlobLengthless
```
public void testUpdateBlobLengthless()
                              throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testUpdateBlobWithLengthofIS
```
public void testUpdateBlobWithLengthofIS()
                                  throws java.lang.Exception
```
    tests the updateBlob that accepts a input stream and the length of the IS.
    
    Throws:
    
    an - Exception
    
    java.lang.Exception
  - testUpdateBlobStringParameterNameWithLengthofIS
```
public void testUpdateBlobStringParameterNameWithLengthofIS()
                                                     throws java.lang.Exception
```
    Tests the updateBlob that accepts a input stream and the length of the IS and the parameter name String.
    
    Throws:
    
    an - Exception
    
    java.lang.Exception
  - testUpdateClobStringParameterName
```
public void testUpdateClobStringParameterName()
                                       throws java.lang.Exception
```
    This methods tests the ResultSet interface method updateClob
    
    Throws:
    
    java.sql.SQLException - if some error occurs while calling the method
    
    java.lang.Exception
  - testUpdateClobLengthlessParameterName
```
public void testUpdateClobLengthlessParameterName()
                                           throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testUpdateClobStringParameterNameWithLengthofIS
```
public void testUpdateClobStringParameterNameWithLengthofIS()
                                                     throws java.lang.Exception
```
    Tests the updateClob that accepts a input stream and the length of the IS and the parameter name String.
    
    Throws:
    
    an - Exception
    
    java.lang.Exception
  - testUpdateBlobStringParameterName
```
public void testUpdateBlobStringParameterName()
                                       throws java.lang.Exception
```
    This methods tests the ResultSet interface method updateBlob
    
    Throws:
    
    java.sql.SQLException - if some error occurs while calling the method
    
    java.lang.Exception
  - testUpdateBlobWithStreamLengthlessParameterName
```
public void testUpdateBlobWithStreamLengthlessParameterName()
                                                     throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - testGetHoldability
```
public void testGetHoldability()
                        throws java.sql.SQLException,
                               java.lang.Exception
```
    Tests that ResultSet.getHoldability() has the correct behaviour.
    
    Throws:
    
    java.sql.SQLException - Thrown if some unexpected error happens
    
    java.lang.Exception - Thrown if some unexpected error happens
  - testIsClosed
```
public void testIsClosed()
                  throws java.sql.SQLException
```
    Tests that ResultSet.isClosed() returns the correct value in different situations.
    
    Throws:
    
    java.sql.SQLException - Thrown if some unexpected error happens
  - testIsClosedOnNonHoldableResultSet
```
public void testIsClosedOnNonHoldableResultSet()
                                        throws java.sql.SQLException
```
    Test that a ResultSet is marked as closed after commit if its holdability is CLOSE_CURSORS_AT_COMMIT (DERBY-3404).
    
    Throws:
    
    java.sql.SQLException
  - testExceptionWhenClosed
```
public void testExceptionWhenClosed()
                             throws java.lang.NoSuchMethodException,
                                    java.lang.IllegalAccessException,
                                    java.lang.reflect.InvocationTargetException,
                                    java.sql.SQLException
```
    Test that an exception is thrown when methods are called on a closed result set (DERBY-1060).
    
    Throws:
    
    java.sql.SQLException - Thrown if some unexpected error happens
    
    java.lang.NoSuchMethodException
    
    java.lang.IllegalAccessException
    
    java.lang.reflect.InvocationTargetException
  - testWrapper
```
public void testWrapper()
                 throws java.sql.SQLException
```
    Tests the wrapper methods isWrapperFor and unwrap. There are two cases to be tested Case 1: isWrapperFor returns true and we call unwrap Case 2: isWrapperFor returns false and we call unwrap
    
    Throws:
    
    java.sql.SQLException - Thrown if some unexpected error happens
  - suite
```
public static junit.framework.Test suite()
```
    T E S T S E T U P *
  - decorateTestSuite
```
private static junit.framework.Test decorateTestSuite(junit.framework.Test rsSuite)
```
  - requestKey
```
private static final int requestKey()
```
    Get a key that is used to identify an inserted row. Introduced to avoid having to delete table contents after each test, and because the order of the tests is not guaranteed.
    
    Returns:
    
    an integer in range [1, Integer.MAX_VALUE -1]
  - prep
```
private java.sql.PreparedStatement prep(java.lang.String colName)
                                 throws java.sql.SQLException
```
    Prepare commonly used statement to insert a row.
    
    Parameters:
    
    colName - name of the column to insert into
    
    Throws:
    
    java.sql.SQLException
  - fetchUpd
```
private java.sql.ResultSet fetchUpd(java.lang.String colName,
                                    int key)
                             throws java.sql.SQLException
```
    Fetch the specified row for update.
    
    Parameters:
    
    colName - name of the column to fetch
    
    key - identifier for row to fetch
    
    Returns:
    
    a ResultSet with zero or one row, depending on the key used
    
    Throws:
    
    java.sql.SQLException
  - fetch
```
private java.sql.ResultSet fetch(java.lang.String colName,
                                 int key)
                          throws java.sql.SQLException
```
    Fetch the specified row.
    
    Parameters:
    
    colName - name of the column to fetch
    
    key - identifier for row to fetch
    
    Returns:
    
    a ResultSet with zero or one row, depending on the key used
    
    Throws:
    
    java.sql.SQLException
  - holdabilityString
```
private static java.lang.String holdabilityString(int holdability)
```
    Convert holdability from an integer to a readable string.
    
    Parameters:
    
    holdability - an int value representing a holdability
    
    Returns:
    
    a String value representing the same holdability
  - threeResultSets
```
public static void threeResultSets(java.sql.ResultSet[] rs1,
                                   java.sql.ResultSet[] rs2,
                                   java.sql.ResultSet[] rs3)
                            throws java.sql.SQLException
```
    Method that is invoked by testIsClosed() (as a stored procedure) to retrieve three result sets.
    
    Parameters:
    
    rs1 - first result set
    
    rs2 - second result set
    
    rs3 - third result set
    
    Throws:
    
    java.sql.SQLException - if a database error occurs
  - getResultSetWithHoldability
```
public static void getResultSetWithHoldability(int holdability,
                                               java.sql.ResultSet[] rs)
                                        throws java.sql.SQLException
```
    Method invoked by testGetHoldability() (as a stored procedure) to retrieve a result set with a given holdability.
    
    Parameters:
    
    holdability - requested holdability
    
    rs - result set returned from stored procedure
    
    Throws:
    
    java.sql.SQLException - if a database error occurs
  - testDerby1368
```
public void testDerby1368()
                   throws java.sql.SQLException,
                          java.io.IOException
```
    EOFException when reading from blob's binary stream and calling length() twice Test with and without lengthless insert.
    
    Throws:
    
    java.sql.SQLException
    
    java.io.IOException
  - testDerby1368
```
public void testDerby1368(boolean lengthless)
                   throws java.sql.SQLException,
                          java.io.IOException
```
    EOFException when reading from blob's binary stream and calling length() twice
    
    Parameters:
    
    lengthless - Insert data with lengthless method.
    
    Throws:
    
    java.sql.SQLException
    
    java.io.IOException
  - testJDBC4_1
```
public void testJDBC4_1()
                 throws java.lang.Exception
```
    Test the JDBC 4.1 extensions.
    
    Throws:
    
    java.lang.Exception
  - vetDataTypeCount
```
private void vetDataTypeCount(java.sql.Connection conn)
                       throws java.lang.Exception
```
    Throws:
    
    java.lang.Exception
  - makeBlob
```
public static final java.sql.Blob makeBlob()
                                    throws java.lang.Exception
```
    Function for making a Blob.
    
    Throws:
    
    java.lang.Exception

Class ResultSetTest

Field Summary

Fields inherited from class org.apache.derbyTesting.functionTests.tests.jdbc4.Wrapper41Test

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

Constructor Summary

Method Summary

Methods inherited from class org.apache.derbyTesting.functionTests.tests.jdbc4.Wrapper41Test

Methods inherited from class org.apache.derbyTesting.junit.BaseJDBCTestCase

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

Methods inherited from class junit.framework.TestCase

Methods inherited from class java.lang.Object

Field Detail

BYTES1

BYTES2

str1

str2

insertKey

stmt

rs

key

Constructor Detail

ResultSetTest

Method Detail

setUp

tearDown

testGetNCharacterStreamIntNotImplemented

testGetNCharaterStreamStringNotImplemented

testGetNClobNotIntImplemented

testGetNClobStringNotImplemented

testGetNStringIntNotImplemented

testGetNStringStringNotImplemented

testGetSQLXMLIntNotImplemented

testGetSQLXMLStringNotImplemented

testUpdateNCharacterStreamIntNotImplemented

testUpdateNCharacterStreamIntLengthLessNotImplemented

testUpdateNCharacterStreamStringNotImplemented

testUpdateNCharacterStreamStringLengthlessNotImplemented

testUpdateNClobIntNotImplemented

testUpdateNClobIntLengthlessNotImplemented

testUpdateNClobStringNotImplemented

testUpdateNClobStringLengthlessNotImplemented

testUpdateNStringIntNotImplemented

testUpdateNStringStringNotImplemented

testUpdateSQLXMLIntNotImplemented

testUpdateSQLXMLStringNotImplemented

testUpdateBinaryStream

testUpdateAsciiStream

testUpdateCharacterStream

testUpdateBinaryStreamStringParameterName

testUpdateBinaryStreamLengthless

testUpdateBinaryStreamLengthlessBlob

testUpdateBinaryStreamLengthlessParameterName

testUpdateAsciiStreamStringParameterName

testUpdateAsciiStreamLengthless

testUpdateAsciiStreamLengthlessParameterName

testUpdateCharacterStreamStringParameterName

testUpdateCharacterStreamLengthless

testUpdateCharacterStreamLengthlessParameterName

testUpdateClob

testUpdateClobLengthless

testUpdateClobwithLengthofIS

testUpdateBlob

testUpdateBlobLengthless

testUpdateBlobWithLengthofIS

testUpdateBlobStringParameterNameWithLengthofIS

testUpdateClobStringParameterName

testUpdateClobLengthlessParameterName

testUpdateClobStringParameterNameWithLengthofIS

testUpdateBlobStringParameterName

testUpdateBlobWithStreamLengthlessParameterName

testGetHoldability

testIsClosed

testIsClosedOnNonHoldableResultSet

testExceptionWhenClosed

testWrapper

suite

decorateTestSuite

requestKey

prep

fetchUpd