aspose file tools
The moose likes JDBC and the fly likes SQL exception errors Big Moose Saloon
  Search | Java FAQ | Recent Topics
Register / Login
JavaRanch » Java Forums » Databases » JDBC
Reply Bookmark "SQL exception errors" Watch "SQL exception errors" New topic
Author

SQL exception errors

Jade Davidson
Ranch Hand

Joined: Oct 12, 2001
Posts: 64
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
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
Thanks.
It turned out I had accidentally deleted the curly braces around the while statement getting the result set.
 
I agree. Here's the link: jrebel
 
subject: SQL exception errors
 
Similar Threads
jdbc error: Invalid Descriptor Index
I am lost... Help me please
Error in row
Kindly help me with this checkbox issue
SQLException: No data found