JPA & Criteria API – Select only specific columns

by

One of the JPA ways for getting only particular columns is to ask for a Tuple object.

In your case you would need to write something like this:

CriteriaQuery<Tuple> cq = builder.createTupleQuery();
// write the Root, Path elements as usual
Root<EntityClazz> root = cq.from(EntityClazz.class);
cq.multiselect(root.get(EntityClazz_.ID), root.get(EntityClazz_.VERSION));  //using metamodel
List<Tuple> tupleResult = em.createQuery(cq).getResultList();
for (Tuple t : tupleResult) {
    Long id = (Long) t.get(0);
    Long version = (Long) t.get(1);
}

Another approach is possible if you have a class representing the result, like T in your case. T doesn’t need to be an Entity class. If T has a constructor like:

public T(Long id, Long version)

then you can use T directly in your CriteriaQuery constructor:

CriteriaQuery<T> cq = builder.createQuery(T.class);
// write the Root, Path elements as usual
Root<EntityClazz> root = cq.from(EntityClazz.class);
cq.multiselect(root.get(EntityClazz_.ID), root.get(EntityClazz_.VERSION));  //using metamodel
List<T> result = em.createQuery(cq).getResultList();

See this link for further reference.

More Related Contents:

  1. PersistentObjectException: detached entity passed to persist thrown by JPA and Hibernate
  2. Difference between FetchType LAZY and EAGER in Java Persistence API?
  3. How to map an entity field whose name is a reserved word in JPA
  4. Why is Hibernate Open Session in View considered a bad practice?
  5. What’s the difference between JPA and Hibernate? [closed]
  6. How to convert a Hibernate proxy to a real entity object
  7. What is the solution for the N+1 issue in JPA and Hibernate?
  8. JPA CascadeType.ALL does not delete orphans
  9. Wrong ordering in generated table in jpa
  10. Solve Hibernate Lazy-Init issue with hibernate.enable_lazy_load_no_trans
  11. what is @JoinColumn and how it is used in Hibernate
  12. JPA eager fetch does not join
  13. In which case do you use the JPA @JoinTable annotation?
  14. How can I get the session object if I have the entity-manager?
  15. can someone please explain me @MapsId in hibernate?
  16. Make Hibernate ignore instance variables that are not mapped [duplicate]
  17. How do I properly cascade save a one-to-one, bidirectional relationship on primary key in Hibernate 3.6
  18. How to call Oracle Function or Procedure using Hibernate (EntityManager) or JPA
  19. Spring data JPA and hibernate detached entity passed to persist on ManyToMany relationship
  20. Refresh and fetch an entity after save (JPA/Spring Data/Hibernate)
  21. Doing an “IN” query with Hibernate
  22. Difference between save and saveAndFlush in Spring data jpa
  23. Inherited abstract class with JPA (+Hibernate)
  24. spring data jpa @query and pageable
  25. org.hibernate.MappingException: Could not determine type for: java.util.Set [duplicate]
  26. Difference between @MapKey, @MapKeyColumn and @MapKeyJoinColumn in JPA and Hibernate
  27. Why hibernate generates insert and update for OneToMany mapping
  28. Name attribute in @Entity and @Table
  29. JPA: Override Auto generated ID [duplicate]
  30. TransactionRequiredException Executing an update/delete query

Leave a Comment