ads/auto.txt

Result Set Has No Current Row

Result Set Has No Current Row. If thats the case rsnext will return false but you are not checking the return value any more. The following code illustrates inserting a row into a ResultSet that consists of all rows in the sample DEPARTMENT table.

Print Your Own Yardzee Rules Instant Download Backyard Games Reception Games Yardzee Yahtzee Rules Dice Game Rules
Print Your Own Yardzee Rules Instant Download Backyard Games Reception Games Yardzee Yahtzee Rules Dice Game Rules from www.pinterest.com

As you move from row to row the window remains unchanged as long as the current row stays within that window. Does the behavior change if you call consetAutoCommitfalse at the start of your program. And the execution of the inner query is causing a commit which is closing the outer querys result set as well.

The most likely explanation is that your ResultSet contains no rows.

Rsnext -----ResultSet has not current row does not mean that the resultset has not returned any records. If the current row has no original value an empty result set must be returned. The following code illustrates inserting a row into a ResultSet that consists of all rows in the sample DEPARTMENT table. May be you should check the number of records in result.