Jpa Parameter value element [xxx] did not match expected type [xxx]

Question

I have a Jpa method like below.

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

This is the code for call the above Spring Data JPA method. And here will be throw a exception when to call the above Spring Data JPA method.

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

        return applicationMaterialFileRepository.findAllByProcessInstanceIdAndApplicationMaterialIn(processInstanceId, applicationMaterials);
    }

Here is the ApplicationMaterial entity struct.

/**
 * 
 * @see <a href="https://code.aliyun.com/butterfly-effect/backend/wikis/plans"
 * @author himly z1399956473@gamil.com
 */
@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;
}

When to call the Spring Data JPA method findAllByProcessInstanceIdAndApplicationMaterialIn will throw a exception like below

Caused by: java.lang.IllegalArgumentException: Parameter value element [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)] did not match expected type [com.hikedu.backend.model.ApplicationMaterial (n/a)]

Can someone please help me?

Update:

The table struct:

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

yes, it is using in the `application_material_library` table. And the column type is varchar. — OnTheRoad, Oct 09 '18 at 03:16
i am not sure if you have any problem about mapping, because we don't see your table field. If you can confirm all mapping is configured correctly and saving new entity is ok or not? — Huy Nguyen, Oct 09 '18 at 03:20
@huy I was delete the tables and created them again. But it did not work. — OnTheRoad, Oct 09 '18 at 03:51
same question, If you can confirm all mapping is configured correctly and saving new entity is ok or not? Because the prerequisite is mapping correct. If you are sure about mapping, then try using @Query on method to define instead of use method name. — Huy Nguyen, Oct 09 '18 at 04:51
@huy Save new entity is all right. But when call the jpa method still is same error. Ok I will try it. — OnTheRoad, Oct 09 '18 at 05:44
@Alien Same error no matter missing or include the university. — OnTheRoad, Oct 09 '18 at 05:46
then i suspect the parameters types are mismatching like expecting Long but you are passing int or something like that. — Alien, Oct 09 '18 at 05:47
@SangamBelose Thank you for try to help me. I already update my post. — OnTheRoad, Oct 09 '18 at 07:43
Please include the full stack trace and format it as code, not as a quote. — Jens Schauder, Oct 09 '18 at 08:36

score 0 · Answer 1 · answered Oct 09 '18 at 08:40

Spring Data doesn't seem to find your custom method implementation.

Therefore it interprets the method as derived query method and complains that the types of parameters don't match what it expects. The error is strange since it complains, although the types seem to match. But that isn't your problem here. The problem is that the custom method is not found.

This answer describes how to do a custom implementation depending on which version of Spring Data you are using.

Jpa Parameter value element [xxx] did not match expected type [xxx]

1 Answers1