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