Exhausted Resultset

[Amit kumar]

Where i am going wrong???

public static void main(String[] args) throws ClassNotFoundException, SQLException {
// TODO Auto-generated method stub
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con = DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:XE", "system", "123");

Statement stat = con.createStatement();

ResultSet rs;

rs = stat.executeQuery("select * from Student");
while(rs.next())
{
System.out.println("Student ID:: " + rs.getString("stdId"));
System.out.println("Student::--:: "+"First Name:: "+ rs.getString("firstName")+" Last Name :: "+ rs.getString("lastName") );

}
rs.close();
 
rs2= stat.executeQuery("select * from Student where firstname='Amit'");
while(rs2.next())
{
System.out.println(rs2.getString("FirstName")+" " + rs2.getString("LastName")+" "+ "his id is "+ rs.getString("stdId"));
}

this exception i am getting

Exception in thread "main" java.sql.SQLException: Exhausted Resultset
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:190)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:286)
at oracle.jdbc.driver.OracleResultSetImpl.getString(OracleResultSetImpl.java:536)
at oracle.jdbc.driver.OracleResultSet.getString(OracleResultSet.java:1515)
at com.jdbc.JdbcExample1.main(JdbcExample1.java:45)

[David O'Meara]

while(rs2.next())
{
System.out.println(rs2.getString("FirstName")+" " + rs2.getString("LastName")+" "+ "his id is "+ rs.getString("stdId"));
}

copy and paste error: check the variable for the result set used in each getString call above.

Dave