SNOW-1853752: Statement batch doesn't reset after statement.executeBatch()

[itdv]

JDBC driver version: 3.20.0
According to the JDBC 4.3 specification (Section 14.1.2, Successful Execution):

The statement’s batch is reset to empty once executeBatch returns.

However, this is not how it is implemented in the Snowflake JDBC driver. The batch does not get cleared unless explicitly cleared using statement.clearBatch().

(As noted here, this behavior may be appropriate for unsuccessful executions as well. However, for successful executions, the specification explicitly states that the batch should be cleared.)

[sfc-gh-sghosh]

Hello @itdv ,

Thanks for raising the issue, yes, we are able to reproduce the issue, the batch is not getting cleared after executebatch, we will work on it and update.

`try {
stmt.execute("drop table Emp_dept1");
stmt.execute("drop table Emp1");
stmt.execute("drop table Dept1");

	} catch (Exception e) {
		// TODO: handle exception
	}

	
	
	stmt.executeUpdate("create or replace table Emp1(id int, name STRING)");
	stmt.executeUpdate("create or replace table Dept1(id int, deptname String)");
	stmt.executeUpdate("create or replace table Emp_dept1(id int, dept int)");
	
	System.out.println("Done creating demo table\n");
	
	con.setAutoCommit(false);

	
	stmt.addBatch("insert into  Emp1 values (1000,'Jones')");
	stmt.addBatch("insert into  Dept1 values (260,'Shoe')");
	stmt.addBatch("insert into  Emp_dept1 values (1000, 260)");
	
	int[] updatecounts = stmt.executeBatch();

	System.out.println("All inserted via batch");

	
    for (int i = 0; i < updatecounts.length; i++) {
        System.out.println("Statement " + (i + 1) + " affected " + updatecounts[i] + " rows.");
    }


    con.commit();
    
   	    

    int[] emptyUpdateCounts = stmt.executeBatch();
    System.out.println("Re-executed the batch. Update counts:");
 
    for (int i = 0; i < updatecounts.length; i++) {
        System.out.println("Statement " + (i + 1) + " affected " + updatecounts[i] + " rows.");
    }
    con.commit();
    `

output:
All inserted via batch
Statement 1 affected 1 rows.
Statement 2 affected 1 rows.
Statement 3 affected 1 rows.

Re-executed the batch. Update counts:
Statement 1 affected 1 rows.
Statement 2 affected 1 rows.
Statement 3 affected 1 rows.

Regards,
Sujan