Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; nested exception is org.hibernate.StaleStateException

Question

I'm facing an issue deleting an entity on my SpringBoot project:

On my service I'm calling the following function in order to delete an entity: ecSignatoryService.deleteById(ecSignatoryDTO.getId());. I've verified before, the entity exist in my Database.

EcSignatoryServiceImpl:

    @Override
    @Transactional
    public void deleteById(Long signatoryId) {
        this.ecSignatoryDao.deleteById(signatoryId);
    }

EcSignatoryDaoImpl:

    @Override
    @Transactional
    public void deleteById(Long signatoryId) {
        this.ecSignatoryRepository.deleteById(signatoryId);
    }

And my repository is just an extension of CrudRepository.

I'm probably missing something somewhere but I have no clue.

Thanks

score 0 · Answer 1 · edited Jun 11 '21 at 18:12

This exception usually occurs when you delete an object and then later update it (hope you are not updating the primary key). I have found that using session.clear() after delete usually removes this exception.

Also, if you are using any generator class for id property in hbm mapping file, then do not set the value explicitly.

Many people have had the same error and has shared there experience or solution at Hibernate - Batch update returned unexpected row count from update: 0 actual row count: 0 expected: 1

Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1; nested exception is org.hibernate.StaleStateException

1 Answers1