Searching An object from @ElementCollection

Question

I am using Spring Data JPA.

I an entity like this

public class A {

    @CollectionTable(name = "B_ITEMS", joinColumns = @JoinColumn(name = "B_ID"))
    @ElementCollection
    private List<B> bs;

}

And an Embedded class

@Embeddable
public class B { 

private String prop1


private String prop2


private String prop3

}

How do I search entity A using the contents @ElementCollection B?

And here's my repository Spring Data JPA Repositry

public interface ARepo extends PagingAndSortingRepository<Clinic, Long> {

}

What Query method name is applicable for my use case?

DSS · Accepted Answer · 2016-02-26 22:28:35Z

4

You seem to be asking for a basic IN query in Spring Data - findBybsIn(List<B> bs)

answered Feb 26, 2016 at 22:28

DSS

1929 bronze badges

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

Comments

Zeromus · Accepted Answer · 2018-05-30 10:10:54Z

4

+25

@ElementCollection is just a simple way to map a @OneToMany relation.

As such you can join them as usual:

public interface ARepo extends PagingAndSortingRepository<A, Long> {
    @Query("select a from A a join a.bs b where b.prop1 = :prop1 and ...")
    A findByProps(@Param("prop1") String prop1)
}

answered May 30, 2018 at 10:10

Zeromus

4,5678 gold badges34 silver badges41 bronze badges

Comments

C. Weber · Accepted Answer · 2018-06-05 13:45:01Z

2

Instead of using @Query like in @Zeromus answer you can also define it by method name (findByElementCollectionProperty_NestedProperty):

public interface ARepo extends JPARepository<A,Long> {

    List<A> findByBs_Prop1(String prop1);
}

More information how SpringData resolves nested Properties can be found under:

Query Property Expressions

answered Jun 5, 2018 at 13:45

C. Weber

9375 silver badges19 bronze badges

1 Comment

Maurice Over a year ago

how would this method look if Bs were not a collection of embeddables but a collection of simple Strings instead? Say, I want to know if a particular string argument matches with a string in the elementcollection. Would the method then look like this: findByBsIn(String arg) or should it be different?

ValerioMC · Accepted Answer · 2018-09-26 13:43:20Z

1

An approach could be to search a list of A objects for all the properties of B object. That means use filters for prop1, prop2 and prop3 together.

public interface ARepo extends PagingAndSortingRepository<Clinic, Long> {
    List<A> findByBsProp1AndBsProp2AndBsProp3(String prop1, String prop2, String prop3); 
}

edited Sep 26, 2018 at 13:43

answered Sep 26, 2018 at 12:46

ValerioMC

3,22618 silver badges28 bronze badges

3 Comments

ValerioMC Over a year ago

this is a findby based on all the 3 properties of @Embeddable object. So if i need to search list of A for a specific object B, i can use this method and filter for all the properties, that means filter for the object itself.

kiran Biradar Over a year ago

While this code could solve the problem, it is best to add elaboration and explain how it works for people who might not understand this piece of code.

ValerioMC Over a year ago

thanks for your feedback. Also if i already explained in comments, i tried to improve the answer

Collectives™ on Stack Overflow

Searching An object from @ElementCollection

4 Answers 4

Comments

Comments

1 Comment

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

4 Answers 4

Comments

Comments

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related