Can anyone help me figure out my mistake?

JPA function:

@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:

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)!

CodePudding user response：

I changed my query syntax to the following:

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

And now it's working.