spring-data-jpa 创建名为“deliveryPartnerRecordController”的Bean时出错:通过字段“dService”表示的依赖关系未满足;嵌套异常

lxkprmvk  于 2022-11-10  发布在  Spring
关注(0)|答案(1)|浏览(163)

有谁能帮我找出我的错误吗?

JPA函数:

@Query("select d from deliverypartnerrecord d where d.status = :d_status and d.id = :d_id")
public Deliverypartnerrecord findDeliveryPartnerRecordById(@Param("d_id") int id, @Param("d_status") String status);

错误:

Error creating bean with name 'deliveryPartnerRecordController': Unsatisfied dependency expressed through field 'dService'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'deliveryPartnerRecordService': Unsatisfied dependency expressed through field 'dRepo'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'deliveryPartnerRecordRepo' defined in com.diatozSnacks.snacks_management.repository.DeliveryPartnerRecordRepo defined in @EnableJpaRepositories declared on JpaRepositoriesRegistrar.EnableJpaRepositoriesConfiguration: Invocation of init method failed; nested exception is org.springframework.data.repository.query.QueryCreationException: Could not create query for public abstract com.diatozSnacks.snacks_management.model.Deliverypartnerrecord com.diatozSnacks.snacks_management.repository.DeliveryPartnerRecordRepo.findDeliveryPartnerRecordById(int,java.lang.String); Reason: Validation failed for query for method public abstract com.diatozSnacks.snacks_management.model.Deliverypartnerrecord com.diatozSnacks.snacks_management.repository.DeliveryPartnerRecordRepo.findDeliveryPartnerRecordById(int,java.lang.String)!; nested exception is java.lang.IllegalArgumentException: Validation failed for query for method public abstract com.diatozSnacks.snacks_management.model.Deliverypartnerrecord com.diatozSnacks.snacks_management.repository.DeliveryPartnerRecordRepo.findDeliveryPartnerRecordById(int,java.lang.String)!
blpfk2vs

blpfk2vs1#

我将查询语法更改为:

@Query(value="select * from deliverypartnerrecord d where d.status = :d_status and d.id = :d_id", nativeQuery=true)

现在起作用了。

相关问题