java, hibernate: mapping property with a query

Question

I have an entity with a property "quantity", this value is not a table field but is dynamically calculated with an hql query.

So, is possibile to add this value in my entities and make hibernate calculate it when I load my entities?

Possible duplicate of [Calculated property with JPA / Hibernate](http://stackoverflow.com/questions/2986318/calculated-property-with-jpa-hibernate) — Draken, Jan 09 '17 at 12:36

score 28 · Accepted Answer · edited May 23 '17 at 12:24

28

You an use formula annotation. for example:

@Formula("(select min(o.creation_date) from Orders o where o.customer_id = id)")
private Date firstOrderDate;

edited May 23 '17 at 12:24

Community

answered Feb 06 '11 at 12:08

danny.lesnik

Be aware that the value might be outdated if the 2nd level cache is enabled for the entity! – Matthias Feb 04 '21 at 08:52

1 Answers1