Spring Data Jpa. How to get a list of objects without any relationship

Question

I have a entity which has a many relationships to other entities like below:

class Customer {

private String email;

// many to many 
private Set<Street> streets

// many to many 
private Set<Address> addresses;

and soo on..
}

I would like to find all customers and get back as a list of Customers with set only an emails - without any sets.

It is possible using query extracted from method name? Or only can I get only a list of objects[] and build objects in service?

Collections are lazy by default, so as long as you don't access them they aren't filled unless of course you made them eager. — M. Deinum
– M. Deinum, Commented Apr 21, 2015 at 11:48

beerbajay · Accepted Answer · 2015-04-21 11:27:31Z

1

You should be able to use the IS EMPTY JPQL, as documented here:

@Query("select c from Customer c WHERE c.streets IS EMPTY AND c.addresses IS EMPTY")
List<Customer> findCustomersWithoutRelations();

answered Apr 21, 2015 at 11:27

beerbajay

20.5k8 gold badges63 silver badges78 bronze badges

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

1 Comment

tomasz-mer Over a year ago

Customers in database are have releationship already. I don't want to get list of customer which are not have any streets or addreses. I wanted to get only a main object. After thinking ...it was a stiupid question. Query should get a current state of object in the database. If collections are lazy that should be filled when I want to access to them.

Collectives™ on Stack Overflow

Spring Data Jpa. How to get a list of objects without any relationship

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related