O'Reilly logo

Java™ Oracle® Database Development by David J. Gallardo

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required