在执行自定义jpa存储库方法时，找不到类型[EntityName]的属性[MethodName]

Question

我需要在ServiceImpl中准备一个查询，因为根据某些逻辑，查询可能会有不同。柱子的。因此，我决定准备一个自定义JPA存储库，但遇到了一些错误。

 Entity class


  @SuppressWarnings("serial")
 
  @Entity
  
  @Getter
  
  @Setter
  
  @Table(name = "REASON_CODE_REPORT",schema="automation") 
  @IdClass(ErrorCodeReportKeys.class)
  public class ErrorCodeReportEntity
  {
        @Id
        private String smsc;
        
        @Id
        private String userid;
        
        @Id
        private String smsc_userid;
        
        @Id
        private String operator;
        
        @Id
        private String circle;
        
        @Id
        private Date log_date;
        
        @Id
        private Integer log_hour;
        
        @Id
        private Integer log_min;
        
        @Id
        private  Integer vf_reason_code;
        
        @Id
        private  Integer smsc_reason_code;

        private Integer count;
        
        private Timestamp create_date;

  }

@Override
    public List<Object[]> errorCodeDefaultSummary(ErrorCodeReportDTO errorCodeReportDTO) {
 
          String finalQuery="select smsc,userid from ErrorCodeReportEntity where log_date='2021-05-27'";
      List<Object[]> result =   errorCodeRepo.presentDaySummarySmscWise(finalQuery);
      
     
        return result;
}

public interface ErrorCodeCustom {

      List<Object[]> presentDaySummarySmscWise(String query);
        
}

public class ErrorCodeCustomImpl implements ErrorCodeCustom{

    @Autowired
    private EntityManager entityManager;
    
    
    @SuppressWarnings("unchecked")
    @Override
    public List<Object[]> presentDaySummarySmscWise(String query) {
        
     final  String finalQuery=query.toString();
        
       List<Object[]>  result= entityManager.createQuery(finalQuery).getResultList();
        
        
        
        return result;
    }

}

@Repository
public interface ErrorCodeRepository extends JpaRepository<ErrorCodeReportEntity, ErrorCodeReportKeys>,ErrorCodeCustom
{
}

我不知道为什么我会犯以下错误

Caused by: java.lang.IllegalArgumentException: Failed to create query for method public abstract java.util.List com.valuefirst.repository.ErrorCodeCustom.presentDaySummarySmscWise(java.lang.String)! No property presentDaySummarySmscWise found for type ErrorCodeReportEntity!

Caused by: org.springframework.data.mapping.PropertyReferenceException: No property presentDaySummarySmscWise found for type ErrorCodeReportEntity!

Answer 1

Spring无法找到您的实现ErrorCodeCustomImpl。您应该将其注释为@component。

所以出现异常是因为ErrorCodeRepository扩展了ErrorCodeCustom，并且由方法名生成的查询试图使用名为PresentdaySummarysMSCwise的属性。一旦Spring注入了ErrorCodeCustomImpl，错误就消失了。