File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes SQLException problem? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Java Interview Guide this week in the Jobs Discussion forum!
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "SQLException problem?" Watch "SQLException problem?" New topic

SQLException problem?

Sam Doder
Ranch Hand

Joined: Feb 06, 2008
Posts: 204
I am getting this exception from the lines below

java.sql.SQLException: Operation not allowed after ResultSet closed

Basically I have to get data out of many different tables so I have to execute about 6 different sql statments. What I want to know is how I can execute these statements and get their results without haveing to close the database connection and the resultset each query.

Why is this happening what is the best/easiest way to remedy this.

Thanks again.

Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33132

That looks like the same prepared statement 6 times. How are you changing the query each time?

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: SQLException problem?
It's not a secret anymore!