java, hibernate: mapping property with a query

java hibernate hibernate-mapping
blow picture blow · Feb 6, 2011 · Viewed 17.6k times · Source

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?

Answer

danny.lesnik picture danny.lesnik · Feb 6, 2011

You an use formula annotation. for example:

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

See this post: Calculated property with JPA / Hibernate

Se also Hibernate tutorial: http://docs.jboss.org/hibernate/core/3.3/reference/en/html/mapping.html#mapping-column

Related questions

Hibernate - A collection with cascade=”all-delete-orphan” was no longer referenced by the owning entity instance

I'm having the following issue when trying to update my entity: "A collection with cascade=”all-delete-orphan” was no longer referenced by the owning entity instance". I have a parent entity and it has a Set<...> of some children …

Read More
In which case do you use the JPA @JoinTable annotation?

In which case do you use the JPA @JoinTable annotation?

Read More
Hibernate table not mapped error in HQL query

I have a web application that use Hibernate to make CRUD operations over a database. I got an error saying that the table is not mapped. See the Java files: Error message: org.springframework.orm.hibernate3.HibernateQueryException: Books is not …

Read More