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

Question

Can anyone point me in the write direction to solve the error: SQLException: Operation not allowed after ResultSet closed

Here is the code i believe the error occurs in

Statement stmt = con.createStatement();
String query1 = "";
String query2 = "";

int candidateNo = 42;

query1 = "SELECT * FROM Candidates WHERE CandidateNo = "+ candidateNo;
ResultSet rs = stmt.executeQuery(query1);
//If query can be completed then display name and prompt to continue
if(rs.next()){
    query2 = "SELECT * FROM Achieved WHERE CandidateNo = " + candidateNo;
    ResultSet ts = stmt.executeQuery(query2);
}

I have tried using resultset rs = null; to create the variable but the error still occurs

Which line throws the exception? Where's the stack trace that should accompany this question? — user207421, Mar 04 '18 at 06:31

score 1 · Accepted Answer · answered Nov 15 '17 at 13:33

You are iterating over the ResultSet bound to a Statement , then while iterating, you are using the exact same Statement object to issue a new query and get and iterate over another ResultSet .

This won't work as long as you are not done with the processing of the first ResultSet, so consider using a distinct Statement object for your second query .

score 1 · Answer 2 · answered Nov 15 '17 at 13:37

1

In your code you used 2 ResultSet executing the same Statement object (stmt)concurrently. Use different Statement Objects for both queries.

answered Nov 15 '17 at 13:37

Har Krishan

273
1
11

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

2 Answers2