I'm trying to work with PreparedStatement and the addBatch.
I tried to use the first query (query1) also as a PreparedStatement but
it doesn't work.
For some reason it only adds the last query (query3).

Any suggestions why it works like this?
Are there some errors in my code?

public void testPrepareStatement() throws SQLException {

    PreparedStatement ps = null;
    Statement st = null;

    String query1 = "CREATE TABLE test3 (i int, s varchar(255))";
    String query2 = "INSERT INTO test3 VALUES (?,?)";
    String query3 = "INSERT INTO test3 VALUES (?,?)";

    st = connection.createStatement();
    st.executeUpdate(query1);
    st.close();
   
    ps = connection.prepareStatement(query2);       
    ps.setInt(1, 1);
    ps.setString(2, "TESTI1");
    ps.addBatch();

    ps = connection.prepareStatement(query3);       
    ps.setInt(1, 2);
    ps.setString(2, "TESTI2");       
    ps.addBatch();

   
    int ret[] = ps.executeBatch();
    System.out.println(ret.length);

}

Shmuel.