Scrollable, Sensitive, Updateable ResultSets
In the past, it was possible to retrieve records from a result set only in order, one by one, primarily because databases like Oracle retrieved data piece-wise into a buffer of fixed size, and this limitation allowed for a more efficient implementation.
This limitation is reflected in the implementation of the JDBC 1.0 ResultSet class, which had a single method for navigating through a ResultSet, next(). But, like other limitations, this has been overcome, and new releases of Oracle and JDBC feature scrollable ResultSets. Scrollability lets you traverse a result set forward and backward. This is furthermore associated with random access of a result set—the ability to access a row by absolute or relative ...
Get Java™ Oracle® Database Development now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
