«

[guptapr]

I am getting an exception (java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid cursor state)
while running this program given below. Please help.


import java.sql.*;
import java.io.*;

class Dbconnect1
{
public static void main(String[] args)
{
String str[]={"Yahoo","Yah"};
int count=0;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con=DriverManager.getConnection("jdbcdbc:db");

String query="Select distinct id from employee";
Statement st=con.createStatement(ResultSet.TYPE_SCROLL_SENSI TIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs = st.executeQuery(query);

rs.beforeFirst();
while(rs.next())
{
System.out.println(rs.getInt(1));
}
st.close();
con.close();
}
catch(Exception e)
{
e.printStackTrace();
}
}
}
i am getting the exception at line:

System.out.println(rs.getInt(1));

output is
1
2
3
4
5
6
7
8
9
10
11
java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid cursor state
at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source)
at sun.jdbc.odbc.JdbcOdbc.SQLGetDataInteger(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.getDataInteger(Unk nown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.getInt(Unknown Source)
at Dbconnect1.main(Dbconnect1.java:29)