JPA@Query java.lang.IllegalArgumentException：

Question

这个代码有问题

public interface CharityRepository extends CrudRepository<Charity,Long> {

  @Query("select sum(sponsorSum) from Charity")
  Integer totalCharitySum();
}

抛出异常

UnsatisfiedDependencyException：创建文件[D:\IdeaProjects\MaraphonSkills(3)\Target\类\COM\Maraphon\MaraphonSkills\Controllers\AdminController.class]中定义的名为“Admin Controller”的bean时出错：通过构造函数参数0表示的不满足的依赖项；嵌套异常为org.springframework.beans.factory.unsatisfiedDependencyException：创建文件[D:\IdeaProjects\maraphonskills(3)\target\类\com\maraphon\maraphonskills\service\charityServiceImpl.class]中定义的名为“慈善ServiceImpl”的bean时出错：通过构造函数参数0表示的不满足的依赖项；嵌套异常为org.springframework.beans.factory.beanCreationException：创建名为“charity repository”的bean时出错：调用init方法失败；嵌套异常为java.lang.IllegalArgumentException：方法public abstract java.lang.short com.maraphon.maraphonskills.Repository.CharityRepository.TotalCharitySum（）查询验证失败！

原因：org.springframework.beans.factory.unsatisfiedDependencyException：创建文件[D:\IdeaProjects\maraphonskills(3)\target\类\com\maraphon\maraphonskills\service\charityServiceImpl.class]中定义的名为“慈善服务Impl”的bean时出错：通过构造函数参数0表示的依赖项不满足；嵌套异常为org.springframework.beans.factory.beanCreationException：创建名为“charity repository”的bean时出错：调用init方法失败；嵌套异常为java.lang.IllegalArgumentException：方法public abstract java.lang.short com.maraphon.maraphonskills.Repository.CharityRepository.TotalCharitySum（）查询验证失败！

原因：org.springframework.beans.factory.BeanCreationException：创建名为“charity repository”的bean时出错：调用init方法失败；嵌套异常为java.lang.IllegalArgumentException：方法public abstract java.lang.short com.maraphon.maraphonskills.Repository.CharityRepository.TotalCharitySum（）查询验证失败！

原因：java.lang.IllegalArgumentException：方法public abstract java.lang.short com.maraphon.maraphonskills.Repository.CharityRepository.TotalCharitySum（）的查询验证失败！

原因：java.lang.NullPointerException：null

但这段代码工作正常

public interface CharityRepository extends CrudRepository<Charity,Long> {
  @Query("select sum(sponsorTarget) from Registration")
  Short totalSum();
}

@修改无济于事。有什么问题吗？

慈善守则

 @Entity
@EqualsAndHashCode(exclude = "registrations")
@Data
public class Charity {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;
    private String name;
    @Lob
    private String description;
    private String fileName;
    private Short SponsorSum;

    @OneToMany(mappedBy = "charity")
    public Set<Registration> registrations = new HashSet<>();
    }

注册码

    @Entity
@EqualsAndHashCode(exclude = "sponsorShips")
@Data
public class Registration {

    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @ManyToOne
    public Runner runner;
    private String registrationDateTime;
    @ManyToOne
    public Charity charity;
    @ManyToOne
    public RaceKitOption raceKitOption;
    @ManyToOne
    public RegistrationStatus registrationStatus;

    private Short sponsorTarget;
    @OneToMany(mappedBy = "registration")
    public Set<SponsorShip> sponsorShips = new HashSet<>();
   // public RegistrationEvent registrationEvent;
}

Answer 1

提示：Java区分大小写。

问题在于在您的CharityRepository接口中使用小写sponsorSum：

@Query("select sum(sponsorSum) from Charity")

和大写一：

private Short SponsorSum;

在两者中使用相同的大小写，它将解决您的问题。