Get the tools you need to learn Java skills fast!
Video tutorials, eBooks, hands-on lab exercises, sample code.
Get started
The moose likes JDBC and Relational Databases and the fly likes Resultset Exception Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Badass: Making Users Awesome this week in the Game Development forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Resultset Exception" Watch "Resultset Exception" New topic

Resultset Exception

asit dhal

Joined: May 05, 2009
Posts: 13

Just go through the following code...

Can somebody tell me the reason the following exception in the above code ??

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 Main.main(
Martin Vajsar

Joined: Aug 22, 2010
Posts: 3675

You seem to be connecting to Oracle using ODBC driver. Stop doing that, use the Oracle's JDBC driver (the JdbcOdbcDriver's documentation itself says you should use target database's JDBC driver if available). I'd be only a bit surprised if this resolves your error.
I agree. Here's the link:
subject: Resultset Exception