Posted on 2003-11-18
Can I do the multi ResultSet?
Statement state = myConn.createStatement();
// the first resultset
ResultSet testRS = state.executeQuery("select * from testing");
//the second result set with the testRS id
ResultSet ndRS = state.executeQuery("select * from nd where nd_id=" + testRS.test_id);
after I added this code, it shows:
Operation not allowed after ResultSet closed
Why it said ResultSet is closed?
How can I settle it?