Subject Re: [Firebird-Java] Re: JDBC
Author Robert Rylly
Does anyone have the code to navigate through record sets is JDBC does not
allow cursor positioning?

How do you move previous, next, first, last, etc...l?

Thanks in advance.

>From: "Roman Rokytskyy" <rrokytskyy@...>
>Subject: [Firebird-Java] Re: JDBC
>Date: Sun, 27 Jul 2003 18:34:17 -0000
> > Can anyone tell me if JDBC for Firebird will allow cursor positioning
> > yet?
>No, because server does not support this.
> > If not, how do you navigate the data?
>You don't. SQL is about manipulating a data sets. If we take the idea
>to the extreem, ORDER BY should be disabled, because it breaks the
>concept. :) SQL client executes a query and fetches the set of data
>back to the client. There you can do with data everything you like:
>scroll, sort, etc.
>This is not convenient for some applications and scrollable cursors
>would be of great help. Unfortunatelly server does not provide this
>functionality. Delphi users have libraries that emulate such
>functionality on the client side, but nobody implemented this for JDBC
>Best regards,
>Roman Rokytskyy

MSN 8 helps eliminate e-mail viruses. Get 2 months FREE*.