ResultSet is closed
Jeg har den mest underlige fejl:java.sql.SQLException: Operation not allowed after ResultSet closed
at com.mysql.jdbc.ResultSet.checkClosed(ResultSet.java:652)
at com.mysql.jdbc.ResultSet.next(ResultSet.java:5942)
at com.kpw.blogwatch.ReportGenerator.getUrgencyBlogsInTimeFrame(ReportGenerator.java:217)
I denne metode:
public List<Blog> getUrgencyBlogsInTimeFrame(Date sincedate) {
List<Blog> results = new ArrayList<Blog>();
try {
Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT * FROM categorizedblog WHERE priority='3'");
while(rs.next()) {
String refindkey = rs.getString("refindkey");
ResultSet rs2 = stmt.executeQuery("SELECT * FROM blog WHERE refindKey='" + refindkey + "' AND TIME_TO_SEC(TIMEDIFF('" + DatabaseFunctions.formatDateSQL(sincedate) + "',blogdate)) > 0");
while(rs2.next()) {
Blog b = new Blog();
b.setRefindkey(rs2.getString("refindKey"));
b.setBlogdate(rs2.getTimestamp("blogdate"));
b.setTitle(rs2.getString("title"));
b.setUrl(rs2.getString("url"));
results.add(b);
}
}
} catch (SQLException e) {
e.printStackTrace(); //To change body of catch statement use File | Settings | File Templates.
}
Collections.sort(results);
Collections.reverse(results);
return results;
}
Linie 217 er while(rs.next()) {
Det er noejagtig samme standard teknik jeg bruger i alle andre metoder, men i denne her synes den resultsettet er closed...
Kan nogen se hvorfor?
