What do these errors mean? java.sql.SQLException: [Microsoft][ODBC Driver Manager] Invalid cursor state at sun.jdbc.odbc.JdbcOdbc.createSQLException(JdbcOdbc.java:6031) at sun.jdbc.odbc.JdbcOdbc.standardError(JdbcOdbc.java:6188) at sun.jdbc.odbc.JdbcOdbc.SQLGetDataString(JdbcOdbc.java:3266) at sun.jdbc.odbc.JdbcOdbcResultSet.getDataString(JdbcOdbcResultSet.java: 5398) at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:326) at sun.jdbc.odbc.JdbcOdbcResultSet.getString(JdbcOdbcResultSet.java:383) at DatabaseFrame.<init>(DatabaseFrame.java:67) at DatabaseFrame.main(DatabaseFrame.java:131)
Dave Vick
Ranch Hand
Joined: May 10, 2001
Posts: 3244
posted
0
Jade The last time I got an InvalidCursor state error it was because I had tried to get a value from a resultSet and hadn't called next() on it to get to the first record. It could be that or your at th end of the result set and trying to access a value. hope that helps
Dave
Jade Davidson
Ranch Hand
Joined: Oct 12, 2001
Posts: 64
posted
0
Thanks. It turned out I had accidentally deleted the curly braces around the while statement getting the result set.