NamedParameterJdbcTemplate batchUpdate returns an array of size 1 when the batchArgs passed is an empty array [SPR-17476]

[spring-projects-issues]

Vinay Shankar opened SPR-17476 and commented

The batchUpdate method of NamedParameterJdbcTemplate returns an array of size 1 when the batchArgs passed is an empty array.

int[] batchUpdate(String sql, SqlParameterSource[] batchArgs);

The batchUpdate method of the JdbcTemplate returns an empty array when the batchArgs passed is an empty array.

public int[] batchUpdate(String sql, List<Object[]> batchArgs) throws DataAccessException;

I am using spring-jdbc 4.2.9

---

Issue Links:

• Support list in IN clause in NamedParameterJdbcTemplate.batchUpdate [SPR-17402] #21935 Support list in IN clause in NamedParameterJdbcTemplate.batchUpdate

Referenced from: commits 4f5ae22, 362c59c, 0167b79

Backported to: 5.0.11, 4.3.21

[spring-projects-issues]

Juergen Hoeller commented

Good catch, we accidentally returned an array with 0 as an element instead of 0 length there. Fixed for 5.1.3 now, and backported to 5.0.11 and 4.3.21 as well.

[spring-projects-issues]

Vinay Shankar commented

Thank you for the fix.