Spring Data Jpa Save and SaveAndFlush

Question

I'm using (Spring Data) JpaRepository to perform CURD operation. Here I saw two methods save and saveAndFlush. in both methods I got the same result, it successfully save data in the database. So what is the difference? I'm not using any sort of transactions mechanism, to issues commit command with the save method.

@Transactional
public BaseDto add(BulkPermitCategoryDto requestDto) {
    BaseDto baseDto = new BaseDto();
    try {
        BulkPermitCategory category = ObjectConverter
                .bulkPermitCategoryDtoToBulkPermitCategory(requestDto);
        bulkPermitCategoryRepository.saveAndFlush(category);
        baseDto.setStatusCode(0);

    } catch (Exception e) {
        log.error("exception occered ", e);
        e.printStackTrace();
    }

    return baseDto;
}

and

@Transactional
public BaseDto add(BulkPermitCategoryDto requestDto) {
    BaseDto baseDto = new BaseDto();
    try {
        BulkPermitCategory category = ObjectConverter
                .bulkPermitCategoryDtoToBulkPermitCategory(requestDto);
        bulkPermitCategoryRepository.save(category);
        baseDto.setStatusCode(0);

    } catch (Exception e) {
        log.error("exception occered ", e);
        e.printStackTrace();
    }

    return baseDto;
}

Simon Martinelli Simon Martinelli · Accepted Answer · 2018-01-09T07:49:34

save()

save() is calling EntityManager.persist() or EntityManager.merge() this will not execute the SQL statements immediately. They will be executed on transaction commit.

saveAndFlush()

saveAndFlush() additionally calls EntityManager.flush() that will execute all retained SQL statements.

So if there are any constraint violations you will get the exceptions when calling saveAndFlush() but not when calling save()

Spring Data Jpa Save and SaveAndFlush

1 Answers