Thread: Autocommit

Hello everyone, I'm finishing my first project that involves database and I have problem with one of the sql. I'll try to explain it, please bear with me, my English is not the best.
Basically, I have db with movie titles and i want to display every movie that was released after the date that is entered by the user. For some reason it is showing me only the first one and following message: "ResultSet not open. Verify that autocommit is OFF."
Could someone point me to what I'm doing wrong. Thanks a lot.

 
public static void New_Release () {
    PreparedStatement query7;
 
    String ReleaseDate =  JOptionPane.showInputDialog(null, "Please enter the Date!);
 
    try{
 
    String host = ".......";
    String uName = "";
    String uPass = "";
 
    Connection con = DriverManager.getConnection(host);
 
 
 
    String sql = "SELECT TITLE from DVD WHERE RELEASEDATE > ? ";
        query7 = con.prepareStatement(sql);
 
        query7.setString(1,ReleaseDate);
        ResultSet rs1 = query7.executeQuery();
 
        while (rs1.next()){
        String TITLE = rs1.getString(1);
        query7.executeQuery();
 
 
 
        } // end of while
    } // end of try
 
    catch (SQLException err) {
 
      System.out.println(err.getMessage());
      } // end of catch
 
    } // end of new_release method

That query7.executeQuery(); inside the while loop is nonsense. Is RELEASEDATE a CHAR/VARCHAR or a DATE column? You fetch the titles into the TITLE String which is defined inside the loop, so you can only have one title. If the query returns 10 titles you only see the last one, briefly until the while loop is closed.
You never clean up resources there. The preparedStatement and ResultSet are never closed.

I suggest you read the JDBC tutorial: Trail: JDBC(TM) Database Access (The Java™ Tutorials)


Get that straight first and then see whether you still have a problem.

RELEASEDATE is a DATE column. I got rid of 'query7.executeQuery();' and it works. It is showing all the movie titles. Now, I will read those tutorials. Thanks

Originally Posted by kave2

RELEASEDATE is a DATE column.

Then this is wrong/ error prone:
query7.setString(1,ReleaseDate);