CODEWITHSUNDEEP
javajdbcconnectionresultsetsqlexception
Imaxo
Imaxo

Reputation: 11

Why am I getting ResultSet is closed error when I never closed any

I have this error in my code and have checked and edited it thoroughly, yet I still get same issue. I also use multiple resultSet and Statements yet same error occurs. Below is the error I get:

    "Database Connected with Current Date 20130221
    java.sql.SQLException: ResultSet is closed
    at sun.jdbc.odbc.JdbcOdbcResultSet.checkOpen(Unknown Source)
    at sun.jdbc.odbc.JdbcOdbcResultSet.next(Unknown Source)
    at UNSUB.main(UNSUB.java:78)"
Press any key to continue . . .

Please What could be the reason? I have no idea on any solution now.

Upvotes: 0

Views: 10446

Answers (2)

Rahul
Rahul

Reputation: 45090

The exception, java.sql.SQLException: ResultSet is closed means that your code has either already closed the result set object you're using, or more likely, that your code has either re-executed or closed the statement that produced the result set. By JDBC specs, either of those actions will close any result set from the statement.

Upvotes: 5

Aashray
Aashray

Reputation: 2763

Have you called the method next() on the ResultSet?? If you haven't that might be the reason for you to get that error.

Upvotes: -2

Related Questions