Subject Re: [firebird-support] Re: [Firebird-Java] Re: JDBC Scrollable cursor
Author Rick Fincher
Hi David,

Not really. Many other databases don't do it either. That is something
that should be done on the server if it is done at all otherwise you are
tranferring a large chunk of data to the client for the client to process.
The whole point of the db is to have the server process the data and not
overload the network or the client with large gobs of unneeded data.

If you design your queries properly you should get atable of pretty much
what you want.

Can you tell us what you are trying to accomplish that you need scrolling
cursors for? Maybe we can suggest an alternative withing the abilities of
JayBird.

Rick

----- Original Message -----

>
> Hmmm...this seems like a very serious limitation to me.
>
> How do other databases handle it - is it all on the client, or on the
> server (hence the cross-post).
>
> Also, saw this in the release notes:
>
> 631090: Calling stored procedures - cannot be fixed with current
> Firebird implementation
>
> I saw the workarounds in the bug notes. Are there any situations where
the
> workaround will NOT work?
>
> Cheers,
>
> David