Win a copy of Design for the Mind this week in the Design forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

How to get the number of rows in a ResultSet

 
Rudy Sam
Greenhorn
Posts: 4
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,
I'm an intern and I'm trying to get the number of rows from result set in oracle using rs.last() and rs.beforeFirst() methods but I got an error. Could Below is my sample code:


When I run the code I do have the following ERROR Message:



Please could any body Help me out here to figure out how to correct this
OR a possible suggestion?
Any Help would be highly apprecited.
 
Abhinav Srivastava
Ranch Hand
Posts: 354
Eclipse IDE Java Oracle
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
stmt = con.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_READ_ONLY)
[ May 25, 2005: Message edited by: Jack Ryan ]
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic