[DERBY-213] ResultSet.next() after last row of FORWARD_ONLY cursor throws an SQL Exception with Network Server

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.1.1.0
• Fix Version/s: 10.2.1.6
• Component/s: Network Client
• Assignee: Philip Wilder
• Reporter: Katherine Marsden
• Created: 11/Apr/05 10:43
• Updated: 26/Jan/06 01:49
• Resolved: 30/Aug/05 21:28

Description

Network Server closes the result set if ResultSet.next() is
called after the last row of the result set. The test code
below throws the following exception.

SQLState: null
Severity: -99999
Message: Invalid operation: result set closed
com.ibm.db2.jcc.am.SqlException: Invalid operation: result set
closed
at
com.ibm.db2.jcc.am.ResultSet.checkForClosedResultSet(ResultSet.j
ava:3419)
at
com.ibm.db2.jcc.am.ResultSet.nextX(ResultSet.java:290)
at
com.ibm.db2.jcc.am.ResultSet.next(ResultSet.java:277)
at AfterLast.test(AfterLast.java:75)
at AfterLast.main(AfterLast.java:32)

stmt.executeUpdate("CREATE TABLE TAB ( I INT)");
stmt.executeUpdate("INSERT INTO TAB VALUES(1)");
stmt.executeUpdate("INSERT INTO TAB VALUES(2)");
String sql ="SELECT * from tab";
ps = conn.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
System.out.println(sql);
while (rs.next())
System.out.println(rs.getInt(1));
try

{ System.out.println("one more next"); rs.next(); }

catch (Exception e)

{ System.out.println("FAIL: next should return false not throw exception"); e.printStackTrace(); }

Issue Links

• relates to: DERBY-545 Should ResultSet Close implicitly?

Sub-Tasks

• Clean up DRDA classes handling of OPNQRY options: Closed