Invalid cursor state?

[Elahe Shafie]

Hi freinds,
I'm getting this error "Invalid cursor state" and I don't know the meaning of that and how can I solve it?
Thanks,
Elahe

[Jamie Robertson]

post the code. From what I can recall, it happens when you try to read a record from a resultset before you move the cursor to the first record
eg. This is wrong:

ResultSet rs = statement.executeQuery("SELECT ......");
//invalid call because the cursor is before the first row
rs.getString(1);

The correct code:

ResultSet rs = statement.executeQuery("SELECT ......");
//correct call (rs.next() is called before the read)
if (rs.next())
{
rs.getString(1);
}

Jamie

[Roy Ben Ami]

please post the code that deals with the cursor maybe..

[Elahe Shafie]

Here are part of my codes...
stmt = con.createStatement();

//Execute an SQL query, get a resultSet
rs=stmt.executeQuery("select userId, Password from security where userId ='"+userId+"' and password ='"+password+"'");
rs.next();
userId = rs.getString("userId");
stmt.close();

[Roy Ben Ami]

check if there is somthn in the resultSet.
try the if(rs.next()) like Jamie suggested above.