I'm using the result set to extract data from the database..
now when I execute the query and take the result from one of the column of the table
String a=rs.getString("f_access");
and now without altering the resultset I again access the rest of the columns
System.out.println(rs.getString("trans_no"));
System.out.println(rs.getString("stud_id"));
System.out.println(rs.getString("f_name"));
System.out.println(rs.getString("f_size"));
System.out.println(rs.getString("trans_date"));
System.out.println(rs.getString("f_access"));
including the column "f_access" again...
but it gives me the following error
java.sql.SQLException: [Oracle][ODBC]Invalid column number <1>.