Hello friends,

I am using jdbc connectivity to access database.


con = DriverManager.getConnection("jdbc:odbc:MyDB","system","manager");

stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE );

ResultSet rs=stmt.executeQuery("select * from Users where userid like 'xyz' ");


In Users table there is no user with userid='xyz' , but when I executes statement



boolean b=rs.first();



b returns true but it should return false and when I try to execute



String str=rs.getString(1);



It gives exception "Invalid cursor state"


Please help me and tell me why Resulset is showing that one row is present in Resultset and how to solve this problem