JDBC in batches of 1000 records

JdbcBatchInsert.java

connection.setAutoCommit(false);
try (PreparedStatement pstmt = connection.prepareStatement(TripEntityInsert.INSERT)) {
    int cont = 0;
    Iterator<TripEntity> iterator = trips.iterator();
    while (iterator.hasNext()) {
        TripEntity entity = iterator.next();
        tripInsert.setParameters(pstmt, entity);
        pstmt.addBatch();
        cont++;
        if (cont % batchSize == 0) {
            pstmt.executeBatch();
            connection.commit();
        }
    }
    connection.commit();
}