Bugzilla – Full Text Bug Listing
| Summary: | Result set closed after first record read. | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | z_Archived | Reporter: | Paul Hoffman <hoffmanp> | ||||||
| Component: | EDT | Assignee: | Project Inbox <edt.javagen-inbox> | ||||||
| Status: | CLOSED WORKSFORME | QA Contact: | |||||||
| Severity: | normal | ||||||||
| Priority: | P3 | CC: | jvincens | ||||||
| Version: | unspecified | ||||||||
| Target Milestone: | --- | ||||||||
| Hardware: | PC | ||||||||
| OS: | Windows XP | ||||||||
| Whiteboard: | |||||||||
| Attachments: |
|
||||||||
Created attachment 204638 [details]
Supporting library for loading db / table
I believe this was fixed with other changes I made, so it works now. I had to change the code to from for ( i from 1 to 10 ) get row from rs ; log ( "Row read: " + row.id ) ; end for ( i from 1 to 10 ) if(rs.setNext()) get row from rs ; log ( "Row read: " + row.id ) ; end end When using a resultSet you need to set its position before attempting to do a get. Issue resolved by other fixes |
Created attachment 204637 [details] Test case See attached test case. Output from test case: connect to jdbc:derby:C:\EDT\derby\SAMPLE;create=true create schema create table Add row 1 Add row 2 Add row 3 Add row 4 Add row 5 Add row 6 Add row 7 Add row 8 Add row 9 Add row 10 Check row 1 Check row 10 Start test for defect: result set closed after first record read Open runs without exception Try reading rows result set Row read: 1 Failure: Exception = ResultSet not open. Operation 'next' not permitted. Verify that autocommit is OFF.: [sqlstate:XCL16][sqlcode:20,000]