File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes Retrieving data from cachedRowSet Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Retrieving data from cachedRowSet" Watch "Retrieving data from cachedRowSet" New topic

Retrieving data from cachedRowSet

renu richard
Ranch Hand

Joined: Oct 06, 2008
Posts: 116
I am using somehting like this,
loRS.getString("employee_no") to fetch the value from the Resultset object. Employee_no is the column name in the table.
I am trying to find the maximum value in a column by using the query
select max(marks) from employee.Now i tried using the int max_marks=loRS.getInt(1);
But i am getting java.sql.SQLException: Invalid cursor position exception.
Please tell me how can i retrieve the value. Thanks.

What i want to know is how can i get the value from the resulset object if i don't have the column name. As in this case, in which it is returniing the maximum value of a particular column.
[ November 27, 2008: Message edited by: renu richard ]

Jesper de Jong
Java Cowboy
Saloon Keeper

Joined: Aug 16, 2005
Posts: 15081

You have to call "next()" on the result set before you can get data from it. For example:

Java Beginners FAQ - JavaRanch SCJP FAQ - The Java Tutorial - Java SE 8 API documentation
Maneesh Godbole
Saloon Keeper

Joined: Jul 26, 2007
Posts: 10817

More related to DB than beginner.

[How to ask questions] [Donate a pint, save a life!] [Onff-turn it on!]
I agree. Here's the link:
subject: Retrieving data from cachedRowSet
It's not a secret anymore!