db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen (JIRA)" <derby-...@db.apache.org>
Subject [jira] Updated: (DERBY-276) ResultSet.relative(int row) cannot be called when the cursor is not positioned on a row.
Date Mon, 13 Jun 2005 11:54:47 GMT
     [ 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)
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 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:
For more information on JIRA, see:

View raw message