[DERBY-3332] ResultSetTest.testGetHoldability has been throwing assert failure since Jan 8th '08

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Duplicate
• Affects Version/s: 10.4.1.3
• Component/s: Test
• Bug behavior facts: Regression Test Failure
• Assignee: Unassigned
• Reporter: Mamta A. Satoor
• Created: 18/Jan/08 06:31
• Updated: 21/Jan/11 17:51
• Resolved: 18/Jan/08 06:52

Description

I am not sure if anyone is looking at the test failures in ResultSetTest.testGetHoldability. This failure started appearing on Tinderbox since Jan 8th '08. The changes committed during that time frame were as follows
Changes from 610199/610199 to 610255:
------------------------------------------------------------------------
r610238 | djd | 2008-01-09 01:07:34 +0100 (Wed, 09 Jan 2008) | 1 line

DERBY-3305 Ensure that a processing a ResultSet into a dynamic result marks the application statment result set as the correct one, based upon the statement the result set is transferred to. Add asserts to jdbcapi.ProcedureTest to check that ResultSet.getStatement returns the correct Statement object.
------------------------------------------------------------------------
r610244 | djd | 2008-01-09 01:41:43 +0100 (Wed, 09 Jan 2008) | 1 line

Cleanup CollationTest2 to use utility methods to make it clear it is a simple single connection test (for each fixture). Includes adding a utility method to BaseJDBCTestCase to read a database property.
------------------------------------------------------------------------

U java/engine/org/apache/derby/impl/jdbc/EmbedResultSet.java
U java/testing/org/apache/derbyTesting/functionTests/tests/lang/CollationTest2.java
U java/testing/org/apache/derbyTesting/functionTests/tests/jdbcapi/ProcedureTest.java
U java/testing/org/apache/derbyTesting/junit/BaseJDBCTestCase.java
Updated to revision 610255.
610255 URL: https://svn.apache.org/repos/asf/db/derby/code/trunk

Tinderbox results for Jan 8th can be found at http://dbtg.thresher.com/derby/test/tinderbox_trunk16/jvm1.6/testing/Limited/testSummary-610255.html

The stack trace for the test failure is as follows
testGetHoldability(org.apache.derbyTesting.functionTests.tests.jdbc4.ResultSetTest)junit.framework.AssertionFailedError: holdability of ResultSet from stored proc: HOLD_CURSORS_OVER_COMMIT expected:<2> but was:<1>
at org.apache.derbyTesting.functionTests.tests.jdbc4.ResultSetTest.testGetHoldability(ResultSetTest.java:1526)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at org.apache.derbyTesting.junit.BaseTestCase.runBare(BaseTestCase.java:96)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:24)
at junit.extensions.TestSetup$1.protect(TestSetup.java:21)
at junit.extensions.TestSetup.run(TestSetup.java:25)
at org.apache.derbyTesting.junit.BaseTestSetup.run(BaseTestSetup.java:57)

Issue Links

• duplicates: DERBY-3311 Client ResultSet.getHoldabilty will return incorrect value when the ResultSet is obtained from a procedure call