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 — Draken
– Draken, Commented Jan 9, 2017 at 12:36

Community · Accepted Answer · 2017-05-23 12:24:37Z

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;

CommunityBot

11 silver badge

answered Feb 6, 2011 at 12:08

danny.lesnik

18.6k31 gold badges141 silver badges206 bronze badges

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

1 Comment

Be aware that the value might be outdated if the 2nd level cache is enabled for the entity!