java - 无法通过jpa存储库删除记录

Question

在 Springboot 中，我在存储库中创建了一个删除方法。我使用相同的存储库方法来删除服务方法中的记录。记录没有被删除。它抛出异常。请指教。

代码:

public interface SopCffDtlDependentRepository extends JpaRepository<SopCffDtlDependent,String>{

    String deleteByQuotationNo(String quotationNo);
    }


@Autowired
SopCffDtlDependentRepository sopCffDtlDependentRepository;


String noOfRecordsDeleted = sopCffDtlDependentRepository.deleteByQuotationNo(params.getQuotationNo());

                @Entity
                @Table(name = "SOP_CFF_DTL_DEPENDENT")
                public class SopCffDtlDependent {


                    @Column(name="NAME")
                    private String name;

                    @Column(name = "RELATIONSHIP")
                    private String relationShip;

                    @Column(name ="DOB")
                    private Date dob;

                    @Column(name="GENDER")
                    private String gender;

                    @Column(name="YEAR_OF_SUPPORT")
                    private Integer yearOfSupport;

                    @Id
                    @Column(name="QUOTATION_NO")    
                    private String quotationNo;

                    @Column(name="INVESTMENT_PREFER")   
                    private String investmentPrefer;

                    @Column(name="SEQUENCE_NO") 
                    private int sequenceNo;
}

异常(exception):

 org.springframework.dao.InvalidDataAccessApiUsageException: No EntityManager with actual transaction available for current thread - cannot reliably process 'remove' call; nested exception is javax.persistence.TransactionRequiredException: No EntityManager with actual transaction available for current thread - cannot reliably process 'remove' call

Answer 1

您应该添加修改和事务注释以按条件删除。通过查看您的日志，我不确定这就是原因。

@Transactional
@Modifying
void deleteByQuotationNo(String quotationNo);