try {
txTemplate.execute(new TransactionCallbackWithoutResult() {
@Override
public void doInTransactionWithoutResult(TransactionStatus ts) {
int[] affectedRows =
npjt.batchUpdate(insertQuery.getSql(), parameters.toArray(new MapSqlParameterSource[0]));
int sum = 0;
for (int i = 0; i < affectedRows.length; ++i) {
sum += DatabaseUtils.getAffectedRowsNumber(affectedRows[i]);
}