db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Fernanda Pizzorno (JIRA)" <derby-...@db.apache.org>
Subject [jira] Closed: (DERBY-517) ResultSet - relative(int rows) behaves different in embedded and client/server mode when the positioning before the first row or after the last row.
Date Thu, 24 Nov 2005 08:58:56 GMT
     [ http://issues.apache.org/jira/browse/DERBY-517?page=all ]
     
Fernanda Pizzorno closed DERBY-517:
-----------------------------------


> 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, testPositionLastPrev.java
>
> 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


Mime
View raw message