spring data - query in array in object

Question

I have an EstablishmentEntity which has an array of Attachment, i want to get the EstablishmentEntity that its Attachments contains an Attachment that its idChild equals the parameter i pass

@Entity
@DiscriminatorValue
public class EstablishmentEntity extends ExerciseFrameworkEntity {

    @ElementCollection
    private Set<Attachment> attachments;

}

public class Attachment implements Serializable {

    private static final long serialVersionUID = 1L;

    private String idChild;

}

I tried with this, but i get this error

Parameter value element [xxxxxxxx] did not match expected type Attachment

@Repository
public interface EstablishmentRepository extends JpaRepository<EstablishmentEntity, String> {
    
    EstablishmentEntity findByAttachmentsIn(String idChild);
    
}

Eklavya · Accepted Answer · 2020-07-07 19:30:30Z

1

findByAttachmentsIn expect List of Attachment for In query but you are passing String.

Use IdChild instead of In in method naming as you search by idChild of Attachment

EstablishmentEntity findByAttachmentsIdChild(String idChild);

answered Jul 7, 2020 at 19:30

Eklavya

18.6k4 gold badges33 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Aymen Kanzari Over a year ago

i get this error:

Failed to create query for method public abstract EstablishmentEntity findByAttachmentsIdChild(java.lang.String)! Illegal attempt to dereference path source [null] of basic type

Eklavya Over a year ago

Use @Embeddable in Attachment class

Collectives™ on Stack Overflow

spring data - query in array in object

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related