Spring Bean创建失败求助：JPA自定义查询验证错误排查

问题详情 #

我遇到了JPA自定义查询的启动报错，相关信息如下：

JPA Repository方法代码 #

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

错误原因分析 #

核心问题是JPA无法通过自定义查询语句的校验，大概率是以下两点：

• JPQL中误用了数据库表名而非实体类名：deliverypartnerrecord是数据库表名的写法，而JPQL需要使用实体类的类名，你的实体类是Deliverypartnerrecord，首字母必须大写。
• 字段名不匹配：需确认实体类Deliverypartnerrecord中确实存在status和id属性，且名称（包括大小写）与JPQL中的写法完全一致。

解决方案 #

修正JPQL语句 #

将查询语句中的实体类名改为正确的类名即可：

@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);

额外检查项 #

• 确认实体类Deliverypartnerrecord上的@Entity注解配置正确，表映射关系无误。
• 若实体类属性与数据库列名不一致，需检查@Column注解是否做了正确映射。
• 验证@Param参数名称与JPQL中的占位符完全匹配（当前代码此部分无问题）。

内容的提问来源于stack exchange，提问作者Shubham Shaw