Why Spring’s jdbcTemplate.batchUpdate() so slow?

These parameters in the JDBC connection URL can make a big difference in the speed of batched statements — in my experience, they speed things up:

?useServerPrepStmts=false&rewriteBatchedStatements=true

See: JDBC batch insert performance