[ http://issues.apache.org/jira/browse/DERBY-276?page=all ]
Daniel John Debrunner updated DERBY-276: ---------------------------------------- Fix Version: 10.2.0.0 Description: If the cursor is not positioned on a row, calling ResultSet.relative() causes the following exception: Exception in thread "main" ERROR X0X87: ResultSet.relative(int row) cannot be called when the cursor is not positioned on a row. at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:301) at org.apache.derby.impl.sql.execute.ScrollInsensitiveResultSet.getRelativeRow(ScrollInsensitiveResultSet.java:336) at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(EmbedResultSet.java:366) at org.apache.derby.impl.jdbc.EmbedResultSet.relative(EmbedResultSet.java:1840) However, The 1.4.2 Javadoc says: Note: Calling the method relative(1) is identical to calling the method next() and calling the method relative(-1) is identical to calling the method previous(). (This is confirmed by the JDBC 3.0 spec, ch. 14.2.2) Since next() is valid, so should rs.relative(1) (and all other arguments, since a too large value will position the cursor after the last row, and a too low value will position it before the first). was: If the cursor is not positioned on a row, calling ResultSet.relative() causes the following exception: Exception in thread "main" ERROR X0X87: ResultSet.relative(int row) cannot be called when the cursor is not positioned on a row. at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:301) at org.apache.derby.impl.sql.execute.ScrollInsensitiveResultSet.getRelativeRow(ScrollInsensitiveResultSet.java:336) at org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(EmbedResultSet.java:366) at org.apache.derby.impl.jdbc.EmbedResultSet.relative(EmbedResultSet.java:1840) However, The 1.4.2 Javadoc says: Note: Calling the method relative(1) is identical to calling the method next() and calling the method relative(-1) is identical to calling the method previous(). (This is confirmed by the JDBC 3.0 spec, ch. 14.2.2) Since next() is valid, so should rs.relative(1) (and all other arguments, since a too large value will position the cursor after the last row, and a too low value will position it before the first). Environment: Patch committed revision 208683. > ResultSet.relative(int row) cannot be called when the cursor is not > positioned on a row. > ---------------------------------------------------------------------------------------- > > Key: DERBY-276 > URL: http://issues.apache.org/jira/browse/DERBY-276 > Project: Derby > Type: Improvement > Components: JDBC > Reporter: Bernt M. Johnsen > Assignee: Bernt M. Johnsen > Priority: Minor > Fix For: 10.2.0.0 > Attachments: DERBY-276-V2.diff > > If the cursor is not positioned on a row, calling ResultSet.relative() causes > the following exception: > Exception in thread "main" ERROR X0X87: ResultSet.relative(int row) cannot be > called when the cursor is not positioned on a row. > at > org.apache.derby.iapi.error.StandardException.newException(StandardException.java:301) > at > org.apache.derby.impl.sql.execute.ScrollInsensitiveResultSet.getRelativeRow(ScrollInsensitiveResultSet.java:336) > at > org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(EmbedResultSet.java:366) > at > org.apache.derby.impl.jdbc.EmbedResultSet.relative(EmbedResultSet.java:1840) > However, The 1.4.2 Javadoc says: > Note: Calling the method relative(1) is identical to calling the method > next() and calling the method relative(-1) is identical to calling the method > previous(). (This is confirmed by the JDBC 3.0 spec, ch. 14.2.2) > Since next() is valid, so should rs.relative(1) (and all other arguments, > since a too large value will position the > cursor after the last row, and a too low value will position it before the > first). -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira