Jpa参数值元素[xxx]与预期的类型[xxx]不匹配

Question

Set<ApplicationMaterialFile> findAllByProcessInstanceIdAndApplicationMaterialIn(String processInstanceId, Collection<ApplicationMaterial> applicationMaterials);

@Override
    public Set<ApplicationMaterialFile> getAllByProcessInstanceIdApplicationMaterialIds(String processInstanceId, Set<Long> applicationMaterialId) {
        List<ApplicationMaterial> applicationMaterials = applicationMaterialService.getAllByIdIfNotExistsThenThrowException(applicationMaterialId);

        return applicationMaterialFileRepository.findAllByProcessInstanceIdAndApplicationMaterialIn(processInstanceId, applicationMaterials);
    }

/**
 * 
 * @see <a href="https://code.aliyun.com/butterfly-effect/backend/wikis/plans"
 * @author himly [e-mail]
 */
@Table(name = "application_material_library")
@Entity
@EntityListeners(AuditingEntityListener.class)
@Data
@ToString(exclude = {"university"})
@EqualsAndHashCode(exclude = {"university"})
public class ApplicationMaterial {
    @Id
    @GeneratedValue(strategy = GenerationType.IDENTITY)
    private Long id;

    @Column(nullable = false)
    private String name;

    private String fileFormat;


    private String description;


    private String templateFileUrl;


    @JsonIgnore
    @ManyToOne
    private University university;


    @CreatedDate
    @Column(nullable = false)
    private Timestamp createdAt;


    @LastModifiedDate
    @Column(nullable = false)
    private Timestamp updatedAt;
}

何时调用Spring数据JPA方法FindAllByProcessInstanceIdandApplicationMaterialIn将引发如下所示的异常

原因：java.lang.IllegalArgumentException：参数值元素[ApplicationMaterial(ID=1,Name=SDFSF,FileFormat=Doc,Description=DFSDFDS,TemplateFileURL=FSDFSDF,CreateDat=2018-09-26 16:54:09.297,UpdateDat=2018-09-26 16:54:23.451)]与预期类型[com.hikedu.backend.model.ApplicationMaterial(N/A)]不匹配

有人能帮帮我吗？

更新：

表结构：

-- auto-generated definition
create table application_material_library
(
  id                bigint auto_increment
    primary key,
  created_at        datetime(6)  not null,
  description       varchar(255) null,
  file_format       varchar(255) null,
  name              varchar(255) not null,
  template_file_url varchar(255) null,
  updated_at        datetime(6)  not null,
  university_id     bigint       null,
  constraint FK9kuemh1kjhyt8u16sqw6i6t59
  foreign key (university_id) references universities (id)
);

Answer 1

Spring数据似乎找不到您的自定义方法实现。

因此，它将该方法解释为派生查询方法，并抱怨参数的类型与它所期望的不匹配。这个错误很奇怪，因为它抱怨，尽管类型似乎是匹配的。但这不是你的问题。问题是找不到自定义方法。

这个答案描述了如何根据您使用的Spring数据的版本进行自定义实现。