Spring boot batch insert, rollback as groups

InspectorGadget 0
Viewed 23

So i'm working on a spring boot project and i need to insert some bulk data. But i want to insert it as groups like say 20 entities per group and if something goes wrong i want it to rollback the group not the whole thing. How can i achive that?

Here is what i have in mind:

@Transactional
public void saveBatchAsGroups(List<EntityClass> data) {
    List<EntityClass> group = new ArrayList();
    for (EntityClass entity : data) {
        //some operations

        group.add(entity);
        if (group.size() > 19) {
            saveGroup(group);
            group.clear();
        }
    }
}

@Transactional(propagation = Propagation.REQUIRES_NEW)
public void saveGroup(List<EntityClass> group) {
    someRepository.saveAll(group);
}

This way saveGroup opens a new transaction for every save operation.

Is this a good practice in terms of performance etc., can it done without a bunch of new transactions like with save points or something like that? what is the best way to achive this kind of job?

spring-data-jpa spring-data spring-boot java
1 Answers

JPA doesn't now stacked transactions, so the outer @Transactional is at least confusing.

Other than that this looks ok. You might want to consider Spring Batch though, which is build for this kind of process.

Jens Schauder0
Related