db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Bernt M. Johnsen" <Bernt.John...@Sun.COM>
Subject Re: [jira] Updated: (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 Tue, 22 Nov 2005 16:24:00 GMT
Reviewed and found sound. I'll committ.

>>>>>>>>>>>> Fernanda Pizzorno (JIRA) wrote (2005-11-21
13:32:44):
>      [ http://issues.apache.org/jira/browse/DERBY-517?page=all ]
> 
> Fernanda Pizzorno updated DERBY-517:
> ------------------------------------
> 
>     Attachment: DERBY-517-2.diff
>                 DERBY-517-2.stat
> 
> I seems like I had forgotten a "svn add", sorry :).
> 
> > 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
> >  Attachments: DERBY-517-2.diff, DERBY-517-2.stat, DERBY-517.diff, DERBY-517.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
> 

-- 
Bernt Marius Johnsen, Database Technology Group, 
Sun Microsystems, Trondheim, Norway

Mime
View raw message