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.

Best regards,
Roman Rokytskyy