[ http://issues.apache.org/jira/browse/DERBY-517?page=all ]
Bernt M. Johnsen resolved DERBY-517:
------------------------------------
Fix Version: 10.2.0.0
Resolution: Fixed
> ResultSet - relative(int rows) behaves different in embedded and
> client/server mode when the positioning before the first row or after the
> last row.
> ----------------------------------------------------------------------------------------------------------------------------------------------------
>
> Key: DERBY-517
> URL: http://issues.apache.org/jira/browse/DERBY-517
> Project: Derby
> Type: Bug
> Components: Network Client
> Reporter: Fernanda Pizzorno
> Assignee: Fernanda Pizzorno
> Fix For: 10.2.0.0
> Attachments: DERBY-517-2.diff, DERBY-517-2.stat
>
> RecordSet - relative(int rows) behaves different in embedded and
> client/server mode when the positioning before the first row or after the
> last row.
> The embedded driver shows the behaviour described in the JDBC 3.0
> specification, returning false and postitioning in either before first or
> after last. While the client/server driver returns true and
> incrementing/decrementing the current row by "rows" and not setting the
> position to either before first of after last.
> I have run a test with a result set with 10 rows, where I positioned in row 5
> and moved +20 and - 20 using relative(int rows). With the embedded driver the
> method returned false, the current row was set to 0 and isAfterLast() and
> isBeforeFirst() returned true (for +20 and -20 respectively). With the
> client/server driver the method returned true, the current row was set to 25
> and -15 (for +20 and -20 respectively) and isAfterLast() and isBeforeFirst()
> returned false.
> I have also run a test as the first one but running next() 5 times instead of
> absolute(5) for postitioning in row 5, and then relative(20) produced the
> expected results with the client/server driver.
--
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
