How to map calculated properties with JPA and Hibernate

by

JPA doesn’t offer any support for derived property so you’ll have to use a provider specific extension. As you mentioned, @Formula is perfect for this when using Hibernate. You can use an SQL fragment:

@Formula("PRICE*1.155")
private float finalPrice;

Or even complex queries on other tables:

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

Where id is the id of the current entity.

The following blog post is worth the read: Hibernate Derived Properties – Performance and Portability.

Without more details, I can’t give a more precise answer but the above link should be helpful.

See also:

More Related Contents:

  1. Difference between @MapKey, @MapKeyColumn and @MapKeyJoinColumn in JPA and Hibernate
  2. Hibernate throws strange error: Class is not mapped
  3. JPA JoinColumn vs mappedBy
  4. How to fix the Hibernate “object references an unsaved transient instance – save the transient instance before flushing” error
  5. Hibernate Annotations – Which is better, field or property access?
  6. How to map an entity field whose name is a reserved word in JPA
  7. What’s the difference between JPA and Hibernate? [closed]
  8. What is the “owning side” in an ORM mapping?
  9. What is the solution for the N+1 issue in JPA and Hibernate?
  10. Can someone explain mappedBy in JPA and Hibernate?
  11. JPA CascadeType.ALL does not delete orphans
  12. Bypass GeneratedValue in Hibernate (merge data not in db?)
  13. When and why JPA entities should implement the Serializable interface?
  14. How to solve the LazyInitializationException when using JPA and Hibernate
  15. I found JPA, or alike, don’t encourage DAO pattern
  16. Getting Database connection in pure JPA setup
  17. Hibernate – @ElementCollection – Strange delete/insert behavior
  18. In which case do you use the JPA @JoinTable annotation?
  19. Hibernate/JPA – annotating bean methods vs fields [duplicate]
  20. Postgresql UUID supported by Hibernate?
  21. JPA: Implementing Model Hierarchy – @MappedSuperclass vs. @Inheritance
  22. Hibernate use of PostgreSQL sequence does not affect sequence table
  23. Is it possible to dynamically define column names in Hibernate / JPA?
  24. Doing an “IN” query with Hibernate
  25. Specifying an Index (Non-Unique Key) Using JPA
  26. Hibernate triggering constraint violations using orphanRemoval
  27. Hibernate vs JPA vs JDO – pros and cons of each? [closed]
  28. Clarifying terminology – What does “hydrating” a JPA or Hibernate entity mean when fetching the entity from the DB
  29. Change Table Name of an Entity on runtime? [duplicate]
  30. org.hibernate.loader.MultipleBagFetchException: cannot simultaneously fetch multiple bags

Leave a Comment