Subject | Re: JDBC |
---|---|
Author | Roman Rokytskyy |
Post date | 2003-07-27T18:34:17Z |
Hi,
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
yet.
Best regards,
Roman Rokytskyy
> Can anyone tell me if JDBC for Firebird will allow cursor positioningNo, because server does not support this.
> yet?
> 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
yet.
Best regards,
Roman Rokytskyy