• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 157
  • Last Modified:

How to find out a total # of rows in a ResultSet object??

Hi Guys,

   It seems ResultSet object does not have any member function to find out total number of rows??

stephen
0
zollen
Asked:
zollen
1 Solution
 
girionisCommented:
 No there is not but you can always move to the last row in the ResultSet by using the last() method and get the count by calling the getRow() method straight after you move to the last row. This will give you the total number of rows. You have to define your ResultSet to be scrollable though (if you want to go back) by using the static TYPE_SCROLL_SENSITIVE.

  Hope it helps.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now