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_SENSITIVE,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(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.getInt(Unknown Source)
at Dbconnect1.main(Dbconnect1.java:29)
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_SENSITIVE,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(Unknown Source)
at sun.jdbc.odbc.JdbcOdbcResultSet.getInt(Unknown Source)
at Dbconnect1.main(Dbconnect1.java:29)
Last edited: