Roman Rokytskyy wrote:

> Hi,
>
>
>>I haven't even started really using Java itself yet, lol. I am
>>learning now, but I want to make sure that I can use my favorite
>>database with Java. If I was reading the faq incorrectly, please
>>let know, but not being able to do things like While...Loop through
>>a dataset seems like a big disadvantage.
>
>
> In Java scrollable result set means bi-directional result set, where
> at least next() and previous() methods are implemented, but it can
> also have implementation for first(), last(), etc. Also it requires
> positioned updates where possible. JayBird does not support
> previous(), first(), last() and other methods, since they are not
> supported by server (so called SCROLLABLE_CURSORS issue). However,
> next() is implemented and you can loop through the result set without
> any problems:
>
> Statement stmt = connection.createStatement();
> ResultSet rs = stmt.executeQuery("SELECT * FROM my_table");
> while(rs.next()) {
> ... //your code
> }
>
>
>>So again, I have nothing specific that I am trying to do other than
>>determine what kind of backend I will be able to use in most of my
>>applications, specifically one that I want to port to Java from
>>Delphi.
>
>
> If compared to Delphi components, JayBird will not cache parts of the
> result set locally and refetch parts of result set in order to
> implement bi-directional cursors.

Thanks again, Roman. I am reading up on JDBC now to get more familiar
with the concepts. But bascially, JBird allows "Firehose"
(Unidirectional) type recordsets, correct? So that would mean no
functionality similar to Locate() either? Its not that big a problem
since I could just execute a WHERE for the exact record I want, but
would require another trip to DB.

I hate to ask such basic questions, but I am just learning java and my
knowledge of it is in its infancy. I appreciate your patience.

--

Warm Regards,

Lee