C H A P T E R  7


Result Sets Explored

You've already seen how result sets work in their simplest form in the earlier chapters. In this chapter, you'll explore many other capabilities of the ResultSet object, most of which were introduced in JDBC 2.0. In particular, this chapter covers the following topics:

  • Prefetching: The ability to set the number of rows to be retrieved with each trip to the database.
  • Scrollability: The ability to scroll backward and forward through the rows of a result set. A ResultSet object with this ability is called a scrollable result set.
  • Positioning: The ability of a scrollable result set to move to a particular row ...

Get Expert Oracle JDBC Programming now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.