[ http://issues.apache.org/jira/browse/DERBY-276?page=all ]
Bernt M. Johnsen updated DERBY-276:
-----------------------------------
Attachment: DERBY-276.diff
New patch with minor issue fixed (relative(0) on empty resultsets)
Stat:
M java/tools/org/apache/derby/impl/tools/ij/utilMain.java
M
java/engine/org/apache/derby/impl/sql/execute/ScrollInsensitiveResultSet.java
M
java/testing/org/apache/derbyTesting/functionTests/tests/lang/scrollCursors2.java
M
java/testing/org/apache/derbyTesting/functionTests/tests/lang/scrollCursors1.sql
M
java/testing/org/apache/derbyTesting/functionTests/master/DerbyNet/scrollCursors1.out
M
java/testing/org/apache/derbyTesting/functionTests/master/DerbyNetClient/scrollCursors1.out
M
java/testing/org/apache/derbyTesting/functionTests/master/scrollCursors1.out
M java/client/org/apache/derby/client/am/ResultSet.java
> 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
> Attachments: DERBY-276.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
