Bugzilla – Full Text Bug Listing
| Summary: | SQL - replace to result set fails | ||||||||
|---|---|---|---|---|---|---|---|---|---|
| Product: | z_Archived | Reporter: | Paul Hoffman <hoffmanp> | ||||||
| Component: | EDT | Assignee: | Project Inbox <edt.javagen-inbox> | ||||||
| Status: | CLOSED FIXED | QA Contact: | |||||||
| Severity: | normal | ||||||||
| Priority: | P3 | CC: | jvincens | ||||||
| Version: | unspecified | ||||||||
| Target Milestone: | --- | ||||||||
| Hardware: | PC | ||||||||
| OS: | Windows XP | ||||||||
| Whiteboard: | |||||||||
| Attachments: |
|
||||||||
Created attachment 206408 [details]
library for loading database for test program
fixed This is still failing for me. The failure is occurring on the rs.update() invocation, exception info = Invalid cursor state - no current row.: [sqlstate:24000][sqlcode:20,000] Cursor was in position from previous rs.setNext() followed by get row. Error log for test case is: Start test for defect: replace simple record to result set fails Open result set Read a row from result set Replace row values in result set row Update row Failure: Exception = Invalid cursor state - no current row.: [sqlstate:24000][sqlcode:20,000] Start test for defect: replace annotated record to result set fails Open result set Read a row from result set Replace row values in result set row Update row Failure: Exception = Invalid cursor state - no current row.: [sqlstate:24000][sqlcode:20,000] There are 2 errors in the testcase.
The testcase does:
replace row to rs ;
log ("Update row") ;
rs.updateRow ( ) ;
The replace actually does a rs.updateRow, so the EGL rs.updateRow will throw an exception because the cursor is not positioned.
The code closes the rs then tries to use it in a get, but didn't reopen it.
close rs ;
log ("Check row updated" ) ;
set row empty ;
get row from rs using id ;
verified and closed |
Created attachment 206407 [details] Test case SQL - replace to result set fails Download test case and load library initialization. Test case results: Start test for defect: replace simple record to result set fails Open result set Read a row from result set Replace row values in result set row Update row Failure: Exception = Invalid cursor state - no current row.: [sqlstate:24000][sqlcode:20,000] Start test for defect: replace annotated record to result set fails Open result set Read a row from result set Replace row values in result set row Failure: Exception = A null value was used.