Invalid cursor state

[Ankitt Gupta]

  import java.sql.*;

class MyConnection
{
	Connection con;
	Statement stmt;
	ResultSet rs;

MyConnection()
{
	try{
		Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		con=DriverManager.getConnection("jdbc:odbc:test");
		if(con!=null)
		System.out.println("Connection Established");
	    }catch(Exception e){System.out.print("Hurray Exception Handled");}
}
public void display() throws Exception
{
	stmt=con.createStatement();
	rs=stmt.executeQuery("select * from Student");
	while(rs.next());
	{
		String s1=rs.getString(1);
		String s2=rs.getString(2);
		String s3=rs.getString(3);
		System.out.println("The values are:" +s1 +"," +s2+ "," +s3 );
	}
	con.close();
}

public static void main(String a[]) throws Exception
{
	MyConnection m=new MyConnection();
	m.display();
}

It is givng the output as

Connection Estabilished Exception in thread main java.sql.SQLException: [ODBC DriverManager] Invalid cursor state......

[Ankitt Gupta]

The database is in Ms Access


Name Address Roll
Ankit Kolkata 1
Gupta Delhi 2
Sachin Mumbai 3

[Aurelian Tutuianu]

Third field is numeric? Maybe that's why. Sometimes the messages from jdbc drivers are not a hell of a help.

[Ankitt Gupta]

i changed it to text but no avail.Please help

[Ankitt Gupta]

i got it fixed....by mistake i put semi colon in while loop...ah so silly