ResultSet--Can not able to get the value of the column

[abhi thewall]

Hi All,

I am working on a swing project.I have created the statement and executed query.
Got the result set object.Now fron result set object I am trying to get the value of the column amount using rs.getInt("Amount");
Its showing Invalid cursor state.

I can get the meta data from the resultset object and from where if i am trying to find the column number or column name its giving correctly.

But not able to call any other method on resultset object except rs.next,rs.first etc.

Here is the code:--

   

      stmt = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE, ResultSet.CONCUR_UPDATABLE);[quote]  here I have done this b\c rs.next was not working before  [/quote]
      rs=stmt.executeQuery(createString);
      System.out.println("\n balance Got the ResultSet:-"+rs);
      while(rs.next()){
         System.out.println("\n get inside loop:-");
         ResultSetMetaData rsmd = rs.getMetaData();
         int NumOfCol=rsmd.getColumnCount();
         System.out.println("\n NumOfCol is :-"+NumOfCol);
         String columnname=rsmd.getColumnName(2);
         System.out.println("\n columnname is :-"+columnname);
      [quote]    Till this point every thing is ok but after this whenever I try to call any method like rs.getmethodname its giving invalid cursor error [/quote]
         int balance = rs.getInt("Amount");
         System.out.println("\n balance in rs.next:- "+balance);
      }
	  stmt.close();
	  con.close();