jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases 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 OCA Java SE 8 Programmer I Study Guide this week in the OCAJP 8 forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "Resultset not Open?" Watch "Resultset not Open?" New topic

Resultset not Open?

Qaiser Mehmood

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

Joined: Dec 20, 2006
Posts: 2551

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

OCUP UML fundamental and ITIL foundation
Qaiser Mehmood

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

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
I agree. Here's the link: http://aspose.com/file-tools
subject: Resultset not Open?
It's not a secret anymore!