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] Created: (DERBY-517) RecordSet - 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, 18 Aug 2005 14:41:54 GMT
RecordSet - 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
 Assigned to: Fernanda Pizzorno 


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