[ http://issues.apache.org/jira/browse/DERBY-1070?page=all ]

Andreas Korneliussen updated DERBY-1070:
----------------------------------------

    Attachment: DERBY-1070.diff
                DERBY-1070.stat

Adding a new junit test called jdbcapi/HoldabilityTest.junit. There are 7 
testcases, all for scrollable resultsets.

The testcases creates different states in the scan controllers  (init, in 
progress, or ended), and verifies that after a commit, the scan can continue, 
and the resultset is scrollable. For updatable resultset, it also verifies 
updatability.

One of the testcases is also written to provoke an error situation in holdable 
scrollable updatable resultsets. It provokes a truncate of pages which the 
resultset have read rows from, and a situation which will cause the SUR to 
update another row if not DERBY-1067 gets implemented correctly.  The tests are 
adaptive to updatability, meaning that if SUR is not implemented for the 
framework being tested, updatability will not be tested. This can later be 
changed when updatability of scrollable resultset is fully supported in Derby.

One of the testcases fails, due to DERBY-1058.

Expected result when running in embedded:

java org.apache.derbyTesting.functionTests.harness.RunTest 
jdbcapi/HoldabilityTest.junit 

*** Start: HoldabilityTest jdk1.4.2_02 2006-03-01 14:42:35 ***
0 add
> ..E.....
> There was 1 error:
> 1) 
> testHeldScrollableResultSetScanInProgress(org.apache.derbyTesting.functionTests.tests.jdbcapi.HoldabilityTest)ERROR
>  XSCB8: The btree conglomerate 1,141,220,557,702 is closed.
> FAILURES!!!
> Tests run: 7,  Failures: 0,  Errors: 1
Test Failed.
*** End:   HoldabilityTest jdk1.4.2_02 2006-03-01 14:42:51 ***

No errors expected if DERBY-1058 gets fixed.


> add tests for holdable SUR
> --------------------------
>
>          Key: DERBY-1070
>          URL: http://issues.apache.org/jira/browse/DERBY-1070
>      Project: Derby
>         Type: Sub-task
>     Reporter: Andreas Korneliussen
>     Assignee: Andreas Korneliussen
>  Attachments: DERBY-1070.diff, DERBY-1070.stat
>


-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira

Reply via email to