help with JDBC cursor/Result Set

From: ANDREW NUSS <andrew.nuss_at_Eng.sun.com>
Date: Thu, 17 Jun 1999 22:09:20 -0700
Message-ID: <3769D480.F376AB54@Eng.sun.com>

Hi,

Can anyone answer?

With Oracle's native JDBC driver, does the JDBC ResultSet function as a true cursor. I.E. if a query produces 100,000 row matches, when is it possible to get the first row from the JDBC ResultSet? As the database server is returning rows, does the server start feeding the rows to the client as requested? Does the server have to compile all the result data before giving any back to the client? Is this complicated by joins? What about "order by" and "distinct"?

Typically my querys are quite complex grammars that will return sparse hits, but one is never sure.

My approach is to just ask for the primary keys of records that match the complex query. Get all of them. Hope its quick, and then begin assembling the records as they are really needed by the client.

Looking for some pointers.

Thanks,
Andy Received on Fri Jun 18 1999 - 00:09:20 CDT