Just create Statement 2 for ResultSet 2

Statement statement2 = connection.createStatement();

ResultSet resultSet2 = statement2.executeQuery("");

If you use Statement 1 for ResultSet 2, Connection is Closed Error comes.