Record Set closing

[Tom Enders]

Why is my record set closed when I try to read from it the line after I execute the sql statement?

[Jeanne Boyarsky]

Tom,
Can you show the relevant code snippet?

[Tom Enders]

        String sql = "SELECT DISTINCT genre FROM songs ORDER BY genre";
        this.rs = this.stmt.executeQuery(sql);
        if(rs.isClosed()) {
            System.out.println("WTF");
        }
        while(this.rs.next()) {
            System.out.println(this.rs.getString("genre"));
        }

[Peter Johnson]

What database and JDBC driver are you using?

If you comment out the ifClosed() check, what happens? Could it be that your query returns no results?

[Tom Enders]

It's working now. The problem was with my inserts. They were not executing because I had some bad boolean logic surrounding them. So, the problem wasn't actually with this piece of code.