[ http://issues.apache.org/jira/browse/DERBY-1475?page=all ]
Fernanda Pizzorno updated DERBY-1475:
-------------------------------------
Attachment: derby-1475.diff
derby-1475.stat
I had not seen the new diff in DERBY-1320 after the applying the same fix as for setTransactionIsolation.
These problems seem to be related. Thank you Myrna for pointing it out.
The attached patch (derby-1475.diff) fixes the problem by closing the result sets before setting
them to null in org.apache.derbyTesting.functionTests.util.ProcedureTest.selectRows, when
the parameter p2 = 199. Closing the result sets before setting them to null, prevents later
tests (calling the Connection.setTransactionIsolation() method) to fail if these result sets
have not yet been garbage collected.
I have run lang/procedure.java more than 4000 consecutive times without failure with this
patch.
Can someone please review the patch?
> lang/procedure.java intermittently fails on SunOS-5.10_i86
> ----------------------------------------------------------
>
> Key: DERBY-1475
> URL: http://issues.apache.org/jira/browse/DERBY-1475
> Project: Derby
> Type: Bug
> Components: Test
> Environment: Java Version: 1.5.0_06
> OS name: SunOS
> OS version: 5.10
> Reporter: Fernanda Pizzorno
> Assignee: Fernanda Pizzorno
> Attachments: derby-1475.diff, derby-1475.stat
>
> Diff:
> *** Start: procedure jdk1.5.0_06 2006-07-04 13:39:05 ***
> 219 del
> < auto commit is true
> 220 del
> < lock count before execution 0
> [...]
> 1017 del
> < JIRA-492 successful -- no hang!
> 1018 del
> < testImplicitClose(): PASSED
> 1018 add
> > ERROR X0X03: Invalid transaction state - held cursor requires same isolation level
> > ERROR X0X03: Invalid transaction state - held cursor requires same isolation level
> Test Failed.
> *** End: procedure jdk1.5.0_06 2006-07-04 13:39:11 ***
--
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
|