Avoiding loading LAZY collection in Spring Data Jpa

Question

I have following relationship:

@Entity class Shop {
@OneToMany(mappedBy = "shop", fetch = LAZY)
private List<Employee> employees = new LinkedList<>();
}

and

@Entity class Employee {
@ManyToOne
private Shop shop;
}

I've declared Spring Data repository like this:

public interface ShopRepository extends JpaRepository<Shop, Long> {}

Calling ShopRepository#findOne(id) method forces fetching of the List<Employee> employees which is LAZY relationship.

I have service which uses Shop repository:

@Service
@Transactional(readOnly = true)
public class ShopService {

private final ShopRepository shopRepository;

@Autowired
public ShopService(ShopRepository shopRepository) {
    this.shopRepository = shopRepository;
}
public Shop find(Long id) {
    return shopRepository.findOne(id);
}

} The service method is called within another controller method:

@RequestMapping(value = "api/schedule/{shopId:[0-9]+}/{date:\\d{4}-\\d{2}-\\d{2}}", method = RequestMethod.GET)
@ResponseBody
public Schedule getSchedule(@PathVariable Long shopId,
                            @PathVariable @DateTimeFormat(pattern = "yyyy-MM-dd") LocalDate date) {
    Schedule schedule = scheduleService.findSchedule(shopId, date);
    if(schedule != null)
        return schedule;
    else {
        Shop shop = shopService.find(shopId);
        Schedule empty = new Schedule(shop, date);
        return empty;
    }
}

How to get rid of fetching employees relationship?

I cannot see how that would be the case unless something in your code was explicitly triggering the load. Show all the code in the method calling the repo. — Alan Hay
– Alan Hay, Commented May 13, 2016 at 9:51
@alanhay, I've added the code involved in calling the repo's method. — mrom
– mrom, Commented May 13, 2016 at 12:34
Are you using Spring Data Rest. Is your controller a @RepositoryRestController? If so: stackoverflow.com/questions/30910996/… — Alan Hay
– Alan Hay, Commented May 13, 2016 at 17:53

Community · Accepted Answer · 2017-05-23 12:10:11Z

2

I found solution.

Actually I used @JsonManagedReference/@JsonBackRefernce on my entity to prevent cycling while marshaling to JSON. It causes fetching LAZY loading data. To avoid this you should add Hibernate4Module to MappingJackson2HttpMessageConverter.

More info at this post: Avoid Jackson serialization on non fetched lazy objects

edited May 23, 2017 at 12:10

CommunityBot

11 silver badge

answered May 14, 2016 at 16:39

mrom

831 silver badge7 bronze badges

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

Collectives™ on Stack Overflow

Avoiding loading LAZY collection in Spring Data Jpa

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related