why Invalide cursor state exception

[Arun Maalik]

import java.io.*;
import java.sql.*;
public class today{ 
public static void main(String\u005B\u005D args){
 try{ 
     String str="select * from User_Login where user_id=?"; 
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); 
     Connection con=DriverManager.getConnection
("jdbc :o dbc:MyDataSource","scott","tiger");
 PreparedStatement ps=con.prepareStatement(str); 
  ps.setString(1,"110010"); 
  ResultSet rs=ps.executeQuery();
  rs.next(); 
  String st=rs.getString("user_password"); 
  System.out.println(st);
   }
    catch(Exception e){
      System.out.println(e.toString());
      } 
    }
  } 

Dear sir i have just created a table in oracle under the scott user whose name is User_Login when i am retriving data by above coding it is throwing an exception that Invalide cursor state why sir? But i am sure that my code is right.
Same coding when i am using with predifined table like emp in scott user by the same code it is working fine.

with regard

Arun kumar maalik
[ August 20, 2006: Message edited by: Barry Gaunt ]

[Jeroen T Wenting]

this is not the correct place to ask JDBC questions.

but for a quick guess: are you sure there's a result being returned? If not, you can't read from the resultset because next() places it beyond the end of the results.

[Barry Gaunt]

Moving to JDBC... (from SCJD)
[ August 20, 2006: Message edited by: Barry Gaunt ]

[Arun Maalik]

Sorry sir but i am sure that table is returning rows in ResultSet because when i am using ResultSetMetadata and using function like
getColumnCount it is returning how many column are retriving.

[Jeanne Boyarsky]

Arun,
Not neccessarily. The getColumns is telling you about the form of the resultset. JDBC considers the resultset to have the same columns as the SQL query, even if nothing is returned.

Try running your query at the SQL command line to see if it returns anything.

Also, try something like the following to make the code more robust against this case. It'll be a lot easier to find out why things failed.

if ( rs.next()) {
  String st=rs.getString("user_password"); 
  System.out.println(st);
} else {
  System.out.println("user not found");
}