Hibernate: @ManyToOne(fetch = FetchType.LAZY) does not work on non-primary key referenced column

Question

I have 2 tables: Order [OrderId(PK), OrderShipmentCode, ...] and Shipment[ShipmentId(PK), ShipmentCode, ...].

In Order class, I declared shipment field as follows:

@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "OrderShipmentCode", referencedColumnName = "ShipmentCode", insertable = false, updatable = false, nullable = false)
private Shipment shipment;

When I get the list of Order, the Shipment is also loaded (I saw many separate SELECT queries). But I want the Shipment to be lazy loaded, not to be fetched together with Order.

For other tables, if the referenced column is primary key then the results are as expected (Lazy-loading is used). In my case, ShipmentCode is not Primary Key of Shipment table, and lazy-loading is not used by Hibernate.

Could you show me how to accomplish that goal?

EDIT: The Query code is as bellow:

Criteria criteria = HibernateUtil.getSessionFactory().getCurrentSession().createCriteria(Order.class);
List result = criteria.list();

SQL queries are: 1 SELECT statement for Order table and a bunch of SELECT statement for Shipment

you can try using a native query like select * from order where condition. — Angad Bansode
– Angad Bansode, Commented Apr 5, 2018 at 5:37
If you know that the joined object is never null you can use optional=false. Hibernate then can lazily load the relation. See this super helpful post: stackoverflow.com/questions/3331907/… — andy
– andy, Commented Feb 16, 2022 at 0:41

Vlad Mihalcea · Accepted Answer · 2020-07-15 00:20:43Z

2

Thd problem is caused by the HHH-13024 issue.

In the true spirit of OSS, you might want to investigate the problem and send a Pull Request with a fix proposal. That's the fastest way of getting an issue fixed.

edited Jul 15, 2020 at 0:20

answered Jan 9, 2015 at 6:55

Vlad Mihalcea

156k85 gold badges599 silver badges984 bronze badges

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

3 Comments

Nghia Le Over a year ago

Thank you. I already tried your solution but the result is the same

Nghia Le Over a year ago

I also tested with your updated answer but the results are still the same.

Guillaume S Over a year ago

I agree with that. Check this post for more detail (stackoverflow.com/questions/17987638/…)

WGSSAMINTHA · Accepted Answer · 2021-03-09 05:31:39Z

1

If you worry about multiple select queries while loading, you can overcome this by using Entity Graphs. please refer to below link for more details https://www.baeldung.com/spring-data-jpa-named-entity-graphs

answered Mar 9, 2021 at 5:31

WGSSAMINTHA

1901 silver badge11 bronze badges

Comments

Vishal Yadav · Accepted Answer · 2017-12-05 06:56:13Z

0

Try this:

Criteria criteria = HibernateUtil.getSessionFactory()
                                 .getCurrentSession()
                                 .createCriteria(Order.class)
                                 .setFetchMode("shipment", FetchMode.LAZY);

edited Dec 5, 2017 at 6:56

Vishal Yadav

3,6893 gold badges28 silver badges43 bronze badges

answered Dec 5, 2017 at 5:31

shady

33 bronze badges

1 Comment

Ori Marko Over a year ago

Please add explanation to your solution

SKD · Accepted Answer · 2019-11-29 06:41:39Z

-1

You can use @JsonIgnore over the shipment field of order. If you are giving using MappedBy over shipment field then removing it might solve your issue.

answered Nov 29, 2019 at 6:41

SKD

873 bronze badges

Comments

Yevhen Kalashnykov · Accepted Answer · 2020-09-02 12:39:58Z

-1

add to your entity field with shipmentCode and set your code for relation, then it`s fork fine

@Column(name = "shipmentCode")
private Long shipmentCode;

@ManyToOne(fetch = FetchType.LAZY)
@JoinColumn(name = "OrderShipmentCode", referencedColumnName = "shipmentCode", insertable = false, updatable = false, nullable = false)
private Shipment shipment;

If you use Lazy-init you entity extracting without fild with relation value, then when you trying extract lazy entity Hibernate can`t find any values becouse it havent relation value

answered Sep 2, 2020 at 12:39

Yevhen Kalashnykov

1402 bronze badges

Collectives™ on Stack Overflow

Hibernate: @ManyToOne(fetch = FetchType.LAZY) does not work on non-primary key referenced column

5 Answers 5

3 Comments

Comments

1 Comment

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

3 Comments

Comments

1 Comment

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related