Two Laptop Bag*
The moose likes JDBC and the fly likes Resultset not Open? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Resultset not Open?" Watch "Resultset not Open?" New topic
Author

Resultset not Open?

Qaiser Mehmood
Greenhorn

Joined: Jan 10, 2011
Posts: 9
I get following error on Result set
java.sql.SQLException: ResultSet not open. Verify that autocommit is OFF.
at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
at org.apache.derby.client.am.ResultSet.next(Unknown Source)

Jan Cumps
Bartender

Joined: Dec 20, 2006
Posts: 2497
    
    8

You close the connection in your finally block. This will also close the ResultSet 'res' that you return.


OCUP UML fundamental and ITIL foundation
youtube channel
Qaiser Mehmood
Greenhorn

Joined: Jan 10, 2011
Posts: 9
Reultset res is outside finaly block.
Paul Sturrock
Bartender

Joined: Apr 14, 2004
Posts: 10336

Qaiser Mehmood wrote:Reultset res is outside finaly block.


Not sure what you mean by that, but Jan is right. Your method returns a ResultSet that is closed, because you closed it in your finally block (by closing the connection).


JavaRanch FAQ HowToAskQuestionsOnJavaRanch
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Resultset not Open?