Spring Data Rest specify lazy loading for collections

Question

I have two entities with one to many relationships:

public class User {
    @Id
    @GeneratedValue
    private Long id;
    private String username;
    private String phoneNumber;
    private Timestamp creationDate;
    @OneToMany(mappedBy = "user")
    private List<Role> roles;

}

public class Role {
    @Id
    @GeneratedValue
    private long id;
    @ManyToOne
    @JoinColumn(name = "user_id", nullable = false)
    private User user;

}

but when I call get method to load user information I can see in the log file that additional query to retrieve user's roles also called. How can I prevent it with spring data rest?

it doesn't work with spring-data-rest entities. Also fetchType is lazy by default. — Alex
– Alex, Commented Feb 26, 2018 at 10:43
What you have to shown is how you retrieve and manipulate the User entities. As a hint, enable the SQL logs you could see whether the query for the roles is performed in a second time — davidxxx
– davidxxx, Commented Feb 26, 2018 at 10:54
actually, I found that problem with show_sql property turned on, but thanks for advice. — Alex
– Alex, Commented Feb 26, 2018 at 10:55

Ram · Accepted Answer · 2018-02-26 10:47:48Z

2

Define FetchType to LAZY as below.

@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "user_id", nullable = false)
private User user;

By default, JPA fetchType for ManyToOne is EAGER. Refer here

answered Feb 26, 2018 at 10:47

Ram

1,8133 gold badges22 silver badges41 bronze badges

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

1 Comment

Alex Over a year ago

I tried that approach and it didn't work. Actually, I loaded all users(not roles) so not sure how the mapping of child entity will fix that...

Cepr0 · Accepted Answer · 2018-02-26 11:19:50Z

1

Since you are using SDR, to prevent Roles from loading when you get Users you can:

1) Create repository for Roles. If you had one check if it exported (@RepositoryRestResource(exported = true) - by default just add this annotation without this parameter).

2) Or make User projection without roles:

@Projection(name = "justUser", types = User.class)
public interface JustUser {
    String getUsername();
    String getPhoneNumber();
    Timestamp getCreationDate();
}

Then use it in your request, like this:

GET /users?projection=justUser

answered Feb 26, 2018 at 11:19

Cepr0

31.1k9 gold badges82 silver badges105 bronze badges

Collectives™ on Stack Overflow

Spring Data Rest specify lazy loading for collections

2 Answers 2

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related