Community
Participate
Working Groups
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.
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
